Instance failover
KakaoCloud provides both manual and automatic instance failover.
Service interruption may occur during failover, and the Standby instance is switched to take on the Primary role. To ensure the newly promoted Primary functions normally, it is recommended to manage resource status such as storage usage of the Standby instance.
Additionally, if no suitable Standby instance is available for failover, the Primary instance will automatically restart, which can lead to service disruption.
The following describes how to perform manual failover for a running MySQL instance.
Perform manual failover
info
- Service interruption may occur during failover.
- If no suitable Standby instance is available, the Primary instance will be restarted.
- Manual failover is restricted when only one instance is in the Single state.
- Go to the KakaoCloud Console > Data Store > MySQL menu.
- In the Instance Group menu, select the MySQL instance group where you want to perform failover.
- Click the Instance tab, then click the [Manual failover] button.
- In the Manual failover popup window, click the [Proceed] button.
info
MySQL endpoints are provided as FQDNs based on DNS. Since the IP mapped to the domain name may change during failover, please note the following:
- Do not cache the MySQL endpoint domain name (TTL 0 seconds).
(Example) TTL setting for Java-based applications:networkaddress.cache.ttl=0 - All existing connections will be dropped during Primary switching. To ensure availability, always configure your application to reconnect.