MySQL JDBC Load Balancing with MySQL Cluster
November 28, 2008
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
Trackbacks
Trackback Address: 684/3EFF38C979A69DFD01019743AC7ACD9B
Comments
On 11/28/2008 at 12:16:15 PM EST O?uz Demirkap? wrote:
1
Thanks Pete.
Great tip!
Post a Comment
Recent Entries
- Cache Template in Request Setting Explained
- What Version of Java is ColdFusion Using?
- ColdFusion 9 Performance Brief from Adobe
- Request Filtering in IIS 7 Howto
- J2EE Session Cookies on ColdFusion / JRun
- Hands on ColdFusion Security Training
- ColdFusion 9 Solr Vulnerability - Are you at Risk?
- FCKEditor Year 2010 Bug for Firefox 3.6 with ColdFusion
Great tip!



add to del.icio.us



