清除 mariadb slave 上 multi_master 設定

1.傳統單 master 模式改多 master 模式
MariaDB [(none)]> stop slave;
MariaDB [(none)]> show slave status;
MariaDB [(none)]> reset slave all;
MariaDB [(none)]> change master 'conn' to master_host='master ip', MASTER_PORT=3306, master_user='帳號', master_password='密碼', master_log_file='mysql-bin.000001', master_log_pos=12345;
MariaDB [(none)]> start slave 'conn';
MariaDB [(none)]> show all slaves status \G 或 show slave 'conn' status \G


2.跳過錯誤
MariaDB [(none)]> stop slave 'conn';
指定來源名稱
MariaDB [(none)]> set @@default_master_connection='conn';
MariaDB [(none)]> set global sql_slave_skip_counter=1;
MariaDB [(none)]> star slave 'conn';


3.清除多 master 設定
指定來源名稱
MariaDB [(none)]> set @@default_master_connection='conn';
MariaDB [(none)]> reset slave all;
MariaDB [(none)]> set @@default_master_connection='';

MairaDB Multi-source replication 多源複製筆記

建立
# CHANGE MASTER 'connection_name_1' TO MASTER_HOST='10.240.0.1', MASTER_USER='slave', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=496;

# CHANGE MASTER 'connection_name_2' TO MASTER_HOST='10.240.0.2', MASTER_USER='slave', MASTER_PASSWORD='slave_password', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=496;

全體指令
# start all slaves;
# stop all slaves;
# show all slaves status\G

單一指令
# change master 'connection_name' .........
# reset slave 'connection_name';
# start slave 'connection_name';
# stop slave 'connection_name';
# show slave 'connection_name' status\G

跳過錯誤
1. stop slave 'connection_name';
2. set @@default_master_connection='connection_name';
3. set global sql_slave_skip_counter=1;
4. start slave 'connection_name';


reference:https://mariadb.com/kb/zh-cn/multi-source-replication/