Timeline for Best practices for schema changes and data migrations to a live database without downtime?
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 1, 2021 at 19:43 | comment | added | Kevin Borders | Another tool for this is pt-online-schema-change, part of the Percona toolkit. | |
| Feb 25, 2021 at 8:51 | comment | added | djvg | Facebook's OnlineSchemaChange tool, linked by @NickChammas above, has a pretty good explanation here: How OSC works | |
| May 13, 2016 at 19:10 | comment | added | Nick Chammas | @SandeepanNath - Sorry, I'm not that familiar with Facebook's tool and so can't point you to more resources. I read an announcement about it and posted my comment years ago, but I've never used it. | |
| May 13, 2016 at 18:58 | comment | added | Sandeepan Nath | @NickChammas Thanks for sharing that. I have a lot of questions on it. Could you please suggest a more detailed tutorial, a video preferably, which explains the things like bit log, non clustered indexes, and answers questions like - 1. How will selecting data from source table into an outfile reduce load as compared to copying to destination table directly. 2. When will the copy phase end? These are only a few questions I have and I have only started reading it. | |
| Jan 22, 2012 at 21:30 | comment | added | ash | K. Scott Allen wrote about a system for managing schema versions here. I created DbUpdater, an open source tool for version-aware schema deployment. More here - http://www.tewari.info/dbupdater | |
| Jan 19, 2012 at 22:10 | vote | accept | Dan Leary | ||
| S Jan 19, 2012 at 15:04 | history | suggested | Chris Aldrich |
added a tag
|
|
| Jan 19, 2012 at 14:30 | review | Suggested edits | |||
| S Jan 19, 2012 at 15:04 | |||||
| Jan 18, 2012 at 23:57 | answer | added | Erwin Brandstetter | timeline score: 34 | |
| Jan 18, 2012 at 23:31 | history | edited | Nick Chammas | CC BY-SA 3.0 |
added 82 characters in body; edited tags
|
| Jan 18, 2012 at 23:28 | history | tweeted | twitter.com/#!/StackDBAs/status/159779271102042112 | ||
| Jan 18, 2012 at 23:27 | comment | added | Nick Chammas | Facebook developed a tool to do this for MySQL. | |
| Jan 18, 2012 at 22:48 | history | migrated | from stackoverflow.com (revisions) | ||
| Jan 18, 2012 at 22:44 | history | asked | Dan Leary | CC BY-SA 3.0 |