Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - News > Syndicated Linux News
User Name
Syndicated Linux News This forum is for the discussion of Syndicated Linux News stories.


  Search this Thread
Old 10-25-2007, 11:42 PM   #1
LXer NewsBot
Registered: Dec 2005
Posts: 82,921

Rep: Reputation: 87
LXer: Setting Up Master-Master Replication With MySQL 5 On Debian Etch

Published at LXer:

Since version 5, MySQL comes with built-in support for master-master replication, solving the problem that can happen with self-generated keys. In former MySQL versions, the problem with master-master replication was that conflicts arose immediately if node A and node B both inserted an auto-incrementing key on the same table. The advantages of master-master replication over the traditional master-slave replication are that you do not have to modify your applications to make write accesses only to the master, and that it is easier to provide high-availability because if the master fails, you still have the other master.



Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL master-master replication monitor zafar466 Linux - General 0 10-06-2007 11:42 AM
Multiple Master to one Slave for MySQL Replication Swakoo Linux - General 0 03-31-2007 05:40 AM
ldap replication master - slave jadid Linux - Software 2 10-18-2006 12:25 PM
LXer: MySQL Master Master Replication LXer Syndicated Linux News 0 10-08-2006 11:54 AM
Master image replication? rbonafied Mandriva 6 10-05-2005 04:09 PM

All times are GMT -5. The time now is 03:24 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration