Hi Neal, right now I don't have the time to advance over this , digging the code of tracing features. Trace data have a big part of information needed to do a transaction log retention (in sql) but surely isn't the best place to get this information just a casual gift. Other feature that probably has some handling useful to retain transactions can be the CREATE CLUSTER that synchronize a slave node; it's another code to digg.
Anyway all this would be just a start point or a suggestion to create a new feature in H2 that has to be approved and supported by Thomas. El 17/03/10 23:35, [email protected] escribió: > We looked at all the transaction logging, but found that there was no > clean way to get the DML statements. And I agree, that would really > be a great way to handle the replication, as we would essentially just > be playing back logs. Unfortunately it does not seem that there is a > way to do that with H2 right now (although I might be missing it) > I'm sure that must will be a better way to do that. But if actual features with some arrangement are close , we can work on it or suggest a feature request. > We also took a look at SymmetricDS. The overhead of the extra tables/ > columns and the relatively heavyweight replication was not ideal for > us. > I was looked it some time ago , seems very complete, consistent , well defined and ideal for large scale scenarios ; but in my opinion it's over-sized for some use cases. No matter that log retention it's a very desirable feature and the choice of many databases as the vehicle for replication, incremental backups and recovery. > So, sadly, we are using triggers (well -- one trigger over and over > again) on individual tables (they do not work on the session table). > The end result will be fine, but it will be quite a bit of code to get > the change objects cleanly converted to SQL. regards, Dario -- 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.
