MaxScale Log for MariaDB MaxScale 22.08

Overview

MariaDB MaxScale 22.08 writes most log messages to a single MaxScale log.

Reference material is available for MariaDB MaxScale 22.08.

Purpose

The MaxScale log is intended for:

  • Monitoring the MaxScale system status

  • Diagnosing problems with query routing

  • Diagnosing communication problems between MaxScale and the back-end nodes

  • Diagnosing connection failures

Format

The MaxScale log uses the following log format:

timestamp logging level: message

The fields in each log message are:

Field

Description

timestamp

The timestamp for the log message in the format YYYY-MM-DD HH:MM:SS

logging level

The log level for the log message

message

The log message.

Location

The MaxScale log is written to maxscale.log.

By default, the MaxScale log is created in the /var/log/maxscale/ directory.

The MaxScale log is also written to the syslog by default.

Configuration

Several aspects of the MaxScale log are configurable.

Configure the Path

The log directory can be configured by setting the logdir parameter.

The parameter can be set in the MaxScale configuration file, which is located at /etc/maxscale.cnf by default:

[maxscale]
logdir=/var/log/maxscale1/

Enable and Disable Log Levels

Several log levels can be enabled or disabled in the MaxScale log by configuring several parameters:

The parameters can be set in the MaxScale configuration file, which is located at /etc/maxscale.cnf by default:

[maxscale]
log_info=true
log_warn_super_user=true

Disable Syslog

All messages in the MaxScale log will also be written to the syslog by default. To disable syslog, configure the syslog parameter.

The parameter can be set in the MaxScale configuration file, which is located at /etc/maxscale.cnf by default:

[maxscale]
syslog=false

Disable Log File

The MaxScale log file will be used by default. To disable the MaxScale log file, configure the maxlog parameter.

The parameter can be set in the MaxScale configuration file, which is located at /etc/maxscale.cnf by default:

[maxscale]
maxlog=false