Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.
I don't use MYSQL myself, and you would want to double check, but from what I have read, I am pretty sure you could achieve this by creating DRBD on top of LVM, taking a snapshot of the LVM on the secondary, mounting that and backing up the raw database files. In this way your data is frozen at a point in time on the secondary so the data should be consistent. A gotcha I came across when doing something similar (but different database) was that LVM's create a huge write performance penalty, so make sure your disks are fast enough. Cheers, David Go On Tue, 29 Mar 2011 23:37:20 +0200, Mateusz Kalisiak wrote > 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 David Go for iPayroll Ltd ---- iPayroll Phone: +64 9 377-1517 Fax: +64 9 377-1529 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.linbit.com/pipermail/drbd-user/attachments/20110330/1b55e464/attachment.htm>