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

MySQL to NoSQL & Search Engine

Gea-Suan Lin
October 28, 2017

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

More Decks by Gea-Suan Lin

Other Decks in Technology


  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!