Comment 1 for bug 1376727

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

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%';
+----------------------------------+------------------+
| Variable_name | Value |
+----------------------------------+------------------+
| daemon_memcached_enable_binlog | ON |
| daemon_memcached_engine_lib_name | innodb_engine.so |
| daemon_memcached_engine_lib_path | |
| daemon_memcached_option | |
| daemon_memcached_r_batch_size | 1 |
| daemon_memcached_w_batch_size | 1 |
+----------------------------------+------------------+
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
Bye
root@deb-pxc56-1:/var/lib/mysql# 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.
root@deb-pxc56-1:/var/lib/mysql#
root@deb-pxc56-1:/var/lib/mysql# mysql -uroot -p
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 |
+----+--------------+------+------+------+
| AA | HELLO, HELLO | 8 | 0 | 0 |
+----+--------------+------+------+------+
1 row in set (0.00 sec)

mysql>