Page MenuHomeDevCentral

No OneTemporary

diff --git a/pillar/dbserver/cluster-B.sls b/pillar/dbserver/cluster-B.sls
index d8783dd..1b9ae2b 100644
--- a/pillar/dbserver/cluster-B.sls
+++ b/pillar/dbserver/cluster-B.sls
@@ -1,119 +1,134 @@
dbserver_mysql_aliases:
hosts:
- &viperserv 172.27.27.33
+ - &windriver 172.27.27.35
- &web-001 172.27.27.10
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
- database: datacubes
scope: database
- database: datasource_lyrics
scope: table
privileges: SELECT, INSERT
tables:
# Tabled managed as datacube by Dæghrefn
- lyrics_sneakers
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
###
### Nasqueron members
###
dereckson_www:
password: dbserver/cluster-B/users/dereckson_www
host: *web-001
privileges:
- database: Dereckson
scope: database
dereckson_blog:
password: dbserver/cluster-B/users/dereckson_blog
host: *web-001
privileges:
- database: Dereckson_Blog
scope: database
+ ###
+ ### Wolfplex
+ ###
+
+ wolfplex_zine:
+ password: dbserver/cluster-B/users/wolfplex_zine
+ host: *windriver
+ privileges:
+ - database: wolfplex_zine
+ scope: database
+
###
### Zed / HyperShip
###
zed:
password: dbserver/cluster-B/users/zed
host: *web-001
privileges:
- database: zed_prod
scope: database
# 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: utf8mb4_uca1400_as_ci
datacubes: *unicode
datasource_lyrics: *unicode
# Databases used by MediaWiki SaaS
wikis: &mediawiki
encoding: utf8mb4
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
# Nasqueron members
Dereckson: *unicode
Dereckson_Blog: *unicode
+ # Wolfplex
+ wolfplex_zine: *unicode
+
# Zed / Hypership
zed_prod: *unicode

File Metadata

Mime Type
text/x-diff
Expires
Sat, Oct 11, 20:17 (14 h, 35 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3057283
Default Alt Text
(3 KB)

Event Timeline