Read after transaction from secondary session not visible
If you can install Mysql UDF Plugin, you can using lib_mysqludf_redis plugin to synchronous records between Mysql and Redis by Mysql trigger. 

Here is a example:

CREATE TABLE `player_channel_log` (
  id       int         AUTO_INCREMENT PRIMARY KEY,
  date     datetime,
  player   int,
  channel  varchar(32)
);


set up a trigger for the table and call redis command by mysql udf

DELIMITER $$
CREATE TRIGGER `after_insert_player_channel_log`
AFTER INSERT ON `my_table` FOR EACH ROW
BEGIN
  DO `redis`('redis://@127.0.0.1/0/', 'SET', new.`player`, new.`channel`);
END $$
DELIMITER ;


then you can get value by player id

from mysql:

mysql&gt;  SELECT `redis`('redis://@127.0.0.1/0/', 'GET', &lt;player id&gt;)\G
*************************** 1. row ***************************
`redis`('redis://@127.0.0.1/0/', 'GET', &lt;player id&gt;): {
        "out":  &lt;channel&gt;
}


from redis-cli utility:


$ redis-cli -h 127.0.0.1 -n 0 GET &lt;player id&gt;
"&lt;channel&gt;"