Labels

Android (1) Apache (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 (5) git (5) GitHub (4) Hacking (3) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (33) javascript (3) Linux (171) Mac (20) Machine Learning (1) mySQL (50) Netbeans (5) Networking (1) Nexus (1) OpenVMS (6) Oracle (2) Pandas (3) php (17) 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)

Thursday, 8 January 2026

MariaDB GTID position reset

On Master, do SELECT @@gtid_current_pos;
then on Slave, do SET GLOBAL gtid_slave_pos = 'GTID_FROM_SERVER_1';

if need be do;

CHANGE MASTER TO
  MASTER_HOST='server1',
  MASTER_USER='replica_user',
  MASTER_PASSWORD='password',
  MASTER_USE_GTID=slave_pos;

then;

Start Slave;

SHOW SLAVE STATUS/G;

A note on the above, do it quickly, in case the position changes.

SELECT @@gtid_slave_pos, @@gtid_current_pos; should show the same.

No comments:

Post a Comment

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