Memcached access to InnoDB is not replicated by Galera
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
New
|
Undecided
|
Unassigned | ||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Confirmed
|
High
|
Unassigned |
Bug Description
Even if daemon_
percona11 mysql> select @@version,
+------
| @@version | @@version_comment |
+------
| 5.6.20-68.0-56-log | Percona XtraDB Cluster (GPL), Release rel68.0, Revision 888, WSREP version 25.7, wsrep_25.7.r4126 |
+------
1 row in set (0.00 sec)
percona11 mysql> \! netstat -lpn|grep 11211
tcp 0 0 0.0.0.0:11211 0.0.0.0:* LISTEN 3911/mysqld
tcp 0 0 :::11211 :::* LISTEN 3911/mysqld
udp 0 0 0.0.0.0:11211 0.0.0.0:* 3911/mysqld
udp 0 0 :::11211 :::* 3911/mysqld
percona11 mysql> show variables like '%memc%';
+------
| Variable_name | Value |
+------
| daemon_
| daemon_
| daemon_
| daemon_
| daemon_
| daemon_
+------
6 rows in set (0.00 sec)
percona11 mysql> select @@log_slave_
+------
| @@log_slave_updates |
+------
| 1 |
+------
1 row in set (0.00 sec)
[root@percona11 ~]# telnet 127.0.0.1 11211
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
set a12 10 0 9
123456789
STORED
set a11 10 0 9
123456789
STORED
get a11
VALUE a11 10 9
123456789
END
quit
Connection closed by foreign host.
percona11 mysql> select * from test.demo_test;
+-----+
| c1 | c2 | c3 | c4 | c5 |
+-----+
| a11 | 123456789 | 10 | 5 | 0 |
| a12 | 123456789 | 10 | 4 | 0 |
+-----+
2 rows in set (0.00 sec)
percona22 mysql> select * from test.demo_test;
Empty set (0.00 sec)
percona11 mysql> show binlog events in 'percona11-
+------
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+------
| percona11-
| percona11-
3c4dfc5e-
| percona11-
| percona11-
| percona11-
| percona11-
| percona11-
| percona11-
| percona11-
| percona11-
| percona11-
| percona11-
+------
12 rows in set (0.00 sec)
BEGIN
/*!*/;
# at 352
#700101 0:00:00 server id 1 end_log_pos 412 CRC32 0x1f2310e4 Table_map: `test`.`demo_test` mapped to number 70
# at 412
#700101 0:00:00 server id 1 end_log_pos 479 CRC32 0xd4f9081e Write_rows: table id 70 flags: STMT_END_F
### INSERT INTO `test`.`demo_test`
### SET
### @1='a12'
### @2='123456789'
### @3=10
### @4=4
### @5=0
# at 479
#700101 0:00:00 server id 1 end_log_pos 553 CRC32 0x42eeace6 Query thread_id=8 exec_time=
SET TIMESTAMP=0/*!*/;
COMMIT
/*!*/;
# at 553
#700101 0:00:00 server id 1 end_log_pos 601 CRC32 0x75b717ee GTID [commit=yes]
SET @@SESSION.
# at 601
#700101 0:00:00 server id 1 end_log_pos 674 CRC32 0x98313ae1 Query thread_id=8 exec_time=
SET TIMESTAMP=0/*!*/;
BEGIN
/*!*/;
# at 674
#700101 0:00:00 server id 1 end_log_pos 734 CRC32 0x6cc9947a Table_map: `test`.`demo_test` mapped to number 70
# at 734
#700101 0:00:00 server id 1 end_log_pos 834 CRC32 0xb41784df Update_rows: table id 70 flags: STMT_END_F
### UPDATE `test`.`demo_test`
### WHERE
### @1='a11'
### @2='5535\
### @3=10
### @4=3
### @5=0
### SET
### @1='a11'
### @2='123456789'
### @3=10
### @4=5
### @5=0
# at 834
#700101 0:00:00 server id 1 end_log_pos 908 CRC32 0x615a7623 Query thread_id=8 exec_time=
SET TIMESTAMP=0/*!*/;
COMMIT
Able to reproduce with PXC 5.6.20
mysql> select @@version, @@version_ comment; ------- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------- + ------- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------- + ------- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------- +
+------
| @@version | @@version_comment |
+------
| 5.6.20-68.0-56-log | Percona XtraDB Cluster (GPL), Release 25.7, wsrep_25.7.r4126 |
+------
1 row in set (0.00 sec)
mysql> \! netstat -lpn|grep 11211
tcp 0 0 0.0.0.0:11211 0.0.0.0:* LISTEN 13354/mysqld
tcp6 0 0 :::11211 :::* LISTEN 13354/mysqld
udp 0 0 0.0.0.0:11211 0.0.0.0:* 13354/mysqld
udp6 0 0 :::11211 :::* 13354/mysqld
mysql>
mysql> show variables like '%memc%'; ------- ------- ------- ------- +------ ------- -----+ ------- ------- ------- ------- +------ ------- -----+ memcached_ enable_ binlog | ON | memcached_ engine_ lib_name | innodb_engine.so | memcached_ engine_ lib_path | | memcached_ option | | memcached_ r_batch_ size | 1 | memcached_ w_batch_ size | 1 | ------- ------- ------- ------- +------ ------- -----+
+------
| Variable_name | Value |
+------
| daemon_
| daemon_
| daemon_
| daemon_
| daemon_
| daemon_
+------
6 rows in set (0.00 sec)
mysql> select @@log_slave_ updates; ------- ------- -+ ------- ------- -+ ------- ------- -+
+------
| @@log_slave_updates |
+------
| 1 |
+------
1 row in set (0.00 sec)
mysql> quit pxc56-1: /var/lib/ mysql# telnet 127.0.0.1 11211 pxc56-1: /var/lib/ mysql# pxc56-1: /var/lib/ mysql# mysql -uroot -p
Bye
root@deb-
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
set a12 10 0 9
123456789
STORED
set a11 10 0 9
123456789
STORED
get a11
VALUE a11 10 9
123456789
END
quit
Connection closed by foreign host.
root@deb-
root@deb-
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.6.20-68.0-56-log Percona XtraDB Cluster (GPL), Release 25.7, wsrep_25.7.r4126
Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select * from test.demo_test; ------- ------- +------ +------ +------ + ------- ------- +------ +------ +------ + ------- ------- +------ +------ +------ +
+-----+
| c1 | c2 | c3 | c4 | c5 |
+-----+
| a11 | 123456789 | 10 | 2 | 0 |
| a12 | 123456789 | 10 | 1 | 0 |
| AA | HELLO, HELLO | 8 | 0 | 0 |
+-----+
3 rows in set (0.00 sec)
On node2,
mysql> select * from test.demo_test; ------- ------+ ------+ ------+ ------+
+----+-
| c1 | c2 | c3 | c4 | c5 |
+-...