Ask HN: How to alter big table?

1 pointsckn1 comment

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.

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.

Reply on news.ycombinator.com