Need help with mysql2redis?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

209 Stars 95 Forks 29 Commits 7 Opened issues


A high performance mysql udf to sync the newly modified/inserted data from mysql to redis cache.

Services available


Need anything else?

Contributors list

No Data


Redis udf to sync newly modified data from mysql to redis cache.

When you use redis to cache data only(not persistent), you will face the issue that how to sync the newly modified data from mysql to the redis cache? This project aims to provide a high performance and stable redis udf to solve this issue.


please download the dependencies below and compile/install it properly :

  • apr-1.4.6(
  • apr-util-1.5.2(
  • hiredis(
  • libmysqludfjson(


run make from the src dir directly.


Install redis udf

please make sure that the has been put into the mysql plugin dir. By the way, you can examine where is the mysql plugin dir by run ''' mysqlconfig --plugindir '''. and then connect to your mysql server, run the following command to install the the redis udf. ```sql DROP FUNCTION IF EXISTS redisserverssetv2; DROP FUNCTION IF EXISTS rediscommandv2; DROP FUNCTION IF EXISTS freeresources;

CREATE FUNCTION redisserverssetv2 RETURNS int SONAME ""; CREATE FUNCTION rediscommandv2 RETURNS int SONAME ""; CREATE FUNCTION freeresources RETURNS int SONAME ""; ```

Test redis udf

connect to your mysql server, run the following command to test the the redis udf. ```sql select rediscommandv2("lpush","crmInboxEvents11",jsonobject(jsonmembers("op","insert","value","valuettt")));

select redisserverssetv2("",6379); select rediscommandv2("lpush","crmInboxEvents11",jsonobject(json_members("op","insert","value","valuettt")));

select rediscommandv2("hset","hkey","hfield",jsonobject(jsonmembers("op","insert","value","valuettt")));

select freeresources(); select redisserverssetv2("",6379); ```

What's more

you should create a trigger which will lpush the newly modified data to redis list juste as the following example:

CREATE TRIGGER insert_trigger AFTER INSERT ON email_folder
    SET @ret=
                                                NEW.Id as "id",NEW.type as "type",
                                                NEW.mailserver_id as "mailserverId",NEW.sender as "sender",
                                                NEW.sender_name as "senderName",NEW.recevier as "recevier",
                                                NEW.replyto as "replyto",NEW.bbemails as "bbemails",
                                                NEW.ccemails as "ccemails",NEW.subject as "subject"


Now all update events for that mysql table has been transfer to a redis queue. You need to start a thread(or process) to handle these update events and update the redis cache properly.

For example, you can start a java process to poll the redis queue , and pop the events, then handle it and update the redis cache properly.

Performance test

In my poor labtop, 10,000 row data were synced into redis in 0.4 second.

======== Please feel free to contact me([email protected]) if you have any questions.

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.