LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-15-2017, 09:54 PM   #1
packets
Member
 
Registered: Oct 2005
Posts: 328

Rep: Reputation: 32
mysql master to master replication how to resync


I encountered an error on my setup due to issue on my machine. Lets say Node1 and Node2. Update in Node1 is replication to Node2 and update in Node2 is replication to Node1. MySQL master to master replication is now working fine but there is discrepancies. I believe there is missing data before the replication got fix.

Slave_IO_State: Waiting for master to send event
Slave_IO_Running: Yes
Slave_SQL_Running: Yes

Since replication is now working. The good data is in Node1. How can I copy the missing data to Node2? It will take days if I will use mysqldump to transfer data Node2

mysql> use node1db;select count(id) from log;
Database changed
+-----------+
| count(id) |
+-----------+
| 4154583 |

mysql> use node2db;select count(id) from log;
Database changed
+-----------+
| count(id) |
+-----------+
| 4150386 |
+-----------+
1 row in set (1.24 sec)
 
Old 05-15-2017, 11:44 PM   #2
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Posts: 946

Rep: Reputation: 216Reputation: 216Reputation: 216
On day end, delete all data in node2 (after full back up for safety) and replicate fully from node1.

OK
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Setting up Master-Master Replication with MySQL on Debian 8 (Jessie) LXer Syndicated Linux News 0 09-28-2015 09:03 PM
LXer: MySQL Master to Master Replication, Heartbeat, DRBD, Apache/PHP/Varnish MegaHOWTO LXer Syndicated Linux News 0 10-09-2014 02:21 AM
MySQL Master-Master Replication Setup (v5.5 CentOS6.3 / Ubuntu 12.04) fruitwerks Linux - Server 1 08-20-2013 12:13 AM
LXer: Setting Up Master-Master Replication On Four Nodes With MySQL 5 On Debian Etch LXer Syndicated Linux News 0 11-20-2008 07:30 PM
LXer: Setting Up Master-Master Replication With MySQL 5 On Debian Etch LXer Syndicated Linux News 0 10-25-2007 10:42 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:06 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration