Skip to content

rakeshopensource/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

Releases

No releases published

Packages

No packages published

Languages