Skip to content

cui422/mysql-redis-sync-utility

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 

Repository files navigation

Installation

$ sudo apt-get install python-setuptools $ sudo easy_install pip $ sudo pip install mysql-replication $ sudo pip install redis

#MySQL server settings (/etc/mysql/my.cnf)

[mysqld] server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M binlog-format = row 

#Example

mysql> create database contact; mysql> use contact; mysql> create table contactinfo (fname varchar(20), lname varchar(20)); mysql> insert into contactinfo values ('Rakesh','Rathi'); mysql> update contactinfo set fname='Jai' where fname='Rakesh';
$ sudo python mysql-redis-sync.py [Insert] SQLBinLog Row :{'values': {u'lname': u'Rathi', u'fname': u'Rakesh'}} Updated Cache -> contact-contactinfo-lname : Rathi Updated Cache -> contact-contactinfo-fname : Rakesh [Update] SQLBinLog Row :{'before_values': {u'lname': u'Rathi', u'fname': u'Rakesh'}, 'after_values': {u'lname': u'Rathi', u'fname': u'Jai'}} Updated Cache -> contact-contactinfo-fname : Jai

About

MySQL to Redis cache sync utility

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%