Instance Log Export

This guide explains how to export logs from MySQL instances. Log export can be performed regardless of the instance group or the instance status.

Export logs by instance

You can export MySQL logs from instances within an instance group and store them in Object Storage. Charges for using Object Storage apply separately. For reliable log transmission and storage, you will need your Access Key ID and Secret Access Key. For detailed instructions, refer to the Access Key Issuance Guide.

info

• If log collection is not configured (e.g., via parameter group settings), no logs will be accumulated and therefore cannot be exported. Be sure to check the log-related parameters before exporting.
• If there are no logs available for export, only empty directories may be created in the designated Object Storage path.
• You can check the results of log export-related events through Cloud Trail.
• If a conflict occurs with other operations in Object Storage, the log export may succeed, but storage may fail. Detailed operation request results can be checked in Object Storage's Access Logging.

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

2. In the Instance Group menu, select the instance group containing the instance from which you want to export logs.

3. Go to the Instance menu.

4. Click the [More] icon on the instance from which you want to export logs, then click Export Logs.

5. On the Export Logs page, enter the required information and click the [OK] button.

   Item	Category	Description
   Source Info		Shows the name and role of the instance from which logs will be exported
   Log Type		Select the type of log to export Available types: General log, Error log, Slow query log, Binary log
   Log Export Period		Set the log period to export (must be within the last 7 days in UTC) For binary logs, the period is based on the binlog_expire_logs_seconds parameter
   Object Storage	S3 Connection	Whether to use S3 connection (currently not supported) If not used, the path must be in swifta:// format
   	Bucket	Select the bucket where the logs will be stored
   	Path	Enter the path within the bucket - Supports Korean, English (upper/lowercase), numbers, special characters - Some special characters (\ : * ? " < > | ) are not allowed - Consecutive slashes (/) are not allowed - Relative paths are not supported; full path including bucket and folder must be under 396 bytes
   Account Information	Access Key ID, Secret Key	Required for exporting logs Refer to the Access Key Issuance Guide for details

6. Once log export is complete, you can find the logs in the specified bucket and path within Object Storage.