MariaDB GTID-based replication
1. Configure the service profile of the master-slave node
1.1.Configuring master nodes:
# binlog_format=mixed
Binlog-format=ROW
# required unique id between 1 and 2 ^ 32-1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
Server-id = 1
Log-slave-updates=true
Master-info-repository=TABLE
Relay-log-info-repository=TABLE
Sync-master-info=1
Slave-parallel-threads=2
Binlog-checksum=CRC32
Master-verify-checksum=1
Slave-sql-verify-checksum=1
Binlog-rows-query-log_events=1
Report-port=3306
Report-host=www.pancou.com
1.2.Configuring slave nodes:
[mysqld]
# binlog_format=mixed
Binlog-format=ROW
# required unique id between 1 and 2 ^ 32-1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
Server-id = 2
Log-slave-updates=true
Master-info-repository=TABLE
Relay-log-info-repository=TABLE
Sync-master-info=1
Slave-parallel-threads=2
Binlog-checksum=CRC32
Master-verify-checksum=1
Slave-sql-verify-checksum=1
Binlog-rows-query-log_events=1
Report-port=3306
Report-host=www.pancou.com
MariaDB [(none)] > change master to master_host='192.168.110.128',master_port=3306,master_user='repl_user',master_password='pancou',master_use_gtid=current_pos
Query OK, 0 rows affected (0.06 sec)
MariaDB [(none)] > start slave
Query OK, 0 rows affected (0.01 sec)
MariaDB [(none)] > change master to master_host='192.168.110.130',master_port=3306,master_host='repl_user',master_password='pancou',master_use_gtid=current_pos
Query OK, 0 rows affected (0.03 sec)
MariaDB [(none)] > start slave
Query OK, 0 rows affected (0.02 sec)
MariaDB [(none)] > show slave status\ G
* * 1. Row *
Slave_IO_State: Connecting to master
Master_Host: repl_user
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File:
Read_Master_Log_Pos: 4
Relay_Log_File: www-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File:
Slave_IO_Running: Connecting
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: 4
Relay_Log_Space: 248
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: NULL
Master_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: 2
Master_SSL_Crl:
Master_SSL_Crlpath:
Using_Gtid: Current_Pos
Gtid_IO_Pos: 0-2-645
1 row in set (0.00 sec)
MariaDB [(none)] > show variables like 'slave_parallel%'
+-+ +
| | Variable_name | Value |
+-+ +
| | slave_parallel_max_queued | 131072 | |
| | slave_parallel_threads | 2 | |
+-+ +
2 rows in set (0.01sec)
