Skip to main content

Add instance

When you first create an instance in the MySQL service, an instance with the Primary role 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 instance group. Up to 6 instances can be created per instance group, including the Primary.

For more details on instance states and other information, refer to the Instance documentation.

info

To perform a manual failover, a Standby instance must be created in advance. If failover is performed without a Standby instance, the Primary instance will be restarted. For more information, see the Instance failover guide.

info

A Standby instance can only be added when the instance group's status is 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 where 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.

    ItemDescription
    Selected MySQL instance groupName of the instance group to which a Standby instance will be added
    Total number of instancesFinal number of instances including the ones to be added
    - Up to 6 instances can be created (1 Primary, 5 Standby)
    Standby portWhen adding a Standby instance in a single availability zone, a communication port must be specified
    - Must be within 1024–65535 range; cannot use ports currently used by Primary or reserved ports (e.g., 33060)
    Configure subnet and number of instancesSelect subnets and specify number of instances in the table
    Up to 6 instances including Primary and Standby subnets
    Adding a Standby instance allows switching from single availability to high availability
    Adding subnets enables switching from disabled to enabled multi-AZ option
    Item PrimarySelect the subnet to create the Primary instance and specify the number of instances
    - It is recommended to create at least 2 instances, including the Primary
    Item StandbySelect the subnet to create Standby instances and specify the number of instances
    - Use the [Add subnet] button to configure Standby instances per subnet
    Add subnetSubnets can be added according to the number of availability zones