« Data management (Cloud) » : différence entre les versions
Aucun résumé des modifications |
|||
| (3 versions intermédiaires par le même utilisateur non affichées) | |||
| Ligne 1 : | Ligne 1 : | ||
__NOTOC__ | __NOTOC__ | ||
==Overview== | ==Overview== | ||
Sage FRP 1000 Cloud solution has been developed | Sage FRP 1000 Cloud solution has been developed for SQL Azure Database. | ||
Each production environment has its own SQL virtual server. | Each production environment has its own SQL virtual server. | ||
| Ligne 17 : | Ligne 17 : | ||
== Multitenancy== | == Multitenancy== | ||
A multitenancy environment may | A multitenancy environment, which typically is large, may uses one or several production databases. | ||
A multi tenants repository master database : | A multi tenants repository master database : | ||
| Ligne 29 : | Ligne 29 : | ||
* Has a tenant identifier in each table. | * Has a tenant identifier in each table. | ||
Note that one tenant data set MUST be stored inside a single database, spreading tenant's data | Note that one tenant data set MUST be stored inside a single database, spreading tenant's data on several databases is not supported. | ||
| Ligne 35 : | Ligne 35 : | ||
[[Category:Cloud]] | [[Category:Cloud]] | ||
[[Category:Architecture]] | [[Category:Architecture]] | ||
[[Category:Latest]] | |||
Dernière version du 7 février 2019 à 07:04
Overview
Sage FRP 1000 Cloud solution has been developed for SQL Azure Database.
Each production environment has its own SQL virtual server.
Small environment
In a small environment a single database may be used.
In this case both the repository master database and the production data of a single tenant may be stored in the same database.
Medium and large environments
In these environments a minimum of two databases is required.
- The repository master database base.
- A production database.
Multitenancy
A multitenancy environment, which typically is large, may uses one or several production databases.
A multi tenants repository master database :
- Is managed in shared mode
- (The shared mode is the model used for multi-societies databases)
A multi tenants production database :
- May content data of several tenants.
- Has a tenant identifier in each table.
Note that one tenant data set MUST be stored inside a single database, spreading tenant's data on several databases is not supported.