MySQL
Open-source single-primary relational database with asynchronous replication.
- Provider
- default
- Kind
- SQL database
- Category
- Data
- Official docs
- https://dev.mysql.com/doc/refman/8.4/en/
| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| appendOnly | boolean | — | no | false | inherited |
| backupEnabled | boolean | — | no | false | inherited |
| backupRetentionDays | integer | — | no | — | inherited |
| commitProtocol | enum | single | two-phase | no | single | inherited |
| concurrencyControl | enum | pessimistic | optimistic | constraint | no | — | ▸ pessimistic |
| distributed | boolean | — | no | false | inherited |
| encryptionAtRest | boolean | — | no | false | inherited |
| idEncodesShard | boolean | — | no | false | inherited |
| instances | integer | — | no | — | inherited |
| managed | boolean | — | no | false | inherited |
| multiWriter | boolean | — | no | false | inherited |
| replicaFanout | integer | — | no | — | inherited |
| replicaOf | ref | — | no | — | inherited |
| replication | enum | none | async | sync | no | none | ▸ none |
| shardKey | string | — | no | — | inherited |
| sharded | boolean | — | no | false | inherited |
| storageEngine | enum | innodb | myisam | no | innodb | inherited |
| version | string | — | no | — | 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: "mysql", component: "mysql" }# yaml-language-server: $schema=../../schema/component.schema.json # MySQL: single-primary relational database; replication is asynchronous and opt-in. schemaVersion: "1" type: "component" id: "mysql" kind: "sql-database" provider: "default" docs: "https://dev.mysql.com/doc/refman/8.4/en/" defaults: replication: "none" concurrencyControl: "pessimistic" properties: version: type: "string" storageEngine: type: "enum" values: ["innodb", "myisam"] default: "innodb"