DB Failover for LSCS

nipper

Has anyone set up LSCS for a failover DB ? We have 732 on Linux working with MySQL, want to try something like this:

jdbcUrl=jdbc:mysql://localhost:3306,backupdb.something.com:3306/dbname

LSCS will not start up is server 1 is down, it will reconnect when it comes back.

Any ideas ?

Rick Poulin

[Repeating the answers from old devnet, for people of the future]

This is a function of the JDBC driver being used. As @fish and I had suggested, you usually have a load balancing solution in front of the DB and LSCS is configured to point to that (e.g. with Oracle, DataGuard is the product that usually solves this use case).

 

The MySQL driver may have additional options to understand how to handle multiple named servers and do the failover on its own, but that would be specific to the implementation and may require modifying some of the hibernate configuration to pass those params along.