github.com/percona/percona-xtradb-cluster-operator@v1.14.0/e2e-tests/limits/compare/statefulset_no-limits-proxysql-increased-oc.yml (about) 1 apiVersion: apps/v1 2 kind: StatefulSet 3 metadata: 4 generation: 2 5 name: no-limits-proxysql 6 ownerReferences: 7 - controller: true 8 kind: PerconaXtraDBCluster 9 name: no-limits 10 spec: 11 podManagementPolicy: OrderedReady 12 replicas: 2 13 revisionHistoryLimit: 10 14 selector: 15 matchLabels: 16 app.kubernetes.io/component: proxysql 17 app.kubernetes.io/instance: no-limits 18 app.kubernetes.io/managed-by: percona-xtradb-cluster-operator 19 app.kubernetes.io/name: percona-xtradb-cluster 20 app.kubernetes.io/part-of: percona-xtradb-cluster 21 serviceName: no-limits-proxysql-unready 22 template: 23 metadata: 24 labels: 25 app.kubernetes.io/component: proxysql 26 app.kubernetes.io/instance: no-limits 27 app.kubernetes.io/managed-by: percona-xtradb-cluster-operator 28 app.kubernetes.io/name: percona-xtradb-cluster 29 app.kubernetes.io/part-of: percona-xtradb-cluster 30 spec: 31 containers: 32 - env: 33 - name: PMM_SERVER 34 value: monitoring-service 35 - name: PMM_USER 36 value: pmm 37 - name: PMM_PASSWORD 38 valueFrom: 39 secretKeyRef: 40 key: pmmserver 41 name: internal-no-limits 42 - name: CLIENT_PORT_LISTEN 43 value: "7777" 44 - name: CLIENT_PORT_MIN 45 value: "30100" 46 - name: CLIENT_PORT_MAX 47 value: "30105" 48 - name: POD_NAME 49 valueFrom: 50 fieldRef: 51 apiVersion: v1 52 fieldPath: metadata.name 53 - name: POD_NAMESPASE 54 valueFrom: 55 fieldRef: 56 apiVersion: v1 57 fieldPath: metadata.namespace 58 - name: PMM_AGENT_SERVER_ADDRESS 59 value: monitoring-service 60 - name: PMM_AGENT_SERVER_USERNAME 61 value: pmm 62 - name: PMM_AGENT_SERVER_PASSWORD 63 valueFrom: 64 secretKeyRef: 65 key: pmmserver 66 name: internal-no-limits 67 - name: PMM_AGENT_LISTEN_PORT 68 value: "7777" 69 - name: PMM_AGENT_PORTS_MIN 70 value: "30100" 71 - name: PMM_AGENT_PORTS_MAX 72 value: "30105" 73 - name: PMM_AGENT_CONFIG_FILE 74 value: /usr/local/percona/pmm2/config/pmm-agent.yaml 75 - name: PMM_AGENT_SERVER_INSECURE_TLS 76 value: "1" 77 - name: PMM_AGENT_LISTEN_ADDRESS 78 value: 0.0.0.0 79 - name: PMM_AGENT_SETUP_METRICS_MODE 80 value: push 81 - name: PMM_AGENT_SETUP 82 value: "1" 83 - name: PMM_AGENT_SETUP_FORCE 84 value: "1" 85 - name: PMM_AGENT_SETUP_NODE_TYPE 86 value: container 87 - name: PMM_AGENT_SETUP_NODE_NAME 88 value: $(POD_NAMESPASE)-$(POD_NAME) 89 - name: DB_TYPE 90 value: proxysql 91 - name: MONITOR_USER 92 value: monitor 93 - name: MONITOR_PASSWORD 94 valueFrom: 95 secretKeyRef: 96 key: monitor 97 name: internal-no-limits 98 - name: DB_USER 99 value: monitor 100 - name: DB_PASSWORD 101 valueFrom: 102 secretKeyRef: 103 key: monitor 104 name: internal-no-limits 105 - name: DB_CLUSTER 106 value: pxc 107 - name: DB_HOST 108 value: localhost 109 - name: DB_PORT 110 value: "6032" 111 - name: CLUSTER_NAME 112 value: no-limits 113 - name: PMM_ADMIN_CUSTOM_PARAMS 114 - name: PMM_AGENT_PRERUN_SCRIPT 115 value: /var/lib/mysql/pmm-prerun.sh 116 - name: PMM_AGENT_SIDECAR 117 value: "true" 118 - name: PMM_AGENT_SIDECAR_SLEEP 119 value: "5" 120 - name: PMM_AGENT_PATHS_TEMPDIR 121 value: /tmp 122 envFrom: 123 - secretRef: 124 name: no-limits-env-vars-proxysql 125 optional: true 126 imagePullPolicy: IfNotPresent 127 lifecycle: 128 preStop: 129 exec: 130 command: 131 - bash 132 - -c 133 - pmm-admin unregister --force 134 livenessProbe: 135 failureThreshold: 3 136 httpGet: 137 path: /local/Status 138 port: 7777 139 scheme: HTTP 140 initialDelaySeconds: 60 141 periodSeconds: 10 142 successThreshold: 1 143 timeoutSeconds: 5 144 name: pmm-client 145 ports: 146 - containerPort: 7777 147 protocol: TCP 148 - containerPort: 30100 149 protocol: TCP 150 - containerPort: 30101 151 protocol: TCP 152 - containerPort: 30102 153 protocol: TCP 154 - containerPort: 30103 155 protocol: TCP 156 - containerPort: 30104 157 protocol: TCP 158 - containerPort: 30105 159 protocol: TCP 160 resources: {} 161 terminationMessagePath: /dev/termination-log 162 terminationMessagePolicy: File 163 volumeMounts: 164 - mountPath: /var/lib/mysql 165 name: bin 166 - env: 167 - name: PXC_SERVICE 168 value: no-limits-pxc 169 - name: OPERATOR_PASSWORD 170 valueFrom: 171 secretKeyRef: 172 key: operator 173 name: internal-no-limits 174 - name: PROXY_ADMIN_USER 175 value: proxyadmin 176 - name: PROXY_ADMIN_PASSWORD 177 valueFrom: 178 secretKeyRef: 179 key: proxyadmin 180 name: internal-no-limits 181 - name: MONITOR_PASSWORD 182 valueFrom: 183 secretKeyRef: 184 key: monitor 185 name: internal-no-limits 186 envFrom: 187 - secretRef: 188 name: no-limits-env-vars-proxysql 189 optional: true 190 imagePullPolicy: IfNotPresent 191 name: proxysql 192 ports: 193 - containerPort: 3306 194 name: mysql 195 protocol: TCP 196 - containerPort: 6032 197 name: proxyadm 198 protocol: TCP 199 resources: 200 requests: 201 cpu: 600m 202 memory: 1G 203 terminationMessagePath: /dev/termination-log 204 terminationMessagePolicy: File 205 volumeMounts: 206 - mountPath: /var/lib/proxysql 207 name: proxydata 208 - mountPath: /etc/proxysql/ssl 209 name: ssl 210 - mountPath: /etc/proxysql/ssl-internal 211 name: ssl-internal 212 - args: 213 - /usr/bin/peer-list 214 - -on-change=/usr/bin/add_pxc_nodes.sh 215 - -service=$(PXC_SERVICE) 216 env: 217 - name: PXC_SERVICE 218 value: no-limits-pxc 219 - name: OPERATOR_PASSWORD 220 valueFrom: 221 secretKeyRef: 222 key: operator 223 name: internal-no-limits 224 - name: PROXY_ADMIN_USER 225 value: proxyadmin 226 - name: PROXY_ADMIN_PASSWORD 227 valueFrom: 228 secretKeyRef: 229 key: proxyadmin 230 name: internal-no-limits 231 - name: MONITOR_PASSWORD 232 valueFrom: 233 secretKeyRef: 234 key: monitor 235 name: internal-no-limits 236 envFrom: 237 - secretRef: 238 name: no-limits-env-vars-proxysql 239 optional: true 240 imagePullPolicy: IfNotPresent 241 name: pxc-monit 242 resources: {} 243 terminationMessagePath: /dev/termination-log 244 terminationMessagePolicy: File 245 - args: 246 - /usr/bin/peer-list 247 - -on-change=/usr/bin/add_proxysql_nodes.sh 248 - -service=$(PROXYSQL_SERVICE) 249 env: 250 - name: PROXYSQL_SERVICE 251 value: no-limits-proxysql-unready 252 - name: OPERATOR_PASSWORD 253 valueFrom: 254 secretKeyRef: 255 key: operator 256 name: internal-no-limits 257 - name: PROXY_ADMIN_USER 258 value: proxyadmin 259 - name: PROXY_ADMIN_PASSWORD 260 valueFrom: 261 secretKeyRef: 262 key: proxyadmin 263 name: internal-no-limits 264 - name: MONITOR_PASSWORD 265 valueFrom: 266 secretKeyRef: 267 key: monitor 268 name: internal-no-limits 269 envFrom: 270 - secretRef: 271 name: no-limits-env-vars-proxysql 272 optional: true 273 imagePullPolicy: IfNotPresent 274 name: proxysql-monit 275 resources: {} 276 terminationMessagePath: /dev/termination-log 277 terminationMessagePolicy: File 278 dnsPolicy: ClusterFirst 279 initContainers: 280 - command: 281 - /pxc-init-entrypoint.sh 282 imagePullPolicy: IfNotPresent 283 name: pxc-init 284 resources: 285 limits: 286 cpu: 50m 287 memory: 50M 288 terminationMessagePath: /dev/termination-log 289 terminationMessagePolicy: File 290 volumeMounts: 291 - mountPath: /var/lib/mysql 292 name: bin 293 restartPolicy: Always 294 schedulerName: default-scheduler 295 securityContext: 296 supplementalGroups: 297 - 1001 298 serviceAccount: default 299 serviceAccountName: default 300 terminationGracePeriodSeconds: 30 301 volumes: 302 - name: ssl-internal 303 secret: 304 defaultMode: 420 305 optional: true 306 secretName: some-name-ssl-internal 307 - name: ssl 308 secret: 309 defaultMode: 420 310 optional: false 311 secretName: some-name-ssl 312 - emptyDir: {} 313 name: bin 314 updateStrategy: 315 rollingUpdate: 316 partition: 0 317 type: RollingUpdate 318 volumeClaimTemplates: 319 - metadata: 320 name: proxydata 321 spec: 322 accessModes: 323 - ReadWriteOnce 324 resources: 325 requests: 326 storage: 6Gi 327 status: 328 phase: Pending