pf » MySQL JDBC Load Balancing with MySQL Cluster
November 28, 2008
MySQL JDBC Load Balancing with MySQL Cluster
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
Related Entries
- Multiple Statements with MySQL and JDBC - May 16, 2005
Trackback Address: 684/3EFF38C979A69DFD01019743AC7ACD9B
Comments
On 11/28/2008 at 12:16:15 PM MST O?uz Demirkap? wrote:
1
Thanks Pete.
Great tip!
- ColdFusion 8 FCKeditor Vulnerability
- Ajax Same Origin Policy No More with Firefox 3.5
- Firefox 3.5 Introduces Origin Header, Security Features
- Tips for Secure File Uploads with ColdFusion
- 7 Years And Blog Entry Number 700
- CFCatch Java Exceptions
- Cheat Sheet for SQL Server
- CFML on Google App Engine for Java
Subscribe to my RSS Feed:
RSS
RSS
add to del.icio.us
Pete Freitag is a software engineer, and web developer located in











