How To Properly Handle Service Interruptions Caused by Failover/Switchover on High Available Instances
(Doc ID 2969392.1)
Last updated on SEPTEMBER 04, 2023
Applies to:
MySQL Database Service - Version N/A and laterMySQL Cluster - Version 4.1 and later
MySQL Server - Version 4.0 and later
Information in this document applies to any platform.
Goal
Even on high availability systems, such as HA enabled MDS instances, custom InnoDB Cluster deployments, MySQL NDB Cluster setups, and so forth, your application may face short service interruptions during failover/switchover etc. High availability is a mechanism to keep a system available even in the event of node failures by duplicating nodes. When a node failure happens, there can be some intermittent failures on ongoing requests, which clients have to handle them. Even upon planned maintenance, intermittent disconnections can happen. This document describes how to handle such events on your applications.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |