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

     1  apiVersion: apps/v1
     2  kind: StatefulSet
     3  metadata:
     4    generation: 1
     5    name: custom-proxysql
     6    ownerReferences:
     7      - controller: true
     8        kind: PerconaXtraDBCluster
     9        name: custom
    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: custom
    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: custom-proxysql-unready
    25    template:
    26      metadata:
    27        labels:
    28          app.kubernetes.io/component: proxysql
    29          app.kubernetes.io/instance: custom
    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          nodeAffinity:
    36            preferredDuringSchedulingIgnoredDuringExecution:
    37              - preference:
    38                  matchExpressions:
    39                    - key: another-node-label-key
    40                      operator: In
    41                      values:
    42                        - another-node-label-value
    43                weight: 1
    44            requiredDuringSchedulingIgnoredDuringExecution:
    45              nodeSelectorTerms:
    46                - matchExpressions:
    47                    - key: kubernetes.io/e2e-az-name
    48                      operator: In
    49                      values:
    50                        - e2e-az1
    51                        - e2e-az2
    52          podAffinity:
    53            requiredDuringSchedulingIgnoredDuringExecution:
    54              - labelSelector:
    55                  matchExpressions:
    56                    - key: security
    57                      operator: In
    58                      values:
    59                        - S1
    60                topologyKey: failure-domain.beta.kubernetes.io/zone
    61          podAntiAffinity:
    62            preferredDuringSchedulingIgnoredDuringExecution:
    63              - podAffinityTerm:
    64                  labelSelector:
    65                    matchExpressions:
    66                      - key: security
    67                        operator: In
    68                        values:
    69                          - S2
    70                  topologyKey: kubernetes.io/hostname
    71                weight: 100
    72        containers:
    73          - env:
    74              - name: PXC_SERVICE
    75                value: custom-pxc
    76              - name: OPERATOR_PASSWORD
    77                valueFrom:
    78                  secretKeyRef:
    79                    key: operator
    80                    name: internal-custom
    81              - name: PROXY_ADMIN_USER
    82                value: proxyadmin
    83              - name: PROXY_ADMIN_PASSWORD
    84                valueFrom:
    85                  secretKeyRef:
    86                    key: proxyadmin
    87                    name: internal-custom
    88              - name: MONITOR_PASSWORD
    89                valueFrom:
    90                  secretKeyRef:
    91                    key: monitor
    92                    name: internal-custom
    93            envFrom:
    94              - secretRef:
    95                  name: custom-env-vars-proxysql
    96                  optional: true
    97            imagePullPolicy: Always
    98            name: proxysql
    99            ports:
   100              - containerPort: 3306
   101                name: mysql
   102                protocol: TCP
   103              - containerPort: 6032
   104                name: proxyadm
   105                protocol: TCP
   106            resources:
   107              limits:
   108                cpu: 700m
   109                memory: 1G
   110              requests:
   111                cpu: 600m
   112                memory: 1G
   113            terminationMessagePath: /dev/termination-log
   114            terminationMessagePolicy: File
   115            volumeMounts:
   116              - mountPath: /var/lib/proxysql
   117                name: proxydata
   118              - mountPath: /etc/proxysql/ssl
   119                name: ssl
   120              - mountPath: /etc/proxysql/ssl-internal
   121                name: ssl-internal
   122          - args:
   123              - /usr/bin/peer-list
   124              - -on-change=/usr/bin/add_pxc_nodes.sh
   125              - -service=$(PXC_SERVICE)
   126            env:
   127              - name: PXC_SERVICE
   128                value: custom-pxc
   129              - name: OPERATOR_PASSWORD
   130                valueFrom:
   131                  secretKeyRef:
   132                    key: operator
   133                    name: internal-custom
   134              - name: PROXY_ADMIN_USER
   135                value: proxyadmin
   136              - name: PROXY_ADMIN_PASSWORD
   137                valueFrom:
   138                  secretKeyRef:
   139                    key: proxyadmin
   140                    name: internal-custom
   141              - name: MONITOR_PASSWORD
   142                valueFrom:
   143                  secretKeyRef:
   144                    key: monitor
   145                    name: internal-custom
   146            envFrom:
   147              - secretRef:
   148                  name: custom-env-vars-proxysql
   149                  optional: true
   150            imagePullPolicy: Always
   151            name: pxc-monit
   152            resources: {}
   153            terminationMessagePath: /dev/termination-log
   154            terminationMessagePolicy: File
   155          - args:
   156              - /usr/bin/peer-list
   157              - -on-change=/usr/bin/add_proxysql_nodes.sh
   158              - -service=$(PROXYSQL_SERVICE)
   159            env:
   160              - name: PROXYSQL_SERVICE
   161                value: custom-proxysql-unready
   162              - name: OPERATOR_PASSWORD
   163                valueFrom:
   164                  secretKeyRef:
   165                    key: operator
   166                    name: internal-custom
   167              - name: PROXY_ADMIN_USER
   168                value: proxyadmin
   169              - name: PROXY_ADMIN_PASSWORD
   170                valueFrom:
   171                  secretKeyRef:
   172                    key: proxyadmin
   173                    name: internal-custom
   174              - name: MONITOR_PASSWORD
   175                valueFrom:
   176                  secretKeyRef:
   177                    key: monitor
   178                    name: internal-custom
   179            envFrom:
   180              - secretRef:
   181                  name: custom-env-vars-proxysql
   182                  optional: true
   183            imagePullPolicy: Always
   184            name: proxysql-monit
   185            resources: {}
   186            terminationMessagePath: /dev/termination-log
   187            terminationMessagePolicy: File
   188        dnsPolicy: ClusterFirst
   189        initContainers:
   190          - command:
   191              - /pxc-init-entrypoint.sh
   192            imagePullPolicy: Always
   193            name: pxc-init
   194            resources:
   195              limits:
   196                cpu: 50m
   197                memory: 50M
   198            terminationMessagePath: /dev/termination-log
   199            terminationMessagePolicy: File
   200            volumeMounts:
   201              - mountPath: /var/lib/mysql
   202                name: bin
   203        restartPolicy: Always
   204        schedulerName: default-scheduler
   205        securityContext:
   206          supplementalGroups:
   207            - 1001
   208        serviceAccount: default
   209        serviceAccountName: default
   210        terminationGracePeriodSeconds: 30
   211        volumes:
   212          - name: ssl-internal
   213            secret:
   214              defaultMode: 420
   215              optional: true
   216              secretName: custom-ssl-internal
   217          - name: ssl
   218            secret:
   219              defaultMode: 420
   220              optional: false
   221              secretName: some-name-ssl
   222          - emptyDir: {}
   223            name: bin
   224    updateStrategy:
   225      rollingUpdate:
   226        partition: 0
   227      type: RollingUpdate
   228    volumeClaimTemplates:
   229      - metadata:
   230          name: proxydata
   231        spec:
   232          accessModes:
   233            - ReadWriteOnce
   234          resources:
   235            requests:
   236              storage: 2Gi
   237        status:
   238          phase: Pending