I have a mysql cluster setup and working. When connecting to it I specify one of the mysql nodes (mysqld) in my connection string. However, if this node goes down it doesn't automatically fail over to the other mysqld node (obviously). When someone creats an app to connect to the cluster do they simply specify each mysqld node in their connection string? In a MSSQL cluster you have a virtual IP you connect to so that instead of specifying each SQL node.
Mysql – Single entry point for thesql cluster
MySQL
Related Question
- Mysql – Setting up MySQL Cluster on Two Systems
- MySQL Cluster SQL Node not synchronizing
- Mysql – Load balancing MySQL ndbcluster
- Mysql – Percona Cluster Failed with Haproxy : Connection Limit Exceeded
- MySQL Cluster setup, receiving error “Specify node id”
- Mysql – Is it possible to setup MySQL replication through ProxySQL
- MySQL Cluster Replication and Failover Using Docker-Compose
Best Answer
It's dependent on the connector that you're using. For example, if using Connector/J then you can provide multiple server addresses in your connect-string... http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html
Andrew.