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
[email protected]
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.
_______________________________________________
drbd-user mailing list
[email protected]
http://lists.linbit.com/mailman/listinfo/drbd-user
