The Ultimate Guide to High Availability with MariaDB

Comments - Wierd tables in mysql system database

2 years, 12 months ago Sergio Charrua
Galera support

Hi, as stated in documentation, Galera only supports InnoDB. So, regarding the mysql schema, what is Galera's behaviour when replicating? will Galera ignor mysql? is mysql database replicated by Galera?

I've a 3 node Galera cluster. One those nodes is also Slave of a Mysql Master-Master cluster. When executing :

CHANGE MASTER TO MASTER_HOST='A.B.C.D', MASTER_USER='replicator', MASTER_PASSWORD='XXXXXX', MASTER_LOG_FILE='mariadb-bin.000123', MASTER_LOG_POS=123456789;

all other Galera nodes will start to be slave of the Mysql Cluster. And in fact this will result in many errors, namely Galera losing sync between nodes...

Is there any relation? how can I solve this?

Thanks in advance.

Sergio

 
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.