1apiVersion: sql.cnrm.cloud.google.com/v1beta1
2kind: SQLDatabase
3metadata:
4 name: ${gcp_project_id}
5 namespace: edge-system
6 labels:
7 platform.edge.ncr.com/component: edge-api
8 cluster_hash: ${cluster_hash}
9 cluster_uuid: ${cluster_uuid}
10 annotations:
11 cnrm.cloud.google.com/deletion-policy: abandon
12 cnrm.cloud.google.com/project-id: ${gcp_project_id}
13 pallet.edge.ncr.com/created: "2023-02-16T21:26:39Z"
14 pallet.edge.ncr.com/name: edge-db
15 pallet.edge.ncr.com/revision: 696897a3df910b6e84a88c9336907a17b18159c1
16 pallet.edge.ncr.com/source: https://github.com/ncrvoyix-swt-retail/edge-infra/tree/696897a3df910b6e84a88c9336907a17b18159c1
17 pallet.edge.ncr.com/team: '@ncrvoyix-swt-retail/edge-platform'
18 pallet.edge.ncr.com/version: 7.7.7-rc.1676582799+commit.696897a
19spec:
20 instanceRef:
21 name: ${gcp_project_id}
22---
23apiVersion: sql.cnrm.cloud.google.com/v1beta1
24kind: SQLInstance
25metadata:
26 name: ${gcp_project_id}
27 namespace: edge-system
28 labels:
29 platform.edge.ncr.com/component: edge-api
30 cluster_hash: ${cluster_hash}
31 cluster_uuid: ${cluster_uuid}
32 annotations:
33 cnrm.cloud.google.com/deletion-policy: abandon
34 cnrm.cloud.google.com/project-id: ${gcp_project_id}
35 pallet.edge.ncr.com/created: "2023-02-16T21:26:39Z"
36 pallet.edge.ncr.com/name: edge-db
37 pallet.edge.ncr.com/revision: 696897a3df910b6e84a88c9336907a17b18159c1
38 pallet.edge.ncr.com/source: https://github.com/ncrvoyix-swt-retail/edge-infra/tree/696897a3df910b6e84a88c9336907a17b18159c1
39 pallet.edge.ncr.com/team: '@ncrvoyix-swt-retail/edge-platform'
40 pallet.edge.ncr.com/version: 7.7.7-rc.1676582799+commit.696897a
41spec:
42 databaseVersion: POSTGRES_14
43 region: us-central1
44 rootPassword:
45 valueFrom:
46 secretKeyRef:
47 name: edge-sql-password
48 key: password
49 settings:
50 availabilityType: REGIONAL
51 backupConfiguration:
52 enabled: true
53 pointInTimeRecoveryEnabled: true
54 databaseFlags:
55 - name: cloudsql.enable_pg_cron
56 value: "on"
57 - name: cloudsql.iam_authentication
58 value: "on"
59 - name: cron.database_name
60 value: ${gcp_project_id}
61 tier: db-custom-1-3840
62---
63apiVersion: sql.cnrm.cloud.google.com/v1beta1
64kind: SQLUser
65metadata:
66 name: edge-db-read-only-user
67 namespace: edge-system
68 labels:
69 platform.edge.ncr.com/component: edge-api
70 cluster_hash: ${cluster_hash}
71 cluster_uuid: ${cluster_uuid}
72 annotations:
73 cnrm.cloud.google.com/deletion-policy: abandon
74 cnrm.cloud.google.com/project-id: ${gcp_project_id}
75 pallet.edge.ncr.com/created: "2023-02-16T21:26:39Z"
76 pallet.edge.ncr.com/name: edge-db
77 pallet.edge.ncr.com/revision: 696897a3df910b6e84a88c9336907a17b18159c1
78 pallet.edge.ncr.com/source: https://github.com/ncrvoyix-swt-retail/edge-infra/tree/696897a3df910b6e84a88c9336907a17b18159c1
79 pallet.edge.ncr.com/team: '@ncrvoyix-swt-retail/edge-platform'
80 pallet.edge.ncr.com/version: 7.7.7-rc.1676582799+commit.696897a
81spec:
82 instanceRef:
83 name: ${gcp_project_id}
84 password:
85 valueFrom:
86 secretKeyRef:
87 name: edge-db-read-only-user-pass
88 key: password
View as plain text