Hi, I'm afraid the current implementation does not support it. Of course this could be changed, actually I guess it would be relatively easy to remove the check.
At some point I think it's better to re-implement clustering. But first my priority is to work on the new storage engine (the MVStore), I plan to use this mechanism as the base for the new clustering. Regards, Thomas Am 12.11.2013 02:40 schrieb "Adam McMahon" <a...@cs.miami.edu>: > H2 Group, > > I am checking out the clustering features of H2. I know that the > clustering features are fairly barebones. I am interested in > using clusters/replication for increased performance, as opposed to simply > having a failsafe DB online (which is also a good thing :). > > In the past, using MySQL replication, I would send write queries to the > master (which would eventually be propogated), and then I would load > balance between the master/slaves for read queries. I would do this at the > application level by simply changing the JDBC url depending on if the SQL > was a write or a read. The slaves might be a little behind the master, but > that was fine for many of my queries. > > I know that load balancing is not a built in feature to H2 clustering, but > I figured I may be able to accomplish it at the application level using > something like the above. However, it seems that I am not able to do so, > as client connections to an individual server with in a cluster are > rejected. I appears we can only connect to using the server list url. > > My question: is there any way to load balance reads across a slave? > > Thanks, -Adam > > -- > 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/groups/opt_out. > -- 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/groups/opt_out.
