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

Felix Frank ff at mpexnet.de
Wed Mar 30 15:46:56 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.


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



More information about the drbd-user mailing list