实时同步线上mysql数据到本地mysql数据

log-bin=mysql-bin
binlog-format=row
server-id = 123
expire_logs_days = 7
slow_query_log=1
slow-query-log-file=/www/server/data/mysql-slow.log
long_query_time=3
#log_queries_not_using_indexes=on
early-plugin-load = ""

CREATE USER 'async_user'@'%' IDENTIFIED BY '你的密码';
GRANT SELECT, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'async_user'@'%';
FLUSH PRIVILEGES;

SHOW MASTER STATUS;

[mysqld]
server-id = 246
relay-log = mysql-relay-bin
read_only = 1

--8.0.22以下版本
CHANGE MASTER TO
    MASTER_HOST='线上数据库IP',
    MASTER_USER='async_user',
    MASTER_PASSWORD='your_password',  -- 替换为实际密码
    MASTER_LOG_FILE='记录的File值mysql-bin.000001', -- 请替换为实际的二进制日志文件名
    MASTER_LOG_POS= 记录的Position值123456;            -- 请替换为实际的日志位置
START SLAVE;

--8.0.22及以上版本
CHANGE REPLICATION SOURCE TO
    SOURCE_HOST = '线上数据库IP',
    SOURCE_USER = 'async_user',
    SOURCE_PASSWORD = 'your_password',  -- 替换为实际密码
    SOURCE_LOG_FILE = '记录的File值mysql-bin.000001', -- 请替换为实际的二进制日志文件名
    SOURCE_LOG_POS = 记录的Position值123456;            -- 请替换为实际的日志位置
START REPLICA;  -- 启动复制线程

-- 先停止
STOP SLAVE;
-- 重新设置你需要的过滤和重写规则
CHANGE REPLICATION FILTER REPLICATE_REWRITE_DB = ((主数据库表, 从数据库表));
CHANGE REPLICATION FILTER REPLICATE_WILD_DO_TABLE = ('从数据库表.%');
-- 启动
START SLAVE;