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
Old 25th October 2008, 15:43
tanoy999 tanoy999 is offline
Junior Member
Join Date: Feb 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default multiple master replication with mysql 5

I want howto multiple master replication with mysql 5 in centos / fedora,
example have 3 master or 4 master .etc.. ..... Thank you

from tanoy999 >>>>Thailand
Reply With Quote
Sponsored Links
Old 25th October 2008, 21:56
marchost marchost is offline
Junior Member
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts

Try circular replication....


A slave of D
B slave of A
C slave of B
D slave of C

In /etc/mysql/my.cnf (mysql config file)

auto-increment-offset = 1

Has to be changed. A=1, B=2, C=3, D=4

The rest should be pretty much the same as : http://howtoforge.com/mysql5_master_...on_debian_etch


Last edited by marchost; 25th October 2008 at 21:59.
Reply With Quote


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
mysql master to master replication question ubutux HOWTO-Related Questions 7 13th March 2009 18:07
Master Master replication questions and problems marchost HOWTO-Related Questions 5 4th October 2008 14:50
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
mysql master master replication not working SoftDux HOWTO-Related Questions 5 29th March 2007 15:31
Mysql Master Master replication stormrider HOWTO-Related Questions 5 16th February 2007 19:18

All times are GMT +2. The time now is 13:09.

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