I guess you can set up DRBD as active-active so you can access the DRBD storage on both nodes and setup MySQL as active-passive. I'm not sure about the coherency of the FS on the back up node though even if you will mount it as RO but you will be safe if you are using a clustered FS but in such a case it will add more complexity to the setup and generally speaking two nodes active-active cluster is fragile and might end up with many brain-split situations.
Cheers, n Abraham From: [email protected] [mailto:[email protected]] On Behalf Of Mateusz Kalisiak Sent: Wednesday, 30 March 2011 8:37 AM To: [email protected] Subject: [DRBD-user] Backing up MySQL data in DRBD Cluster Hello Everyone, I'd like to setup the standard MySQL-DRBD-HA architecture: - PRIMARY server with MySQL and mounted /dev/drbd0, - SECONDARY just being standalone and waiting for failover. Additionally, during normal cluster activity (primary server is fine and active) I'd like to perform backup of MySQL data, but using only SECONDARY node. Did anyone tried such thing? Maybe such feature would be available somehow in ACTIVE-ACTIVE architecture (although according to MySQL docs it's not http://dev.mysql.com/doc/refman/5.0/en/drbd-architecture.html#qandaitem-B-14-3-1-1 ) Regards, Mateusz
_______________________________________________ drbd-user mailing list [email protected] http://lists.linbit.com/mailman/listinfo/drbd-user
