根据MysqL Docker映像README,与容器启动时的数据初始化有关的部分是确保所有初始化文件都已安装到容器的/docker- entrypoint-initdb.d
文件夹中。
您可以在中定义初始数据ConfigMap
,然后将相应的卷挂载到pod中,如下所示:
apiVersion: extensions/v1beta1
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');