EclipseLink JPA secondary server

hoping someone may tell me if there is a way to provide automatic redundancy using JPA. We're currently using EclipseLink but can change should another provider have a suitable solution) and we need to ensure that we switch to our backup database should our primary database become unavailable (since its not located in the same building as our application). than开发者_如何学运维ks for your input.

The easiest way is to change the jdbc connection url as explained in the mysql documentation. As an example

jdbc:mysql://master.server.com:3306,backup.server.com:3306/dbname

In this scenario, if maser.server.com fails, the driver will redirect the commands to backup.server.com. I strongly suggest you to read the whole documentation, as there are a lot of properties which change the failover behaviour, in particular the section High Availability and Clustering.