# Resolving excessive binlog growth on mysql 8.4 xtradb cluster

**URL:** <https://forums.percona.com/t/resolving-excessive-binlog-growth-on-mysql-8-4-xtradb-cluster/38080>\
**Category:** Uncategorized\
**Created:** [May 23, 2025, 4:37pm UTC](https://forums.percona.com/t/resolving-excessive-binlog-growth-on-mysql-8-4-xtradb-cluster/38080 "2025-05-23T16:37:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jtlarson](https://avatars.discourse-cdn.com/v4/letter/j/ac8455/32.png) [@jtlarson](https://forums.percona.com/u/jtlarson)\
**Post date:** [May 23, 2025, 4:37pm UTC](https://forums.percona.com/t/resolving-excessive-binlog-growth-on-mysql-8-4-xtradb-cluster/38080/1 "2025-05-23T16:37:50Z")

</div>

TL;DR: Are binlogs required on mysql 8.4 xtradb cluster? And if so, what are my options for limiting excessive binlog growth without risking the cluster health? What are the impacts of disabling them?

I have a 3-node mysql 8.4 xtradb cluster with the following binlog settings on each node:

_# Binary log expiration period is 604800 seconds, which equals 7 days_  
_binlog\_expire\_logs\_seconds=604800_

_# In order for Galera to work correctly binlog format should be ROW_  
_binlog\_format=ROW_

The binlogs have grown to 63GB on each node for a relatively small set of databases (\<10GB) and traffic.

I’ve seen statements that binlogs are not necessary with respect to galera on mysql 5.7, but is that also true for 8.4?

I know they are used for xtrabackup, but I don’t use xtrabackup on this cluster–just mysqldump scripts + Veeam.

---

<div class="post-metadata">

**Author:** ![CTutte](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ctutte/32/1341_2.png) [@CTutte](https://forums.percona.com/u/CTutte)\
**Post date:** [May 26, 2025, 1:26pm UTC](https://forums.percona.com/t/resolving-excessive-binlog-growth-on-mysql-8-4-xtradb-cluster/38080/2 "2025-05-26T13:26:36Z")

</div>

Hi jtlarson,

Binlogs are not needed by PXC. PXC uses gcache (galera cache) for syncing with the other nodes

You only need binlogs if you need to do async replication or PITR (point in time recovery) after restoring a backup.

Thus, you can disable binlogs entirely or modifying binlog\_row\_image : [https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html#sysvar\_binlog\_row\_image](https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html#sysvar_binlog_row_image)

Last:

> The binlogs have grown to 63GB on each node for a relatively small set of databases (\<10GB) and traffic.

The size of the binlogs will depend on the write workload of the server, not on the current database size

Regards
