Pmm mysql backup

Percona Monitoring and Management (PMM)
1

Description:

[Detailed description of the issue or question]

Mysql binary log increases when performing Mysql full backup using PMM.
As far as I know, mysql binary log is created when mysql is restarted,
When I checked with systemctl status mysql, mysql was not restarted.
I wonder why mysql binary log is newly created every time I do a full backup with PMM

thank you

Steps to Reproduce:

[Step-by-step instructions on how to reproduce the issue, including any specific settings or configurations]

Version:

[Insert the version number of the software]

2.40.1

Logs:

[If applicable, include any relevant log files or error messages]

image

image

Expected Result:

[What the user expected to see or happen before the issue occurred]

Actual Result:

[What actually happened when the user encountered the issue]

Additional Information:

[Include any additional information that could be helpful to diagnose the issue, such as browser or device information]

2

Hi @ pmmChobo,
Xtrabackup does not copy all binlogs, it copies only the last binlog file. To copy a smaller last binlog FLUSH NO_WRITE_TO_BINLOG BINARY LOGS is executed as part of the backup, this is why a new binlog is being created.

I hope I could answer your question,

1 Like