JDBC MySQL Load Balancing / Failover

[Nik Ambrosch]

Is anyone running Jira Server or Datacenter in production using any of the multi-host connection parameters enabled in the MySQL connector?

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-multi-host-connections.html

I have a Percona XtraDB cluster and have always used an haproxy server to load balance between the three nodes, however it might be more efficient to let the MySQL connector do the legwork instead.

During my testing Jira seems to connect fine but analytics doesn't seem very happy and I'm not sure what else may not function correctly.

Thanks!