Connection retry allows the MySQL driver to retry connections to the primary database server, and if specified, alternate servers until a successful connection is established. You use the ConnectionRetryCount and ConnectionRetryDelay properties to enable and control how connection retry works. For example:

jdbc:datadirect:mysql://server1:3306;DatabaseName=TEST;User=test;
Password=secret;AlternateServers=(server2:3306;DatabaseName=TEST2,\
server3:3306;DatabaseName=TEST3);
ConnectionRetryCount=2;ConnectionRetryDelay=5

In this example, if a successful connection is not established on the MySQL driver’s first pass through the list of database servers (primary and alternate), the driver retries the list of servers in the same sequence twice (ConnectionRetryCount=2). Because the connection retry delay has been set to five seconds (ConnectionRetryDelay=5), the driver waits five seconds between retry passes.