Hi Thomas Is it possible to do a copy of the source database files to the target server (via FTP or other means). Then start H2 on both servers, and enable clustering?
Would there be any issues with that? Best regards On Monday, April 14, 2014 8:51:17 PM UTC+2, Thomas Mueller wrote: > > Hi, > > The CreateCluster tool will not work well with large databases. Do to the > various limitations, the whole clustering solution within probably be > replaced at some point, maybe with the H2HA project, and / or with MVStore > clustering. I recommend to try the H2HA project. > > H2HA: https://github.com/shesse/h2ha > > Regards, > Thomas > > > On Wednesday, April 9, 2014, nfogh <nikol...@gmail.com <javascript:>> > wrote: > >> Hi >> >> I am using the CreateCluster tool to do replication of a database. >> >> I have two servers connected via a 1Gbps LAN. Setting up clustering takes >> around 1 hour each time for a 10GB database. Can this be right? >> >> I suspect that network latency is eating up the throughput, so I modified >> RunScript to send statements in batches. I noticed that I do not gain much >> improvement when using batches (addBatch(), executeBatch()) instead of >> several single execute() statements. >> >> Does H2 actually bundle the statements, or is the client just issuing >> several execute() statements in a loop? >> >> Thanks, >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to h2-database+unsubscr...@googlegroups.com. >> To post to this group, send email to h2-database@googlegroups.com. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
