'ProxySQL - Different MySQL servers
I wanted to use ProxySQL to manage two groups of servers that would have different databases, how could this be done?
Example:
X instance group
Write server 1
Read Server 2 - Replicate
Read Server 3 - Replicate
- database a
- database b
- database c
Y instance group
Write server 3
Read Server 4 - Replicate
Read Server 5 - Replicate
- database d
- database e
Solution 1:[1]
set two services
/usr/lib/systemd/system/proxysql1.service for X instance group
/usr/lib/systemd/system/proxysql2.service for X instance group
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | dogs Cute |