Ignition with mySQL InnoDB cluster

Is there any way to setup the database connection to high availability mySQL cluster? It seems not possible to setup 3 db hosts directly in connection URL.

MySQL :: MySQL 8.4 Reference Manual :: 23 InnoDB Cluster

Most clusters only use a single entry point "router" or load balancer, thats what Ignition would talk to, not all three databases.

2 Likes

Thanks for the reply. I got the point that we were missing the ‘router’ part.

Not available with the setup like this:

jdbc:mysql://host1,host2,host3/db