-
Notifications
You must be signed in to change notification settings - Fork 1
/
proxysql.cluster.cnf
67 lines (59 loc) · 1.09 KB
/
proxysql.cluster.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
#file proxysql.cfg
datadir="/var/lib/proxysql"
admin_variables=
{
admin_credentials="radmin:radmin;cluster:secretcluster"
mysql_ifaces="0.0.0.0:6032"
web_enabled=true
cluster_username="cluster"
cluster_password="secretcluster"
}
proxysql_servers =
(
{
hostname="sample-proxysql_proxysql_1"
port=6032
comment="cluster 1"
},
{
hostname="sample-proxysql_proxysql_2"
port=6032
comment="cluster 2"
},
{
hostname="sample-proxysql_proxysql_3"
port=6032
comment="cluster 3"
}
)
mysql_variables=
{
interfaces="0.0.0.0:6033"
monitor_username="monitor"
monitor_password="monitor"
commands_stats=true
sessions_sort=true
eventslog_filename="/var/log/proxysql/queries.log"
}
mysql_servers =
(
{
address = "mysql" # no default, required . If port is 0 , address is interpred as a Unix Socket Domain
port = 3306 # no default, required . If port is 0 , address is interpred as a Unix Socket Domain
hostgroup = 0 # no default, required
}
)
mysql_users:
(
{ username = "root" }
)
mysql_query_rules:
(
{
rule_id=1
active=1
match_pattern="."
log=1
apply=0
}
)