HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Master Master replication questions and problems (http://www.howtoforge.com/forums/showthread.php?t=26955)

marchost 19th September 2008 17:56

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

falko 20th September 2008 13:28

Quote:

Originally Posted by marchost (Post 145845)
1)If server1 reboot, will it resync automatically with server2 upon restart?

Yes, provided that the server's downtime is < expire_logs_days. If not, then there are no logs so that the server doesn't know what to replicate.


Quote:

Originally Posted by marchost (Post 145845)
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???

What is important is that Slave_IO_Running and Slave_SQL_Running both show Yes.
The servers might not always be 100% in sync - depending on network load or server load it can take a few seconds until a server catches up.

If you need to repair replication, this tutorial might be interesting: http://www.howtoforge.com/how-to-rep...ql-replication

marchost 22nd September 2008 07:10

Great...
 
Thanks for your answer Falko...

I successfully build a load balanced + high availability server (currently in production) on 2 real servers running Xen (instead of having 4 servers...) with http, mysql, mail and dns based on many of your howtos...

Im almost done writing an howto about it, will post it on howtoforge when it will be completed but you can take a peak :

http://blogama.org/?q=node/21

Marc

falko 23rd September 2008 20:44

Looks great! I'd love to see it on HowtoForge. :)

marchost 3rd October 2008 19:04

Done...
 
Just put up the howto on howtoforge last night (took me 3-4h formatting the tutorial from my website :( )...

Soon will start working on a better version with shared high availability NFS for mail & web files instead of rsync, more user friendly interface (DNS, mail config, etc) and vmware.

Its totally unrelated but i benchmarked the xen kernel with unixbench on 3 computers and I always get 50% of the score compared with the standard kernel. Do you think vmware would give better performance? Maybe unixbench is not a good real life benchmark?

Marc

falko 4th October 2008 13:50

Quote:

Originally Posted by marchost (Post 148346)
Just put up the howto on howtoforge last night (took me 3-4h formatting the tutorial from my website :( )...

Thanks a lot, will publish it soon! :)

Quote:

Originally Posted by marchost (Post 148346)
Its totally unrelated but i benchmarked the xen kernel with unixbench on 3 computers and I always get 50% of the score compared with the standard kernel. Do you think vmware would give better performance? Maybe unixbench is not a good real life benchmark?

Maybe with VMware ESX, but not with VMware Server. You might also want to try OpenVZ.


All times are GMT +2. The time now is 04:22.

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