Manage backup

Backups are managed at the MySQL instance group level and are performed without stopping the instance group.

View backup list

You can view the list of backups created for MySQL instance groups in your project.

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

2. Click the Backup menu and select either the Manual backups or Automated backups tab.

   Manual backup tab

   Item	Description
   Name	Name of the backup
   Instance group name	Name of the instance group associated with the backup
   Status	Backup status - For details, refer to Instance lifecycle and status values
   Engine version	MySQL engine version that the backup can be restored to
   Backup size	Size of the backup
   Base storage size	Default storage size when restoring
   Created at	Date the backup was created
   [⋮] button	Restore, delete

   Automated backup tab

   Item	Description
   Name	Name of the backup
   Instance group name	Name of the instance group associated with the backup
   Status	Backup status - For details, refer to Instance lifecycle and status values
   Engine version	MySQL engine version that the backup can be restored to
   Backup size	Size of the backup
   Base storage size	Default storage size when restoring
   Automated backup retention period	Retention period set for automated backups
   Retention expiration date	Date when retention ends; backups are deleted automatically
   Created at	Date the backup was created
   [⋮] button	Restore

Configure automated backup

Automated backups in the MySQL service are performed once per day at a specified time. After enabling the automated backup option, a backup is triggered within 30 minutes, then follows the specified schedule.

You can perform point-in-time recovery based on automated backups. For details, see the Point-in-time recovery guide.

When creating instance group

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

2. Click the [Create instance group] button.

3. In Create instance group, enter automated backup settings and click the [Create] button.

   Item	Category	Description
   Automated backup	Enable automated backup	Whether to enable automated backup; when enabled, backup is performed daily
   	Backup retention period	Retention period of automated backups; select from 1 to 35 days - Affects all automated backups created for the instance group
   	Start time	Start time for automated backups; backup begins within 15 minutes of the selected time

When managing instance group

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

2. In the Instance Group menu, click the [⋮] button of the target instance group and select [Configure automated backup].

3. Enter the necessary settings and click the [OK] button.

   Item	Category	Description
   Automated backup	Enable automated backup	Whether to enable automated backup; when enabled, backup is performed daily
   	Backup retention period	Retention period of automated backups; select from 1 to 35 days - Affects all automated backups created for the instance group
   	Start time	Start time for automated backups; backup begins within 15 minutes of the selected time

Create manual backup

You can manually create backups in the MySQL service.

info

Manual backup is only available when the instance group status is AVAILABLE, PRIMARY_AVAILABLE, or ERROR, and availability status is READY, PARTIAL-READY, or PARTIAL-UNAVAILABLE, and the instance status is Running.

• For details, refer to Backup lifecycle and status values.

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

2. In the Instance Group menu, select the instance group to back up.

3. Click the Backup menu, then click the [Create backup] button.

   Item	Description
   Backup name	Name entered at creation
   Status	Backup status - For details, refer to Backup lifecycle and status values
   Backup type	Currently only manual backup is available - Automated backup will be supported later
   Created at	Backup creation time
   Created by	User who created the backup

4. In the Create backup popup, enter required information and click the [Create] button.

5. Check the backup file in the Backup menu.

Delete backup

You can delete backups that are no longer needed.

Delete automated backup

Automated backups cannot currently be deleted individually. Deletion is only possible by shortening the retention period or disabling automated backup.

• When shortening the retention period, backups past the new retention date are deleted within minutes.
• If automated backup is disabled, all existing backups are deleted within minutes.

For more information, see Configure automated backup.

Delete manual backup

caution

Once deleted, backups are permanently removed and cannot be recovered.

1. Go to the KakaoCloud Console > Data Store > MySQL menu.
2. In the Instance Group menu, select the instance group containing the backup to delete.
3. In the Backup menu, click the [⋮] button for the target backup and select [Delete backup].
4. In the Delete backup popup, enter the required information and click the [Delete] button.

Restore

With the restore function in the MySQL service, you can create a new instance group using a backup. A valid backup must exist for the source instance group.

info

• A new instance group can be created from a backup only when the backup status is Succeeded. The storage size for the new group must be equal to or larger than that of the source group.
• To use the Add instance after restore feature, use a backup created on or after January 16, 2023.

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

2. In the Instance Group menu, select the group containing the backup to restore.

3. In the Backup menu, click the [⋮] button for the desired backup and select [Restore].

4. Enter the required information and click the [Restore] button.

   Item	Category	Description
   Restoration info	Instance group name	Basic info of selected backup - Includes instance group name, backup name, storage size, and backup date - Used as the base for restore
   Basic settings	Instance group name	Name of the new MySQL instance group - Must be unique within the project - Example: mysql-instance-01
   	Description (optional)	Additional description of the instance group (up to 100 characters)
   Instance availability	High availability (Primary, Standby)	Creates a Primary and multiple Standby instances - Supports single or multi-AZ
   	Single (Primary only)	Creates only a Primary instance - Supports single AZ only
   MySQL settings	Engine version	Automatically selected based on backup - Supported: 8.0.34, 8.0.41 - Cannot restore to a lower version
   	MySQL username	Admin account name - Format: 1–32 characters, lowercase letters and underscores only - Example: admin (reserved name root not allowed)
   	MySQL password	Initial password for admin account - Format: 8–16 characters - Cannot include space, /, ', ", @ ⚠️ Can be changed after DB launch ⚠️ Changed passwords cannot be retrieved
   Parameter group		Select parameter group compatible with the engine version
   Instance type		Choose instance type for DB compute resources - See Instance types for details
   Base storage type/size	SSD	Configure type and size of storage volume - Only SSD supported (more types in future) - Size: 100–5,120 GB * Minimum size may vary by instance type
   Log storage type/size	SSD	Storage for DB logs; cannot be changed later - Only SSD supported - Size: 100–16,384 GB * Minimum size may vary by instance type
   Network settings	Multi-AZ option	Available when high availability is selected; specify subnet and instance count per AZ
   	VPC	Select the network for MySQL instance
   	Subnet and instance count	Select subnet and instance count in table - Single: 1 instance - High availability: Up to 6 instances (Primary + Standby)
   	Category Primary	Select subnet and count for Primary - Single: 1 instance - High availability: At least 2 instances including Primary
   	Category Standby	Select subnet and count for Standby - Available only with multi-AZ enabled; use [Add subnet] to set per subnet
   	Add subnet	Add as many subnets as availability zones
   	Security group	Create or select a security group to apply - Multiple selections allowed
   Automated backup	Enable automated backup	Whether to enable automated backup; performs backup once per day
   	Backup retention period	Retention period of automated backups; select from 1 to 35 days
   	Start time	Time to start automated backup; begins within 15 minutes of selected time

info

For more on instance groups, see Instance group.