top | item 36039342 (no title) brootstrap | 2 years ago have worked on 20TB+ tables before. proper schema / index / query, shit is still fast as hell when you do it right discuss order hn newest mh-|2 years ago Yep, was just sharing this experience in the comments as well. By far the most painful part is schema migrations, and that's well-solved with pt-osc or gh-osc. duskwuff|2 years ago With MySQL 8.0+, you might not even need pt-osc. A lot of schema changes can be performed online now.https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-op... load replies (1)
mh-|2 years ago Yep, was just sharing this experience in the comments as well. By far the most painful part is schema migrations, and that's well-solved with pt-osc or gh-osc. duskwuff|2 years ago With MySQL 8.0+, you might not even need pt-osc. A lot of schema changes can be performed online now.https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-op... load replies (1)
duskwuff|2 years ago With MySQL 8.0+, you might not even need pt-osc. A lot of schema changes can be performed online now.https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-op... load replies (1)
mh-|2 years ago
duskwuff|2 years ago
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-op...