We need to add a set of columns which is large enough (2 GB). Running a migration just adding 1 column (ad_common) 690 Now to add 6 columns will lock the table for approximately 1 hour which is not desirable.
Any suggestions about how to achieve this with beauty? [Switching from MySQL to Postgres or any other platform is not an option.]
A gem has evolved Soundcloud is called a Large Hadron Accelerator (LHM) which simplifies these kinds of migration through the use of the copy table.
I hope this can help you.
Comments
Post a Comment