How to design a multi tenant mysql database

by

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, and examples of implementations.

Microsoft has apparently taken down the pages I referred to, but they are on on archive.org. Links have been changed to point there.

For reference, this is the original link for the second article

More Related Contents:

  1. What does character set and collation mean exactly?
  2. Implementing Comments and Likes in database
  3. Auto Generate Database Diagram MySQL [closed]
  4. MySQL stored procedures use them or not to use them
  5. In SQL, is it OK for two tables to refer to each other?
  6. Modeling Product Variants
  7. DOs and DONTs for Indexes [closed]
  8. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  9. Difference between two table structure
  10. Proper database model for a user feedback system (an interesting case)
  11. Strings as Primary Keys in MYSQL Database [closed]
  12. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  13. Inventory management with stock options
  14. How to store multiple options in a single table?
  15. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  16. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  17. Is there a MySQL option/feature to track history of changes to records?
  18. How to pivot a MySQL entity-attribute-value schema
  19. MySQL: multiple tables or one table with many columns? [closed]
  20. single fixed table with multiple columns vs flexible abstract tables
  21. Unique constraint that allows empty values in MySQL
  22. MySQL Insert Into from one Database in another
  23. How do I get the ID of multiple inserted rows in MySQL?
  24. How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
  25. Case statement in MySQL
  26. How to find out the MySQL root password
  27. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  28. MySQL – how to front pad zip code with “0”?
  29. Easiest way to copy a table from one database to another?
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment