-
Notifications
You must be signed in to change notification settings - Fork 126
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
rs_master 和 rs_slave启动成功后,redis没有被同步 #5
Comments
insert 的时候,是否是 SET BINLOG_FORMAT='row' |
query sql : INSERT INTO test(col) VALUES('Mytest1') |
谢谢。问题解决了。 binlog_format=ROW 重启后,成功了。slave日志中的pos位置也改变了。 |
客气了! ------------------ 原始邮件 ------------------ 谢谢。问题解决了。 binlog_format=ROW 重启后,成功了。slave日志中的pos位置也改变了。 — |
您好:
所有配置按照README.zh.md文档配置以及之前的issus解决出现的问题。
所有软件都在一台虚拟机上,包括mysql,redis,mysql-syncer
在成功启动了master 和 slave 后,进行了mysql数据库的test表的insert工作。
进入redis-cli查看
redis 127.0.0.1:6379> keys *
(empty list or set)
以下是日志
master日志如下:
2013-09-24 14:44:15 [DEBUG] <thread : 140176434669312>
========== XID_EVENT ==============
2013-09-24 14:44:15 [DEBUG] <thread : 140176434669312>
tran : 0
tran id : 24
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
========== event header =============
server id : 1
event type : 2
event length : 68
event next position : 1065
dump position : 1065
data length : 49
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
========== QUERY_EVENT ==============
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
database name : test
query sql : BEGIN
next position : 1065
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
========== event header =============
server id : 1
event type : 5
event length : 28
event next position : 1093
dump position : 1093
data length : 9
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
========== INTVAR_EVNET ==============
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
increment id : 8
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
========== event header =============
server id : 1
event type : 2
event length : 102
event next position : 1195
dump position : 1195
data length : 83
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
========== QUERY_EVENT ==============
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
database name : test
query sql : INSERT INTO test(col) VALUES('Mytest1')
next position : 1195
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
========== event header =============
server id : 1
event type : 16
event length : 27
event next position : 1222
dump position : 1222
data length : 8
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
========== XID_EVENT ==============
2013-09-24 14:46:23 [DEBUG] <thread : 140176434669312>
tran : 0
tran id : 56
slave日志提示一直flush slave.info。而位置就是最开始写入的位置。
日志如下:
2013-09-24 14:46:45 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:47:15 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:47:45 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:48:15 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:48:45 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:49:15 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:49:45 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:50:15 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:50:45 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:51:15 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:51:45 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:52:15 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
2013-09-24 14:52:45 [INFO] <thread : 140119431694080> flush slave.info /var/lib/mysql/master_binlog.000002,106
烦请帮忙解决一下,谢谢
The text was updated successfully, but these errors were encountered: