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

MySQL to NoSQL & Search Engine

Avatar for Gea-Suan Lin Gea-Suan Lin
October 28, 2017
Technology
0
2k

MySQL to NoSQL & Search Engine

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

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
Avatar for Gea-Suan Lin gslin
0
6.9k
用 AWS CodeDeploy 解決程式佈署
Avatar for Gea-Suan Lin gslin
0
380
用 Vagrant 與 Docker 拯救世界
Avatar for Gea-Suan Lin gslin
1
240
Startup IT infrastructure: Developing and Working with AWS
Avatar for Gea-Suan Lin gslin
8
3.5k
Talk about Percona XtraDB Cluster
Avatar for Gea-Suan Lin gslin
0
180
API Design Optimized for Mobile Platform
Avatar for Gea-Suan Lin gslin
9
8.4k
Use Facebook::Graph to write desktop application
Avatar for Gea-Suan Lin gslin
2
490
COSCUP 2012 - MySQL System Stability
Avatar for Gea-Suan Lin gslin
17
12k
MySQL System Stability
Avatar for Gea-Suan Lin gslin
4
5.8k

Other Decks in Technology

See All in Technology
2025年8月から始まるAWS Lambda INITフェーズ課金/AWS Lambda INIT phase billing changes
Avatar for quiver quiver
1
630
2025-04-14 Data & Analytics 井戸端会議 Multi tenant log platform with Iceberg
Avatar for kamijin_fanta kamijin_fanta
1
180
AndroidアプリエンジニアもMCPを触ろう
Avatar for Shinnosuke Kugimiya kgmyshin
2
610
企業が押さえるべきMCPの未来
Avatar for TakaakiKakei takaakikakei
3
740
Simplify! 10 ways to reduce complexity in software development
Avatar for Uwe Friedrichsen ufried
1
230
Twelve-Factor-Appから学ぶECS設計プラクティス/ECS practice for Twelve-Factor-App
Avatar for k-ozawa ozawa
3
160
大規模サーバーレスプロジェクトのリアルな零れ話
Avatar for mai miya maimyyym
3
150
読んで学ぶ Amplify Gen2 / Amplify と CDK の関係を紐解く #jawsug_tokyo
Avatar for Kihara, Takuya tacck
PRO
1
300
Azure & DevSecOps
Avatar for KAMEGAWA Kazushi kkamegawa
2
150
今日からはじめるプラットフォームエンジニアリング
Avatar for Kazuto Kusama jacopen
8
2k
2025-04-24 "Manga AI Understanding & Localization" Furukawa Arata (CyberAgent, Inc)
Avatar for Arata Furukawa ornew
2
340
白金鉱業Meetup_Vol.18_生成AIはデータサイエンティストを代替するのか？
Avatar for BrainPad brainpadpr
4
240

Featured

See All Featured
Fireside Chat
Avatar for paigeccino paigeccino
37
3.4k
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
329
24k
The Web Performance Landscape in 2024 [PerfNow 2024]
Avatar for Tammy Everts tammyeverts
5
560
Code Review Best Practice
Avatar for Trisha Gee trishagee
67
18k
Performance Is Good for Brains [We Love Speed 2024]
Avatar for Tammy Everts tammyeverts
10
780
Navigating Team Friction
Avatar for Lara Hogan lara
185
15k
Designing for humans not robots
Avatar for Tammie Lister tammielis
253
25k
Optimizing for Happiness
Avatar for Tom Preston-Werner mojombo
378
70k
Keith and Marios Guide to Fast Websites
Avatar for Keith Pitt keithpitt
411
22k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
Avatar for Sam Stephenson sstephenson
160
15k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
Avatar for Irina Nazarova irinanazarova
8
700
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
29
1.7k

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！