在线QQ客服:1922638
专业的SQL Server、MySQL数据库同步软件
主库:10.0.2.75;子库:10.0.2.230;
mysql \>显示从站状态\\\\ G;
mysql \>刷新具有读锁\\\\ G
的表
mysql \>显示主状态\\\\ G
mysql \>将master更改为master_host =” 10.0.2.230″,master_user =” root”,master_password =” 123456″,master_log_file =” mysql-bin.000005″,master_log_pos = 625;
### mater_log_file和master_log_pos是在从属库上显示主状态的结果
mysql \>启动奴隶;
发生错误;处理;
mysql \>重置从站;
重新配置;
mysql \>将master更改为master_host =” 10.0.2.230″,master_user =” root”,master_password =” 123456″,master_log_file =” mysql-bin.000005″,master_log_pos = 625;
mysql \>启动奴隶;
mysql \>显示从站状态\\\\ G;
成功的主库;开始配置从库;
mysql \>刷新具有读锁\\\\ G
的表
mysql \>显示主状态\\\\ G
mysql \>将master更改为master_host =” 10.0.2.75″,master_user =” root”,master_password =” 123456″,master_log_file =” mysql-bin.000008″,master_log_pos = 639208;
### mater_log_file和master_log_pos是在主库上执行的显示主状态的结果
mysql \ gt ;?启动奴隶;
mysql \>重置从站;
mysql \>将master更改为master_host =” 10.0.2.75″,master_user =” root”,master_password =” 123456″,master_log_file =” mysql-bin.000008″,master_log_pos = 639208;
mysql \ gt ;?启动奴隶;
mysql \>显示从属状态\\\\ G
mysql \>解锁表;