Live Backups of MySQL Using Replication
Subject:   bi-directional replication
Date:   2005-06-20 15:39:46
From:   sakshale
I have two web servers. Both run a server management system based on MySQL databases. (So, they both have databases with the same name, but different content.) I currently back them up with a nightly mysql dump of each individual database, without taking down the servers. Could they (easily) be configured to use replication to back each other up, without the database name collisions being an issue?
Full Threads Newest First

Showing messages 1 through 1 of 1.

  • bi-directional replication
    2005-07-08 10:50:40  ugob [View]

    I don't think a master-master relationship is supported at this time. Maybe in new, future release. I read somewhere that it is possible, but unsupported by MySQL team.