Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This release offers the 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: 

  1. Before using

...

  1. SkySQL OS and Log Monitoring, generate a SkySQL API Key

...

  1. :

https://mariadb.com/docs/skysql-previous-release/security/api-key/#Generate_a_SkySQL_API_Key

Please make 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

...

are part of MariaDB SkySQL previous release documentation.

...

  1. 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

Click on the service (testsqldm for example testsqldm) to view the nodes running this service:

You In the Connect window, you need the node name – in this (for example testsqldm-mdb-ms-0) and your username , visible in connect window (in this (for example dbpwf25657325):

  • To make up your Server Datasource ID in the format:
    username/node_name
    For our example this is dbpwf25657325/testsqldm-mdb-ms-0

...


  1. Enable the System Metrics feature for

...

  1. the MariaDB SkySQL server connection and fill

...

  1. the Server Datasource ID and API Key from previous steps:

For any of MariaDB Error Log, MariaDB Query Log, and Audit Log you may , enable employing the SkySQL API by selecting the SkySQL (Using API) option from READ FILE FROM dropdown:

And fill your Type the Server Datasource ID and SKYSQL API Key you got from the first steps:



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse