Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Is it possible to use virtual IP address in JDBC connection string for MySQL

We are planning to have an active-active(2 Master nodes) MySQL replication setup for SCH relational database. We are using a virtual IP which will migrate between these nodes in case of any failover. We are using keepalived service to monitor the MySQL service and also node failure. Is it possible to give virtual IP address in JDBC connection string? jdbc:mysql://<host name="">:<port>/<database name=""> Will this connection URL take care of the migration of one node to another node since we are providing the virtual IP and it might migrate to another node in case of failover?

Is it possible to use virtual IP address in JDBC connection string for MySQL

We are planning to have an active-active(2 Master nodes) MySQL replication setup for SCH relational database. We are using a virtual IP which will migrate between these nodes in case of any failover. We are using keepalived service to monitor the MySQL service and also node failure. Is it possible to give virtual IP address in JDBC connection string? string?

jdbc:mysql://<host name="">:<port>/<database name=""> name="">

Will this connection URL take care of the migration of one node to another node since we are providing the virtual IP and it might migrate to another node in case of failover?

Is it possible to use virtual IP address in JDBC connection string for MySQL

We are planning to have an active-active(2 Master nodes) MySQL replication setup for SCH relational database. We are using a virtual IP which will migrate between these nodes in case of any failover. We are using keepalived service to monitor the MySQL service and also node failure. Is it possible to give virtual IP address in JDBC connection string?

jdbc:mysql://<host name="">:<port>/<database jdbc:mysql://<virtual_ip_address>:<port>/<database name="">

Will this connection URL take care of the migration of one node to another node since we are providing the virtual IP and it might migrate to another node in case of failover?