Percona XtraDB Cluster - HA scalable solution for MySQL

Galera does not replicate Innodb memcached plugin writes

Reported by Jay Janssen on 2013-11-22
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Undecided
Unassigned
Percona XtraDB Cluster
Status tracked in Trunk
5.6
Undecided
Unassigned
Trunk
Undecided
Unassigned

Bug Description

3 node cluster following example here: http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html

[root@node1 ~]# mysql < /usr/share/mysql/innodb_memcached_config.sql

Set these settings: (based on http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-replication.html)
log-bin
innodb_api_enable_binlog = ON

[root@node1 ~]# service mysql restart

But when I write to a row, it does not replicate:

# telnet 127.0.0.1 11211
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
get all
VALUE all 10 9
123456789
END
get AA
VALUE AA 8 12
HELLO, HELLO
END
set BB 0 0 1
0
STORED
^]
telnet> quit
Connection closed.

[root@node1 mysql]# telnet 127.0.0.1 11211
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
incr BB 1
1
incr BB 1
2
^]
telnet> ^]
?Invalid command
telnet> quit
Connection closed.

node1 mysql> select * from demo_test;
+-----+--------------+------+------+------+
| c1 | c2 | c3 | c4 | c5 |
+-----+--------------+------+------+------+
| AA | HELLO, HELLO | 8 | 0 | 0 |
| all | 123456789 | 10 | 2 | 0 |
| BB | 2 | 0 | 3 | 0 |
+-----+--------------+------+------+------+
3 rows in set (0.00 sec)

But the other nodes do not get the new rows or updates:

node3 mysql> select * from demo_test;
+----+--------------+------+------+------+
| c1 | c2 | c3 | c4 | c5 |
+----+--------------+------+------+------+
| AA | HELLO, HELLO | 8 | 0 | 0 |
+----+--------------+------+------+------+
1 row in set (0.00 sec)

There are no errors in replication, the cluster otherwise behaves normally.

summary: - Galera does not replicate memcached plugin writes
+ Galera does not replicate Innodb memcached plugin writes
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers