MySQL 8.0 (the DMR version is available now) has two great features (among others):
- The new data dictionary completely removed *.frm files, which is great
- The ability to create a tablespace and assign a group of tables to it (originally introduced in 5.7).
With those two options, we can use MySQL for creating multi-tenant environments with a “schema per customer” approach.
Schema per Customer with MySQL 8.0
Using schema per customer with older MySQL versions presents issues … namely the number of files. (I’ve described …[Read more]