Ask HN: How to alter big table?

1 points by sckn 9y ago ↗ HN

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 comment

[ 2.6 ms ] story [ 10.4 ms ] thread

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.