Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

MariaDB 10.3 master-slave semi-synchronous replication

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

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.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report