<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>