The Ultimate Guide to High Availability with MariaDB

Comments - MaxScale and multimaster

7 years, 4 months ago Markus Mäkelä
Re: MaxScale and multimaster [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.

 
7 years, 2 months ago Takeshi Matsuzaki
Re: MaxScale and multimaster

I am very sorry too late response. Thank you very much to reply and we tried the way you taught. It has seemed working well.

 
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.