Register
Login
Contribute
Subscribe
RSS
News
FAQForge
ISPConfig
Subscribe
Contribute
Forums
Howtos
Navigation
Howtos
Linux
Android
CentOS
Debian
Fedora
Kernel
Mandriva
PCLinuxOS
SuSE
Ubuntu
Web Server
Apache
Cherokee
Lighttpd
nginx
Backup
Control Panels
ISPConfig
DNS
BIND
MyDNS
PowerDNS
djbdns
Desktop
Email
Anti-Spam/Virus
Postfix
FTP
High-Availability
Lighttpd
Monitoring
MySQL
Programming
C/C++
PHP
Samba
Security
Anti-Spam/Virus
Storage
Virtualization
KVM
OpenVZ
VMware
VirtualBox
Xen
Other
FreeBSD
Commercial
Mini-Howtos
Linux
Apache
Backup
DNS
Errors
FTP
MySQL
Networking
PHP
Postfix
Security
Sendmail
Shell
Other
ISPConfig
Forums
Contribute
Create Content
Subscription
Login
Site Map/RSS Feeds
Facebook
News
SugarCRM: Big Growth Now, Exit Strategy Later?
Caitlyn Martin Joins Linux Advocates
Google engineers discuss fragmentation, hardware, and Project Butter
Ubuntu Linux Community: Canonical to Close Brainstorm Web Portal?
Mageia 3 Arrives: All Grown Up and Ready to Go Dancing
How to use the "tee" command
24 Peachy Free Linux Games (Part 2 of 4)
Canonical's Mir for Ubuntu Linux: New Open Source Innovations?
Wikiweapons and Printing 3D Guns. It's Just a Stalking Horse for What's to Come
Nick Carr's 'IT Doesn't Matter' still matters
more
Recent comments
Nice Guide Of Lamp
2 days 1 hour ago
THANKS Falko
2 days 10 hours ago
Tested on PfSense 2.0.3, VMWare ESXi5.1 and VMWare Player 5.0.1
2 days 13 hours ago
No guarantee?
2 days 14 hours ago
Problems with SSL logins on IMAP and POP
2 days 16 hours ago
Last step
2 days 17 hours ago
remove kvm to install vmplayer
2 days 19 hours ago
Re: Re: Re: Re: Apache Configuration
2 days 20 hours ago
playsms webpage wont send
3 days 12 hours ago
Re: master details in slave my.cnf not explicitly needed
3 days 13 hours ago
Newsletter
Subscribe to HowtoForge Newsletter
and stay informed about our latest HOWTOs and projects.
(To unsubscribe from our newsletter, visit this
link
.)
English
|
Deutsch
|
Site Map/RSS Feeds
|
Advertise
HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials
>
Linux Forums
>
HOWTO-Related Questions
multiple master replication with mysql 5
User Name
Remember Me?
Password
Register
FAQ
Members List
Social Groups
Calendar
Search
Today's Posts
Mark Forums Read
Do you like HowtoForge? Please consider supporting us by
becoming a subscriber
.
Thread Tools
Display Modes
#
1
25th October 2008, 14:43
tanoy999
Junior Member
Join Date: Feb 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
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
tanoy999
View Public Profile
Send a private message to tanoy999
Find all posts by tanoy999
Sponsored Links
#
2
25th October 2008, 20:56
marchost
Junior Member
Join Date: Feb 2008
Posts: 27
Thanks: 1
Thanked 4 Times in 4 Posts
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
.
marchost
View Public Profile
Send a private message to marchost
Find all posts by marchost
Bookmarks
Digg
del.icio.us
StumbleUpon
Google
«
Previous Thread
|
Next Thread
»
Thread Tools
Show Printable Version
Email this Page
Display Modes
Linear Mode
Switch to Hybrid Mode
Switch to Threaded Mode
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 Rules
Forum Jump
User Control Panel
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
Linux Forums
HOWTO-Related Questions
Installation/Configuration
Server Operation
Desktop Operation
Kernel Questions
Programming/Scripts
Technical
Suggest HOWTO
ISPConfig 3
General
Installation/Configuration
ISPConfig 3 Priority Support
Plugins/Modules/Addons
Tips/Tricks/Mods
Feature Requests
Developers' Forum
ISPConfig 2
General
Installation/Configuration
Tips/Tricks/Mods
Feature Requests
Developers' Forum
MyDNSConfig
General
Other Forums
Smalltalk
Forum Suggestions
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
10:49
.
Contact Us
-
HowtoForge - Linux Howtos and Tutorials
-
Archive
-
Top
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2013, vBulletin Solutions, Inc.
Recent comments
2 days 1 hour ago
2 days 10 hours ago
2 days 13 hours ago
2 days 14 hours ago
2 days 16 hours ago
2 days 17 hours ago
2 days 19 hours ago
2 days 20 hours ago
3 days 12 hours ago
3 days 13 hours ago