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

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