Shulou(Shulou.com)06/01 Report--

This article is mainly about the method of regular remote backup of MYSQL binlog log files, if you are interested, let's take a look at this article. I believe that the method of regular remote backup of MYSQL binlog log files is of some reference value to everyone.

Rsync binlog push is done every 10 seconds, and the script is executed in the background after writing the script through daemon.

#! / bin/bashwhile truedo rsync-az / data/3306/mysql-bin.* rsync_backup@172.16.1.2:backup-- password-file=/etc/rsync.password & sleep 10

Done

Is it helpful for you to back up MYSQL binlog log files remotely on a regular basis? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.