-
Notifications
You must be signed in to change notification settings - Fork 10
/
Copy pathmaxscale.cnf
83 lines (70 loc) · 1.06 KB
/
maxscale.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
[maxscale]
threads=4
[server1]
type=server
address=server1
port=3306
protocol=MySQLBackend
[server2]
type=server
address=server2
port=3306
protocol=MySQLBackend
[server3]
type=server
address=server3
port=3306
protocol=MySQLBackend
[Galera_Monitor]
type=monitor
module=galeramon
servers=server1,server2,server3
user=myuser
password=mypwd
monitor_interval=10000
disable_master_failback=1
[qla]
type=filter
module=qlafilter
options=case,extended
filebase=/tmp/SqlQueryLog
[fetch]
type=filter
module=regexfilter
match=fetch
replace=select
[RW]
type=service
router=readwritesplit
servers=server1,server2,server3
user=myuser
password=mypwd
max_slave_connections=100%
[RR]
type=service
router=readconnroute
router_options=synced
servers=server1,server2,server3
user=myuser
password=mypwd
[CLI]
type=service
router=cli
[RWlistener]
type=listener
service=RW
protocol=MySQLClient
address=maxscale
port=3307
[RRlistener]
type=listener
service=RR
protocol=MySQLClient
address=maxscale
port=3308
[CLI-Listener]
type=listener
service=CLI
protocol=maxscaled
address=127.0.0.1
port=6603