Re: Another way to ALTER table on heavily loaded database
Posted by: Rick James
Date: April 22, 2016 05:54PM

Plan A: pt-online-schema-change

Plan B: ALTER TABLE ... ALGORITHM=INPLACE ...; it should be minimally invasive in 5.6.26.

Plan C: Disconnect the two masters, take one master offline, make the change with out replicating the ALTER, failovcer, make the change in the other machine, then go back to normal.

Plan D: Don't add the column to the current table; make a parallel table with the same PRIMARY KEY, plus the new column.

Options: ReplyQuote


Subject
Written By
Posted
Re: Another way to ALTER table on heavily loaded database
April 22, 2016 05:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.