Ask HN: How to alter big table?

Y	Hacker News new \| ask \| show \| jobs

1 points by sckn 3224 days ago

Hi, I have MySQL cluster. Some tables have ~8m records. Alter process made downtime.

What is your solution?

Example: Blue/Green create table instead of alter. horizontal scaling etc. Thanks.

1 comments

GrumpyNl 3224 days ago

If its not feed with realtime data,create new table with all the bells and whisles you need. Copy and insert the table data. Rename the tables. Remove the unused table.

link