<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<font size="2"><b>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.
<br />
<br />In this way your data is frozen at a point in time on the secondary so the data should be consistent.
<br />
<br />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.
<br />
<br />Cheers,
<br />David Go
<br />
<br />On Tue, 29 Mar 2011 23:37:20 +0200, Mateusz Kalisiak wrote</b>
<br />> Hello
Everyone,
<br />>
<br />> I'd like to setup the standard MySQL-DRBD-HA
architecture:
<br />> - PRIMARY server with MySQL and mounted
/dev/drbd0,
<br />> - SECONDARY just being standalone and waiting for
failover.
<br />> 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.
<br />>
Did anyone tried such thing?
<br />> Maybe such feature would be available
somehow in ACTIVE-ACTIVE architecture (although according to MySQL docs it's
not <a href="http://dev.mysql.com/doc/refman/5.0/en/drbd-architecture.html#qandaitem-B-14-3-1-1">http://dev.mysql.com/doc/refman/5.0/en/drbd-architecture.html#qandaitem-B-14-3-1-1</a>
)
<br />>
<br />> Regards,
<br />> Mateusz
<br />
<br />
<br />David Go
<br />
for iPayroll Ltd
<br />
----
<br />
iPayroll
<br />
Phone: +64 9 377-1517
<br />
Fax: +64 9 377-1529
<br />
<br />
</font>
</BODY>
</HTML>