Add Instance

When you first create an instance in the MySQL service, a Primary instance is created. You can then add Standby instances as needed. A Standby instance is created with the same specifications as the currently used instance in the group. Each instance group can have up to 6 instances including the Primary.

For more information about MySQL instance status values, refer to the Instance documentation.

info

To perform manual failover, you must create a Standby instance in advance. If you attempt failover without a Standby instance, the Primary instance will be restarted. For details, refer to the Instance Failover documentation.

info

Standby instances can only be added when the status of the instance group is either Available or Primary-Available.

1. Go to the KakaoCloud Console > Data Store > MySQL menu.

2. In the Instance Group menu, select the MySQL instance group to which you want to add an instance and click the [Add Standby] button.

3. In the Add Standby popup window, enter the subnet and number of instances, then click the [OK] button.

   Category	Description
   Selected MySQL instance group	Name of the instance group where the Standby instance will be added
   Total number of instances	Final number of instances including the ones being added - Up to 6 instances can be created (1 Primary, 5 Standby)
   Standby port	When adding a Standby instance in a single availability zone, a port must be specified for communication - Must be within 1024 ~ 65535, ports used by Primary or reserved (e.g., 33060) cannot be used
   Set subnet and instance count	You can select a subnet and specify the number of instances within the table Up to 6 instances can be created including Primary and Standby When adding Standby instances, you can switch from single AZ to high availability If you add subnets, you can switch from no multi-AZ option to enabled
   Category Primary	Select the subnet and specify the number of instances for the Primary - At least 2 instances including Primary are recommended
   Category Standby	Select the subnet and specify the number of Standby instances - Use the [Add Subnet] button to configure Standby instances per subnet
   Add subnet	You can add as many subnets as the number of availability zones