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


Related Entries

4 people found this page useful, what do you think?

Trackbacks

Trackback Address: 684/3EFF38C979A69DFD01019743AC7ACD9B

Comments

On 11/28/2008 at 2:16:15 PM EST O?uz Demirkap? wrote:
1
Thanks Pete.

Great tip!

On 12/22/2011 at 12:14:58 AM EST Manuel Galgana wrote:
2
Is there any way I can use that loadbalance when I am using XaDatasource?

Post a Comment




  



Spell Checker by Foundeo

Recent Entries



foundeo


did you hack my cf?