Motivation:
When it imports OAGIS components of new release to upgrade/patch Score in end-user sides, it needs to provide some complex DB script/program due to a primary key conflict in between Developer’s and End User’s.
Proposal:
Sequence diagram
Directory records example:
Username | Role | Shard Node |
|---|---|---|
Serm | EndUser | enduser |
Sermdev | Developer | developer |
Question) Would one user be able to have multiple roles (e.g., ‘Serm’ user could be used for both ‘Developer’ and ‘End User’)?
Case of one database instance
Shard Node | Endpoint |
|---|---|
enduser | mysql://localhost:3306/enduser |
developer | mysql://localhost:3306/developer |
Dealing with multiple database in one MySQL instance
Case of two database instance
Shard Node | Endpoint |
|---|---|
enduser | mysql://172.12.3.1:3306/oagi |
developer | mysql://172.12.3.2:3306/oagi |
Dealing with multiple server for each MySQL instance