[DRBD-user] Backing up MySQL data in DRBD Cluster
mk.spare999 at gmail.com
Thu Mar 31 10:48:16 CEST 2011
Thank you very much for advices. I'm going to test your propositions and
I'll let you know how they've worked.
2011/3/30 Bart Coninckx <bart.coninckx at telenet.be>
> On 03/30/11 15:46, Felix Frank wrote:
>> On 03/29/2011 11:37 PM, 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
>> application level backup from your secondary will not readily work.
>> In many cases, you can disconnect DRBD and make binary copies (using dd)
>> from your secondary's backing device. If such a binary copy is good
>> enough for you, you can probably go that way.
>> drbd-user mailing list
>> drbd-user at lists.linbit.com
> What you also might try (at your own risk) is to have LVM involved,
> snapshot the whole deal in the secondary, mount it and start mysql with the
> mount as data directory. Next backup from there.
> It's interesting to try I think.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the drbd-user