How do you handle the task of changing the schema of a production MySQL database?
Posted
by Continuation
on Server Fault
See other posts from Server Fault
or by Continuation
Published on 2009-10-25T22:10:30Z
Indexed on
2010/04/22
3:54 UTC
Read the original article
Hit count: 227
One of the biggest complaints I have heard about MySQL is that it locks up a table if you try to change its schema like adding a column or adding an index.
By "locking up the table" does it mean I can neither read nor write to the table? Sometimes for hours?
That seems a pretty severe limitations. I was going to use MySQL for my new project but this gives me pause.
Is there a workaround for this? How do you handle the task of changing the schema of your production MySQL database?
By the way someone told me Postgresql doesn't have this problem. Is that true - I can both read and write to a Postgresql table while changing its schema? Is there any performance penalty incurred?
Would love to hear your experiences.
© Server Fault or respective owner