Not the answer you need?
Register and ask your own question!

Logrotate script for percona 5.7 on ubuntu 16.04

YathusYathus ContributorCurrent User Role Novice
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

fetch?filedataid=1009&type=thumb


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

Comments

  • Big BossBig Boss Entrant Current User Role Novice
    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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.