MySQL Master/Slave Load Balancing with JPA and Spring - Dragisa Krsmanovic

MySQL Connector/J driver has built-in feature for load balancing. If you have a cluster of read/write MySQL servers. Putting loadbalance: in the JDBC URL will ensure both read and write operations are distributed across servers. jdbc:mysql:loadbalance://master1,master2,master3…/database?loadBalanceBlacklistTimeout=5000&loadBalanceConnectionGroup=cgroup&loadBalanceEnableJMX=true&autoReconnect=true&

[oinume]

master/slave構成にする場合、MySQLのドライバでスレーブへの分散設定を行い、Slaveを見に行かせたい時はServiceクラスのメソッドにアノテーションつける。EntityManagerからConnection取るやり方が参考になる。