[DRBD-user] Backing up MySQL data in DRBD Cluster

Mateusz Kalisiak mk.spare999 at gmail.com
Thu Mar 31 10:48:16 CEST 2011

Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.


Thank you very much for advices. I'm going to test your propositions and
I'll let you know how they've worked.

Regards,
Mateusz

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
>>>
>>> http://dev.mysql.com/doc/refman/5.0/en/drbd-architecture.html#qandaitem-B-14-3-1-1
>>> )
>>>
>>
>> Hi,
>>
>> 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.
>>
>> Cheers,
>> Felix
>> _______________________________________________
>> drbd-user mailing list
>> drbd-user at lists.linbit.com
>> http://lists.linbit.com/mailman/listinfo/drbd-user
>>
>
> 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.
>
> B.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.linbit.com/pipermail/drbd-user/attachments/20110331/3d1b3cbf/attachment.htm>


More information about the drbd-user mailing list