-
1. How to Synchronise Backups of Database and HornetQ Journals
rhinmass Mar 26, 2011 9:14 AM (in response to jnakatabe)I'm also new, but I'll take a stab. It seems like you might want to use global transactions so that you always update the database and message queue in the same transaction.
How do you back up your database? Do you lock it, so that the db backup is consistent with itself? If so, can you copy the journals while the db is locked?
-
2. Re: How to Synchronise Backups of Database and HornetQ Journals
jnakatabe Mar 26, 2011 9:39 AM (in response to rhinmass)Yes, I use global transactions. Once I recover DB and HornetQ journals, it is important that the set of existing messages exactly matches the states of the correspondent entities.
And I don't understand what you mean with the DB backup being consistent with itself by lock. Doesn't it require a JBoss shutdown if I lock the underlying DB? I would rather like to do the backup while DB and application server keep running. It might become too much a down time if I shut down the server for every backup.