github.com/verrazzano/verrazzano@v1.7.1/tests/testdata/grafana/grafana-mysql.yaml (about)

     1  # Copyright (c) 2022, Oracle and/or its affiliates.
     2  # Licensed under the Universal Permissive License v 1.0 as shown at https://oss.oracle.com/licenses/upl.
     3  ---
     4  apiVersion: v1
     5  kind: ConfigMap
     6  metadata:
     7    name: mysql-initialization
     8    namespace: verrazzano-install
     9  data:
    10    create-db.sql: |-
    11      create database if not exists grafana; use grafana; GRANT CREATE, ALTER, DROP, INDEX, REFERENCES, SELECT, INSERT, UPDATE, DELETE ON grafana.* TO 'grafana'@'%';flush privileges;
    12  ---
    13  apiVersion: v1
    14  kind: Service
    15  metadata:
    16    name: mysql
    17    namespace: verrazzano-install
    18    labels:
    19      app: mysql
    20      release: "mysql"
    21  spec:
    22    type: ClusterIP
    23    ports:
    24      - name: mysql
    25        port: 3306
    26        targetPort: mysql
    27    selector:
    28      app: mysql
    29  ---
    30  apiVersion: apps/v1
    31  kind: Deployment
    32  metadata:
    33    name: mysql
    34    namespace: verrazzano-install
    35    labels:
    36      app: mysql
    37      release: "mysql"
    38  spec:
    39    strategy:
    40      type: Recreate
    41    selector:
    42      matchLabels:
    43        app: mysql
    44        release: mysql
    45    template:
    46      metadata:
    47        labels:
    48          app: mysql
    49          release: mysql
    50      spec:
    51        imagePullSecrets:
    52          - name: verrazzano-container-registry
    53        serviceAccountName: default
    54        initContainers:
    55          - name: "remove-lost-found"
    56            image: "ghcr.io/oracle/oraclelinux:7-slim"
    57            imagePullPolicy: "IfNotPresent"
    58            resources:
    59              requests:
    60                cpu: 10m
    61                memory: 10Mi
    62            command:  ["rm", "-fr", "/var/lib/mysql/lost+found"]
    63            volumeMounts:
    64              - name: data
    65                mountPath: /var/lib/mysql
    66          - command:
    67              - chown
    68              - -R
    69              - 27:27
    70              - /var/lib/mysql
    71            image: "ghcr.io/oracle/oraclelinux:7-slim"
    72            imagePullPolicy: IfNotPresent
    73            name: chown-data-dir
    74            resources:
    75              requests:
    76                cpu: 10m
    77                memory: 10Mi
    78            terminationMessagePath: /dev/termination-log
    79            terminationMessagePolicy: File
    80            volumeMounts:
    81              - mountPath: /var/lib/mysql
    82                name: data
    83        containers:
    84          - name: mysql
    85            image: "ghcr.io/verrazzano/mysql-server:8.0.31"
    86            imagePullPolicy: "IfNotPresent"
    87            resources:
    88              requests:
    89                cpu: 100m
    90                memory: 256Mi
    91            env:
    92              - name: MYSQL_ROOT_PASSWORD
    93                valueFrom:
    94                  secretKeyRef:
    95                    name: grafana-db
    96                    key: root-password
    97              - name: MYSQL_PASSWORD
    98                valueFrom:
    99                  secretKeyRef:
   100                    name: grafana-db
   101                    key: password
   102              - name: MYSQL_USER
   103                value: "grafana"
   104              - name: MYSQL_DATABASE
   105                value: ""
   106            ports:
   107              - name: mysql
   108                containerPort: 3306
   109            livenessProbe:
   110              exec:
   111                command:
   112                  - sh
   113                  - -c
   114                  - "mysqladmin ping -u root -p${MYSQL_ROOT_PASSWORD}"
   115              initialDelaySeconds: 30
   116              periodSeconds: 10
   117              timeoutSeconds: 5
   118              successThreshold: 1
   119              failureThreshold: 3
   120            readinessProbe:
   121              exec:
   122                command:
   123                  - sh
   124                  - -c
   125                  - "mysqladmin ping -u root -p${MYSQL_ROOT_PASSWORD}"
   126              initialDelaySeconds: 5
   127              periodSeconds: 10
   128              timeoutSeconds: 1
   129              successThreshold: 1
   130              failureThreshold: 3
   131            volumeMounts:
   132              - name: data
   133                mountPath: /var/lib/mysql
   134              - name: migrations
   135                mountPath: /docker-entrypoint-initdb.d
   136        volumes:
   137          - name: migrations
   138            configMap:
   139              name: mysql-initialization
   140          - name: data
   141            emptyDir: {}