Logrotate script for percona 5.7 on ubuntu 16.04

[Yathus]

Hi,

After some weeks my /var/log/mysqld.log is huge (430Mb).

I was looking for the logrotate and i found this one :

/etc/logrotate.d/percona-xtradb-cluster-server-5.7

But it can’t work :

[IMG2=JSON]{“data-align”:“none”,“data-size”:“full”,“src”:“https://www.percona.com/forums/filedata/fetch?filedataid=1008&type=thumb”}[/IMG2]

It’s look like some package / script are not tested on Ubuntu ?

Best regards

Yathus

[Big_Boss]

First, let’s fix the bug in the Percona log rotate script:

sed -i 's#/var/log/mysql.log#/var/log/mysqld.log#' /etc/logrotate.d/percona-xtradb-cluster-server-5.7

From your screenshots, I can see you don’t have /etc/mysql/debian.cnf file, so either you don’t have the debian-sys-maint user in your database (then you should create one) or it is there but the file is only installed on the bootstrap node, if so do copy this file to all the cluster nodes.

Debian and Ubuntu installation doesn’t automatically create a special debian-sys-maint user which can be used by the control scripts to control the Percona Server mysqld and mysqld_safe services like it was the case with previous Percona Serverversions. If you still require this user you’ll need to create it manually.

https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.html