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.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th October 2008, 14: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
  #2  
Old 25th October 2008, 20:56
marchost marchost is offline
Junior Member
 
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts
 
Default

Try circular replication....

A--------------B
|................|
|................|
D--------------C

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

Marc

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

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


All times are GMT +2. The time now is 16:40.


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