File proxysql-logrotate of Package proxysql
1
2
/var/lib/proxysql/*.log {
3
missingok
4
daily
5
notifempty
6
compress
7
create 0600 proxysql proxysql
8
rotate 15
9
postrotate
10
. /etc/proxysql-admin.cnf
11
/usr/bin/printf "%s\n" "[client]" "user=${PROXYSQL_USERNAME}" "password=${PROXYSQL_PASSWORD}" "host=${PROXYSQL_HOSTNAME}" "port=${PROXYSQL_PORT}" | /usr/bin/mysql --defaults-file=/dev/stdin --protocol=tcp -Nse "PROXYSQL FLUSH LOGS"
12
endscript
13
}
14