A combination of Redis and MySQL solutions

Scenarios are made from easy to difficult order, but regardless of the method. There is a need to ensure that data consistency is Reids and MySQL.

Programme one:

Program write Redis and MySQL at the same time
Read Redis

Scenario Two:

The program writes MySQL, using Gearman to invoke the MySQL UDF. Finished writing to Redis.
Read Redis
Copy of MySQL to Redis using Gearman

Programme III:

Program to write MySQL, parsing binlog. Data into queue write Redis
Read Redis
The use of canal complete MySQL data synchronization redis

Programme IV:

Program to write Redis. and write it into MQ to write MySQL
Read Redis

A combination of Redis and MySQL solutions