Slide 1

Slide 1 text

Percona Migrator Active Record Adapter for online MySQL Migrations

Slide 2

Slide 2 text

@prez_pau Backend developer at Redbooth and doing stuff with relational databases

Slide 3

Slide 3 text

What’s Percona Migrator?

Slide 4

Slide 4 text

❤ to the users

Slide 5

Slide 5 text

to developers

Slide 6

Slide 6 text

migrations for apps but with steroids

Slide 7

Slide 7 text

respectful with the database

Slide 8

Slide 8 text

by default!

Slide 9

Slide 9 text

No need to learn a new DSL

Slide 10

Slide 10 text

to customers

Slide 11

Slide 11 text

Does not affect the database’s functioning

Slide 12

Slide 12 text

downtime

Slide 13

Slide 13 text

How does it do that?

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

No content

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

With dynamic copy chunks replica lag monitoring load monitoring ...

Slide 19

Slide 19 text

The glue: An ActiveRecord connection adapter

Slide 20

Slide 20 text

No content

Slide 21

Slide 21 text

No content

Slide 22

Slide 22 text

No content

Slide 23

Slide 23 text

OK, but show me

Slide 24

Slide 24 text

No content

Slide 25

Slide 25 text

Breaking news!

Slide 26

Slide 26 text

Breaking news! There will be a rename

Slide 27

Slide 27 text

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

Slide 28

Slide 28 text

bird, db_bird, angry_bird, paharoo?

Slide 29

Slide 29 text

please, help us! redbooth/percona_migrator issues/43

Slide 30

Slide 30 text

Do you want to know more? blog post

Slide 31

Slide 31 text

Q&A