I’d like to know what’s the people using out there to run rails migrations with MySQL.
Things are slowly improving regarding schema changes in MySQL but blocked tables is still an issue to run online schema changes in large databases. I feel like it’s something that the Rails community hasn’t discussed much about but it’s a know problem many Rails apps on MySQL run into.
At Redbooth we’ve implemented Percona Migrator, an Active Record adapter that executes the statements through Percona’s
pt-online-schema-change. What we first thought it was very challenging it’s proven to be an exciting and successful experiment. It’s become an essential part of a our toolchain.
On the other hand, I’d also like to hear the experience of those running Postgres with large databases. What’s your experience? Does it really allow you to run online schema changes without any problem?