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.
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 |
+----+-
| AA | HELLO, HELLO | 8 | 0 | 0 |
+----+-
1 row in set (0.00 sec)
mysql>