A little background... My development team has been using postgresql for years and we have a nagging problem that it lacks good master slave replication (over a wan). After replication being dropped from 8.4 I am looking for other solutions.
I am interested in H2 in that its written in Java, and if I need too I can contribute. I looked through the docs and it doesn't look like H2 implements master-slave replication, only master-master via statement propagation to both instances. This wouldn't work over the WAN in that you can easily get into a split brain situation. So I was hoping I might be able to write what I want on top of H2. Here is what I am looking for: 1) Master keeps a transaction log of all INSERT, UPDATE, DELETE, CREATE, ALTER statements. (anything that changes the db) 2) No triggers, I don't want to alter schema to support this. 3) Slave is in read only mode, and knows what its last transaction id is. 4) Slave runs job on defined schedule that sends last transaction id to master asking for all transactions since its last. 5) Master responds with all transactions since given last transaction id. 6) Slave executes received transactions. 7) If slave is unable to connect to master, keep trying on schedule until max_tries is reached and send email notification. So my question is, does H2 have the necessary internals for someone to go write this? Any pointers at where to begin? Is there an API for reading the database.X.log.db files? Will they contain the info I need? Thank you in advance, Jacob --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
