Comments - Multi-Tennat Setup MariaDB

6 years, 7 months ago Markus Mäkelä

The MaxScale schemarouter module allows multi-tenant setups by sharding the database based on the schema of the table: https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-21-schemarouter-router/

By using the schemarouter, you can isolate each database either virtually, by using different database instances, or physically, by using different database servers. All of these options can be used with MariaDB encryption.

 
6 years, 6 months ago Satvinder Singh

Am i correct in interpreting that for this to work we will need to have a virtual or a physical MariaDB instance for each tenant?

 
6 years, 6 months ago Markus Mäkelä

If each schema for a tenant must be encrypted by a unique encryption key, then I think it means a separate MariaDB instance for each tenant if the schemarouter is used. MariaDB supports either server level encryption or table level encryption.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.