On 15/07/2015 8:51pm, Daniel Sanz wrote: > Hi, > > we are thinking in use Cayenne within MySQL and Galera cluster. Has anyone > any experience with this enironment?
I have no experience with Galera, but with a regular mySQL cluster there isn't much more to do at the application layer than add "jdbc:mysql:loadbalance" to the front of your JDBC connection [1]. I've done that with read only database connections in an application where a slave getting a few seconds behind would not cause any problems, and it was pretty simple. I don't know much about how you handle multi-master failure modes which could get much more complicated. I don't think that using Cayenne will make your infrastructure problems any different. Ari [1] http://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
