This release will offer complete functionality for the SkySQL previous release database-as-a-service from MariaDB. Most of the functionality for SQL Diagnostic Manager for MySQL already works with SkySQL. SkySQL provides an API for downloading the log file data and to fetch OS information. Log file includes Audit Log, Slow Query Log and Error Log.
Steps to view the log files and OS information:
- Before using the SkySQL OS and Log Monitoring, a SkySQL API Key must be generated:
https://mariadb.com/docs/skysql-previous-release/security/api-key/#Generate_a_SkySQL_API_Key
Please make sure the Observability API scopes are enabled for your API Key, as described here:
https://mariadb.com/docs/skysql-previous-release/security/api-key/#SkySQL_API_Key_Scopes
Note: These links and documentation are part of MariaDB SkySQL previous release documentation. We are employing the MariaDB SkySQL new release API, as all MariaDB SkySQL services are either new release or currently in process of migration to new release, but there is no SkySQL new release API documentation published yet.
- Obtain the Server Datasource ID for each node you want to monitor in SQL DM:
Open the MariaDB SkySQL dashboard, accessible via https://skysql.mariadb.com/dashboard