MariaDB 10.3 Instant Add column billion large table millisecond-level plus field

Add field is painful, need to rebuild the table, especially for the million-level table, although the online DDL can avoid the lock table, but if it takes 30 minutes to execute on the main library, then copy to the execution from the library, master-slave replication is delayed. With the Instant ADD column feature, you just have to bounce down the soot and the fields are up, and enjoy the flexibility and convenience of the unstructured storage like MongoDB.

Limit
1. If after is specified, the field must be in the last column, or the table will be re-established
2. Not applicable to Row_format = Compressed
3. DROP column need to rebuild table

MariaDB 10.3 Instant Add column billion large table millisecond-level plus field