Comments on: Thoughts and ideas for Online Schema Change https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change Blog by Shlomi Noach Tue, 26 Jul 2011 04:50:31 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: shlomi https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/comment-page-1#comment-47093 Tue, 26 Jul 2011 04:50:31 +0000 https://shlomi-noach.github.io/blog/?p=3005#comment-47093 Hmmm, I don’t see that it has been released yet.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/comment-page-1#comment-47092 Tue, 26 Jul 2011 04:48:43 +0000 https://shlomi-noach.github.io/blog/?p=3005#comment-47092 @Rudi,

Yes, I was aware they were developing the tool: see discussion on first links you’ve attached.
I wasn’t aware it was out, though. I suspect this will become the preferred tool for this job.

]]> By: Rudi https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/comment-page-1#comment-47039 Mon, 25 Jul 2011 20:55:31 +0000 https://shlomi-noach.github.io/blog/?p=3005#comment-47039 Maakit has just released a new command line tool for mysql live online schema changes as well. Have a look. Seems to also support foreign keys 😉

http://code.google.com/p/maatkit/issues/detail?id=1268

http://code.google.com/p/maatkit/
http://www.maatkit.org/

]]> By: Rudi https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/comment-page-1#comment-46408 Mon, 18 Jul 2011 21:35:21 +0000 https://shlomi-noach.github.io/blog/?p=3005#comment-46408 I agree, in an age of online application it should be possible to do database schema updates without having to bring your applications offline. This is a wonderful tool by facebook that could be taken further and save many headaches for administrator and developers.

You would almost expect this to be a function built into mysql workbench! Load a list of SQL DB Schema change statements and run them.

I have looked but do not seem to be able to find any projects related to the live upgrade of mysql schemas.
Is live updates not a big problem for most HA applications?

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/comment-page-1#comment-23451 Wed, 15 Dec 2010 10:55:17 +0000 https://shlomi-noach.github.io/blog/?p=3005#comment-23451 @willem,
To support your point, can you please provide with counter examples or facts?

]]> By: willem https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/comment-page-1#comment-23444 Wed, 15 Dec 2010 09:52:13 +0000 https://shlomi-noach.github.io/blog/?p=3005#comment-23444 “Well, allow me to add a few words: the CREATE INDEX is by far not the only thing you can achieve with OSC (although it may be Facebook’s major concern). You should be able to:

* Add columns
* Drop columns
* Convert character sets
* Modify column types
* Add partitioning
* Reorganize partitioning
* Compress the table
* Otherwise changing table format
* Heck, you could even modify the storage engine! (To other transactional engine)

These are giant steps.”

I agree- in 1985 that would have been a big step indeed. Wonderful how well described the crappiness of mysql :
“How easy would it be to write these down into the database? It only takes a few weeks time to work out a working solution with reasonable limitations, just using the resources the MySQL server provides you with”.
Amen!

]]> By: Jonas Oreland https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/comment-page-1#comment-18613 Fri, 08 Oct 2010 04:37:36 +0000 https://shlomi-noach.github.io/blog/?p=3005#comment-18613 Maybe you already no, but if you’re using ndb with MySQL (aka MySQL Cluster) then we have create/drop index, add column, reorganize partition and optimize table online. And by online I mean without table copying and both reads/writes are allowed in parallel.

]]> By: Justin Swanhart https://shlomi-noach.github.io/blog/mysql/thoughts-and-ideas-for-online-schema-change/comment-page-1#comment-18609 Thu, 07 Oct 2010 20:39:23 +0000 https://shlomi-noach.github.io/blog/?p=3005#comment-18609 They certainly deserve a lot of credit, and so do you.

Thanks for you contributions to the open source community surrounding MySQL.

]]>