Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 19th September 2008, 17:56
marchost marchost is offline
Junior Member
 
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts
Default Master Master replication questions and problems

I set up a master master replication as explained by falko how-to.

It works but I ran in some problems.

Let say there is a replication between server1 and server2 (master-master)

1)If server1 reboot, will it resync automatically with server2 upon restart?

From what Ive seen, it doesnt seem to resync automatically but maybe I did something wrong.

Everytime I reboot a machine I have to :

stop slave;
reset slave;
reset master;
start slave;

because log position is not the same...

on both machines and then find tables that are not in sync with maatkit :

#mk-table-checksum h=server1,u=root,p=pass h=server2,u=root,p=pass | mk-checksum-filter

and resync tables - in this example table1 on db1 (on server1 that rebooted):

mk-table-sync --synctomaster --execute h=localhost,u=root,p=pass,D=db1,t=table1

2)My second question is about replication in general. Again I will suppose that server1 rebooted.

If I do (on server1)

show slave status;

I will get a "Read_Master_Log_Pos:" that does not match the output of "Position" :

(on server 2)
show master status;


Will the replication still work??? I mean, is it necessary to do stop slave, reset master, reset slave, start slave on both to restart the replication?

Any help would be greatly appreciated

Marc
Reply With Quote
Sponsored Links
 

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems and Questions Krrose27 Installation/Configuration 10 15th November 2007 12:37
Mysql Master Master replication stormrider HOWTO-Related Questions 5 16th February 2007 18:18
Multiple ISPConfig & DNS Questions and Problems bfriend Installation/Configuration 3 6th January 2007 06:14
Users and websites aren't created Glorfindel Installation/Configuration 9 23rd February 2006 04:20


All times are GMT +2. The time now is 02:42.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.