How to initialize mysql container when created on Kubernetes?

by

According to the MySQL Docker image README, the part that is relevant to data initialization on container start-up is to ensure all your initialization files are mount to the container’s /docker-entrypoint-initdb.d folder.

You can define your initial data in a ConfigMap, and mount the corresponding volume in your pod like this:

apiVersion: v1
kind: Pod
metadata:
  name: mysql
spec:
  containers:
  - name: mysql
    image: mysql        
    ports:
      - containerPort: 3306
    volumeMounts:
      - name: mysql-initdb
        mountPath: /docker-entrypoint-initdb.d
  volumes:
    - name: mysql-initdb
      configMap:
        name: mysql-initdb-config
---
apiVersion: v1
kind: ConfigMap
metadata:
  name: mysql-initdb-config
data:
  initdb.sql: |
    CREATE TABLE friends (id INT, name VARCHAR(256), age INT, gender VARCHAR(3));
    INSERT INTO friends VALUES (1, 'John Smith', 32, 'm');
    INSERT INTO friends VALUES (2, 'Lilian Worksmith', 29, 'f');
    INSERT INTO friends VALUES (3, 'Michael Rupert', 27, 'm');

More Related Contents:

  1. Setting up MySQL and importing dump within Dockerfile
  2. How can I initialize a MySQL database with schema in a Docker container?
  3. Connect to mysql in a docker container from the host
  4. How to connect mysql workbench to running mysql inside docker?
  5. Docker-compose check if mysql connection is ready
  6. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  7. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  8. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  9. Commit data in a mysql container
  10. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  11. Connect to Docker MySQL container from localhost?
  12. Node.js connect to MySQL Docker container ECONNREFUSED
  13. How to connect locally hosted MySQL database with the docker container
  14. Access to mysql container from other container
  15. connecting to a docker-compose mysql container denies access but docker running same image does not
  16. Access mysql running on localhost from minikube
  17. django cannot connect mysql in docker-compose
  18. MySQL scripts in docker-entrypoint-initdb are not executed
  19. How can I do three table JOINs in an UPDATE query?
  20. How to convert a string to date in MySQL?
  21. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  22. MySQL : isn’t in GROUP BY
  23. How do you extract a numerical value from a string in a MySQL query?
  24. How do I add a custom CHECK constraint on a MySQL table?
  25. MySql Count cannot show 0 values
  26. How to store uuid as number?
  27. How can I enable MySQL’s slow query log without restarting MySQL?
  28. Selecting multiple columns/fields in MySQL subquery
  29. How to store a one to many relation in MySQL database?
  30. Execute multiple semi-colon separated query using mysql Prepared Statement

Leave a Comment