Multiple master hosts in JDBC connection string

[Serhiy Chupov]

Hi there,

My problem is the following: I need to set multiple hosts in JDBC connection string, like jdbc:mysql://192.168.0.1,192.168.0.2/mydb, but every one of them should be a master, not a slave, for me to have opportunity to write to second host if the first fails. Also they will all be working on the same port, so I would like to write port number just one time, but if it's impossible, string like jdbc:mysql://192.168.0.1:3306,192.168.0.2:3306/mydb also fits.

Thanks in advance