MariaDB 10.3 master-slave semi-synchronous replication

This article introduces MariaDB master-slave semi-synchronous replication, based on the previous article "MariaDB 10.3 master-slave replication," introducing master-slave semi-synchronous replication configuration.

1. profile

MariaDB has added semi-synchronous plug-ins to Server since 10.3.3, so there is no need to load plug-ins when configuring master-slave semi-synchronization. The MariaDB version used in this article is 10.3.7.

2. View semi-synchronous replication parameters

MariaDB01 Master

MariaDB02 from

3. Initiate semi-synchronous replication

MariaDB01

master enable command: SET GLOBAL rpl_semi_sync_master_enabled = 1;

MariaDB02

slave enable command: SET GLOBAL rpl_semi_sync_slave_enabled = 1;

restart slave thread: stop slave;

start slave;

4. View semi-synchronous status

MariaDB01 Master

SHOW GLOBAL VARIABLES LIKE '%semi%';

SHOW GLOBAL STATUS LIKE 'rpl_semi%';

MariaDB02 from

SHOW GLOBAL VARIABLES LIKE '%semi%';

SHOW GLOBAL STATUS LIKE 'rpl_semi%';

At this point, MariaDB master-slave semi-synchronous configuration is complete.