Oneproxy the ability to manage multiple master-slave clusters is required to implement a split-table.
The startup script is truncated as follows:
#################################################
--proxy-master-addresses=172.30.12.9:[email protected] \
--proxy-master-addresses=172.30.12.8:[email protected] \
--proxy-user-list=test/[email protected] \
###################################################
Note The red part is 2 master nodes.
The proxy-user-list gives the user name and password to log on to all nodes.
If Oneproxy is configured with multiple proxy-user-list,oneproxy, the individual data nodes are polled using the configured user and password. If any of the users are not configured on the backend data node, then the node is marked as down.
So when you see Oneproxy log and a node is rotated by Mark down and mark up, make sure that each user configured in Proxy-user-list has the appropriate authorization for each backend database.
Oneproxy FAQ's Proxy-user-list