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" <[email protected]>: > 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 [email protected]. > To post to this group, send email to [email protected]. > 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
