It’s 2AM and your system fails…
Management is breathing down your neck. This is not the best time to test your DBA pro skills.
Automatic failover is the process of automatically moving an application to a standby server during a failure or service event to preserve its uptime. It can be part of a high-availability approach, or part of a disaster recovery (DR) approach, depending on where the second system is and how it is used.
There’s often some complexity involved, and some serious trust in your architecture in that you are turning over control to an automated process. Nowadays, companies choose automatic failover because they have very little downtime tolerance, understanding there will be some added complexity and cost to minimize risk.
OpenSCG offers complete configuration, support and training on all of our deployment and maintenance solutions.
Take a look at our BigSQL sponsored pgHA product that is a major component in our high availability solution.