MaxScale Logs record important output related to configuration and operation of the MariaDB MaxScale load balancer and SQL router.
Single Node Analytics
MaxScale Log data is available in the Log Archive.
To download log data:
Log in to the MariaDB SkySQL portal.
Access "Monitoring" in left navigation.
From SkySQL Monitoring, access "Logs" in left navigation.
Select the desired server(s), log types (such as "MaxScale Log"), and time frame, then click the "Download" button to download the logs.
Log files can be downloaded in your choice of JSON and/or plain text formats.
.ziparchive will contain one file per server, log, day, and format.
The Log Archive retains log data for 7 years. Data is retained even if the SkySQL service is deleted.
Logs are stored by day, by service, by server, by log type.
To request log data expungement, submit a Support Request.
Data retention requirements vary by business. A business process may be needed to download MaxScale log data in support of your data retention requirements.
MaxScale log lines vary in structure and content.
Most rows include as a first field the date in YYYY-MM-DD format.
Most rows state precedence of error, warning, or note.
When downloaded in plain text format, MaxScale Log data is as outputted by MariaDB MaxScale.
When downloaded in JSON format, MaxScale Log data has this format for each line, incorporating the plain text format:
One JSON object is produced for each logical line from the original plain text log file.
JSON key order is not guaranteed.