Single tenant architecture typically means one client per database. IOW, if you have multiple clients, you create a separate database for each client. This prevents one category of programming errors from exposing client data to the wrong client.
In a multi-client architecture, some or all clients are stored in a single database. Most of the tables have additional columns for a client ID, etc in order to logically separate one client's data from all of the others
2 comments
[ 3.0 ms ] story [ 12.3 ms ] threadIn a multi-client architecture, some or all clients are stored in a single database. Most of the tables have additional columns for a client ID, etc in order to logically separate one client's data from all of the others