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