SQL database

1# yaml-language-server: $schema=../schema/kind.schema.json
2# Relational datastore, usually the system of record.
3# multiWriter and sharded default false so single-writer-primary-at-peak-qps can fire on the common case.
4schemaVersion: "1"
5type: "kind"
6id: "sql-database"
7category: "data"
8properties:
9  backupEnabled:
10    type: "boolean"
11    default: false
12  backupRetentionDays:
13    type: "integer"
14  replication:
15    type: "enum"
16    values: ["none", "async", "sync"]
17    default: "none"
18  replicaOf:
19    type: "ref"
20    refKind: "sql-database"
21  encryptionAtRest:
22    type: "boolean"
23    default: false
24  sharded:
25    type: "boolean"
26    default: false
27  shardKey:
28    type: "string"
29  multiWriter:
30    type: "boolean"
31    default: false
32  distributed:
33    type: "boolean"
34    default: false
35  replicaFanout:
36    type: "integer"
37    advanced: true
38  idEncodesShard:
39    type: "boolean"
40    default: false
41    advanced: true
42  concurrencyControl:
43    type: "enum"
44    values: ["pessimistic", "optimistic", "constraint"]
45    advanced: true
46  commitProtocol:
47    type: "enum"
48    values: ["single", "two-phase"]
49    default: "single"
50    advanced: true
51  appendOnly:
52    type: "boolean"
53    default: false
54    advanced: true
55  instances:
56    type: "integer"
57  managed:
58    type: "boolean"
59    default: false