In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.