The Ultimate Guide to High Availability with MariaDB

Comments - MariaDB binary logging and master-master replication

 
3 years, 10 months ago Stéphane Varoqui
Re: MariaDB binary logging and master-master replication

replication-manager https://docs.signal18.io/ have a configurator your pick tags and get a tar.gz for each server of your cluster that contains config files with the best practice on replication, it can also help for failover driving proxies route in multi master to a single leader.

 
3 years, 10 months ago Daniel Black
Re: MariaDB binary logging and master-master replication [Answer]

note bind-address is only a single address which might be the cause. There's no need for 'FLUSH PRIVILEGES'. There's no need for replication filters on information_schema or performance schema, they aren't replicated anyway.

Caution about using /var/log/mysql as some logrotate rules may hit the binary log which can be problematic.

Did you following https://mariadb.com/kb/en/setting-up-replication/ though to see if you missed anything?

Is there anything in the error-log?

 
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.