Speaker: Gea-Suan Lin (@gslin) Topic: MySQL to NoSQL & Search Engine Conference: MOPCON 2017 (in Kaohsiung, Taiwan)
MySQL toNoSQL & Search EngineGea-Suan Lin
View Slide
我是誰?
Gea-Suan Lin (DK)
PIXNET (Sr. Engineer)KKBOX (Lead Engineer)104 (CTO)無業遊民
今天來講個台灣不常提到,但很有用的技術...
Change data capture (CDC)
In databases, change data capture(CDC) is a set of software designpatterns used to determine (and track)the data that has changed so that actioncan be taken using the changed data.(from Wikipedia)
MySQL Replication 就是一種 CDC
今天要推銷的技術...
Python 的 mysql-replication:pip install mysql-replication
Pure Python Implementation of MySQLreplication protocol build on top ofPyMYSQL
https://github.com/noplay/python-mysql-replication
Live Demo!
所以我們可以拿來做什麼事情?
MySQL to Redis?
MySQL to Cassandra?
MySQL to Search Engine?
MySQL to PostgreSQL?
MySQL to Cache Invalidation?
或者是「Projects using this library」提到的專案
更重要的是...
組織決定技術架構
同個老闆直接摸 DB不同老闆透過 API
是個不給摸 DB 時的選擇
像是...
Account & Other System
Operation & Data Science
Thanks!