mysql innodb_memcache plugin error in replication

0
votes

I start using mysql 5.6 for innodb_memcache plugins , everything is working fine till I configured master-slave replication.
two things puzzle me while configured it with master-slave. Note below are lines which I enabled for memcache in my.cnf

daemon_memcached_w_batch_size=25  
daemon_memcached_option='-v -m 1048'

  1. when i am not using innodb_api_enable_binlog=1 in my.cnf insert / update through memcache prompt (telnet localhost 11211) innodb_memcache table doesnot replicated,but saved in table(access through memcache prompt/sql prompt). when i am doing this thing from sql prompt everything works fine ,data get replicated. don't knew how mysql replicate data without save it in binary logs.

  2. when i enable innodb_api_enable_binlog=1 in my.cnf insert record from sql / memcache prompt all replicated to slave server,but problem is when i am updating records using memcache prompt it throws below error. Connection closed by foreign host and data doesnot save in table .
    now i dont know what to do, as i am plan to using mysql 5.6 in production but due to this problem i am unable to do this up gradation.

1
mysql
Please describe your problem in more detail. On what server did you activate memcache? Both? Which servers my.cnf did you put innodb_api_enable_binlog into? Which server did you try to query or update via memcache? Please edit your original post to include more details. – Ulrich Thomas Gabor
Hi , on master slave conf , I enable memcache plugin on master server , for innodb_api_enable_binlog obvious it has been enabled on master my.cnf and for memcache / query obvious i am using master server. hope you get all information. – Rajnish
even I make daemon_memcached_w_batch_size=1 , still i am facing same issue – Rajnish
Have you taken a look at this site? It says you should add -vvv (not just -v) to the parameters and then should take a look at the MySQL error file. Maybe this provides additional information. – Ulrich Thomas Gabor
Furthermore: Do you use the most current minor version of 5.6? – Ulrich Thomas Gabor

1 Answers

0
votes

Finally I found solution for it .
few things should be remember when using innodb table with memcache plugin.

  1. when we create innodb table which are going to used through memcache, we keep 3 more columns for memcache parameter, like if we want to create a table with 3 column to save our information so we have to keep 3 more columns for memcache plugins so we create table with 6 columns ( 3 to sotre values + 3 column (data type should be integer for c1 and c3 and big int for c2) for make entry in memcache container table ,it is fixed).

  2. when we insert records in innodb_memcache.containers ,use these 3 extra column here ,below are details .

Note: 3 extra column named c1,c2,c3 data type should be int.

so we insert records in containers table as below
flags: c1
cas_column: c2
expire_time_column: c3

after setting this now my MySQL doesnot crashed and it is working fine.