2 ms·

Ask HN: How to alter big table?

1 points by sckn 9y 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.

GrumpyNl 9y 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.