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

Bin logs too large - XtradbCluster

augusto.ferronatoaugusto.ferronato EntrantCurrent User Role Novice
Hello, i have a cluster with 3 nodes, the bin-log files is too big in the 3 nodes, and i don't use for a backup recovery scenario, can i just set:
SET GLOBAL expire_logs_days = 3;
For the mysql purge the logs? For cluster, this is my wsrep.cnf file
wsrep_sst_method=xtrabackup-v2
And for the existing bin-logs, i can run the command below?
PURGE BINARY LOGS TO `mysql-bin.000223`;
Thanks so much. Regards,

Comments

  • vadimtkvadimtk Contributor Percona Staff Role
    You do not need binary logs for Percona XtraDB Cluster, you can purge them all.
    Binary logs are only needed for backups and point-in-time recovery.
  • augusto.ferronatoaugusto.ferronato Entrant Current User Role Novice
    Hello,

    Thanks so much.
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.