github.com/percona/percona-xtradb-cluster-operator@v1.14.0/e2e-tests/limits/compare/statefulset_no-limits-pxc.yml (about)

     1  apiVersion: apps/v1
     2  kind: StatefulSet
     3  metadata:
     4    generation: 1
     5    name: no-limits-pxc
     6    ownerReferences:
     7      - controller: true
     8        kind: PerconaXtraDBCluster
     9        name: no-limits
    10  spec:
    11    podManagementPolicy: OrderedReady
    12    replicas: 3
    13    revisionHistoryLimit: 10
    14    selector:
    15      matchLabels:
    16        app.kubernetes.io/component: pxc
    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-pxc
    22    template:
    23      metadata:
    24        labels:
    25          app.kubernetes.io/component: pxc
    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: mysql
    91              - name: DB_USER
    92                value: monitor
    93              - name: DB_PASSWORD
    94                valueFrom:
    95                  secretKeyRef:
    96                    key: monitor
    97                    name: internal-no-limits
    98              - name: DB_ARGS
    99                value: --query-source=perfschema
   100              - name: DB_CLUSTER
   101                value: pxc
   102              - name: DB_HOST
   103                value: localhost
   104              - name: DB_PORT
   105                value: "33062"
   106              - name: CLUSTER_NAME
   107                value: no-limits
   108              - name: PMM_ADMIN_CUSTOM_PARAMS
   109              - name: PMM_AGENT_PRERUN_SCRIPT
   110                value: /var/lib/mysql/pmm-prerun.sh
   111              - name: PMM_AGENT_SIDECAR
   112                value: "true"
   113              - name: PMM_AGENT_SIDECAR_SLEEP
   114                value: "5"
   115              - name: PMM_AGENT_PATHS_TEMPDIR
   116                value: /tmp
   117            envFrom:
   118              - secretRef:
   119                  name: no-limits-env-vars-pxc
   120                  optional: true
   121            imagePullPolicy: IfNotPresent
   122            lifecycle:
   123              preStop:
   124                exec:
   125                  command:
   126                    - bash
   127                    - -c
   128                    - pmm-admin unregister --force
   129            livenessProbe:
   130              failureThreshold: 3
   131              httpGet:
   132                path: /local/Status
   133                port: 7777
   134                scheme: HTTP
   135              initialDelaySeconds: 60
   136              periodSeconds: 10
   137              successThreshold: 1
   138              timeoutSeconds: 5
   139            name: pmm-client
   140            ports:
   141              - containerPort: 7777
   142                protocol: TCP
   143              - containerPort: 30100
   144                protocol: TCP
   145              - containerPort: 30101
   146                protocol: TCP
   147              - containerPort: 30102
   148                protocol: TCP
   149              - containerPort: 30103
   150                protocol: TCP
   151              - containerPort: 30104
   152                protocol: TCP
   153              - containerPort: 30105
   154                protocol: TCP
   155            resources: {}
   156            terminationMessagePath: /dev/termination-log
   157            terminationMessagePolicy: File
   158            volumeMounts:
   159              - mountPath: /var/lib/mysql
   160                name: datadir
   161          - args:
   162              - mysqld
   163            command:
   164              - /var/lib/mysql/pxc-entrypoint.sh
   165            env:
   166              - name: PXC_SERVICE
   167                value: no-limits-pxc-unready
   168              - name: MONITOR_HOST
   169                value: '%'
   170              - name: MYSQL_ROOT_PASSWORD
   171                valueFrom:
   172                  secretKeyRef:
   173                    key: root
   174                    name: internal-no-limits
   175              - name: XTRABACKUP_PASSWORD
   176                valueFrom:
   177                  secretKeyRef:
   178                    key: xtrabackup
   179                    name: internal-no-limits
   180              - name: MONITOR_PASSWORD
   181                valueFrom:
   182                  secretKeyRef:
   183                    key: monitor
   184                    name: internal-no-limits
   185              - name: OPERATOR_ADMIN_PASSWORD
   186                valueFrom:
   187                  secretKeyRef:
   188                    key: operator
   189                    name: internal-no-limits
   190              - name: LIVENESS_CHECK_TIMEOUT
   191                value: "5"
   192              - name: READINESS_CHECK_TIMEOUT
   193                value: "15"
   194              - name: DEFAULT_AUTHENTICATION_PLUGIN
   195                value: mysql_native_password
   196            envFrom:
   197              - secretRef:
   198                  name: no-limits-env-vars-pxc
   199                  optional: true
   200            imagePullPolicy: IfNotPresent
   201            livenessProbe:
   202              exec:
   203                command:
   204                  - /var/lib/mysql/liveness-check.sh
   205              failureThreshold: 3
   206              initialDelaySeconds: 300
   207              periodSeconds: 10
   208              successThreshold: 1
   209              timeoutSeconds: 5
   210            name: pxc
   211            ports:
   212              - containerPort: 3306
   213                name: mysql
   214                protocol: TCP
   215              - containerPort: 4444
   216                name: sst
   217                protocol: TCP
   218              - containerPort: 4567
   219                name: write-set
   220                protocol: TCP
   221              - containerPort: 4568
   222                name: ist
   223                protocol: TCP
   224              - containerPort: 33062
   225                name: mysql-admin
   226                protocol: TCP
   227              - containerPort: 33060
   228                name: mysqlx
   229                protocol: TCP
   230            readinessProbe:
   231              exec:
   232                command:
   233                  - /var/lib/mysql/readiness-check.sh
   234              failureThreshold: 5
   235              initialDelaySeconds: 15
   236              periodSeconds: 30
   237              successThreshold: 1
   238              timeoutSeconds: 15
   239            resources:
   240              requests:
   241                cpu: 300m
   242                memory: 500M
   243            terminationMessagePath: /dev/termination-log
   244            terminationMessagePolicy: File
   245            volumeMounts:
   246              - mountPath: /var/lib/mysql
   247                name: datadir
   248              - mountPath: /etc/percona-xtradb-cluster.conf.d
   249                name: config
   250              - mountPath: /tmp
   251                name: tmp
   252              - mountPath: /etc/mysql/ssl
   253                name: ssl
   254              - mountPath: /etc/mysql/ssl-internal
   255                name: ssl-internal
   256              - mountPath: /etc/mysql/mysql-users-secret
   257                name: mysql-users-secret-file
   258              - mountPath: /etc/my.cnf.d
   259                name: auto-config
   260              - mountPath: /etc/mysql/vault-keyring-secret
   261                name: vault-keyring-secret
   262              - mountPath: /etc/mysql/init-file
   263                name: mysql-init-file
   264        dnsPolicy: ClusterFirst
   265        initContainers:
   266          - command:
   267              - /pxc-init-entrypoint.sh
   268            imagePullPolicy: IfNotPresent
   269            name: pxc-init
   270            resources:
   271              limits:
   272                cpu: 50m
   273                memory: 50M
   274            terminationMessagePath: /dev/termination-log
   275            terminationMessagePolicy: File
   276            volumeMounts:
   277              - mountPath: /var/lib/mysql
   278                name: datadir
   279        restartPolicy: Always
   280        schedulerName: default-scheduler
   281        securityContext:
   282          fsGroup: 1001
   283          supplementalGroups:
   284            - 1001
   285        serviceAccount: default
   286        serviceAccountName: default
   287        terminationGracePeriodSeconds: 600
   288        volumes:
   289          - emptyDir: {}
   290            name: tmp
   291          - configMap:
   292              defaultMode: 420
   293              name: no-limits-pxc
   294              optional: true
   295            name: config
   296          - name: ssl-internal
   297            secret:
   298              defaultMode: 420
   299              optional: true
   300              secretName: some-name-ssl-internal
   301          - name: ssl
   302            secret:
   303              defaultMode: 420
   304              optional: false
   305              secretName: some-name-ssl
   306          - configMap:
   307              defaultMode: 420
   308              name: auto-no-limits-pxc
   309              optional: true
   310            name: auto-config
   311          - name: vault-keyring-secret
   312            secret:
   313              defaultMode: 420
   314              optional: true
   315              secretName: no-limits-vault
   316          - name: mysql-users-secret-file
   317            secret:
   318              defaultMode: 420
   319              optional: false
   320              secretName: internal-no-limits
   321          - name: mysql-init-file
   322            secret:
   323              defaultMode: 420
   324              optional: true
   325              secretName: no-limits-mysql-init
   326    updateStrategy:
   327      rollingUpdate:
   328        partition: 0
   329      type: RollingUpdate
   330    volumeClaimTemplates:
   331      - metadata:
   332          name: datadir
   333        spec:
   334          accessModes:
   335            - ReadWriteOnce
   336          resources:
   337            requests:
   338              storage: 6Gi
   339        status:
   340          phase: Pending