How to work with binary logs?

Question

MySQL

I am completely new to mysql and databases and I have a question. I understand correctly that binary logs are used for replication, since they can be used to easily, roughly speaking, restore the entire transaction history and bring the database from its original state to the current one?
If so, is it possible to do replication, and actively rub binary logs after that? That is, when the slave was already synchronized with the master, is it necessary to store the "used" binary log somewhere for some reason?

Answer 1

You can overwrite everything, the only question is that you need to understand that the replica uses a binary log after it receives the data. Ideally, this should be instant. But! Receiving data can be delayed: it depends on many parameters, one of these parameters is the speed of the network connection between the replicated server and the replicant. In addition to the speed of the network connection, the performance of both servers should also be taken into account. Therefore, before making a decision on the storage time of binlog files, it should be determined whether there is a backlog of the replicant from the replicated server. In addition to the above, it should be borne in mind that a replica is created not only to duplicate data,