|
This is a test setup. I send two requests per second, the requests are always the same. Sometimes the date and time are missing in the query_audit.unified log.
2022-08-01 23:59:47,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:47,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:48,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:49,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:50,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:51,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:52,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:53,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:54,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:54,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:55,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:56,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:56,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:57,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:58,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-01 23:59:59,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-02 00:00:00,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
2022-08-02 00:00:01,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
,user@::ffff:192.168.68.88,SELECT * FROM db1 WHERE id=1
|
maxscale.cnf
[maxscale]
|
threads=auto
|
skip_name_resolve=true
|
admin_gui=false
|
admin_secure_gui=false
|
log_warning=true
|
log_notice=true
|
log_info=false
|
log_debug=false
|
|
[MyLogFilter]
|
type=filter
|
module=qlafilter
|
filebase=/var/log/maxscale/query_audit
|
log_type=unified
|
|
[node1]
|
type=server
|
address=10.77.1.1
|
port=3306
|
priority=1
|
rank=primary
|
|
[node2]
|
type=server
|
address=10.77.1.2
|
port=3306
|
priority=3
|
rank=secondary
|
|
[service]
|
type=service
|
router=readwritesplit
|
master_accept_reads=true
|
servers=node1,node2
|
user=mos_maxscale
|
password=ze6e1pio9ixh
|
filters=MyLogFilter
|
version_string=maxscale02
|
|
[monitor]
|
type=monitor
|
module=galeramon
|
user=mos_maxscale
|
password=ze6e1pio9ixh
|
servers=node1,node2
|
disable_master_failback=true
|
available_when_donor=true
|
use_priority=true
|
|
[galera-listener]
|
type=listener
|
service=service
|
port=3306
|
protocol=mariadbclient
|
|