天天看点

mysql 多租户,如何设计多租户mysql数据库

mysql 多租户,如何设计多租户mysql数据库

Let us say I need to design a database which will host data for multiple companies. Now for security and admin purposes I need to make sure that the data for different companies is properly isolated but I also do not want to start 10 mysql processes for hosting the data for 10 companies on 10 different servers. What are the best ways to do this with the mysql database.

解决方案

There are several approaches to multi-tenant databases. For discussion, they're usually broken into three categories.

One database per tenant.

Shared database, one schema per

tenant.

Shared database, shared schema. A tenant identifier (tenant key) associates every row with the right tenant.

MSDN has a good article on the pros and cons of each design.

继续阅读