Export and reset logs

You can export MySQL instance logs to Object Storage or reset logs that are no longer needed.

Export logs by instance

Object Storage usage fees apply separately when exporting logs. To ensure reliable log transmission and storage, you need an access key ID and secret access key. For details, see Issue an IAM access key.

Before exporting logs

• If log collection is not configured in a parameter group or other settings, logs are not collected and cannot be exported. Check the log-related parameters before exporting logs.
• To export Audit logs, Audit logging must be set to Use for the target instance group. If Audit logging is not configured, no Audit logs are collected and the export cannot complete normally.
• If no logs are available in the system, only an empty directory may be created in the specified Object Storage location.
• If a conflict occurs with another Object Storage operation, the log export can succeed while storage fails. For detailed operation request results, see Object Storage Access logging.

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

2. In the Instance Group menu, click the instance group containing the instance whose logs you want to export.

3. Go to the Instance tab.

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

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

   Item	Category	Description
   Export target information		View the instance group name, instance name, and role
   Log type		Select one or more log types to export - General log: Exports all client connections and SQL execution history - Error log: Exports diagnostic information generated during startup, shutdown, and errors - Slow query log: Exports queries that exceed the configured execution time - Audit log: Exports major activities for security auditing, including database access and activity history - Binary log: Records data change events and is used for replication and recovery
   Log export period		Set a period within the last seven days based on UTC Binary logs are exported according to the retention period configured in binlog_expire_logs_seconds, not the selected export period
   Storage location	Bucket	Select the bucket where logs will be stored
   	Path	Enter a path in the bucket - Korean and English letters, numbers, and special characters are supported - The following special characters are unavailable: `\ : * ? " < > \
   	Full path	View the full storage path composed of the bucket and path
   Authentication information	Access key ID	Select an access key for Object Storage access - IAM access keys are currently supported; S3 access keys will be supported later
   	Secret access key	Enter the secret access key corresponding to the selected access key ID - For issuance instructions, see Issue an access key

6. After the export completes, view the logs in the specified Object Storage bucket and path.

Log export events

• You can view MySQL log export event results in Cloud Trail.

Reset logs

You can reset logs for an instance.

Before resetting logs

Reset logs cannot be recovered. Before resetting logs, export and save any logs you need using Export logs by instance.

1. Go to the KakaoCloud Console > Data Store > MySQL.
2. In the Instance Group menu, click the instance group containing the instance whose logs you want to reset.
3. Go to the Instance tab.
4. Click the [⋮] button for the instance and select Reset logs.
5. In the Reset logs dialog, select one or more log types to reset.
   • Available types: general log, error log, slow query log, and Audit log
6. Enter 로그 초기화 in the confirmation field and click [Reset].