github.com/percona/percona-xtradb-cluster-operator@v1.14.0/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127-oc.yml (about)

     1  apiVersion: apps/v1
     2  kind: StatefulSet
     3  metadata:
     4    generation: 2
     5    name: upgrade-proxysql-pxc
     6    ownerReferences:
     7      - controller: true
     8        kind: PerconaXtraDBCluster
     9        name: upgrade-proxysql
    10  spec:
    11    persistentVolumeClaimRetentionPolicy:
    12      whenDeleted: Retain
    13      whenScaled: Retain
    14    podManagementPolicy: OrderedReady
    15    replicas: 3
    16    revisionHistoryLimit: 10
    17    selector:
    18      matchLabels:
    19        app.kubernetes.io/component: pxc
    20        app.kubernetes.io/instance: upgrade-proxysql
    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: upgrade-proxysql-pxc
    25    template:
    26      metadata:
    27        labels:
    28          app.kubernetes.io/component: pxc
    29          app.kubernetes.io/instance: upgrade-proxysql
    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        affinity:
    35          podAntiAffinity:
    36            requiredDuringSchedulingIgnoredDuringExecution:
    37              - labelSelector:
    38                  matchLabels:
    39                    app.kubernetes.io/component: pxc
    40                    app.kubernetes.io/instance: upgrade-proxysql
    41                    app.kubernetes.io/managed-by: percona-xtradb-cluster-operator
    42                    app.kubernetes.io/name: percona-xtradb-cluster
    43                    app.kubernetes.io/part-of: percona-xtradb-cluster
    44                topologyKey: kubernetes.io/hostname
    45        containers:
    46          - env:
    47              - name: LOG_DATA_DIR
    48                value: /var/lib/mysql
    49              - name: POD_NAMESPASE
    50                valueFrom:
    51                  fieldRef:
    52                    apiVersion: v1
    53                    fieldPath: metadata.namespace
    54              - name: POD_NAME
    55                valueFrom:
    56                  fieldRef:
    57                    apiVersion: v1
    58                    fieldPath: metadata.name
    59            envFrom:
    60              - secretRef:
    61                  name: upgrade-proxysql-log-collector
    62                  optional: true
    63            imagePullPolicy: Always
    64            name: logs
    65            resources:
    66              requests:
    67                cpu: 200m
    68                memory: 100M
    69            terminationMessagePath: /dev/termination-log
    70            terminationMessagePolicy: File
    71            volumeMounts:
    72              - mountPath: /var/lib/mysql
    73                name: datadir
    74          - args:
    75              - logrotate
    76            env:
    77              - name: SERVICE_TYPE
    78                value: mysql
    79              - name: MONITOR_PASSWORD
    80                valueFrom:
    81                  secretKeyRef:
    82                    key: monitor
    83                    name: internal-upgrade-proxysql
    84            imagePullPolicy: Always
    85            name: logrotate
    86            resources:
    87              requests:
    88                cpu: 200m
    89                memory: 100M
    90            terminationMessagePath: /dev/termination-log
    91            terminationMessagePolicy: File
    92            volumeMounts:
    93              - mountPath: /var/lib/mysql
    94                name: datadir
    95          - args:
    96              - mysqld
    97            command:
    98              - /var/lib/mysql/pxc-entrypoint.sh
    99            env:
   100              - name: PXC_SERVICE
   101                value: upgrade-proxysql-pxc-unready
   102              - name: MONITOR_HOST
   103                value: '%'
   104              - name: MYSQL_ROOT_PASSWORD
   105                valueFrom:
   106                  secretKeyRef:
   107                    key: root
   108                    name: internal-upgrade-proxysql
   109              - name: XTRABACKUP_PASSWORD
   110                valueFrom:
   111                  secretKeyRef:
   112                    key: xtrabackup
   113                    name: internal-upgrade-proxysql
   114              - name: MONITOR_PASSWORD
   115                valueFrom:
   116                  secretKeyRef:
   117                    key: monitor
   118                    name: internal-upgrade-proxysql
   119              - name: LOG_DATA_DIR
   120                value: /var/lib/mysql
   121              - name: IS_LOGCOLLECTOR
   122                value: "yes"
   123              - name: OPERATOR_ADMIN_PASSWORD
   124                valueFrom:
   125                  secretKeyRef:
   126                    key: operator
   127                    name: internal-upgrade-proxysql
   128              - name: LIVENESS_CHECK_TIMEOUT
   129                value: "5"
   130              - name: READINESS_CHECK_TIMEOUT
   131                value: "15"
   132              - name: DEFAULT_AUTHENTICATION_PLUGIN
   133                value: mysql_native_password
   134            envFrom:
   135              - secretRef:
   136                  name: upgrade-proxysql-env-vars-pxc
   137                  optional: true
   138            imagePullPolicy: Always
   139            livenessProbe:
   140              exec:
   141                command:
   142                  - /var/lib/mysql/liveness-check.sh
   143              failureThreshold: 3
   144              initialDelaySeconds: 300
   145              periodSeconds: 10
   146              successThreshold: 1
   147              timeoutSeconds: 5
   148            name: pxc
   149            ports:
   150              - containerPort: 3306
   151                name: mysql
   152                protocol: TCP
   153              - containerPort: 4444
   154                name: sst
   155                protocol: TCP
   156              - containerPort: 4567
   157                name: write-set
   158                protocol: TCP
   159              - containerPort: 4568
   160                name: ist
   161                protocol: TCP
   162              - containerPort: 33062
   163                name: mysql-admin
   164                protocol: TCP
   165              - containerPort: 33060
   166                name: mysqlx
   167                protocol: TCP
   168            readinessProbe:
   169              exec:
   170                command:
   171                  - /var/lib/mysql/readiness-check.sh
   172              failureThreshold: 5
   173              initialDelaySeconds: 15
   174              periodSeconds: 30
   175              successThreshold: 1
   176              timeoutSeconds: 15
   177            resources:
   178              requests:
   179                cpu: 600m
   180                memory: 1G
   181            terminationMessagePath: /dev/termination-log
   182            terminationMessagePolicy: File
   183            volumeMounts:
   184              - mountPath: /var/lib/mysql
   185                name: datadir
   186              - mountPath: /etc/percona-xtradb-cluster.conf.d
   187                name: config
   188              - mountPath: /tmp
   189                name: tmp
   190              - mountPath: /etc/mysql/ssl
   191                name: ssl
   192              - mountPath: /etc/mysql/ssl-internal
   193                name: ssl-internal
   194              - mountPath: /etc/mysql/mysql-users-secret
   195                name: mysql-users-secret-file
   196              - mountPath: /etc/my.cnf.d
   197                name: auto-config
   198              - mountPath: /etc/mysql/vault-keyring-secret
   199                name: vault-keyring-secret
   200              - mountPath: /etc/mysql/init-file
   201                name: mysql-init-file
   202        dnsPolicy: ClusterFirst
   203        initContainers:
   204          - command:
   205              - /pxc-init-entrypoint.sh
   206            imagePullPolicy: Always
   207            name: pxc-init
   208            resources:
   209              limits:
   210                cpu: 50m
   211                memory: 50M
   212            terminationMessagePath: /dev/termination-log
   213            terminationMessagePolicy: File
   214            volumeMounts:
   215              - mountPath: /var/lib/mysql
   216                name: datadir
   217        restartPolicy: Always
   218        schedulerName: default-scheduler
   219        securityContext:
   220          supplementalGroups:
   221            - 1001
   222        serviceAccount: default
   223        serviceAccountName: default
   224        terminationGracePeriodSeconds: 600
   225        volumes:
   226          - emptyDir: {}
   227            name: tmp
   228          - configMap:
   229              defaultMode: 420
   230              name: upgrade-proxysql-pxc
   231              optional: true
   232            name: config
   233          - name: ssl-internal
   234            secret:
   235              defaultMode: 420
   236              optional: true
   237              secretName: some-name-ssl-internal
   238          - name: ssl
   239            secret:
   240              defaultMode: 420
   241              optional: false
   242              secretName: some-name-ssl
   243          - configMap:
   244              defaultMode: 420
   245              name: auto-upgrade-proxysql-pxc
   246              optional: true
   247            name: auto-config
   248          - name: vault-keyring-secret
   249            secret:
   250              defaultMode: 420
   251              optional: true
   252              secretName: some-name-vault
   253          - name: mysql-users-secret-file
   254            secret:
   255              defaultMode: 420
   256              optional: false
   257              secretName: internal-upgrade-proxysql
   258          - name: mysql-init-file
   259            secret:
   260              defaultMode: 420
   261              optional: true
   262              secretName: upgrade-proxysql-mysql-init
   263    updateStrategy:
   264      type: OnDelete
   265    volumeClaimTemplates:
   266      - metadata:
   267          name: datadir
   268        spec:
   269          accessModes:
   270            - ReadWriteOnce
   271          resources:
   272            requests:
   273              storage: 6G
   274        status:
   275          phase: Pending