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.
