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">On Tue, Oct 26, 2010 at 6:17 PM, Ahmed M. Osman <span dir="ltr"><<a href="mailto:a.medhat.cs@gmail.com">a.medhat.cs@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><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>_______________________________________________<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></div>