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

Bart Coninckx bart.coninckx at telenet.be
Wed Mar 30 20:48:07 CEST 2011



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.



More information about the drbd-user mailing list