CentOS系统可以通过MySQL8实现异地备份，以下是具体步骤：
1. 安装MySQL8sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpmsudo yum install mysql-community-server2. 配置MySQL8sudo mysql_secure_installation #按照提示设置数据库密码等信息sudo systemctl start mysqld #启动MySQL服务sudo systemctl enable mysqld #设置MySQL服务开机自启动3. 启用二进制日志编辑MySQL配置文件/etc/my.cnf，在[mysqld]段增加以下内容：log-bin=mysql-binbinlog-format=rowserver_id=1然后重新启动MySQL服务sudo systemctl restart mysqld4. 配置备份用户和目录登录MySQL后台，创建备份用户：CREATE USER backup IDENTIFIED BY 'password';GRANT RELOAD, PROCESS, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'backup';FLUSH PRIVILEGES;然后创建备份目录：sudo mkdir /var/mysql_backupsudo chown mysql:mysql /var/mysql_backup5. 配置主从复制主服务器执行以下命令：SHOW MASTER STATUS;得到输出，如：+------------------+----------+--------------+------------------+-------------------+| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |+------------------+----------+--------------+------------------+-------------------+| mysql-bin.000002 | 1208 | | | |+------------------+----------+--------------+------------------+-------------------+将得到的信息保存下来。从服务器执行以下命令：CHANGE MASTER TOMASTER_HOST='10.0.0.1',MASTER_PORT=3306,MASTER_USER='backup',MASTER_PASSWORD='password',MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=1208;START SLAVE;在从服务器上执行SHOW SLAVE STATUS;，如果看到Slave_IO_Running和Slave_SQL_Running的值都为Yes，则主从复制已经成功。6. 配置定时备份使用crontab，将以下命令加入到备份用户的计划任务中：mysqldump -ubackup -ppassword --all-databases | gzip >/var/mysql_backup/backup_$(date '+%Y-%m-%d_%H-%M-%S').sql.gz然后在crontab中设置备份频率即可。
