-
Notifications
You must be signed in to change notification settings - Fork 46
/
Copy pathops-postgres-to-mysql.yml
115 lines (107 loc) · 2.68 KB
/
ops-postgres-to-mysql.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
- type: replace
path: /name
value: sample-credhub-mysql-uaa
- type: remove
path: /releases/name=postgres
- type: replace
path: /releases/-
value:
name: pxc
version: latest
- type: replace
path: /variables/name=uaa-tls/options/alternative_names/-
value: localhost
- type: replace
path: /variables/name=database-tls/options/common_name
value: 127.0.0.1
- type: replace
path: /variables/name=database-tls/options/alternative_names
value:
- ((external-ip-address))
- ((internal-ip-address))
- 127.0.0.1
- type: replace
path: /variables/-
value:
name: credhub-db
type: password
- type: replace
path: /variables/-
value:
name: uaa-db
type: password
- type: replace
path: /variables/-
value:
name: galera-healthcheck-db
type: password
- type: replace
path: /variables/-
value:
name: galera-healthcheck-endpoint
type: password
- type: replace
path: /variables/-
value:
name: cluster-health
type: password
- type: replace
path: /instance_groups/name=credhub/persistent_disk?
value: 10240
- type: replace
path: /instance_groups/name=credhub/jobs/name=credhub/properties/credhub/data_storage
value:
type: mysql
username: credhub
password: ((credhub-db))
host: 127.0.0.1
port: 3306
database: credhub
require_tls: true
tls_ca: ((database-tls.ca))
- type: remove
path: /instance_groups/name=credhub/jobs/name=postgres
- type: replace
path: /instance_groups/name=credhub/jobs/-
value:
name: pxc-mysql
release: pxc
properties:
admin_username: admin
admin_password: ((database-admin))
tls:
server: ((database-tls))
seeded_databases:
- name: credhub
username: credhub
password: ((credhub-db))
- name: uaa
username: uaa
password: ((uaa-db))
- type: replace
path: /instance_groups/name=credhub/jobs/-
value:
name: galera-agent
release: pxc
properties:
db_password: ((galera-healthcheck-db))
endpoint_password: ((galera-healthcheck-endpoint))
- type: replace
path: /instance_groups/name=credhub/jobs/-
value:
name: cluster-health-logger
release: pxc
properties:
db_password: ((cluster-health))
- type: replace
path: /instance_groups/name=credhub/jobs/name=uaa/properties/uaadb/port
value: 3306
- type: replace
path: /instance_groups/name=credhub/jobs/name=uaa/properties/uaadb/db_scheme
value: mysql
- type: replace
path: /instance_groups/name=credhub/jobs/name=uaa/properties/uaadb/roles/tag=admin/name
value: uaa
- type: replace
path: /instance_groups/name=credhub/jobs/name=uaa/properties/uaadb/roles/tag=admin/password
value: ((uaa-db))