<div dir="ltr">Hi,<br><br>I've been looking into this, and one additional solution from the erlang land seems to be possible using the functions described in this document:<br><br><a href="http://www.erlang.org/doc/apps/mnesia/Mnesia_chap7.html#id74479">http://www.erlang.org/doc/apps/mnesia/Mnesia_chap7.html#id74479</a><br>
<br>Assuming that backing up mnesia is all what's needed.<br><br>Unfortunately, I couldn't find any ready-to-use tools that abstract the mnesia routines described in the document above, making them accessible to the average system administrator.<br>
<br>Best Regards,<br><br><div class="gmail_quote">On Wed, Oct 27, 2010 at 10:43 AM, Alex Lovell-Troy <span dir="ltr"><<a href="mailto:alex.lovelltroy@gmail.com">alex.lovelltroy@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
We've been tackling this problem as well for transactional persistent messages on durable queues in a very low traffic situation. Our solution was to write a small wrapper around the transaction that also commits the message content to a database and then transactionally deletes the message from the database as part of the ack. The wrapper also stores information about the queues and routing on startup. With that, an additional small script can recreate our queues in the case of host death. It's certainly not fast, but it is durable and keeps us from using the anti-pattern of polling the database for status changes.<div>
<br></div><div>Since our queues and routing don't change very often, we think that a slow/triggered update of that information is good enough which only leaves the messages themselves. We've been thinking of using erlang directly to bind to the ETS table on the rabbitmq host and dump the messages to a fresh ETS table on another node for a less db-centric backup/HA option. We're still not sure if that's a good idea or if it is workable, but it may point you in another direction.</div>
<div><br></div><div>I'd be happy to hear if anyone else has already ascertained if this route is fraught with danger.</div><div><br></div><div>-sascha</div><div><br></div><div><br><br><div class="gmail_quote"><div><div>
</div><div class="h5">On Tue, Oct 26, 2010 at 6:17 PM, Ahmed M. Osman <span dir="ltr"><<a href="mailto:a.medhat.cs@gmail.com" target="_blank">a.medhat.cs@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5"><div dir="ltr">Hello Friends,<div><br><div>i just have a little question about RabbitMQ backup and i hope that i can found the answer here</div>
<div><br></div><div>simply, i want to make backup and and restore system to my Rabbit server, mainly backup the <span style="font-family: Verdana,sans-serif; font-size: 13px; color: rgb(85, 85, 85); line-height: 18px;">persistent</span> messages, do i have to handle this using extra consumer that consume the messages then save it and enqueue it again in the queue ?</div>
<div><br></div><div>or backuping <span style="font-family: Verdana,sans-serif; font-size: 13px; color: rgb(85, 85, 85); line-height: 18px;">Mnesia</span>, but according to the following link</div>
<div><a href="http://www.rabbitmq.com/faq.html#migrate-to-another-machine" target="_blank">http://www.rabbitmq.com/faq.html#migrate-to-another-machine</a></div><div>i think backupping <span style="font-family: Verdana,sans-serif; font-size: 13px; color: rgb(85, 85, 85); line-height: 18px;">Mnesia</span> won't be a good solution.</div>
<div><div><br></div><div>and if backuping <span style="font-family: Verdana,sans-serif; font-size: 13px; color: rgb(85, 85, 85); line-height: 18px;">Mnesia</span> is the solution are there a way to use any other language to make this backup other than using Erlang or any command or command line tool.</div>
<div><br><div dir="ltr"><i><span style="font-family: arial,sans-serif; font-style: normal; font-size: 13px; border-collapse: collapse;"><font face="'courier new', monospace">-- <br></font><div dir="ltr"><i><div><font face="'courier new', monospace">Kind Regards,<br>
<br>Ahmed<br></font></div></i></div></span></i></div><br>
</div></div></div></div>
<br></div></div>_______________________________________________<br>
rabbitmq-discuss mailing list<br>
<a href="mailto:rabbitmq-discuss@lists.rabbitmq.com" target="_blank">rabbitmq-discuss@lists.rabbitmq.com</a><br>
<a href="https://lists.rabbitmq.com/cgi-bin/mailman/listinfo/rabbitmq-discuss" target="_blank">https://lists.rabbitmq.com/cgi-bin/mailman/listinfo/rabbitmq-discuss</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________<br>
rabbitmq-discuss mailing list<br>
<a href="mailto:rabbitmq-discuss@lists.rabbitmq.com">rabbitmq-discuss@lists.rabbitmq.com</a><br>
<a href="https://lists.rabbitmq.com/cgi-bin/mailman/listinfo/rabbitmq-discuss" target="_blank">https://lists.rabbitmq.com/cgi-bin/mailman/listinfo/rabbitmq-discuss</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Amr Mostafa<br>Egypt Development Center<br>Member of NTG<br>Mobile: +(2012)1700502<br>Office: +(202)24052355/6 - Ext.: 2005<br>
</div>