MaxScale and multimaster
You are viewing an old version of this question. View
the current version here.
Answer
The service definition looks OK. Multi-master setups usually set one of the servers into read-only mode with SET GLOBAL read_only=ON to allow it to be used as a read-only slave.
The main problem with multiple master servers will be that the chosen master will depend on the order of the servers declared with the servers parameter. It is also not recommended to use readwritesplit in a setup with more than one master server as it will not use the other masters for reads. The readconnroute router combined with server weghting is a better solution for a highly available setup with multiple masters.
For more information, read the readconnroute documentation and the section on server weights in the configuration guide.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
