Another way to ALTER table on heavily loaded database

MySQL & MariaDB Other MySQL® Questions
#1
#2

The Percona Toolkit has a tool for changing tables without locking, based on triggers. It’s probably what you’re looking for.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2021 Percona LLC. All rights reserved.