The premise of this document is to provide reader with ideas on how to manage a growing number of reference databases as teams adopt Datical.
...
During early phase of Datical adoption, teams typically setup Reference Databases on their own, i.e., they may not be using centralized infrastructure from day 1. This allows teams flexibility to manage and configure their Reference Databases as well as underlying servers. However, as Datical usage grows, the approach above would create a sprawl of Reference Databases. To better manage demandsprawl, it would be ideal to move Reference Databases to centralized/shared infrastructure.
...
The best practice, however, for scaling out SQL Server-based Reference Databases would be to arrange separate servers for each version of SQL Server. And then run only one version of Database Engine (SQL Server instance) per server.
Name collisions when multiple applications use the same name.
Impact when database goes down
Manage backup and restore when database or server goes down - storage separate from server
Backup server -
Reference Database for Oracle 11g
...
| Environments in the pipeline | Notes | |
|---|---|---|
| Pipeline 1 | REF1 → DEV1 → QA1 → UAT → PROD | Reference Databases (numbered) for each pipeline. DEV1-5, QA1-5, UAT and PROD are existing databases in pipelines. |
| Pipeline 2 | REF2 → DEV2 → QA2 → UAT → PROD | |
| Pipeilne 3 | REF3 → DEV3 → QA3 → UAT → PROD | |
| Pipeline 4 | REF4 → DEV4 → QA4 → UAT → PROD | |
| Pipeline 5 | REF5 → DEV5 → QA5 → UAT → PROD |
...
Oracle 12c has the concept of pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and non-schema objects that appear to an Oracle Net client as a separate database. One or more PDBs together are called a container database (CDB).
Because each PDB is a separate database, you can configure all Reference Databases as PDBs on a single Oracle 12c instance. The number of PDBs (hence number Reference Databases) per Oracle 12 instance would be dictated by the size of each Reference Database (size depends on number of objects in the database and the amount of data needed in the database).
...