关于 Linux 下 Mysql 集群同步 (主从、一主多从、主从从) 部署及同步策略的一些笔记

┌──[root@vms152.liruilongs.github.io]-[~]└─$cat inventory[master]192.168.26.152[node]192.168.26.153192.168.26.154[web]192.168.26.155192.168.26.156[db_node]192.168.26.153192.168.26.154192.168.26.155┌──[root@vms152.liruilongs.github.io]-[~]└─$

┌──[root@vms152.liruilongs.github.io]-[~]└─$ansible node -m yum -a 'name=mariadb,mariadb-server state=installed'

┌──[root@vms152.liruilongs.github.io]-[~]└─$ansible 192.168.26.153 -m shell -a "sed '/\[mysqld\]/a server_id=153\nlog_bin=master153' /etc/my.cnf -i"┌──[root@vms152.liruilongs.github.io]-[~]└─$ansible 192.168.26.153 -m service -a 'name=mariadb state=restarted'

┌──[root@vms153.liruilongs.github.io]-[~]└─$mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
In order to log into MariaDB to secure it, we'll need the currentpassword for the root user.  If you've just installed MariaDB, andyou haven't set the root password yet, the password will be blank,so you should just press enter here.
Enter current password for root (enter for none):OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MariaDBroot user without the proper authorisation.
Set root password? [Y/n] yNew password:Re-enter new password:Password updated successfully!Reloading privilege tables.. ... Success!
，。。。
All done!  If you've completed all of the above steps, your MariaDBinstallation should now be secure.
Thanks for using MariaDB!┌──[root@vms153.liruilongs.github.io]-[~]└─$

┌──[root@vms153.liruilongs.github.io]-[~]└─$cat /etc/my.cnf[mysqld]server_id=153log_bin=master153# 字符集init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake
datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid
## include all files from the config directory#!includedir /etc/my.cnf.d

┌──[root@vms153.liruilongs.github.io]-[~]└─$cat /etc/my.cnf.d/client.cnf## These two groups are read by the client library# Use it for options that affect all clients, but not the server#

[client]
# This group is not read by mysql client library,# If you use the same .cnf file for MySQL and MariaDB,# use it for MariaDB-only client options[client-mariadb]

┌──[root@vms153.liruilongs.github.io]-[~]└─$sed '/\[client\]/a default-character-set=utf8' /etc/my.cnf.d/client.cnf -i

┌──[root@vms153.liruilongs.github.io]-[~]└─$cat /etc/my.cnf.d/mysql-clients.cnf## These groups are read by MariaDB command-line tools# Use it for options that affect only one utility#
[mysql]
[mysql_upgrade]
[mysqladmin]
[mysqlbinlog]
[mysqlcheck]
[mysqldump]
[mysqlimport]
[mysqlshow]
[mysqlslap]
┌──[root@vms153.liruilongs.github.io]-[~]└─$sed -i '/\[mysql\]/a default-character-set=utf8' /etc/my.cnf.d/mysql-clients.cnf

┌──[root@vms153.liruilongs.github.io]-[~]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 3Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show variables like "%character%";show variables like "%collation%";+--------------------------+----------------------------+| Variable_name            | Value                      |+--------------------------+----------------------------+| character_set_client     | utf8                       || character_set_connection | utf8                       || character_set_database   | utf8                       || character_set_filesystem | binary                     || character_set_results    | utf8                       || character_set_server     | utf8                       || character_set_system     | utf8                       || character_sets_dir       | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+8 rows in set (0.00 sec)
+----------------------+-----------------+| Variable_name        | Value           |+----------------------+-----------------+| collation_connection | utf8_unicode_ci || collation_database   | utf8_unicode_ci || collation_server     | utf8_unicode_ci |+----------------------+-----------------+3 rows in set (0.00 sec)
MariaDB [(none)]>

MariaDB [(none)]> grant replication slave on *.* to repluser@"%" identified by "repluser";Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> select user,host from mysql.user    -> ; ###在mysql库下的user表中查看用户的授权信息+----------+-----------------------------+| user     | host                        |+----------+-----------------------------+| repluser | %                           || root     | 127.0.0.1                   || root     | ::1                         || root     | localhost                   || root     | vms153.liruilongs.github.io |+----------+-----------------------------+5 rows in set (0.00 sec)
MariaDB [(none)]> show master status    -> ; ###查看binlog日志的状态信息+------------------+----------+--------------+------------------+| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |+------------------+----------+--------------+------------------+| master153.000004 |      391 |              |                  |+------------------+----------+--------------+------------------+

┌──[root@vms154.liruilongs.github.io]-[~]└─$cat /etc/my.cnf[mysqld]server_id=154# 字符集init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake
datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid
## include all files from the config directory#!includedir /etc/my.cnf.d

┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 9Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.####指定主服务器信息#master_host=       指定主服务器的IP地址#master_user=       指定主服务器授权用户 #master_password=   指定授权用户的密码#master_log_file=   指定主服务器binlog日志文件(去153上查看)#master_log_pos=    指定主服务器binlog日志偏移量(去153上查看)MariaDB [(none)]>  change master to    -> master_host="192.168.26.153",    -> master_user="repluser",    -> master_password="repluser",    -> master_log_file="master153.000004",    -> master_log_pos=391;Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]>

┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$systemctl restart  mariadb.service┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 4Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> start slave;Query OK, 0 rows affected, 1 warning (0.00 sec)
MariaDB [(none)]> show slave status\G;*************************** 1. row ***************************               Slave_IO_State: Waiting for master to send event                  Master_Host: 192.168.26.153  ##主服务器IP地址                  Master_User: repluser         #主服务器授权用户                  Master_Port: 3306            #主服务器端口号                Connect_Retry: 60              Master_Log_File: master153.000004   #主服务器端binlog日志          Read_Master_Log_Pos: 391       #主服务器端binlog日志偏移量               Relay_Log_File: mariadb-relay-bin.000003                Relay_Log_Pos: 529        Relay_Master_Log_File: master153.000004             Slave_IO_Running: Yes  #IO线程运行            Slave_SQL_Running: Yes  #SQL线程运行              Replicate_Do_DB:          Replicate_Ignore_DB:           Replicate_Do_Table:       Replicate_Ignore_Table:      Replicate_Wild_Do_Table:  Replicate_Wild_Ignore_Table:                   Last_Errno: 0                   Last_Error:                 Skip_Counter: 0          Exec_Master_Log_Pos: 391              Relay_Log_Space: 825              Until_Condition: None               Until_Log_File:                Until_Log_Pos: 0           Master_SSL_Allowed: No           Master_SSL_CA_File:           Master_SSL_CA_Path:              Master_SSL_Cert:            Master_SSL_Cipher:               Master_SSL_Key:        Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No                Last_IO_Errno: 0   #IO线程报错信息提示                Last_IO_Error:               Last_SQL_Errno: 0   #SQL线程报错信息提示               Last_SQL_Error:  Replicate_Ignore_Server_Ids:             Master_Server_Id: 1531 row in set (0.00 sec)
ERROR: No query specified
MariaDB [(none)]>

MariaDB [(none)]> show master status;+------------------+----------+--------------+------------------+| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |+------------------+----------+--------------+------------------+| master153.000004 |      391 |              |                  |+------------------+----------+--------------+------------------+1 row in set (0.00 sec)
MariaDB [(none)]> create database liruilong_db;Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> use liruilong_db;create table liruilong_db.user(id int(10),create_date datetime);Database changedQuery OK, 0 rows affected (0.00 sec)
MariaDB [liruilong_db]> insert into user values(1,now());Query OK, 1 row affected (0.00 sec)
MariaDB [liruilong_db]> select * from user;+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 00:22:36 |+------+---------------------+1 row in set (0.00 sec)
MariaDB [liruilong_db]>

┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 5Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> select * from liruilong_db.user;+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 00:22:36 |+------+---------------------+1 row in set (0.00 sec)
MariaDB [(none)]>

┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$lsaria_log.00000001  ib_logfile0   mariadb-relay-bin.000002  master.info  performance_schemaaria_log_control   ib_logfile1   mariadb-relay-bin.000003  mysql        relay-log.infoibdata1            liruilong_db  mariadb-relay-bin.index   mysql.sock   test

┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$cat /var/lib/mysql/master.info18master153.000004854192.168.26.153repluserrepluser330660.......

┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$ls | grep mariadb-relay-binmariadb-relay-bin.000002mariadb-relay-bin.000003mariadb-relay-bin.index┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$cat mariadb-relay-bin.index./mariadb-relay-bin.000002./mariadb-relay-bin.000003

┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$cat relay-log.info./mariadb-relay-bin.000003  ##本机正在使用的中继日志文jian992               #中继日志记录主服务器sql命令的偏移量master153.000004  #继日志从哪个文件中拷贝sql命令(主服务器854  #此为主服务器最近的binlog日志的偏移量┌──[root@vms154.liruilongs.github.io]-[/var/lib/mysql]└─$

┌──[root@vms153.liruilongs.github.io]-[/var/lib/mysql]└─$yum -y install percona-xtrabackup

####完全备份：备份所有库和所有表#--user           指定数据库的用户名: root#--password       指定数据库的密码:   liruilong#/alldb          指定备份数据存放的目录，不需要提前创建，会自动创建#--no-timestamp   指定不用日期时间作为存储数据的子目录名称#--slave-info     指备份数据时,记录sql命令的偏移量和binlog日志文件名，便于从服务器去读取┌──[root@vms153.liruilongs.github.io]-[/var/lib/mysql]└─$innobackupex --user root --password 'liruilong' --slave-info /alldb --no-timestamp220929 00:53:41 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.           At the end of a successful backup run innobackupex           prints "completed OK!".
Can't locate Digest/MD5.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at - line 693.BEGIN failed--compilation aborted at - line 693.220929 00:53:41 Connecting to MySQL server host: localhost, user: root, password: set, port: 0, socket: /var/lib/mysql/mysql.sockUsing server version 5.5.68-MariaDBinnobackupex version 2.3.6 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )xtrabackup: uses posix_fadvise().xtrabackup: cd to /var/lib/mysqlxtrabackup: open files limit requested 0, set to 1024xtrabackup: using the following InnoDB configuration:xtrabackup:   innodb_data_home_dir = ./xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextendxtrabackup:   innodb_log_group_home_dir = ./.......
220929 00:53:43 Executing UNLOCK TABLES220929 00:53:43 All tables unlocked220929 00:53:43 Backup created in directory '/alldb'MySQL binlog position: filename 'master153.000004', position '854'220929 00:53:43 [00] Writing backup-my.cnf220929 00:53:43 [00]        ...done220929 00:53:43 [00] Writing xtrabackup_info220929 00:53:43 [00]        ...donextrabackup: Transaction log of lsn (1600828) to (1600828) was copied.220929 00:53:43 completed OK!┌──[root@vms153.liruilongs.github.io]-[/var/lib/mysql]└─$

┌──[root@vms153.liruilongs.github.io]-[/]└─$scp -r /alldb/ root@192.168.26.155:/opt/root@192.168.26.155's password:xtrabackup_logfile。。。。

┌──[root@vms155.liruilongs.github.io]-[~]└─$yum -y install percona-xtrabackup

┌──[root@vms155.liruilongs.github.io]-[/opt]└─$cd alldb/┌──[root@vms155.liruilongs.github.io]-[/opt/alldb]└─$lsbackup-my.cnf  liruilong_db  performance_schema  xtrabackup_binlog_info  xtrabackup_infoibdata1        mysql         test                xtrabackup_checkpoints  xtrabackup_logfile┌──[root@vms155.liruilongs.github.io]-[/opt/alldb]└─$cd ~

┌──[root@vms155.liruilongs.github.io]-[~]└─$cat /opt/alldb/xtrabackup_binlog_infomaster153.000004        854

┌──[root@vms155.liruilongs.github.io]-[~]└─$systemctl stop mariadb┌──[root@vms155.liruilongs.github.io]-[~]└─$systemctl status mariadb● mariadb.service - MariaDB database server   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)   Active: inactive (dead)

┌──[root@vms155.liruilongs.github.io]-[~]└─$rm -rf /var/lib/mysql/*┌──[root@vms155.liruilongs.github.io]-[~]└─$innobackupex --apply-log /opt/alldb/220929 10:45:50 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.           At the end of a successful apply-log run innobackupex           prints "completed OK!".
innobackupex version 2.3.6 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )xtrabackup: cd to /opt/alldb/xtrabackup: This target seems to be not prepared yet.xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1600828)。。。。。。。。InnoDB: Starting shutdown...InnoDB: Shutdown completed; log sequence number 1601046220929 10:45:53 completed OK!

┌──[root@vms155.liruilongs.github.io]-[~]└─$innobackupex --copy-back /opt/alldb/220929 10:46:23 innobackupex: Starting the copy-back operation
IMPORTANT: Please check that the copy-back run completes successfully.           At the end of a successful copy-back run innobackupex           prints "completed OK!".
innobackupex version 2.3.6 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )220929 10:46:23 [01] Copying ib_logfile0 to /var/lib/mysql/ib_logfile0220929 10:46:23 [01]        ...done220929 10:46:23 [01] Copying ib_logfile1 to /var/lib/mysql/ib_logfile1220929 10:46:23 [01]        ...done...........................220929 10:46:24 [01] Copying ./xtrabackup_binlog_pos_innodb to /var/lib/mysql/xtrabackup_binlog_pos_innodb220929 10:46:24 [01]        ...done220929 10:46:24 completed OK!┌──[root@vms155.liruilongs.github.io]-[~]└─$

┌──[root@vms155.liruilongs.github.io]-[~]└─$ls /var/lib/mysql/ibdata1  ib_logfile0  ib_logfile1  liruilong_db  mysql  performance_schema  test  xtrabackup_binlog_pos_innodb  xtrabackup_info┌──[root@vms155.liruilongs.github.io]-[~]└─$chown -R mysql.mysql /var/lib/mysql┌──[root@vms155.liruilongs.github.io]-[~]└─$systemctl start mariadb.service

┌──[root@vms155.liruilongs.github.io]-[~]└─$mysql -uroot -pliruilong -e'select * from liruilong_db.user'+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 00:22:36 |+------+---------------------+┌──[root@vms155.liruilongs.github.io]-[~]└─$

┌──[root@vms155.liruilongs.github.io]-[~]└─$vim /etc/my.cnf┌──[root@vms155.liruilongs.github.io]-[~]└─$cat /etc/my.cnf[mysqld]server_id=155# 字符集init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake
datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid
## include all files from the config directory#!includedir /etc/my.cnf.d┌──[root@vms155.liruilongs.github.io]-[~]└─$sed '/\[client\]/a default-character-set=utf8' /etc/my.cnf.d/client.cnf -i┌──[root@vms155.liruilongs.github.io]-[~]└─$sed -i '/\[mysql\]/a default-character-set=utf8' /etc/my.cnf.d/mysql-clients.cnf┌──[root@vms155.liruilongs.github.io]-[~]└─$systemctl restart mariadb.service

┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 6Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show master status    -> ;+------------------+----------+--------------+------------------+| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |+------------------+----------+--------------+------------------+| master153.000004 |      854 |              |                  |+------------------+----------+--------------+------------------+1 row in set (0.00 sec)
MariaDB [(none)]>

┌──[root@vms155.liruilongs.github.io]-[~]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 4Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> change master to    -> master_host="192.168.26.153",    -> master_user="repluser",    -> master_password="repluser",    -> master_log_file="master153.000004",    -> master_log_pos="854";ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"854"' at line 6MariaDB [(none)]> change master to master_host="192.168.26.153", master_user="repluser", master_password="repluser", master_log_file="master153.000004", master_log_pos=854;Query OK, 0 rows affected (0.04 sec)
MariaDB [(none)]>

MariaDB [(none)]> stop slave    -> ;Query OK, 0 rows affected, 1 warning (0.00 sec)
MariaDB [(none)]> start slave;Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> show slave status\G;*************************** 1. row ***************************               Slave_IO_State:                  Master_Host: 192.168.26.153                  Master_User: repluser                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: master153.000004          Read_Master_Log_Pos: 854               Relay_Log_File: mariadb-relay-bin.000001                Relay_Log_Pos: 4        Relay_Master_Log_File: master153.000004             Slave_IO_Running: No            Slave_SQL_Running: Yes              Replicate_Do_DB:          Replicate_Ignore_DB:           Replicate_Do_Table:       Replicate_Ignore_Table:      Replicate_Wild_Do_Table:  Replicate_Wild_Ignore_Table:                   Last_Errno: 0                   Last_Error:                 Skip_Counter: 0          Exec_Master_Log_Pos: 854              Relay_Log_Space: 245              Until_Condition: None               Until_Log_File:                Until_Log_Pos: 0           Master_SSL_Allowed: No           Master_SSL_CA_File:           Master_SSL_CA_Path:              Master_SSL_Cert:            Master_SSL_Cipher:               Master_SSL_Key:        Seconds_Behind_Master: NULLMaster_SSL_Verify_Server_Cert: No                Last_IO_Errno: 1593                Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it).               Last_SQL_Errno: 0               Last_SQL_Error:  Replicate_Ignore_Server_Ids:             Master_Server_Id: 1531 row in set (0.00 sec)
ERROR: No query specified

┌──[root@vms155.liruilongs.github.io]-[~]└─$cat /etc/my.cnf[mysqld]server_id=153# 字符集。。。。。!includedir /etc/my.cnf.d┌──[root@vms155.liruilongs.github.io]-[~]└─$vim /etc/my.cnf

┌──[root@vms155.liruilongs.github.io]-[~]└─$systemctl restart mariadb.service┌──[root@vms155.liruilongs.github.io]-[~]└─$mysql -uroot -pliruilong -e'show slave status\G'*************************** 1. row ***************************               Slave_IO_State: Waiting for master to send event                  Master_Host: 192.168.26.153                  Master_User: repluser                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: master153.000004          Read_Master_Log_Pos: 854               Relay_Log_File: mariadb-relay-bin.000004                Relay_Log_Pos: 529        Relay_Master_Log_File: master153.000004             Slave_IO_Running: Yes            Slave_SQL_Running: Yes              Replicate_Do_DB:          Replicate_Ignore_DB:           Replicate_Do_Table:       Replicate_Ignore_Table:      Replicate_Wild_Do_Table:  Replicate_Wild_Ignore_Table:                   Last_Errno: 0                   Last_Error:                 Skip_Counter: 0          Exec_Master_Log_Pos: 854              Relay_Log_Space: 825              Until_Condition: None               Until_Log_File:                Until_Log_Pos: 0           Master_SSL_Allowed: No           Master_SSL_CA_File:           Master_SSL_CA_Path:              Master_SSL_Cert:            Master_SSL_Cipher:               Master_SSL_Key:        Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No                Last_IO_Errno: 0                Last_IO_Error:               Last_SQL_Errno: 0               Last_SQL_Error:  Replicate_Ignore_Server_Ids:             Master_Server_Id: 153┌──[root@vms155.liruilongs.github.io]-[~]└─$

┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 6Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> insert into liruilong_db.user values(1,now());Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> select * from liruilong_db.user;+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 00:22:36 ||    1 | 2022-09-29 11:08:38 |+------+---------------------+2 rows in set (0.00 sec)
MariaDB [(none)]>

┌──[root@vms155.liruilongs.github.io]-[~]└─$mysql -uroot -pliruilong -e' select * from liruilong_db.user'+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 00:22:36 ||    1 | 2022-09-29 11:08:38 |+------+---------------------+┌──[root@vms155.liruilongs.github.io]-[~]└─$

┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e' select * from liruilong_db.user'+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 00:22:36 ||    1 | 2022-09-29 11:08:38 |+------+---------------------+┌──[root@vms154.liruilongs.github.io]-[/]└─$

┌──[root@vms154.liruilongs.github.io]-[/]└─$vim /etc/my.cnf┌──[root@vms154.liruilongs.github.io]-[/]└─$┌──[root@vms154.liruilongs.github.io]-[/]└─$cat /etc/my.cnf[mysqld]server_id=154log_bin=master154log_slave_updates# 字符集init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake
datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid
## include all files from the config directory#!includedir /etc/my.cnf.d┌──[root@vms154.liruilongs.github.io]-[/]└─$systemctl restart mariadb.service┌──[root@vms154.liruilongs.github.io]-[/]└─$

┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e' show slave status\G'*************************** 1. row ***************************               Slave_IO_State: Waiting for master to send event                  Master_Host: 192.168.26.153                  Master_User: repluser                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: master153.000006          Read_Master_Log_Pos: 245               Relay_Log_File: mariadb-relay-bin.000009                Relay_Log_Pos: 529        Relay_Master_Log_File: master153.000006             Slave_IO_Running: Yes            Slave_SQL_Running: Yes              Replicate_Do_DB:          Replicate_Ignore_DB:           Replicate_Do_Table:       Replicate_Ignore_Table:      Replicate_Wild_Do_Table:  Replicate_Wild_Ignore_Table:                   Last_Errno: 0                   Last_Error:                 Skip_Counter: 0          Exec_Master_Log_Pos: 245              Relay_Log_Space: 825              Until_Condition: None               Until_Log_File:                Until_Log_Pos: 0           Master_SSL_Allowed: No           Master_SSL_CA_File:           Master_SSL_CA_Path:              Master_SSL_Cert:            Master_SSL_Cipher:               Master_SSL_Key:        Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No                Last_IO_Errno: 0                Last_IO_Error:               Last_SQL_Errno: 0               Last_SQL_Error:  Replicate_Ignore_Server_Ids:             Master_Server_Id: 153┌──[root@vms154.liruilongs.github.io]-[/]└─$

┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 5Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> grant replication slave on *.* to tom@"%" identified by "liruilong";Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> show master status;+------------------+----------+--------------+------------------+| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |+------------------+----------+--------------+------------------+| master154.000001 |      387 |              |                  |+------------------+----------+--------------+------------------+1 row in set (0.00 sec)
MariaDB [(none)]>

┌──[root@vms155.liruilongs.github.io]-[~]└─$cd /var/lib/mysql/┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$lsaria_log.00000001  ib_logfile1               mariadb-relay-bin.index  master155.index  performance_schema            xtrabackup_infoaria_log_control   liruilong_db              master155.000001         master.info      relay-log.infoibdata1            mariadb-relay-bin.000003  master155.000002         mysql            testib_logfile0        mariadb-relay-bin.000004  master155.000003         mysql.sock       xtrabackup_binlog_pos_innodb┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$rm -rf master.info┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$rm -rf mariadb-relay-bin.00000*┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$rm -rf mariadb-relay-bin.index┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$rm -rf relay-log.info┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$lsaria_log.00000001  ib_logfile0   master155.000001  master155.index  performance_schema            xtrabackup_infoaria_log_control   ib_logfile1   master155.000002  mysql            testibdata1            liruilong_db  master155.000003  mysql.sock       xtrabackup_binlog_pos_innodb┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$

┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$systemctl restart mariadb.service┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$mysql -uroot -pliruilong -e 'show slave status;'┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$mysql -uroot -pliruilongWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 4Server version: 5.5.68-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> change master to    -> master_host="192.168.26.154",    -> master_user="tom",    -> master_password="liruilong",    -> master_log_file="master154.000001",    -> master_log_pos=387;Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> start slave    -> ;Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> show slave status\G*************************** 1. row ***************************               Slave_IO_State: Waiting for master to send event                  Master_Host: 192.168.26.154                  Master_User: tom                  Master_Port: 3306                Connect_Retry: 60              Master_Log_File: master154.000001          Read_Master_Log_Pos: 387               Relay_Log_File: mariadb-relay-bin.000002                Relay_Log_Pos: 529        Relay_Master_Log_File: master154.000001             Slave_IO_Running: Yes            Slave_SQL_Running: Yes              Replicate_Do_DB:          Replicate_Ignore_DB:           Replicate_Do_Table:       Replicate_Ignore_Table:      Replicate_Wild_Do_Table:  Replicate_Wild_Ignore_Table:                   Last_Errno: 0                   Last_Error:                 Skip_Counter: 0          Exec_Master_Log_Pos: 387              Relay_Log_Space: 825              Until_Condition: None               Until_Log_File:                Until_Log_Pos: 0           Master_SSL_Allowed: No           Master_SSL_CA_File:           Master_SSL_CA_Path:              Master_SSL_Cert:            Master_SSL_Cipher:               Master_SSL_Key:        Seconds_Behind_Master: 0Master_SSL_Verify_Server_Cert: No                Last_IO_Errno: 0                Last_IO_Error:               Last_SQL_Errno: 0               Last_SQL_Error:  Replicate_Ignore_Server_Ids:             Master_Server_Id: 1541 row in set (0.00 sec)
MariaDB [(none)]>

┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e' insert into liruilong_db.user values(1,now());'┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'select * from liruilong_db.user'+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 00:22:36 ||    1 | 2022-09-29 11:08:38 ||    1 | 2022-09-29 13:43:09 ||    1 | 2022-09-29 13:51:33 ||    1 | 2022-09-29 13:54:41 |+------+---------------------+┌──[root@vms153.liruilongs.github.io]-[/]└─$

┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'select * from liruilong_db.user'+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 00:22:36 ||    1 | 2022-09-29 11:08:38 ||    1 | 2022-09-29 13:43:09 ||    1 | 2022-09-29 13:51:33 ||    1 | 2022-09-29 13:54:41 |+------+---------------------+┌──[root@vms154.liruilongs.github.io]-[/]└─$

┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$mysql -uroot -pliruilong -e'select * from liruilong_db.user'+------+---------------------+| id   | create_date         |+------+---------------------+|    1 | 2022-09-29 13:43:09 ||    1 | 2022-09-29 13:51:33 ||    1 | 2022-09-29 13:54:41 |+------+---------------------+┌──[root@vms155.liruilongs.github.io]-[/var/lib/mysql]└─$

mysq1>install plugin rpl semi sync_master SONAME "semisync_master.so";  //加载master模块mysq1>install plugin rpl_semi_sync_slave  SONAME "semisync_slave.so";   //加载slave模块

┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'desc information_schema.PLUGINS'+------------------------+-------------+------+-----+---------+-------+| Field                  | Type        | Null | Key | Default | Extra |+------------------------+-------------+------+-----+---------+-------+| PLUGIN_NAME            | varchar(64) | NO   |     |         |       || PLUGIN_VERSION         | varchar(20) | NO   |     |         |       || PLUGIN_STATUS          | varchar(10) | NO   |     |         |       || PLUGIN_TYPE            | varchar(80) | NO   |     |         |       || PLUGIN_TYPE_VERSION    | varchar(20) | NO   |     |         |       || PLUGIN_LIBRARY         | varchar(64) | YES  |     | NULL    |       || PLUGIN_LIBRARY_VERSION | varchar(20) | YES  |     | NULL    |       || PLUGIN_AUTHOR          | varchar(64) | YES  |     | NULL    |       || PLUGIN_DESCRIPTION     | longtext    | YES  |     | NULL    |       || PLUGIN_LICENSE         | varchar(80) | NO   |     |         |       || LOAD_OPTION            | varchar(64) | NO   |     |         |       || PLUGIN_MATURITY        | varchar(12) | NO   |     |         |       || PLUGIN_AUTH_VERSION    | varchar(80) | YES  |     | NULL    |       |+------------------------+-------------+------+-----+---------+-------+

┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'select PLUGIN_NAME,PLUGIN_STATUS from information_schema.PLUGINS where PLUGIN_NAME like "%semi%";'┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'install plugin rpl_semi_sync_master SONAME "semisync_master.so";select PLUGIN_NAME,PLUGIN_STATUS from information_schema.PLUGINS where PLUGIN_NAME like "%semi%";'+----------------------+---------------+| PLUGIN_NAME          | PLUGIN_STATUS |+----------------------+---------------+| rpl_semi_sync_master | ACTIVE        |+----------------------+---------------+┌──[root@vms153.liruilongs.github.io]-[/]└─$

┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'select PLUGIN_NAME,PLUGIN_STATUS from information_schema.PLUGINS where PLUGIN_NAME like "%semi%";'┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'install plugin rpl_semi_sync_master SONAME "semisync_master.so";select PLUGIN_NAME,PLUGIN_STATUS from information_schema.PLUGINS where PLUGIN_NAME like "%semi%";'+----------------------+---------------+| PLUGIN_NAME          | PLUGIN_STATUS |+----------------------+---------------+| rpl_semi_sync_master | ACTIVE        |+----------------------+---------------+┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'install plugin rpl_semi_sync_slave SONAME "semisync_slave.so";'┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'select PLUGIN_NAME,PLUGIN_STATUS from information_schema.PLUGINS where PLUGIN_NAME like "%semi%";'+----------------------+---------------+| PLUGIN_NAME          | PLUGIN_STATUS |+----------------------+---------------+| rpl_semi_sync_master | ACTIVE        || rpl_semi_sync_slave  | ACTIVE        |+----------------------+---------------+┌──[root@vms154.liruilongs.github.io]-[/]└─$

┌──[root@vms155.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'select PLUGIN_NAME,PLUGIN_STATUS from information_schema.PLUGINS where PLUGIN_NAME like "%semi%";'┌──[root@vms155.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'install plugin rpl_semi_sync_slave SONAME "semisync_slave.so";'┌──[root@vms155.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'select PLUGIN_NAME,PLUGIN_STATUS from information_schema.PLUGINS where PLUGIN_NAME like "%semi%";'+---------------------+---------------+| PLUGIN_NAME         | PLUGIN_STATUS |+---------------------+---------------+| rpl_semi_sync_slave | ACTIVE        |+---------------------+---------------+┌──[root@vms155.liruilongs.github.io]-[/]└─$

┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'show variables like "%semi%";'+------------------------------------+-------+| Variable_name                      | Value |+------------------------------------+-------+| rpl_semi_sync_master_enabled       | OFF   || rpl_semi_sync_master_timeout       | 10000 || rpl_semi_sync_master_trace_level   | 32    || rpl_semi_sync_master_wait_no_slave | ON    |+------------------------------------+-------+┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'set global rpl_semi_sync_master_enabled=1;'┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'show variables like "%semi%";'+------------------------------------+-------+| Variable_name                      | Value |+------------------------------------+-------+| rpl_semi_sync_master_enabled       | ON    || rpl_semi_sync_master_timeout       | 10000 || rpl_semi_sync_master_trace_level   | 32    || rpl_semi_sync_master_wait_no_slave | ON    |+------------------------------------+-------+┌──[root@vms153.liruilongs.github.io]-[/]└─$

┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'set global rpl_semi_sync_master_enabled=1; set global rpl_semi_sync_slave_enabled=1;'┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'show variables like "%semi%";'+------------------------------------+-------+| Variable_name                      | Value |+------------------------------------+-------+| rpl_semi_sync_master_enabled       | ON    || rpl_semi_sync_master_timeout       | 10000 || rpl_semi_sync_master_trace_level   | 32    || rpl_semi_sync_master_wait_no_slave | ON    || rpl_semi_sync_slave_enabled        | ON    || rpl_semi_sync_slave_trace_level    | 32    |+------------------------------------+-------+┌──[root@vms154.liruilongs.github.io]-[/]└─$

┌──[root@vms155.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'set global rpl_semi_sync_slave_enabled=1;'┌──[root@vms155.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'show variables like "%semi%";'+---------------------------------+-------+| Variable_name                   | Value |+---------------------------------+-------+| rpl_semi_sync_slave_enabled     | ON    || rpl_semi_sync_slave_trace_level | 32    |+---------------------------------+-------+┌──[root@vms155.liruilongs.github.io]-[/]└─$

plugin-load=rpl_semi_sync_master=semisync_master.sorpl_semi_sync_master_enabled=1

┌──[root@vms153.liruilongs.github.io]-[/]└─$vim /etc/my.cnf┌──[root@vms153.liruilongs.github.io]-[/]└─$cat /etc/my.cnf[mysqld]
plugin-load=rpl_semi_sync_master=semisync_master.sorpl_semi_sync_master_enabled=1

server_id=153log_bin=master153# 字符集init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake
datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid
## include all files from the config directory#!includedir /etc/my.cnf.d
┌──[root@vms153.liruilongs.github.io]-[/]└─$systemctl restart mariadb.service┌──[root@vms153.liruilongs.github.io]-[/]└─$

┌──[root@vms153.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'show variables like "%semi%";'+------------------------------------+-------+| Variable_name                      | Value |+------------------------------------+-------+| rpl_semi_sync_master_enabled       | ON    || rpl_semi_sync_master_timeout       | 10000 || rpl_semi_sync_master_trace_level   | 32    || rpl_semi_sync_master_wait_no_slave | ON    |+------------------------------------+-------+┌──[root@vms153.liruilongs.github.io]-[/]└─$

┌──[root@vms154.liruilongs.github.io]-[/]└─$vim /etc/my.cnf┌──[root@vms154.liruilongs.github.io]-[/]└─$cat /etc/my.cnf[mysqld]
plugin-load="rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"rpl_semi_sync_master_enabled=1rpl_semi_sync_slave_enabled=1

server_id=154log_bin=master154log_slave_updates# 字符集init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake
datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid
## include all files from the config directory#!includedir /etc/my.cnf.d┌──[root@vms153.liruilongs.github.io]-[/]└─$systemctl restart mariadb.service

┌──[root@vms154.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'show variables like "%semi%";'+------------------------------------+-------+| Variable_name                      | Value |+------------------------------------+-------+| rpl_semi_sync_master_enabled       | ON    || rpl_semi_sync_master_timeout       | 10000 || rpl_semi_sync_master_trace_level   | 32    || rpl_semi_sync_master_wait_no_slave | ON    || rpl_semi_sync_slave_enabled        | ON    || rpl_semi_sync_slave_trace_level    | 32    |+------------------------------------+-------+┌──[root@vms154.liruilongs.github.io]-[/]└─$

plugin-load=rpl_semi_sync_slave=semisync_slave.sorpl_semi_sync_slave_enabled=1

┌──[root@vms155.liruilongs.github.io]-[/]└─$vim /etc/my.cnf 31L, 879C 已写入┌──[root@vms155.liruilongs.github.io]-[/]└─$cat /etc/my.cnf[mysqld]
plugin-load=rpl_semi_sync_slave=semisync_slave.sorpl_semi_sync_slave_enabled=1
server_id=155# 字符集init_connect='SET collation_connection = utf8_unicode_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_unicode_ciskip-character-set-client-handshake
datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Settings user and group are ignored when systemd is used.# If you need to run mysqld under a different user or group,# customize your systemd unit file for mariadb according to the# instructions in http://fedoraproject.org/wiki/Systemd
[mysqld_safe]log-error=/var/log/mariadb/mariadb.logpid-file=/var/run/mariadb/mariadb.pid
## include all files from the config directory#!includedir /etc/my.cnf.d┌──[root@vms155.liruilongs.github.io]-[/]└─$systemctl restart mariadb.service

┌──[root@vms155.liruilongs.github.io]-[/]└─$mysql -uroot -pliruilong -e'show variables like "%semi%";'+---------------------------------+-------+| Variable_name                   | Value |+---------------------------------+-------+| rpl_semi_sync_slave_enabled     | ON    || rpl_semi_sync_slave_trace_level | 32    |+---------------------------------+-------+┌──[root@vms155.liruilongs.github.io]-[/]└─$