Hacker News new | ask | show | jobs
by fraktl 1967 days ago
MySQL has pluggable storage engines. TokuDB does what you're after (adds indexes on the fly, as well as alter tables on the fly without overloading the server).
2 comments
hu3 1967 days ago
This page about TokuDB reads:

> TokuDB has been deprecated by its upstream maintainer. It is disabled from MariaDB 10.5 and has been been removed in MariaDB 10.6 - MDEV-19780. We recommend MyRocks as a long-term migration path.

https://mariadb.com/kb/en/tokudb/

Is MyRocks comparable?

link
wolf550e 1967 days ago
Altering table online without using pt-online-schema-change doesn't help if they want an index that covers only some of the keys but not others.
link