GRANT REPLICATION SLAVE ON *.* to 'backup'@'%' identified by 'gao19901108'; GRANT ALL PRIVILEGES ON *.* TO 'backup'@'%' IDENTIFIED BY 'gao19901108' WITH GRANT OPTION; 从库设置 CHANGE MASTER TO master_host = '36.41.175.249', master_user = 'backup', master_password = 'gao19901108', master_log_file = 'mysql-bin.000001', master_log_pos = 0, master_port = 32768; start slave; show slave status show master status; show variables like '%log_bin%'; server-id = 1 log-bin=mysql-bin binlog-do-db = test binlog-ignore-db = mysql #主-主形式需要多添加的部分 log-slave-updates sync_binlog = 1 auto_increment_offset = 1 auto_increment_increment = 2 replicate-do-db = test 从 server-id = 2 log-bin=mysql-bin #master-slave need replicate-do-db = test replicate-do-db = dbtest replicate-ignore-db = mysql,information_schema,performance_schema binlog-do-db = test binlog-do-db = dbtest binlog-ignore-db = mysql log-slave-updates sync_binlog = 1 auto_increment_offset = 2 auto_increment_increment = 2
linux数据库同步
最新推荐文章于 2024-05-07 23:37:30 发布