Page MenuHomeDevCentral
Files F11722279

No OneTemporary
Actions

View Options

diff --git a/pillar/dbserver/cluster-B.sls b/pillar/dbserver/cluster-B.sls
index 3c01f0c..1502d17 100644
--- a/pillar/dbserver/cluster-B.sls
+++ b/pillar/dbserver/cluster-B.sls
@@ -1,66 +1,70 @@
dbserver_mysql_aliases:
hosts:
- &viperserv 172.27.27.33
dbserver_mysql:
server:
salt:
# Account used by Salt to configure the server
credentials: dbserver/cluster-B/users/salt
users:
# Password paths are relative to ops/secrets
nasqueron:
password: dbserver/cluster-B/users/nasqueron
host: *viperserv
privileges:
- database: Nasqueron
scope: database
saas-mediawiki:
password: dbserver/cluster-B/users/saas-mediawiki
host: "%"
privileges:
- database: wikis
scope: database
- database: utopia
scope: database
- database: arsmagica
scope: database
- database: wolfplexdb
scope: database
- database: inidal_wiki
scope: database
- database: nasqueron_wiki
scope: database
- # Tips for databases:
+ # Notes for databases encoding and collation:
+ #
# This is a MariaDB cluster. At version 10.6, MariaDB is still using utf8mb3
# by default, but we generally prefer utf8mb4 as encoding.
#
# For collation, MySQL 8 uses utf8mb4_0900_ai_ci / utf8mb4_0900_as_cs
# It's a accent (in)sensitive case (in)sensitive based on Unicode 9.0.
# For MariaDB 10.10+, we can use uca1400_as_ci, that's Unicode 14.0.
#
+ # We note it with the full name utf8mb4_uca1400_as_ci, something not needed
+ # for manual requests, but allowing mysql_database.present to check equality.
+ #
# TRANSITION NOTE. On MariaDB 10.6, utf8mb4_unicode_520_ci is the "newest".
# From 2023-04-15, we starting to use uca1400_as_ci as default collation.
databases:
# Database used by IRC eggdrops
Nasqueron: &unicode
encoding: utf8mb4
- collation: uca1400_as_ci
+ collation: utf8mb4_uca1400_as_ci
# Databases used by MediaWiki SaaS
wikis: &mediawiki
encoding: utf8mb4
- collation: utf8_bin
+ collation: utf8mb4_bin
arsmagica: *mediawiki
inidal_wiki: *mediawiki
nasqueron_wiki: *mediawiki
# Databases used by MediaWiki SaaS - still to split from other content
utopia: *mediawiki
wolfplexdb: *mediawiki

File Metadata

Mime Type
text/x-diff
Expires
Thu, Sep 18, 02:06 (1 d, 13 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2989768
Default Alt Text
(2 KB)

Event Timeline

Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator