1PROXYSQL(1) General Commands Manual PROXYSQL(1)
2
3
4
6 proxysql - High Performance Advanced Proxy for MySQL
7
9 proxysql [OPTIONS]
10
12 proxysql is a high performance, high availability, protocol aware proxy
13 for MySQL and forks (like Percona Server and MariaDB).
14
16 -c, --config ARG
17 Configuration file. By default, the proxy looks for the config
18 file in the following locations (in this exact order):
19
20 • `proxysql.cnf`, in the directory of the proxysql binary
21
22 • `proxysql.cfg`, in the directory of the proxysql binary
23
24 • `/etc/proxysql.cnf`
25
26 • `/etc/proxysql.cfg`
27
28 This setting allows you to override the configuration file, and
29 specify a custom location.
30
31 -D, --datadir ARG
32 The data directory is where the proxy keeps its running files:
33
34 • the SQLite database which stores the runtime configuration for
35 the proxy
36
37 • the pidfile
38
39 • the log files
40
41 -e, --exit-on-error
42 Do not restart ProxySQL if crashes.
43
44 -f, --foreground
45 Run the daemon process in the foreground.
46
47 -h, -help, --help, --usage
48 Display usage instructions.
49
50 -M, --no-monitor
51 Do not start Monitor Module.
52
53 -n, --no-start
54 Starts only the admin service, which helps to configure the dae‐
55 mon. This will not accept any traffic until the daemon is
56 started from the admin interface.
57
58 -r, --reuseport
59 Use SO_REUSEPORT.
60
61 -S, --admin-socket ARG
62 Administration Unix Socket.
63
64 -V, --version
65 Print the current version of ProxySQL.
66
67 --idle-threads
68 Create auxiliary threads to handle idle connections.
69
70 --initial
71 Reset the admin database with the content from the configuration
72 file.
73
74 --no-version-check
75 Do not check for the latest version of ProxySQL.
76
77 --reload
78 Merge the configuration from the config file with the current
79 runtime database.
80
81 --sqlite3-server
82 Enable SQLite3 Server.
83
85 https://github.com/sysown/proxysql/tree/master/doc -- Online documenta‐
86 tion
87
89 /etc/proxysql.cnf
90 Configuration file.
91
93 Written by René Cannaò.
94
96 If you find a bug, please report it at <https://github.com/sysown/prox‐
97 ysql/issues>
98
100 Copyright (C) 2013-2017 René Cannaò. Modified by Marek Kulik 2021.
101 This program is free and without warranty.
102
103
104
105 PROXYSQL(1)