Export instance logs

This section explains how to export instance logs in the MySQL service. Log export can be performed regardless of instance group or instance status.

Export logs by instance

You can export MySQL logs from instances within an instance group and store them in Object Storage. Object Storage usage fees apply separately. To ensure stable log transmission and storage, you must provide your access key ID and access secret key. For details, refer to the Access key issuance guide.

info

• If log collection settings are not configured (e.g., in parameter groups), logs will not accumulate and thus cannot be exported. Be sure to check log-related parameters before exporting.
• If no logs are available in the system, only a directory without files may be created in the designated Object Storage location.
• Events related to MySQL log export can be found in Cloud Trail.
• If conflicts occur with other operations in Object Storage, log export may succeed but storage may fail. For detailed operation request results, refer to Access logging in Object Storage.

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

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

3. Go to the Instance tab.

4. Click the [⋮] button for the target instance and select [Export logs].

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

   Item	Category	Description
   Export source info		Displays the name and role of the instance to export logs from
   Log type		Select the type of logs to export Available types: general log, error log, slow query log, binary log
   Log export period		Set the log period to export (within the last 7 days, UTC-based) For binary logs, export period depends on the value set in the binlog_expire_logs_seconds parameter
   Object Storage	S3 connection	Whether to use S3 connection option (if not used, path must be in the form of swifta://) S3 support will be provided later
   	Bucket	Select the bucket where logs will be stored
   	Path	Enter the path within the bucket - Supports Korean, English (case-sensitive), numbers, and some special characters - Disallowed characters: `\ : * ? " < >
   Account info	Access key ID, Secret key	Required for log export See Access key issuance guide for details

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