TDSQL for MySQL has database audit capability, which can record accesses to databases and executions of SQL statements to help you manage risks and improve the database security.
The database audit feature is currently in the beta testing. To use this feature, submit a ticket.
Alternatively, in Audit Instance on the Audit Log tab, directly search for audit-disabled instances and then enable audit for them.
- You can select 7 days, 30 days, 3 months, 6 months, 1 year, 3 years, or 5 years as the audit log retention period. You can also modify it in the console after enabling audit. For more information, see Modifying Log Retention Period.
- In order to meet the security compliance requirements for the retention period of SQL logs, we recommend you select 180 days or above.
After enabling audit, you can view SQL audit logs on the Audit Log tab. For more information, see Viewing Audit Logs