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.