Thank you very much for advices. I'm going to test your propositions and I'll let you know how they've worked.<br><br>Regards,<br>Mateusz<br><br><div class="gmail_quote">2011/3/30 Bart Coninckx <span dir="ltr"><<a href="mailto:bart.coninckx@telenet.be">bart.coninckx@telenet.be</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div class="h5"><br>
<br>
On 03/30/11 15:46, Felix Frank wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div class="h5">
On 03/29/2011 11:37 PM, Mateusz Kalisiak wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hello Everyone,<br>
<br>
I'd like to setup the standard MySQL-DRBD-HA architecture:<br>
- PRIMARY server with MySQL and mounted /dev/drbd0,<br>
- SECONDARY just being standalone and waiting for failover.<br>
Additionally, during normal cluster activity (primary server is fine and<br>
active) I'd like to perform backup of MySQL data, but using only<br>
SECONDARY node.<br>
Did anyone tried such thing?<br>
Maybe such feature would be available somehow in ACTIVE-ACTIVE<br>
architecture (although according to MySQL docs it's not<br>
<a href="http://dev.mysql.com/doc/refman/5.0/en/drbd-architecture.html#qandaitem-B-14-3-1-1" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/drbd-architecture.html#qandaitem-B-14-3-1-1</a><br>
)<br>
</blockquote>
<br>
Hi,<br>
<br>
application level backup from your secondary will not readily work.<br>
<br>
In many cases, you can disconnect DRBD and make binary copies (using dd)<br>
from your secondary's backing device. If such a binary copy is good<br>
enough for you, you can probably go that way.<br>
<br>
Cheers,<br>
Felix<br></div></div><div class="im">
_______________________________________________<br>
drbd-user mailing list<br>
<a href="mailto:drbd-user@lists.linbit.com" target="_blank">drbd-user@lists.linbit.com</a><br>
<a href="http://lists.linbit.com/mailman/listinfo/drbd-user" target="_blank">http://lists.linbit.com/mailman/listinfo/drbd-user</a><br>
</div></blockquote>
<br>
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.<br>
<br>
It's interesting to try I think.<br><font color="#888888">
<br>
B.<br>
<br>
</font></blockquote></div><br>