MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 00:56:03 2020
----------------------------------------------------------------------------
2020-09-11 00:56:03   notice : syslog logging is enabled.
2020-09-11 00:56:03   notice : maxlog logging is enabled.
2020-09-11 00:56:03   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 00:56:03   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 00:56:03   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 00:56:03   notice : Worker message queue size: 1MiB
2020-09-11 00:56:03   warning: The 'log_debug' option has no effect in release mode.
2020-09-11 00:56:03   notice : The logging of debug messages has been enabled.
2020-09-11 00:56:03   notice : The logging of informational messages has been enabled.
2020-09-11 00:56:03   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 00:56:03   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 00:56:03   notice : Total usable main memory: 3.45GiB.
2020-09-11 00:56:03   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 00:56:03   notice : MaxScale is running in process 17074
2020-09-11 00:56:03   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 00:56:03   notice : Log directory: /var/log/maxscale
2020-09-11 00:56:03   notice : Data directory: /var/lib/maxscale
2020-09-11 00:56:03   notice : Module directory: /usr/lib64/maxscale
2020-09-11 00:56:03   notice : Service cache: /var/cache/maxscale
2020-09-11 00:56:03   notice : Working directory: /var/log/maxscale
2020-09-11 00:56:03   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 00:56:03   info   : qc_sqlite loaded.
2020-09-11 00:56:03   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 00:56:03   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 00:56:03   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 00:56:03   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 00:56:03   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139846380484352.
2020-09-11 00:56:03   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139846372091648.
2020-09-11 00:56:03   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 00:56:03   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139846563106560.
2020-09-11 00:56:03   notice : Loading /etc/maxscale.cnf.
2020-09-11 00:56:03   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 00:56:03   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 00:56:03   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 00:56:03   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 00:56:03   notice : (Read-Write-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 00:56:03   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 00:56:03   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 00:56:03   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 00:56:03   notice : Server 'server1' charset: latin1
2020-09-11 00:56:03   notice : Server 'server2' charset: latin1
2020-09-11 00:56:03   notice : Server 'server3' charset: latin1
2020-09-11 00:56:03   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 00:56:03   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 00:56:03   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 00:56:03   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 00:56:03   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 00:56:03   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 00:56:03   notice : Starting a total of 1 services...
2020-09-11 00:56:03   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 00:56:03   notice : Service 'Read-Write-Service' started (1/1)
2020-09-11 00:56:04   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 00:57:01   info   : Accept authentication from 'admin', using password. Request: /auth
2020-09-11 00:59:27   info   : Accept authentication from 'admin', using password. Request: /auth
2020-09-11 01:00:11   info   : Waiting for worker 0xb3cf20.
2020-09-11 01:00:11   info   : Worker 0xb3cf20 received shutdown message.
2020-09-11 01:00:11   info   : Worker 0xb3cf20 has shut down.
2020-09-11 01:00:11   info   : Waited for worker 0xb3cf20.
2020-09-11 01:00:11   notice : Stopped MaxScale REST API
2020-09-11 01:00:11   info   : Worker 0xb0f290 received shutdown message.
2020-09-11 01:00:11   info   : Worker 0xb0f290 has shut down.
2020-09-11 01:00:11   info   : Worker 0xb0ed20 received shutdown message.
2020-09-11 01:00:11   info   : Worker 0xb0ed20 has shut down.
2020-09-11 01:00:11   info   : Worker 0x7ffd3d1db5b0 received shutdown message.
2020-09-11 01:00:11   info   : Worker 0x7ffd3d1db5b0 has shut down.
2020-09-11 01:00:11   notice : MaxScale is shutting down.
2020-09-11 01:00:11   info   : Waiting for worker 0xb0ed20.
2020-09-11 01:00:11   info   : Waited for worker 0xb0ed20.
2020-09-11 01:00:11   info   : Waiting for worker 0xb0f290.
2020-09-11 01:00:11   info   : Waited for worker 0xb0f290.
2020-09-11 01:00:11   notice : All workers have shut down.
2020-09-11 01:00:11   info   : Destroying 'Read-Write-Service'
2020-09-11 01:00:11   info   : Destroying 'Read-Write-Listener'
2020-09-11 01:00:11   notice : MaxScale shutdown completed.
2020-09-11 01:00:11   notice : MaxScale received signal SIGTERM. Exiting.
2020-09-11 01:00:11   MariaDB MaxScale is shut down.
----------------------------------------------------


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 01:00:18 2020
----------------------------------------------------------------------------
2020-09-11 01:00:18   notice : syslog logging is enabled.
2020-09-11 01:00:18   notice : maxlog logging is enabled.
2020-09-11 01:00:18   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 01:00:18   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 01:00:18   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 01:00:18   notice : Worker message queue size: 1MiB
2020-09-11 01:00:18   notice : The logging of informational messages has been enabled.
2020-09-11 01:00:18   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 01:00:18   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 01:00:18   notice : Total usable main memory: 3.45GiB.
2020-09-11 01:00:18   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 01:00:18   notice : MaxScale is running in process 17194
2020-09-11 01:00:18   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 01:00:18   notice : Log directory: /var/log/maxscale
2020-09-11 01:00:18   notice : Data directory: /var/lib/maxscale
2020-09-11 01:00:18   notice : Module directory: /usr/lib64/maxscale
2020-09-11 01:00:18   notice : Service cache: /var/cache/maxscale
2020-09-11 01:00:18   notice : Working directory: /var/log/maxscale
2020-09-11 01:00:18   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 01:00:18   info   : qc_sqlite loaded.
2020-09-11 01:00:18   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 01:00:18   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 01:00:18   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:00:18   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:00:18   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139783252932352.
2020-09-11 01:00:18   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139783244539648.
2020-09-11 01:00:18   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 01:00:18   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139783435554560.
2020-09-11 01:00:18   notice : Loading /etc/maxscale.cnf.
2020-09-11 01:00:18   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 01:00:18   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 01:00:18   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 01:00:18   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 01:00:18   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 01:00:18   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 01:00:18   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 01:00:18   notice : Query classifier cache disabled.
2020-09-11 01:00:18   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 01:00:18   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 01:00:18   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 01:00:18   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 01:00:18   notice : Server 'server1' charset: latin1
2020-09-11 01:00:18   notice : Server 'server2' charset: latin1
2020-09-11 01:00:18   notice : Server 'server3' charset: latin1
2020-09-11 01:00:18   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:00:18   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:00:18   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:00:18   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 01:00:18   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 01:00:18   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 01:00:18   notice : Starting a total of 2 services...
2020-09-11 01:00:18   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 01:00:18   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 01:00:18   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 01:00:18   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 01:00:19   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 01:00:19   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 01:00:33   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 01:00:36 2020
----------------------------------------------------------------------------
2020-09-11 01:00:36   notice : syslog logging is enabled.
2020-09-11 01:00:36   notice : maxlog logging is enabled.
2020-09-11 01:00:36   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 01:00:36   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 01:00:36   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 01:00:36   notice : Worker message queue size: 1MiB
2020-09-11 01:00:36   notice : The logging of informational messages has been enabled.
2020-09-11 01:00:36   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 01:00:36   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 01:00:36   notice : Total usable main memory: 3.45GiB.
2020-09-11 01:00:36   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 01:00:36   notice : MaxScale is running in process 17281
2020-09-11 01:00:36   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 01:00:36   notice : Log directory: /var/log/maxscale
2020-09-11 01:00:36   notice : Data directory: /var/lib/maxscale
2020-09-11 01:00:36   notice : Module directory: /usr/lib64/maxscale
2020-09-11 01:00:36   notice : Service cache: /var/cache/maxscale
2020-09-11 01:00:36   notice : Working directory: /var/log/maxscale
2020-09-11 01:00:36   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 01:00:36   info   : qc_sqlite loaded.
2020-09-11 01:00:36   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 01:00:36   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 01:00:36   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:00:36   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:00:36   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140023985985280.
2020-09-11 01:00:36   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140023977592576.
2020-09-11 01:00:36   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 01:00:36   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140024168607488.
2020-09-11 01:00:36   notice : Loading /etc/maxscale.cnf.
2020-09-11 01:00:36   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 01:00:36   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 01:00:36   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 01:00:36   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 01:00:36   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 01:00:36   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 01:00:36   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 01:00:36   notice : Query classifier cache disabled.
2020-09-11 01:00:36   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 01:00:36   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 01:00:36   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 01:00:36   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 01:00:36   notice : Server 'server1' charset: latin1
2020-09-11 01:00:36   notice : Server 'server2' charset: latin1
2020-09-11 01:00:36   notice : Server 'server3' charset: latin1
2020-09-11 01:00:36   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:00:36   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 01:00:36   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:00:36   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 01:00:36   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:00:36   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 01:00:36   notice : Starting a total of 2 services...
2020-09-11 01:00:36   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 01:00:36   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 01:00:36   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 01:00:36   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 01:00:37   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 01:00:37   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 01:00:51   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 01:00:53 2020
----------------------------------------------------------------------------
2020-09-11 01:00:53   notice : syslog logging is enabled.
2020-09-11 01:00:53   notice : maxlog logging is enabled.
2020-09-11 01:00:53   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 01:00:53   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 01:00:53   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 01:00:53   notice : Worker message queue size: 1MiB
2020-09-11 01:00:53   notice : The logging of informational messages has been enabled.
2020-09-11 01:00:53   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 01:00:53   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 01:00:53   notice : Total usable main memory: 3.45GiB.
2020-09-11 01:00:53   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 01:00:53   notice : MaxScale is running in process 17366
2020-09-11 01:00:53   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 01:00:53   notice : Log directory: /var/log/maxscale
2020-09-11 01:00:53   notice : Data directory: /var/lib/maxscale
2020-09-11 01:00:53   notice : Module directory: /usr/lib64/maxscale
2020-09-11 01:00:53   notice : Service cache: /var/cache/maxscale
2020-09-11 01:00:53   notice : Working directory: /var/log/maxscale
2020-09-11 01:00:53   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 01:00:53   info   : qc_sqlite loaded.
2020-09-11 01:00:53   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 01:00:53   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 01:00:53   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:00:53   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:00:53   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139891042522880.
2020-09-11 01:00:53   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139891034130176.
2020-09-11 01:00:53   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 01:00:53   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139891225145088.
2020-09-11 01:00:53   notice : Loading /etc/maxscale.cnf.
2020-09-11 01:00:53   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 01:00:54   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 01:00:54   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 01:00:54   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 01:00:54   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 01:00:54   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 01:00:54   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 01:00:54   notice : Query classifier cache disabled.
2020-09-11 01:00:54   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 01:00:54   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 01:00:54   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 01:00:54   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 01:00:54   notice : Server 'server1' charset: latin1
2020-09-11 01:00:54   notice : Server 'server2' charset: latin1
2020-09-11 01:00:54   notice : Server 'server3' charset: latin1
2020-09-11 01:00:54   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:00:54   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 01:00:54   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:00:54   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 01:00:54   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:00:54   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 01:00:54   notice : Starting a total of 2 services...
2020-09-11 01:00:54   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 01:00:54   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 01:00:54   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 01:00:54   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 01:00:55   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 01:00:55   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 01:10:54   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:10:54   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:10:54   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:13:52   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 01:13:56 2020
----------------------------------------------------------------------------
2020-09-11 01:13:56   notice : syslog logging is enabled.
2020-09-11 01:13:56   notice : maxlog logging is enabled.
2020-09-11 01:13:56   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 01:13:56   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 01:13:56   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 01:13:56   notice : Worker message queue size: 1MiB
2020-09-11 01:13:56   notice : The logging of informational messages has been enabled.
2020-09-11 01:13:56   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 01:13:56   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 01:13:56   notice : Total usable main memory: 3.45GiB.
2020-09-11 01:13:56   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 01:13:56   notice : MaxScale is running in process 17644
2020-09-11 01:13:56   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 01:13:56   notice : Log directory: /var/log/maxscale
2020-09-11 01:13:56   notice : Data directory: /var/lib/maxscale
2020-09-11 01:13:56   notice : Module directory: /usr/lib64/maxscale
2020-09-11 01:13:56   notice : Service cache: /var/cache/maxscale
2020-09-11 01:13:56   notice : Working directory: /var/log/maxscale
2020-09-11 01:13:56   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 01:13:56   info   : qc_sqlite loaded.
2020-09-11 01:13:56   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 01:13:56   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 01:13:56   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:13:56   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:13:56   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139872107972352.
2020-09-11 01:13:56   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139872099579648.
2020-09-11 01:13:56   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 01:13:56   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139872290594560.
2020-09-11 01:13:56   notice : Loading /etc/maxscale.cnf.
2020-09-11 01:13:56   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 01:13:56   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 01:13:56   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 01:13:56   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 01:13:56   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 01:13:56   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 01:13:56   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 01:13:56   notice : Query classifier cache disabled.
2020-09-11 01:13:56   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 01:13:56   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 01:13:56   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 01:13:56   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 01:13:56   notice : Server 'server1' charset: latin1
2020-09-11 01:13:56   notice : Server 'server2' charset: latin1
2020-09-11 01:13:56   notice : Server 'server3' charset: latin1
2020-09-11 01:13:56   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:13:56   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 01:13:56   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:13:56   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 01:13:56   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:13:56   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 01:13:56   notice : Starting a total of 2 services...
2020-09-11 01:13:56   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 01:13:56   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 01:13:56   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 01:13:56   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 01:13:57   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 01:13:57   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 01:14:49   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 01:14:52 2020
----------------------------------------------------------------------------
2020-09-11 01:14:52   notice : syslog logging is enabled.
2020-09-11 01:14:52   notice : maxlog logging is enabled.
2020-09-11 01:14:52   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 01:14:52   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 01:14:52   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 01:14:52   notice : Worker message queue size: 1MiB
2020-09-11 01:14:52   notice : The logging of informational messages has been enabled.
2020-09-11 01:14:52   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 01:14:52   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 01:14:52   notice : Total usable main memory: 3.45GiB.
2020-09-11 01:14:52   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 01:14:52   notice : MaxScale is running in process 17741
2020-09-11 01:14:52   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 01:14:52   notice : Log directory: /var/log/maxscale
2020-09-11 01:14:52   notice : Data directory: /var/lib/maxscale
2020-09-11 01:14:52   notice : Module directory: /usr/lib64/maxscale
2020-09-11 01:14:52   notice : Service cache: /var/cache/maxscale
2020-09-11 01:14:52   notice : Working directory: /var/log/maxscale
2020-09-11 01:14:52   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 01:14:52   info   : qc_sqlite loaded.
2020-09-11 01:14:52   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 01:14:52   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 01:14:52   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:14:52   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:14:52   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139690518796032.
2020-09-11 01:14:52   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139690510403328.
2020-09-11 01:14:52   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 01:14:52   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139690701418240.
2020-09-11 01:14:52   notice : Loading /etc/maxscale.cnf.
2020-09-11 01:14:52   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 01:14:52   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 01:14:52   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 01:14:52   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 01:14:52   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 01:14:52   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 01:14:52   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 01:14:52   notice : Query classifier cache disabled.
2020-09-11 01:14:52   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 01:14:52   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 01:14:52   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 01:14:52   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 01:14:52   notice : Server 'server1' charset: latin1
2020-09-11 01:14:52   notice : Server 'server2' charset: latin1
2020-09-11 01:14:52   notice : Server 'server3' charset: latin1
2020-09-11 01:14:52   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:14:52   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 01:14:52   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:14:52   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 01:14:52   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:14:52   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 01:14:52   notice : Starting a total of 2 services...
2020-09-11 01:14:52   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 01:14:52   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 01:14:52   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 01:14:52   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 01:14:53   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 01:14:53   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 01:15:04   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 01:15:07 2020
----------------------------------------------------------------------------
2020-09-11 01:15:07   notice : syslog logging is enabled.
2020-09-11 01:15:07   notice : maxlog logging is enabled.
2020-09-11 01:15:07   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 01:15:07   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 01:15:07   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 01:15:07   notice : Worker message queue size: 1MiB
2020-09-11 01:15:07   notice : The logging of informational messages has been enabled.
2020-09-11 01:15:07   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 01:15:07   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 01:15:07   notice : Total usable main memory: 3.45GiB.
2020-09-11 01:15:07   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 01:15:07   notice : MaxScale is running in process 17828
2020-09-11 01:15:07   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 01:15:07   notice : Log directory: /var/log/maxscale
2020-09-11 01:15:07   notice : Data directory: /var/lib/maxscale
2020-09-11 01:15:07   notice : Module directory: /usr/lib64/maxscale
2020-09-11 01:15:07   notice : Service cache: /var/cache/maxscale
2020-09-11 01:15:07   notice : Working directory: /var/log/maxscale
2020-09-11 01:15:07   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 01:15:07   info   : qc_sqlite loaded.
2020-09-11 01:15:07   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 01:15:07   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 01:15:07   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:15:07   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 01:15:07   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140017533486848.
2020-09-11 01:15:07   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140017525094144.
2020-09-11 01:15:08   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 01:15:08   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140017716109056.
2020-09-11 01:15:08   notice : Loading /etc/maxscale.cnf.
2020-09-11 01:15:08   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 01:15:08   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 01:15:08   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 01:15:08   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 01:15:08   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 01:15:08   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 01:15:08   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 01:15:08   notice : Query classifier cache disabled.
2020-09-11 01:15:08   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 01:15:08   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 01:15:08   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 01:15:08   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 01:15:08   notice : Server 'server2' charset: latin1
2020-09-11 01:15:08   notice : Server 'server3' charset: latin1
2020-09-11 01:15:08   notice : Server 'server1' charset: latin1
2020-09-11 01:15:08   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:15:08   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:15:08   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 01:15:08   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 01:15:08   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:15:08   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 01:15:08   notice : Starting a total of 2 services...
2020-09-11 01:15:08   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 01:15:08   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 01:15:08   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 01:15:08   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 01:15:09   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 01:15:09   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 01:20:39   info   : Accept authentication from 'admin', using password. Request: /v1/services/Read-Write-Service
2020-09-11 01:20:58   info   : Accept authentication from 'admin', using password. Request: /v1/maxscale/modules
2020-09-11 01:25:12   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:25:12   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:25:12   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:26:22   info   : Accept authentication from 'admin', using password. Request: /v1/services
2020-09-11 01:26:35   info   : Accept authentication from 'admin', using password. Request: /v1/listeners
2020-09-11 01:27:13   info   : Accept authentication from 'admin', using password. Request: /v1/servers
2020-09-11 01:28:28   info   : (1) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges.
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Target connection counts:
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) current operations : 0 in 	server1 Master, Running
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) current operations : 0 in 	server2 Slave, Running
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) current operations : 0 in 	server3 Slave, Running
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Connected to 'server1'
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Selected Master: server1
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Connected to 'server2'
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Selected Slave: server2
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Connected to 'server3'
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Selected Slave: server3
2020-09-11 01:28:28   info   : (1) Started Read-Write-Service client session [1] for 'appuser' from ::ffff:10.0.2.180
2020-09-11 01:28:28   info   : (1) Connected to 'server1' with thread id 158
2020-09-11 01:28:28   info   : (1) Connected to 'server3' with thread id 939
2020-09-11 01:28:28   info   : (1) Connected to 'server2' with thread id 34
2020-09-11 01:28:28   info   : (1) (Read-Write-Service) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 37, type: QUERY_TYPE_READ|QUERY_TYPE_SYSVAR_READ, stmt: select @@version_comment limit 1
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Route query to slave: server2 <
2020-09-11 01:28:28   info   : (1) Authentication to 'server1' succeeded.
2020-09-11 01:28:28   info   : (1) Authentication to 'server3' succeeded.
2020-09-11 01:28:28   info   : (1) Authentication to 'server2' succeeded.
2020-09-11 01:28:28   info   : (1) [readwritesplit] (Read-Write-Service) Reply complete, last reply from server2
2020-09-11 01:28:46   info   : (1) (Read-Write-Service) > Autocommit: [enabled], trx is [not open], cmd: (0x01) COM_QUIT, plen: 5, type: QUERY_TYPE_SESSION_WRITE, stmt:
2020-09-11 01:28:46   info   : (1) [readwritesplit] (Read-Write-Service) Session write, routing to all servers.
2020-09-11 01:28:46   info   : (1) (Read-Write-Service) Execute sescmd 1 on 'server1':
2020-09-11 01:28:46   info   : (1) [readwritesplit] (Read-Write-Service) Route query to master: server1
2020-09-11 01:28:46   info   : (1) (Read-Write-Service) Execute sescmd 1 on 'server2':
2020-09-11 01:28:46   info   : (1) [readwritesplit] (Read-Write-Service) Route query to slave: server2
2020-09-11 01:28:46   info   : (1) (Read-Write-Service) Execute sescmd 1 on 'server3':
2020-09-11 01:28:46   info   : (1) [readwritesplit] (Read-Write-Service) Route query to slave: server3
2020-09-11 01:28:46   info   : Stopped Read-Write-Service client session [1]
2020-09-11 01:28:48   info   : (2) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges.
2020-09-11 01:28:48   info   : (2) [readconnroute] (Database-Firewall-Service) New session for server server1. Connections : 1
2020-09-11 01:28:48   info   : (2) Started Database-Firewall-Service client session [2] for 'appuser' from ::ffff:10.0.2.180
2020-09-11 01:28:48   info   : (2) Connected to 'server1' with thread id 159
2020-09-11 01:28:48   info   : (2) Authentication to 'server1' succeeded.
2020-09-11 01:28:48   info   : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' select @@version_comment limit 1
2020-09-11 01:28:51   info   : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' SELECT DATABASE()
2020-09-11 01:28:51   info   : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_INIT_DB] to 'server1'
2020-09-11 01:28:51   info   : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' show databases
2020-09-11 01:28:51   info   : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' show tables
2020-09-11 01:28:51   info   : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_FIELD_LIST] to 'server1'
2020-09-11 01:29:07   notice : (2) [dbfwfilter] (Database-Firewall-Service) rule 'example_rule_1': regex matched on query
2020-09-11 01:33:53   info   : Pinging 'server1', idle for 301 seconds
2020-09-11 01:33:53   info   : (2) Response to COM_CHANGE_USER is OK, writing stored query
2020-09-11 01:35:13   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:35:13   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:35:13   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:38:54   info   : Pinging 'server1', idle for 301 seconds
2020-09-11 01:38:54   info   : (2) Response to COM_CHANGE_USER is OK, writing stored query
2020-09-11 01:43:55   info   : Pinging 'server1', idle for 301 seconds
2020-09-11 01:43:55   info   : (2) Response to COM_CHANGE_USER is OK, writing stored query
2020-09-11 01:45:13   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:45:13   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:45:13   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:48:57   info   : Pinging 'server1', idle for 301 seconds
2020-09-11 01:48:57   info   : (2) Response to COM_CHANGE_USER is OK, writing stored query
2020-09-11 01:53:58   info   : Pinging 'server1', idle for 301 seconds
2020-09-11 01:53:58   info   : (2) Response to COM_CHANGE_USER is OK, writing stored query
2020-09-11 01:55:14   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 01:55:14   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 01:55:14   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 01:56:11   info   : (2) [qc_sqlite] (Database-Firewall-Service) Parsing the query failed, cannot report query type: exot
exit
2020-09-11 01:56:11   warning: (2) [dbfwfilter] (Database-Firewall-Service) Query could not be tokenized and will hence be rejected. Please ensure that the SQL syntax is correct: exot
exit
2020-09-11 01:56:12   info   : (2) [readconnroute] (Database-Firewall-Service) Routed [COM_QUIT] to 'server1'
2020-09-11 01:56:12   info   : Stopped Database-Firewall-Service client session [2]
2020-09-11 02:01:26   info   : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. The data was identical to existing user data.
2020-09-11 02:01:26   warning: (3) [mariadbclient] Authentication failed for user 'injection_test'@[::ffff:10.0.2.180] to service 'Database-Firewall-Service'. Originating listener: 'Database-Firewall-Listener'. MariaDB error: 'Access denied for user 'injection_test'@'::ffff:10.0.2.180' (using password: YES)'.
2020-09-11 02:01:26   info   : Stopped Database-Firewall-Service client session [3]
2020-09-11 02:05:15   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 02:05:15   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 02:05:15   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 02:07:58   info   : (4) Found matching user entry 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' but user tried to access non-existing database 'injection_test'.
2020-09-11 02:07:58   info   : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'. The data was identical to existing user data.
2020-09-11 02:07:58   warning: (4) [mariadbclient] Authentication failed for user 'appuser'@[::ffff:10.0.2.180] to service 'Database-Firewall-Service'. Originating listener: 'Database-Firewall-Listener'. MariaDB error: 'Unknown database 'injection_test''.
2020-09-11 02:07:58   info   : Stopped Database-Firewall-Service client session [4]
2020-09-11 02:11:06   info   : (5) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges.
2020-09-11 02:11:06   info   : (5) [readconnroute] (Database-Firewall-Service) New session for server server1. Connections : 1
2020-09-11 02:11:06   info   : (5) Started Database-Firewall-Service client session [5] for 'appuser' from ::ffff:10.0.2.180
2020-09-11 02:11:06   info   : (5) Connected to 'server1' with thread id 162
2020-09-11 02:11:06   info   : (5) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' CREATE DATABASE sql_injection
2020-09-11 02:11:06   info   : (5) Authentication to 'server1' succeeded.
2020-09-11 02:11:06   info   : (5) [readconnroute] (Database-Firewall-Service) Routed [COM_QUIT] to 'server1'
2020-09-11 02:11:06   info   : Stopped Database-Firewall-Service client session [5]
2020-09-11 02:11:19   info   : (6) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges.
2020-09-11 02:11:19   info   : (6) [readconnroute] (Database-Firewall-Service) New session for server server1. Connections : 1
2020-09-11 02:11:19   info   : (6) Started Database-Firewall-Service client session [6] for 'appuser' from ::ffff:10.0.2.180
2020-09-11 02:11:19   info   : (6) Connected to 'server1' with thread id 163
2020-09-11 02:11:19   info   : (6) Authentication to 'server1' succeeded.
2020-09-11 02:11:19   info   : (6) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' SHOW DATABASES
2020-09-11 02:11:19   info   : (6) [readconnroute] (Database-Firewall-Service) Routed [COM_QUIT] to 'server1'
2020-09-11 02:11:19   info   : Stopped Database-Firewall-Service client session [6]
2020-09-11 02:15:15   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 02:15:15   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 02:15:15   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 02:17:01   info   : (7) Found matching user entry 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' but user tried to access non-existing database 'injection_test'.
2020-09-11 02:17:01   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 02:17:01   info   : (7) Found matching user entry 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' but user tried to access non-existing database 'injection_test'.
2020-09-11 02:17:01   warning: (7) [mariadbclient] Authentication failed for user 'appuser'@[::ffff:10.0.2.180] to service 'Database-Firewall-Service'. Originating listener: 'Database-Firewall-Listener'. MariaDB error: 'Unknown database 'injection_test''.
2020-09-11 02:17:01   info   : Stopped Database-Firewall-Service client session [7]
2020-09-11 02:17:14   info   : (8) Found matching user 'appuser'@'10.0.2.%' for client 'appuser'@'::ffff:10.0.2.180' with sufficient privileges.
2020-09-11 02:17:14   info   : (8) [readconnroute] (Database-Firewall-Service) New session for server server1. Connections : 1
2020-09-11 02:17:14   info   : (8) Started Database-Firewall-Service client session [8] for 'appuser' from ::ffff:10.0.2.180
2020-09-11 02:17:14   info   : (8) Connected to 'server1' with thread id 165
2020-09-11 02:17:14   info   : (8) [readconnroute] (Database-Firewall-Service) Routed [COM_QUERY] to 'server1' CREATE TABLE users1 AS SELECT * FROM users
2020-09-11 02:17:14   info   : (8) Authentication to 'server1' succeeded.
2020-09-11 02:17:14   info   : (8) [readconnroute] (Database-Firewall-Service) Routed [COM_QUIT] to 'server1'
2020-09-11 02:17:14   info   : Stopped Database-Firewall-Service client session [8]
2020-09-11 02:20:17   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 02:20:20 2020
----------------------------------------------------------------------------
2020-09-11 02:20:20   notice : syslog logging is enabled.
2020-09-11 02:20:20   notice : maxlog logging is enabled.
2020-09-11 02:20:20   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 02:20:20   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 02:20:20   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 02:20:20   notice : Worker message queue size: 1MiB
2020-09-11 02:20:20   notice : The logging of informational messages has been enabled.
2020-09-11 02:20:20   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 02:20:20   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 02:20:20   notice : Total usable main memory: 3.45GiB.
2020-09-11 02:20:20   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 02:20:20   notice : MaxScale is running in process 18785
2020-09-11 02:20:20   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 02:20:20   notice : Log directory: /var/log/maxscale
2020-09-11 02:20:20   notice : Data directory: /var/lib/maxscale
2020-09-11 02:20:20   notice : Module directory: /usr/lib64/maxscale
2020-09-11 02:20:20   notice : Service cache: /var/cache/maxscale
2020-09-11 02:20:20   notice : Working directory: /var/log/maxscale
2020-09-11 02:20:20   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 02:20:20   info   : qc_sqlite loaded.
2020-09-11 02:20:20   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 02:20:20   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 02:20:20   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 02:20:20   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 02:20:20   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139989741901568.
2020-09-11 02:20:20   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139989733508864.
2020-09-11 02:20:20   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 02:20:20   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139989924523776.
2020-09-11 02:20:20   notice : Loading /etc/maxscale.cnf.
2020-09-11 02:20:20   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 02:20:20   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 02:20:20   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 02:20:20   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 02:20:20   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 02:20:20   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 02:20:20   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 02:20:20   notice : Query classifier cache disabled.
2020-09-11 02:20:20   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 02:20:20   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 02:20:20   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 02:20:20   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 02:20:20   notice : Server 'server1' charset: latin1
2020-09-11 02:20:20   notice : Server 'server2' charset: latin1
2020-09-11 02:20:20   notice : Server 'server3' charset: latin1
2020-09-11 02:20:20   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 02:20:20   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 02:20:20   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 02:20:20   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 02:20:20   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 02:20:20   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 02:20:20   notice : Starting a total of 2 services...
2020-09-11 02:20:20   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 02:20:20   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 02:20:20   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 02:20:20   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 02:20:21   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 02:20:21   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 02:30:21   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 02:30:21   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 02:30:21   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 02:40:21   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 02:40:21   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 02:40:21   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 02:50:26   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 02:50:26   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 02:50:26   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 03:00:26   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 03:00:26   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 03:00:26   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 03:10:27   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 03:10:27   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 03:10:27   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 03:20:28   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 03:20:28   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 03:20:28   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 03:30:28   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 03:30:28   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 03:30:28   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 03:40:28   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 03:40:28   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 03:40:28   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 03:50:28   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 03:50:28   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 03:50:28   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 04:00:29   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 04:00:29   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 04:00:29   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 04:10:29   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 04:10:29   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 04:10:29   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 04:20:30   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 04:20:30   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 04:20:30   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 04:30:31   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 04:30:31   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 04:30:31   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 04:40:31   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 04:40:31   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 04:40:31   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 04:50:36   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 04:50:36   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 04:50:36   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 05:00:36   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 05:00:36   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 05:00:36   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 05:10:37   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 05:10:37   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 05:10:37   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 05:20:38   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 05:20:38   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 05:20:38   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 05:30:42   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 05:30:42   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 05:30:42   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 05:40:47   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 05:40:47   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 05:40:47   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 05:50:52   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 05:50:52   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 05:50:52   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 06:00:52   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 06:00:52   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 06:00:52   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 06:10:57   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 06:10:57   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 06:10:57   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 06:20:58   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 06:20:58   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 06:20:58   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 06:30:58   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 06:30:58   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 06:30:58   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 06:40:59   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 06:40:59   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 06:40:59   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 06:50:59   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 06:50:59   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 06:50:59   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 07:01:04   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 07:01:04   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 07:01:04   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 07:11:04   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 07:11:04   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 07:11:04   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 07:21:05   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 07:21:05   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 07:21:05   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 07:31:05   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 07:31:05   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 07:31:05   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 07:41:05   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 07:41:05   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 07:41:05   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 07:51:06   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 07:51:06   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 07:51:06   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 08:01:11   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 08:01:11   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 08:01:11   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 08:11:11   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 08:11:11   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 08:11:11   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 08:21:12   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 08:21:12   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 08:21:12   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 08:31:12   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 08:31:12   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 08:31:12   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 08:41:13   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 08:41:13   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 08:41:13   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 08:51:13   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 08:51:13   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 08:51:13   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 09:01:13   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 09:01:13   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 09:01:13   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 09:11:13   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 09:11:13   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 09:11:13   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 09:21:14   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 09:21:14   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 09:21:14   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 09:31:19   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 09:31:19   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 09:31:19   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 09:41:19   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 09:41:19   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 09:41:19   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 09:51:20   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 09:51:20   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 09:51:20   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 10:01:21   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 10:01:21   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 10:01:21   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 10:11:21   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 10:11:21   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 10:11:21   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 10:21:22   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 10:21:22   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 10:21:22   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 10:31:22   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 10:31:22   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 10:31:22   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 10:41:23   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 10:41:23   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 10:41:23   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 10:51:23   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 10:51:23   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 10:51:23   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 11:01:23   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 11:01:23   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 11:01:23   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 11:11:24   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 11:11:24   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 11:11:24   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 11:21:24   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 11:21:24   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 11:21:24   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 11:31:25   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 11:31:25   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 11:31:25   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 11:41:25   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 11:41:25   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 11:41:25   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 11:51:26   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 11:51:26   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 11:51:26   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 12:01:26   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 12:01:26   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 12:01:26   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 12:11:27   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 12:11:27   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 12:11:27   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 12:16:19   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 12:16:22 2020
----------------------------------------------------------------------------
2020-09-11 12:16:22   notice : syslog logging is enabled.
2020-09-11 12:16:22   notice : maxlog logging is enabled.
2020-09-11 12:16:23   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 12:16:23   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 12:16:23   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 12:16:23   notice : Worker message queue size: 1MiB
2020-09-11 12:16:23   notice : The logging of informational messages has been enabled.
2020-09-11 12:16:23   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 12:16:23   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 12:16:23   notice : Total usable main memory: 3.45GiB.
2020-09-11 12:16:23   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 12:16:23   notice : MaxScale is running in process 26842
2020-09-11 12:16:23   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 12:16:23   notice : Log directory: /var/log/maxscale
2020-09-11 12:16:23   notice : Data directory: /var/lib/maxscale
2020-09-11 12:16:23   notice : Module directory: /usr/lib64/maxscale
2020-09-11 12:16:23   notice : Service cache: /var/cache/maxscale
2020-09-11 12:16:23   notice : Working directory: /var/log/maxscale
2020-09-11 12:16:23   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 12:16:23   info   : qc_sqlite loaded.
2020-09-11 12:16:23   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 12:16:23   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 12:16:23   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 12:16:23   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 12:16:23   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140088009389824.
2020-09-11 12:16:23   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140088000997120.
2020-09-11 12:16:23   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 12:16:23   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140088192012032.
2020-09-11 12:16:23   notice : Loading /etc/maxscale.cnf.
2020-09-11 12:16:23   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 12:16:23   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 12:16:23   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 12:16:23   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 12:16:23   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 12:16:23   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 12:16:23   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 12:16:23   notice : Query classifier cache disabled.
2020-09-11 12:16:23   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 12:16:23   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 12:16:23   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 12:16:23   notice : Journal file was created 35763 seconds ago. Maximum journal age is 28800 seconds.
2020-09-11 12:16:23   notice : Removing stale journal file for monitor 'MariaDB-Monitor'.
2020-09-11 12:16:23   notice : Server 'server2' charset: latin1
2020-09-11 12:16:23   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 12:16:23   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 12:16:23   notice : Server 'server1' charset: latin1
2020-09-11 12:16:23   notice : Server 'server3' charset: latin1
2020-09-11 12:16:23   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 12:16:23   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 12:16:23   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 12:16:23   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 12:16:23   notice : [mariadbmon] Selecting new master server.
2020-09-11 12:16:23   notice : [mariadbmon] Setting 'server1' as master.
2020-09-11 12:16:23   notice : Server changed state: server1[10.0.2.133:3306]: master_up. [Down] -> [Master, Running]
2020-09-11 12:16:23   notice : Server changed state: server2[10.0.2.47:3306]: slave_up. [Down] -> [Slave, Running]
2020-09-11 12:16:23   notice : Server changed state: server3[10.0.2.254:3306]: slave_up. [Down] -> [Slave, Running]
2020-09-11 12:16:23   notice : Starting a total of 2 services...
2020-09-11 12:16:23   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 12:16:23   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 12:16:23   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 12:16:23   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 12:16:24   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 12:16:24   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 12:26:24   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 12:26:24   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 12:26:24   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 12:36:24   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 12:36:24   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 12:36:24   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 12:46:25   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 12:46:25   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 12:46:25   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 12:56:25   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 12:56:25   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 12:56:25   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:06:25   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:06:25   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:06:25   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 13:16:25   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:16:25   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:16:25   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 13:26:26   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 13:26:26   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:26:26   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:36:26   info   : Accept authentication from 'admin', using password. Request: /auth
2020-09-11 13:36:26   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:36:26   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:36:26   info   : Server variables loaded from 'server2', next update in 600 seconds.


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 13:36:29 2020
----------------------------------------------------------------------------
2020-09-11 13:36:29   notice : syslog logging is enabled.
2020-09-11 13:36:29   notice : maxlog logging is enabled.
2020-09-11 13:36:29   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 13:36:29   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 13:36:29   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 13:36:29   notice : Worker message queue size: 1MiB
2020-09-11 13:36:29   notice : The logging of informational messages has been enabled.
2020-09-11 13:36:29   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 13:36:29   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 13:36:29   notice : Total usable main memory: 3.45GiB.
2020-09-11 13:36:29   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 13:36:29   notice : MaxScale is running in process 28043
2020-09-11 13:36:29   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 13:36:29   notice : Log directory: /var/log/maxscale
2020-09-11 13:36:29   notice : Data directory: /var/lib/maxscale
2020-09-11 13:36:29   notice : Module directory: /usr/lib64/maxscale
2020-09-11 13:36:29   notice : Service cache: /var/cache/maxscale
2020-09-11 13:36:29   notice : Working directory: /var/log/maxscale
2020-09-11 13:36:29   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 13:36:29   info   : qc_sqlite loaded.
2020-09-11 13:36:29   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 13:36:29   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 13:36:29   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 13:36:29   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 13:36:29   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140474302334720.
2020-09-11 13:36:29   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140474220279552.
2020-09-11 13:36:29   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 13:36:29   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140474484956928.
2020-09-11 13:36:29   notice : Loading /etc/maxscale.cnf.
2020-09-11 13:36:29   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 13:36:29   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 13:36:29   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 13:36:29   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 13:36:29   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 13:36:29   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 13:36:29   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 13:36:29   notice : Query classifier cache disabled.
2020-09-11 13:36:29   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 13:36:29   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 13:36:29   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 13:36:29   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 13:36:29   notice : Server 'server1' charset: latin1
2020-09-11 13:36:29   notice : Server 'server2' charset: latin1
2020-09-11 13:36:29   notice : Server 'server3' charset: latin1
2020-09-11 13:36:29   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:36:29   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 13:36:29   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 13:36:29   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 13:36:29   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:36:29   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 13:36:29   notice : Starting a total of 2 services...
2020-09-11 13:36:29   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 13:36:29   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 13:36:29   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 13:36:29   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 13:36:30   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 13:36:30   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 13:37:41   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 13:37:45 2020
----------------------------------------------------------------------------
2020-09-11 13:37:45   notice : syslog logging is enabled.
2020-09-11 13:37:45   notice : maxlog logging is enabled.
2020-09-11 13:37:45   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 13:37:45   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 13:37:45   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 13:37:45   notice : Worker message queue size: 1MiB
2020-09-11 13:37:45   notice : The logging of informational messages has been enabled.
2020-09-11 13:37:45   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 13:37:45   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 13:37:45   notice : Total usable main memory: 3.45GiB.
2020-09-11 13:37:45   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 13:37:45   notice : MaxScale is running in process 28147
2020-09-11 13:37:45   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 13:37:45   notice : Log directory: /var/log/maxscale
2020-09-11 13:37:45   notice : Data directory: /var/lib/maxscale
2020-09-11 13:37:45   notice : Module directory: /usr/lib64/maxscale
2020-09-11 13:37:45   notice : Service cache: /var/cache/maxscale
2020-09-11 13:37:45   notice : Working directory: /var/log/maxscale
2020-09-11 13:37:45   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 13:37:45   info   : qc_sqlite loaded.
2020-09-11 13:37:45   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 13:37:45   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 13:37:45   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 13:37:45   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 13:37:45   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139996919445248.
2020-09-11 13:37:45   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139996911052544.
2020-09-11 13:37:45   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 13:37:45   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 139997102067456.
2020-09-11 13:37:45   notice : Loading /etc/maxscale.cnf.
2020-09-11 13:37:45   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 13:37:45   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 13:37:45   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 13:37:45   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 13:37:45   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 13:37:45   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 13:37:45   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 13:37:45   notice : Query classifier cache disabled.
2020-09-11 13:37:45   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 13:37:45   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 13:37:45   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 13:37:45   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 13:37:45   notice : Server 'server1' charset: latin1
2020-09-11 13:37:45   notice : Server 'server2' charset: latin1
2020-09-11 13:37:45   notice : Server 'server3' charset: latin1
2020-09-11 13:37:45   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 13:37:45   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 13:37:45   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:37:45   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 13:37:45   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:37:45   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 13:37:45   notice : Starting a total of 2 services...
2020-09-11 13:37:45   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 13:37:45   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 13:37:45   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 13:37:45   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 13:37:46   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 13:37:46   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 13:47:45   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:47:45   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 13:47:45   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:48:11   info   : Accept authentication from 'admin', using password. Request: /auth


MariaDB MaxScale  /var/log/maxscale/maxscale.log  Fri Sep 11 13:48:14 2020
----------------------------------------------------------------------------
2020-09-11 13:48:14   notice : syslog logging is enabled.
2020-09-11 13:48:14   notice : maxlog logging is enabled.
2020-09-11 13:48:14   notice : The collection of SQLite memory allocation statistics turned off.
2020-09-11 13:48:14   notice : Threading mode of SQLite set to Multi-thread.
2020-09-11 13:48:14   notice : The systemd watchdog is Enabled. Internal timeout = 30s
2020-09-11 13:48:14   notice : Worker message queue size: 1MiB
2020-09-11 13:48:14   notice : The logging of informational messages has been enabled.
2020-09-11 13:48:14   notice : Using up to 530.07MiB of memory for query classifier cache
2020-09-11 13:48:14   notice : Running OS: Linux@3.10.0-327.10.1.el7.x86_64, #1 SMP Tue Feb 16 17:03:50 UTC 2016, x86_64 with 2 processor cores.
2020-09-11 13:48:14   notice : Total usable main memory: 3.45GiB.
2020-09-11 13:48:14   notice : MariaDB MaxScale 2.5.3 started (Commit: de3770579523e8115da79b1696e600cce1087664)
2020-09-11 13:48:14   notice : MaxScale is running in process 28469
2020-09-11 13:48:14   notice : Configuration file: /etc/maxscale.cnf
2020-09-11 13:48:14   notice : Log directory: /var/log/maxscale
2020-09-11 13:48:14   notice : Data directory: /var/lib/maxscale
2020-09-11 13:48:14   notice : Module directory: /usr/lib64/maxscale
2020-09-11 13:48:14   notice : Service cache: /var/cache/maxscale
2020-09-11 13:48:14   notice : Working directory: /var/log/maxscale
2020-09-11 13:48:14   notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2020-09-11 13:48:14   info   : qc_sqlite loaded.
2020-09-11 13:48:14   notice : Query classification results are cached and reused. Memory used per thread: 265.04MiB
2020-09-11 13:48:14   notice : Password encryption key file '/var/lib/maxscale/.secrets' not found, using configured passwords as plaintext.
2020-09-11 13:48:14   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 13:48:14   info   : Epoll instance for listening sockets added to worker epoll instance.
2020-09-11 13:48:14   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140548302317312.
2020-09-11 13:48:14   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140548293924608.
2020-09-11 13:48:14   notice : MaxScale started with 2 worker threads, each with a stack size of 8388608 bytes.
2020-09-11 13:48:14   info   : [qc_sqlite] In-memory sqlite database successfully opened for thread 140548484939520.
2020-09-11 13:48:14   notice : Loading /etc/maxscale.cnf.
2020-09-11 13:48:14   notice : /etc/maxscale.cnf.d does not exist, not reading.
2020-09-11 13:48:14   notice : Loaded module readconnroute: V2.0.0 from /usr/lib64/maxscale/libreadconnroute.so
2020-09-11 13:48:14   notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2020-09-11 13:48:14   notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2020-09-11 13:48:14   notice : Loaded module dbfwfilter: V1.2.0 from /usr/lib64/maxscale/libdbfwfilter.so
2020-09-11 13:48:14   notice : Loaded module mariadbmon: V1.5.0 from /usr/lib64/maxscale/libmariadbmon.so
2020-09-11 13:48:14   notice : [dbfwfilter] The parameter 'treat_string_arg_as_field' or(and) 'treat_string_as_field' is enabled for Database-Firewall, disabling the query classifier cache.
2020-09-11 13:48:14   notice : Query classifier cache disabled.
2020-09-11 13:48:14   notice : (Database-Firewall-Listener) Loaded module MariaDBAuth: V2.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2020-09-11 13:48:14   notice : The REST API will be encrypted, all requests must use HTTPS.
2020-09-11 13:48:14   notice : Started REST API on [0.0.0.0]:8989
2020-09-11 13:48:14   info   : Loaded server states from journal file: /var/lib/maxscale/MariaDB-Monitor/monitor.dat
2020-09-11 13:48:14   notice : Server 'server1' charset: latin1
2020-09-11 13:48:14   notice : Server 'server2' charset: latin1
2020-09-11 13:48:14   notice : Server 'server3' charset: latin1
2020-09-11 13:48:14   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:48:14   notice : Server 'server1' version: 10.4.14-MariaDB-log
2020-09-11 13:48:14   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 13:48:14   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 13:48:14   notice : Server 'server2' version: 10.4.14-MariaDB-log
2020-09-11 13:48:14   notice : Server 'server3' version: 10.4.14-MariaDB-log
2020-09-11 13:48:14   notice : Starting a total of 2 services...
2020-09-11 13:48:14   notice : (Read-Write-Listener) Listening for connections at [::]:4006
2020-09-11 13:48:14   notice : Service 'Read-Write-Service' started (1/2)
2020-09-11 13:48:14   notice : (Database-Firewall-Listener) Listening for connections at [::]:4004
2020-09-11 13:48:14   notice : Service 'Database-Firewall-Service' started (2/2)
2020-09-11 13:48:15   notice : Read 10 user@host entries from 'server1' for service 'Database-Firewall-Service'.
2020-09-11 13:48:15   notice : Read 10 user@host entries from 'server1' for service 'Read-Write-Service'.
2020-09-11 13:58:14   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 13:58:14   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 13:58:14   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 14:08:15   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 14:08:15   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 14:08:15   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 14:18:15   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 14:18:15   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 14:18:15   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 14:28:15   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 14:28:15   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 14:28:15   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 14:38:16   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 14:38:16   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 14:38:16   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 14:48:16   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 14:48:16   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 14:48:16   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 14:58:17   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 14:58:17   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 14:58:17   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 15:08:17   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 15:08:17   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 15:08:17   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 15:18:18   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 15:18:18   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 15:18:18   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 15:28:18   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 15:28:18   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 15:28:18   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 15:38:19   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 15:38:19   info   : Server variables loaded from 'server2', next update in 600 seconds.
2020-09-11 15:38:19   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 15:48:24   info   : Server variables loaded from 'server1', next update in 600 seconds.
2020-09-11 15:48:24   info   : Server variables loaded from 'server3', next update in 600 seconds.
2020-09-11 15:48:24   info   : Server variables loaded from 'server2', next update in 600 seconds.