Geek asks and answers

How to move data from mysql to redis

I am trying to put some commonly used data in a redis server from mysql. so redis as a read server, I need to move data from mysql to redis. can anyone recommend a good approach? I read some topics and have some thinking

1, use the mysql trigger to write the correct data, use the time reference application to move the data to redis 2, read the mysql logs, analyze it, then move it to redis.

BTW: in my applications, the data stored in redis is not needed in real time, a little latency is fine.

+3
source share
2 answers

Use the redis-cli bulk insert mode.

- http://dcw.ca/blog/2013/01/02/mysql-to-redis-in-one-step/

0

, mysql udf (https://github.com/Ideonella-sakaiensis/lib_mysqludf_redis) Mysql Redis.

:

DELIMITER $$
CREATE TABLE `my_table` (
  id    varchar(16) PRIMARY KEY,
  text  varchar(32)
);

redis mysql udf

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

my_table id

mysql>  SELECT `redis`('redis://@127.0.0.1/0/', 'GET', <my_table id>)\G
*************************** 1. row ***************************
`redis`('redis://@127.0.0.1/0/', 'GET', <my_table id>): {
        "out":  <my_table text>
}
0

More articles:


All Articles