Bug #2300 Built-in mySQL synchronization between two mySQLs

• Submitted: 6 Jan 2004 17:06
• Modified: 7 Jan 2004 3:32
• Reporter: Scott Fletcher
• Status: Closed
• Category: MySQL Server
• Severity: S4 (Feature request)
• OS: Any (ALL)
• CPU Architecture: Any

[6 Jan 2004 17:06] Scott Fletcher

Description:
A wishlist for mySQL to have synchronization feature between two mySQLs for keeping two seperate databases up to date while they are running.  That way if one  machine where mySQL reside on, goes down then the other machine with the existing mySQL on it, will take over until the downed machine goes back up.  It is very useful to keep the databases up-to-date.  Relexus Linter, MS-SQL and a couple of other database softwares have this feature, so it would be nice to see one in mySQL one day.

Searched the mySQL bug database and found none for this similiar bug report, so filed the bug report.

How to repeat:
N/A

[7 Jan 2004 3:32] Guilhem Bichot

Hi,

Such need is adressed by the current MySQL replication, which keeps 2 databases on 2 machines identical. Documentation is here:
http://www.mysql.com/doc/en/Replication.html
You may need circular replication, which is discussed at:
http://www.mysql.com/doc/en/Replication_Features.html

Regards,
Guilhem