Note: Cluster 2 cluster replication using PXC requires that server_id and binlog settings are identical on all nodes of the slave cluster. You can achieve this by creating a slave config template:
PXC 5.6:
sudo cp /usr/share/cmon/templates/my.cnf.galera /etc/cmon/templates/my.cnf.galera-binlog-slave
PXC 5.7:
sudo cp /usr/share/cmon/templates/my57.cnf.galera /etc/cmon/templates/my.cnf.galera-binlog-slave
and add/change in the [mysqld] section:
server_id=123456
binlog_format=ROW
log_bin=binlog
log_slave_updates=ON
gtid_mode=ON
enforce_gtid_consistency=ON
relay_log=relay-bin
expire_logs_days=7
Then select the my.cnf.galera-binlog-slave template in the Create Slave Cluster Deployment dialog.
Master Cluster
We also recommend you create the Galera Master Cluster using the same server_id and binlog settings by creating a master template:
PXC 5.6:
sudo cp /usr/share/cmon/templates/my.cnf.galera /etc/cmon/templates/my.cnf.galera-binlog-master
PXC 5.7:
sudo cp /usr/share/cmon/templates/my57.cnf.galera /etc/cmon/templates/my.cnf.galera-binlog-master
and add/change in the [mysqld] section:
server_id=567890
binlog_format=ROW
log_bin=binlog
log_slave_updates=ON
gtid_mode=ON
enforce_gtid_consistency=ON
relay_log=relay-bin
expire_logs_days=7
Then select the my.cnf.galera-binlog-master template in the Create Cluster Deployment dialog.
Comments
0 comments
Please sign in to leave a comment.