Changing skip_log_bin on a v5.7 Percona Cluster

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

I have a vendor supplied Percona 3 node cluster v5.7. They have skip_log_bin set so binlogs are not captured. I want to turn binlogs on for all 3 nodes but my team and I do not have a whole lot of experience with Percona Clusters. I am thinking I remove this variable from the my.cnf file on all 3 systems, then shut down node 3, 2 then 1…then fire back up 1, 2 then 3. Will this work without having to bootstrap node 1 again? Will they re-connect?

I will add expire_logs_days (yes I know it is deprecated) on all 3 nodes plus expire them once XtraBackup runs…

Any help would be greatly appreciated!

2

Welcome back @jimbo881,

So we’re talking about Percona XtraDB Cluster 5.7. Find the steps below I’d try making this change.

  • edit my.cnf
  server-id=1
  log-bin=mysql1-bin
  binlog_format=row
  log-slave-updates = ON
  expire_logs_days = 7

(note: adjust server-id and log-bin name as per your server)

  • restart mysql
  • Once the node joins back to cluster proceed further with next cluster node.
    show global status like 'wsrep%';

Thanks,
Kedar