Shulou(Shulou.com)06/01 Report--

MariaDB master semi-synchronization, that is, both master-slave synchronizations enable semi-synchronous replication.

one。 MariaDB01 master MariaDB02 slave enables semi-synchronous replication

1. MariaDB01 Master

SET GLOBAL rpl_semi_sync_master_enabled = 1

2. MariaDB02 from

SET GLOBAL rpl_semi_sync_slave_enabled = 1

Stop slave

Start slave

two。 MariaDB02 master MariaDB01 slave enables semi-synchronous replication

1. MariaDB02 Master

SET GLOBAL rpl_semi_sync_master_enabled = 1

2. MariaDB01 from

SET GLOBAL rpl_semi_sync_slave_enabled = 1

Stop slave

Start slave

three。 View semi-synchronous status

1. MariaDB01

SHOW GLOBAL VARIABLES LIKE'% semi%'

SHOW GLOBAL STATUS LIKE 'rpl_semi%'

2. MariaDB02

SHOW GLOBAL VARIABLES LIKE'% semi%'

SHOW GLOBAL STATUS LIKE 'rpl_semi%'

At this point, the primary and primary semi-synchronous replication configuration is complete.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.