Autonomous AI Database on Dedicated Exadata Infrastructure
Autonomous Oracle in a private Autonomous Container Database on dedicated Exadata.
- Provider
- oci
- Kind
- SQL database
- Category
- Data
- Also known as
- ADB-D
| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| appendOnly | boolean | — | no | false | inherited |
| autonomousDataGuard | boolean | — | no | false | inherited |
| backupDestination | enum | object-storage | recovery-service | no | object-storage | inherited |
| backupEnabled | boolean | — | no | false | ▸ true |
| backupRetentionDays | integer | — | no | — | ▸ 15 |
| commitProtocol | enum | single | two-phase | no | single | inherited |
| concurrencyControl | enum | pessimistic | optimistic | constraint | no | — | ▸ pessimistic |
| crossRegionBackup | boolean | — | no | false | inherited |
| distributed | boolean | — | no | false | inherited |
| encryptionAtRest | boolean | — | no | false | ▸ true |
| idEncodesShard | boolean | — | no | false | inherited |
| instances | integer | — | no | — | inherited |
| managed | boolean | — | no | false | ▸ true |
| multiWriter | boolean | — | no | false | inherited |
| replicaFanout | integer | — | no | — | inherited |
| replicaOf | ref | — | no | — | inherited |
| replication | enum | none | async | sync | no | none | ▸ none |
| retentionLock | boolean | — | no | false | inherited |
| shardKey | string | — | no | — | inherited |
| sharded | boolean | — | no | false | inherited |
Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.
Application servers write this database and the design keeps a search index, but nothing captures the database's changes. The index then depends on the application writing to both places, and the two drift apart silently.
- — all of these hold:
- — the node has at least one synchronous incoming edge from an app-server
- — the design contains a node of kind search-index
- — this does not hold:
- — the node has at least one outgoing edge to a change-data-capture
A system of record with backups off, or with no retention period stated, cannot be restored. The loss is discovered on the day it matters.
- — any of these hold:
- — the node's `backupEnabled` is false
- — the node's `backupRetentionDays` has no value
The design promises multi-region availability, but this datastore sits in one region and does not replicate. A region outage takes the system of record with it.
- — all of these hold:
- — the design requirement `availability.multiRegion` is true
- — the node sits inside exactly 1 region group
- — the node's `replication` is "none"
The design states a read-heavy workload and application servers read this datastore directly, yet the design has no cache anywhere. Every read pays a database round trip.
- — all of these hold:
- — the design requirement `traffic.readWriteRatio` is a number greater than 10
- — the node has at least one synchronous incoming edge from an app-server
- — this does not hold:
- — the design contains a node of kind cache
Asynchronous read replicas scale reads only. When the store is neither sharded nor distributed the writes still land on one primary, so the replicas add nothing at the declared peak.
- — all of these hold:
- — the node's `replication` is "async"
- — the node's `sharded` is false
- — the node's `distributed` is false
- — the node's declared requests per second is more than 5000
A single-writer, unsharded relational primary has a throughput ceiling. Declaring more than five thousand requests per second against it means the peak finds that ceiling in production.
- — all of these hold:
- — the node's `multiWriter` is false
- — the node's `sharded` is false
- — the node's declared requests per second is more than 5000
nodes:
- { id: "autonomous-database-dedicated", component: "oci-autonomous-database-dedicated" }# yaml-language-server: $schema=../../schema/component.schema.json # Autonomous AI Database on Dedicated Exadata Infrastructure: autonomous databases inside a # customer-isolated Autonomous Container Database. "Backup and Restore Autonomous AI Database on # Dedicated Exadata Infrastructure": automatic backups on, 15-day retention (7-95), weekly full # plus daily incremental, Object Storage the default destination in the public cloud. schemaVersion: "1" type: "component" id: "oci-autonomous-database-dedicated" kind: "sql-database" provider: "oci" docs: "https://docs.oracle.com/en/cloud/paas/autonomous-database/dedicated/adbaa/backup-and-restore-autonomous-ai-database-on-dedicated.html" aliases: ["ADB-D"] defaults: managed: true backupEnabled: true backupRetentionDays: 15 replication: "none" encryptionAtRest: true concurrencyControl: "pessimistic" properties: backupDestination: type: "enum" values: ["object-storage", "recovery-service"] default: "object-storage" autonomousDataGuard: type: "boolean" default: false retentionLock: type: "boolean" default: false crossRegionBackup: type: "boolean" default: false