Pete Freitag Pete Freitag

MySQL JDBC Load Balancing with MySQL Cluster

databases

Here's a neat tip posted by Henrik Ingo from the MySQL Telecom Team

It's not really properly documented in the manual part, but I found in the changelogs, and confirmed on IRC that to do load-balancing across the SQL nodes in MySQL Cluster, you would use a different JDBC connection string with the "loadbalance" keyword added...
jdbc:mysql:loadbalance://host-1,host-2,...host-n/database?loadBalanceBlacklistTimeout=5000

Like this? Follow me ↯

MySQL JDBC Load Balancing with MySQL Cluster was first published on November 28, 2008.

If you like reading about mysql, jdbc, cluster, or load balancing then you might also like: