mysql主从服务器
2024-10-19 06:23:07
#mysql主从服务器
mysql-bin.003673 | 106
查看错误日志
show variables like '%log_error%';
replicate-do-table=testmysql
change master to master_host='182.61.28.4',master_user='mysync',
master_password='123456',master_log_file='mysql-bin.003673',master_log_pos=511;
Slave I/O: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please check the manual before using it). Error_code: 1593
180607 10:04:08 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.003673', position 511
最新文章
- arcgis api for flex之专题图制作(饼状图,柱状图等)
- LINUX下NFS系统的安装配置
- ubutu安装搜狗
- 9x9乘法表输出[Java]
- js 获取时间差
- CreateProcess error=206, The filename or extension is too long";的一个解决方案
- oracle存储过程分页
- hdoj 5522 Numbers
- ProcessStartInfo.UseShellExecute 属性
- jQuery 的.data()方法
- lua学习笔记1
- 微渠道发展 BAE交通运输平台和java呼声,微信mysql数据库开发实例 --图文开发教程
- PHP $_POST 变量
- 【Unity游戏开发】tolua之wrap文件的原理与使用
- 初识正则表达式matcher.group
- JS promise
- CC2541设置中断输入模式
- 温故而知新 监听 XMLHttpRequest 发起请求
- quartz开源作业调度框架的配置
- Screen Monitors