Skip to main content

Manage Backup

Manage backups per MySQL instance group without stopping the group.

View backup list

Check the list of backups created in your MySQL instance group.

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

  2. Click the Back up menu, then select either the Manual Backup or Automated backup tab.

    Manual backup tab

    ItemDescription
    NameName of the backup
    Instance Group NameThe instance group associated with the backup
    StatusCheck backup status
    - See Instance Lifecycle and Status Values
    Engine VersionMySQL engine version that the backup can be restored to
    Backup SizeSize of the backup
    Base Storage SizeDefault storage size for restoration
    Created DateBackup creation date
    [More]Restore, Delete

    Automated backup tab

    ItemDescription
    NameName of the backup
    Instance Group NameThe instance group associated with the backup
    StatusCheck backup status
    - See Instance Lifecycle and Status Values
    Engine VersionMySQL engine version that the backup can be restored to
    Backup SizeSize of the backup
    Base Storage SizeDefault storage size for restoration
    Automated backup Retention PeriodRetention period for the automated backup
    Retention Expiration DateDate the automated backup will expire and be deleted
    Created DateBackup creation date
    [More]Restore

Configure automated backup

Set automated backup to run once daily at the specified time.
You can configure this during or after instance group creation.
Automatic backup is only supported in kr-central-2.

When creating instance group

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

  2. Click the [Create Instance Group] button.

  3. In the Create Instance Group screen, fill out the automated backup settings and click [Create].

    ItemFieldDescription
    Automated backupBackup OptionEnable daily automated backup
    Retention PeriodSet backup retention (1–35 days)
    - Applies to all automatic backups
    Backup Start TimeStart time for automated backup (starts within 15 minutes of set time)

When managing instance group

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

  2. In the Instance Group menu, click the [More] icon > select Configure Automated backup.

  3. Set the necessary values and click [OK].

    ItemFieldDescription
    Automated backupBackup OptionEnable daily automated backup
    Retention PeriodSet backup retention (1–35 days)
    - Applies to all automatic backups
    Backup Start TimeStart time for automated backup (starts within 15 minutes of set time)

Create manual backup

Manually create a backup via the MySQL service.

info

Backups can only be created when:

  • Instance group status: AVAILABLE, PRIMARY_AVAILABLE, or ERROR
  • Availability status: READY, PARTIAL-READY, or PARTIAL-UNAVAILABLE
  • Instance status: Running
    See Backup Lifecycle and Status Values for details.
  1. Go to the KakaoCloud Console > Data Store > MySQL.

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

  3. Go to the Backup tab and click [Create Backup].

    Image Create MySQL Backup

    ItemDescription
    Backup NameName entered at creation
    StatusBackup status
    - See Backup Lifecycle and Status Values
    Backup TypeOnly manual backup is currently supported
    - Automatic backup support coming soon
    Created DateDate and time of backup creation
    Created ByUser who created the backup
  4. Enter the details in the Create Backup popup and click [Create].

  5. Check the backup files in the Backup menu.

Delete backup

Delete backups that are no longer needed.

Delete automated backup

You cannot delete automatic backups individually. Instead, delete them by:

  • Reducing the retention period, or
  • Disabling automated backup altogether

Automatic backup is only supported in kr-central-2.

  • Backups exceeding the updated retention period will be deleted within minutes.
  • Disabling automated backup deletes existing automatic backups within minutes.

See Configure Automated backup for more.

Delete manual backup

caution

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

  1. Go to the KakaoCloud Console > Data Store > MySQL.
  2. From the Instance Group menu, select the group with the backup.
  3. In the Backup tab, click the [More] icon next to the backup > select Delete Backup.
  4. Fill out the popup and click [Delete].

Restore from backup

Use the backup restore feature to create a new MySQL instance group.
A backup must exist before restoration.

info
  • Only backups with Succeeded status can be used.
  • The new storage size must match or exceed the backup size.
  • To add instances post-restore, use the Create Instance Group from Backup feature for backups created after Jan 16, 2023.
  1. Go to the KakaoCloud Console > Data Store > MySQL.

  2. In the Instance Group menu, select the group with the desired backup.

  3. In the Backup tab, click the [More] icon next to the backup > select Restore.

  4. Enter the required information in the Restore popup and click [Restore].

    SectionFieldDescription
    Restore InfoInstance Group NameSelected backup info: name, storage size, and date
    Used to base the restoration
    Basic SettingsInstance Group NameName of the new MySQL instance group (must be unique)
    Example: mysql-instance-01
    Description (Optional)Optional 100-character group description
    Instance AvailabilityHigh AvailabilityCreate Primary + multiple Standby instances (single/multi AZ)
    SingleCreate a single Primary instance (single AZ only)
    MySQL SettingsEngine VersionAuto-selected version
    Supported: 8.0.34, 8.0.41
    Cannot restore to a lower version
    MySQL UsernameAdmin account name (1–32 lowercase letters or underscores)
    Example: admin (cannot use root)
    MySQL PasswordAdmin initial password (8–16 chars, no spaces or / ' " @)
    ⚠️ Can be changed after DB is running
    ⚠️ User-set password cannot be retrieved
    Parameter GroupSelect a group matching your MySQL version
    Instance TypeChoose compute resources
    See Instance Types
    Base Storage Type/SizeSSDVolume for DB (100–16,384 GB)
    Minimum size may vary by instance type
    Log Storage Type/SizeSSDLog storage (same specs as base)
    Cannot be changed after creation
    Network SettingsMulti-AZ OptionConfigure subnets and number of instances per AZ
    VPCSelect the VPC for the instance
    Subnet & Instance CountChoose subnet and number of instances
    Max 6 for HA, 1 for single availability
    Primary SubnetSubnet + count for Primary instance
    Standby SubnetAdd Standby subnet(s) for multi-AZ use
    Add SubnetAdd more subnets as needed
    Security GroupSelect or create security group(s) to apply
    Automated backupBackup OptionEnable daily automatic backups
    Retention PeriodSet retention period (1–35 days)
    Backup Start TimeTime for backup to begin (within 15 mins of selection)
    info

    For more on instance groups, see Instance Group.