Dans cet exemple, la base répliqué sera qwerty.
crm configure group servsql IPFailover serveursql meta migration-threshold="5"
CREATE USER 'ha'@'%' IDENTIFIED BY 'qwerty123';
GRANT REPLICATION SLAVE ON *.* TO 'ha'@'%';
FLUSH PRIVILEGES;
EXIT;
vi /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld]
user = mysql
pid-file = /run/mysqld/mysqld.pid
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
lc-messages = en_US
skip-external-lockingcharacter-set-server = utf8mb4
collation-server = utf8mb4_general_cilog_error = /var/log/mysql/error.log
server-id = 100
log_bin = /var/log/mysql/mysql-bin.log
log-slave-updatesexpire_logs_days = 10
max_binlog_size = 100Mbinlog_do_db = gsb_valide
master-retry-count = 20
replicate-do-db = gsb_valide
/etc/init.d/mysql restart
mysql -p
FLUSH TABLES WITH READ LOCK;
show master status;
vi /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld]
user = mysql
pid-file = /run/mysqld/mysqld.pid
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
lc-messages = en_US
skip-external-lockingcharacter-set-server = utf8mb4
collation-server = utf8mb4_general_cilog_error = /var/log/mysql/error.log
log_bin = /var/log/mysql/mysql-bin.log
log-slave-updatesserver-id = 104
expire_logs_days = 10
max_binlog_size = 100Mmaster-retry-count = 20
replicate-do-db = qwerty
binlog_do_db = qwerty
/etc/init.d/mysql restart
STOP SLAVE;
mysql -p
CHANGE MASTER TO MASTER_HOST='10.0.1.10', MASTER_USER='ha', MASTER_PASSWORD='qwerty123', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=328;
START SLAVE;
EXIT;
mysql -p
UNLOCK TABLES;
EXIT;
SHOW MASTER STATUS;
Sur le maître.
GRANT REPLICATION SLAVE ON *.* TO 'ha'@'%' IDENTIFIED BY 'qwerty123'
CHANGE MASTER TO MASTER_HOST='10.0.1.10', MASTER_USER='ha', MASTER_PASSWORD='qwerty123', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=526;
CHANGE MASTER TO MASTER_HOST='10.0.1.11', MASTER_USER='ha', MASTER_PASSWORD='qwerty123', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=526;
crm configure primitive serviceMySQL ocf:heartbeat:mysql params socket=/var/run/mysqld/mysqld.sock
crm configure clone cServiceMySQL serviceMySQL