Instance failover
KakaoCloud provides both manual and automatic instance failover. This document describes how to manually fail over a running MySQL instance.
Perform manual failover
Notes when performing failover
- Temporary service interruption may occur during failover, and the Standby instance switches to the Primary role.
- To ensure that the switched instance operates normally, we recommend managing the resource status of Standby role instances, such as storage usage.
- If there is no suitable Standby instance for failover, the Primary instance may restart and cause service interruption.
- Manual failover is restricted in the Single state where there is only one instance.
- 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.
Endpoint connection notes
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.