Upgrade to Pro — share decks privately, control downloads, hide ads and more …

MySQL to NoSQL & Search Engine

Gea-Suan Lin
October 28, 2017
Technology
0
1.9k

MySQL to NoSQL & Search Engine

Speaker: Gea-Suan Lin (@gslin)
Topic: MySQL to NoSQL & Search Engine
Conference: MOPCON 2017 (in Kaohsiung, Taiwan)

Gea-Suan Lin

October 28, 2017
Tweet

More Decks by Gea-Suan Lin

See All by Gea-Suan Lin
High Availability Vault Service on AWS Environment
gslin
0
6.9k
用 AWS CodeDeploy 解決程式佈署
gslin
0
360
用 Vagrant 與 Docker 拯救世界
gslin
1
230
Startup IT infrastructure: Developing and Working with AWS
gslin
8
3.4k
Talk about Percona XtraDB Cluster
gslin
0
170
API Design Optimized for Mobile Platform
gslin
9
8.4k
Use Facebook::Graph to write desktop application
gslin
2
470
COSCUP 2012 - MySQL System Stability
gslin
17
12k
MySQL System Stability
gslin
4
5.8k

Other Decks in Technology

See All in Technology
[CV勉強会@関東 ECCV2024 読み会] オンラインマッピング x トラッキング MapTracker: Tracking with Strided Memory Fusion for Consistent Vector HD Mapping (Chen+, ECCV24)
abemii
0
230
個人でもIAM Identity Centerを使おう!(アクセス管理編)
ryder472
4
240
【LT】ソフトウェア産業は進化しているのか？ #Agilejapan
takabow
0
100
OCI 運用監視サービス 概要
oracle4engineer
PRO
0
4.8k
AI前提のサービス運用ってなんだろう？
ryuichi1208
8
1.4k
あなたの知らない Function.prototype.toString() の世界
mizdra
PRO
2
340
Introduction to Works of ML Engineer in LY Corporation
lycorp_recruit_jp
0
140
CDCL による厳密解法を採用した MILP ソルバー
imai448
3
180
誰も全体を知らない ～ ロールの垣根を超えて引き上げる開発生産性 / Boosting Development Productivity Across Roles
kakehashi
2
230
Making your applications cross-environment - OSCG 2024 NA
salaboy
0
200
New Relicを活用したSREの最初のステップ / NRUG OKINAWA VOL.3
isaoshimizu
3
640
SDN の Hype Cycle を 一通り経験してみて思うこと / Going through the Hype Cycle of SDN
mshindo
1
130

Featured

See All Featured
5 minutes of I Can Smell Your CMS
philhawksworth
202
19k
Designing the Hi-DPI Web
ddemaree
280
34k
The Cult of Friendly URLs
andyhume
78
6k
What’s in a name? Adding method to the madness
productmarketing
PRO
22
3.1k
Reflections from 52 weeks, 52 projects
jeffersonlam
346
20k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
26
2.1k
The Illustrated Children's Guide to Kubernetes
chrisshort
48
48k
Imperfection Machines: The Place of Print at Facebook
scottboms
265
13k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
44
6.8k
For a Future-Friendly Web
brad_frost
175
9.4k
Into the Great Unknown - MozCon
thekraken
32
1.5k
Why Our Code Smells
bkeepers
PRO
334
57k

Transcript

  1. MySQL to NoSQL & Search Engine Gea-Suan Lin

  2. 我是誰？

  3. Gea-Suan Lin (DK)

  4. PIXNET (Sr. Engineer) KKBOX (Lead Engineer) 104 (CTO) 無業遊民

  5. 今天來講個台灣不常提到， 但很有用的技術...

  6. Change data capture (CDC)

  7. In databases, change data capture (CDC) is a set of

    software design patterns used to determine (and track) the data that has changed so that action can be taken using the changed data. (from Wikipedia)

  8. MySQL Replication 就是一種 CDC

  9. 今天要推銷的技術...

  10. Python 的 mysql-replication： pip install mysql-replication

  11. Pure Python Implementation of MySQL replication protocol build on top

    of PyMYSQL

  12. https://github.com/noplay/python-mysql-r eplication

  13. Live Demo！

  14. 所以我們可以拿來做什麼事情？

  15. MySQL to Redis？

  16. MySQL to Cassandra？

  17. MySQL to Search Engine？

  18. MySQL to PostgreSQL？

  19. MySQL to Cache Invalidation？

  20. 或者是 「Projects using this library」 提到的專案

  21. 更重要的是...

  22. 組織決定技術架構

  23. 同個老闆直接摸 DB 不同老闆透過 API

  24. 是個不給摸 DB 時的選擇

  25. 像是...

  26. Account & Other System

  27. Operation & Data Science

  28. Thanks！