With InfiniDB, you can add new columns to existing tables in an online fashion; queries are not blocked on the table while the alter is running. Executing an online alter involves two steps:
1. Execute the InfiniDB online add column function
2. Synchronize the MySQL database with the altered InfiniDB object
As an example, let's say you want to add a new column named 'p_new' to an existing table called 'part':
mysql> select calonlinealter('alter table part add column p_new int;');
+----------------------------------------------------------+
| calonlinealter('alter table part add column p_new int;') |
+----------------------------------------------------------+
| 0 |
+----------------------------------------------------------+
1 row in set (21.20 sec)
mysql> alter table part add column p_new int comment 'schema sync only';
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0
