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