The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

figuring out which binary logs of master are applied on slaves from the master itself

Hello everybody!!

We have set up a replication and need to figure out which binary logs are received by slave completely to be able to purge the binary logs on master safely periodically. (like every hour). The aim is to find out this information on master without using "mysql -h Slave_IP -u <user> -p<pass>" meaning we cannot connect from master to slave's database engine. Does master keep such information and can we figure this out from master alone? I appreciate your help.

Best regards, Ali

Answer Answered by Daniel Black in this comment.

No, the master doesn't store this information. The information available on the master is SHOW REPLICA HOSTS.

note binlog_expire_logs_seconds was added in 10.6

An option to look at might be MaxScale's binlog router or Semisync replication.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.