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

Percona Migrator: an ActiveRecord adapter for online MySQL migrations

F93acf41fbe5f1b68a4edba716e865a1?s=47 Pau Pérez
February 14, 2017

Percona Migrator: an ActiveRecord adapter for online MySQL migrations

Presentation of https://github.com/redbooth/percona_migrator in Barcelona's MySQL meetup


Pau Pérez

February 14, 2017


  1. Percona Migrator Active Record Adapter for online MySQL Migrations

  2. @prez_pau Backend developer at Redbooth and doing stuff with relational

  3. What’s Percona Migrator?

  4. ❤ to the users

  5. to developers

  6. migrations for apps but with steroids

  7. respectful with the database

  8. by default!

  9. No need to learn a new DSL

  10. to customers

  11. Does not affect the database’s functioning

  12. downtime

  13. How does it do that?

  14. from the folks at Percona pt-online-schema-change

  15. None
  16. None
  17. None
  18. With dynamic copy chunks replica lag monitoring load monitoring ...

  19. The glue: An ActiveRecord connection adapter

  20. None
  21. None
  22. None
  23. OK, but show me

  24. None
  25. Breaking news!

  26. Breaking news! There will be a rename

  27. departure? some migrating animal? stork, caribou, etc.

  28. bird, db_bird, angry_bird, paharoo?

  29. please, help us! redbooth/percona_migrator issues/43

  30. Do you want to know more? blog post

  31. Q&A