Clients → VIP 192.168.9.114 (Keepalived)
→ HAProxy (MASTER: 8.112 OR BACKUP: 8.113)
→ ProxySQL cluster (9.115, 8.112, 8.113)
→ MySQL: HG10 writer (8.15), HG20 readers (8.241, 8.242, 8.243)
| Role |
IP |
SSH User |
MySQL Root |
| Primary (smartb-prod-db02) |
192.168.8.15 |
angus / DigSAces1@23# |
p£w3Qr#0BJ3O9 |
| Replica 1 (smartb-db-01) |
192.168.8.241 |
manojm / manojM@1289 |
p£w3Qr#0BJ3O9 |
| Replica 2 (smartb-db-02) |
192.168.8.242 |
manojm / manojM@1289 |
p£w3Qr#0BJ3O9 |
| Replica 3 (smartb-db-primary) |
192.168.8.243 |
manojm / manojM@1289 |
p£w3Qr#0BJ3O9 |
| Dev/test |
192.168.8.13 |
— |
p£w3Qr#0BJ3O9 |
Replica 8.241 has log_replica_updates=ON — used for backup (binlog chain survives failover).
| VM |
IP |
Role |
| proxysql-vm |
192.168.9.115 |
ProxySQL primary, Orchestrator, Consul |
| dg-kafka-02 |
192.168.8.112 |
ProxySQL node2, HAProxy MASTER, Consul |
| dg-kafka-03 |
192.168.8.113 |
ProxySQL node3, HAProxy BACKUP, Consul |
All 3 are ESXi VMs — migration to Proxmox pending.
# Connect to ProxySQL admin interface
mysql -h 192.168.9.115 -P 6032 -u admin -padmin
# Cluster sync user
mysql -h 192.168.9.115 -P 6032 -u cluster -pClusterProx@2024
Config changes on any node propagate to all 3 automatically via ProxySQL clustering.
| User |
Password |
Default HG |
Purpose |
| sb |
k7VltaqDeHBrDgR |
10 |
Main app |
| sb_rw |
Sb_Rw@Pr0xy2024! |
10 |
Read-write |
| sb_child_process |
nJQiUcJ6kFS0X8M |
10 |
Background processes |
| root |
£w3Qr#0BJ3O9 |
0 |
Admin |
| root_staging |
A9kLmQ7xTzP2Rw@c |
1 |
Staging |
| HG |
Role |
Members |
| 10 |
Writer |
192.168.8.15 (primary) |
| 20 |
Readers |
192.168.8.241, 8.242, 8.243 |
# Replication user on all replicas
User: replicator
Password: Repl!cAt0r#2024
# Orchestrator (topology management)
URL: http://192.168.9.115 (check port)
User: orchestrator / Orch3str@t0r#2024
- Gossip encrypt key:
i1RMeKrbSNmF90h1exCs2NleuKUXqJYtw5Ob/1ehE68=
- Running on all 3 ProxySQL nodes
- User:
exporter / N9u@hP3!zQx4
# From any jump host (bm02 as example)
mysql -h 192.168.8.15 -u root -p'p£w3Qr#0BJ3O9'
# Via ProxySQL VIP (recommended for apps)
mysql -h 192.168.9.114 -P 3306 -u sb -p'k7VltaqDeHBrDgR' smartb
# Check replication
mysql -h 192.168.8.241 -u root -p'p£w3Qr#0BJ3O9' -e "SHOW REPLICA STATUS\G"
| Database |
Primary User |
Notes |
| sb |
sb / sb_rw |
Main production |
| fantasy_sport |
sb |
Fantasy sports |
| c4_api, c4_api_1 |
sb |
C4 API services |
| sb_wp |
sb |
WordPress |
| unibee |
sb |
Unibee service |
| superset |
sb |
Apache Superset |
| c4_wp |
sb |
C4 WordPress |
| email_tracking |
sb |
Email events |
| wikijs |
wikijs / WikiJs@Smartb1289 |
Wiki.js (on 8.15) |