Hacker News .hnnew | past | comments | ask | show | jobs | submitlogin

Do people still use pt-online-schema-change for production schema changes? I remember using it a long time ago.


Gh-ost is the new hotness. Simple to use and lots of great features: https://github.com/github/gh-ost


Unfortunately yes, but as always only for the type of time-consuming DDL changes that incur a write block in a situation where you just can't have the production environment stall or wait that long. The past 5-10 years have seen several improvements allowing some types of schema changes to be done "online" without blocking writes.


Django just does it, run those migrations all the way through dev -> test -> prod.

Look ma, no DBA required.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: