If you have a Master-Master and you explicitly name all the columns in
your queries, you can do it by doing it on one master and flipping the
application and etc.
If not, look at
http://www.percona.com/doc/percona-toolkit/2.0/pt-online-schema-change.html
Singer
On Thu, Feb 16, 2012 at 20:29, Wi
duplicate the table structure, add the column to the new table, import the
records into the table. this should be faster based on my experience and also
will not disturb your transactions :)
On Feb 17, 2012, at 8:21 AM, Angela liu wrote:
> Hi, Folk:
>
> I will need to add a column to a huge
