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.