Setting up Multi-Master JDBC for MySQL/Galera
Submitted by alex on Wed, 07/06/2011 - 18:04
Henrik Ingo has advised us that there is a native multi-master support in MySQL JDBC!:
jdbc:mysql:loadbalance://<node1>,<node2>,...<nodeN>/<database>?loadBalanceBlacklistTimeout=5000
This is great news as it allows to avoid using intermediate load balancer (which kills performance and complicates the whole system).
Full discussion here. Initially it was targeted to NDB cluster, but it can be used with MySQL/Galera just as well.
- Log in to post comments
