Labels

Android (1) bash (2) boost (2) C (34) C++ (2) cheatsheet (2) CLion (6) css (3) Debian (33) DL (17) Docker (2) Dreamweaver (2) Eclipse (3) fail2ban (4) git (5) GitHub (4) Hacking (3) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (31) javascript (3) Linux (169) Mac (19) Machine Learning (1) mySQL (49) Netbeans (4) Networking (1) Nexus (1) OpenVMS (6) Oracle (1) Pandas (3) php (16) Postgresql (8) Python (9) raid (1) RedHat (14) Samba (2) Slackware (48) SQL (14) svn (1) tar (1) ThinkPad (1) Virtualbox (3) Visual Basic (1) Visual Studio (1) Windows (2)

Tuesday, 17 December 2024

Reset mySQL (mariadb) master/slave with GTID replication

To reset and start fresh, do;

1) RESET BINARY LOGS AND GTID STATE:

STOP SLAVE;
RESET SLAVE ALL; (note ALL means we need to reconfigure the master as per step 2)
RESET MASTER; (if it is a master)
SET GLOBAL gtid_slave_pos = '';

2) RECONFIGURE REPLICATION:

CHANGE MASTER TO
MASTER_HOST='master_host',
MASTER_USER='replication_user',
MASTER_PASSWORD='replication_password',
MASTER_PORT=3306,
MASTER_USE_GTID=slave_pos;

3) START REPLICATION:

START SLAVE;
 

 

 






No comments:

Post a Comment

Note: only a member of this blog may post a comment.