at present, the master and slave Synchronize of MYSQL has been done. Now we are considering the issue of log capacity, which has been exploded by binlog.
Master-slave mysql-bin and slave relay logs exist. I would like to ask if there is a way to automatically clean these two logs without affecting the master-slave data Synchronize. Baidu is in manual form, which is too troublesome.
my idea is that mysql-bin has pos. I don"t know if I can start with pos to clean up the log before a certain point, so there is no need to lock the table. But I don"t know how to make it happen.
if you are cleaning from the entire mysql-bin, you may need to use the lock table. Is it not easy to clean up automatically when using the lock watch?
or which god has a complete solution? Thank you for your advice!