部署 MySQL
以下是 mysql.yaml
的内容:
apiVersion: apps/v1
kind: Deployment
metadata:
creationTimestamp: null
labels:
app: mysql
name: mysql
namespace: demo-test
spec:
replicas: 1
selector:
matchLabels:
app: mysql
strategy: {}
template:
metadata:
creationTimestamp: null
labels:
app: mysql
spec:
containers:
- image: mysql:5.7
name: mysql
env:
- name: MYSQL_ROOT_PASSWORD
value: VMware1!
ports:
- containerPort: 3306
resources: {}
status: {}
编写 Job 的 ConfigMap(即 SQL 语句)
以下是 sql-config.yaml
的内容:
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql-initdb-sql-config
namespace: demo-test
data:
initdb.sql: |
CREATE DATABASE IF NOT EXISTS `database_audit` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `database_audit`;
DROP TABLE IF EXISTS `t_alert`;
CREATE TABLE `t_alert` (
`id` int(11) NOT NULL,
`address` varchar(20) NOT NULL,
`db_type` varchar(45) NOT NULL,
`log_type` varchar(45) NOT NULL,
`message` text,
`create_date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
DROP TABLE IF EXISTS `t_dic`;
CREATE TABLE `t_dic` (
`id` int(11) NOT NULL,
`type` varchar(45) NOT NULL,
`value` varchar(45) NOT NULL,
`code` char(6) NOT NULL,
`description` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
编写 Job 的 YAML
以下是 init-sql.yaml
的内容:
apiVersion: batch/v1
kind: Job
metadata:
name: mysql-init
namespace: demo-test
spec:
template:
metadata:
name: myjob
spec:
containers:
- name: init-sql
image: monasca/mysql-init
imagePullPolicy: IfNotPresent
volumeMounts:
- name: mysql-initdb
mountPath: app/config
command: ["sh","-c","mysql -u root -pVMware1! -P3306 -h $MYSQL_SERVICE_HOST < app/config/init.sql"]
volumes:
- name: mysql-initdb
configMap:
name: mysql-initdb-sql-config
items:
- key: initdb.sql
path: init.sql
restartPolicy: OnFailure
在运行 Job 完成对 MySQL 的 SQL 语句插入之前,需要确保以下条件:
- MySQL 正在运行。
- MySQL Service (
svc
) 正常。 - MySQL 的环境变量 (
env
) 正常(即有MYSQL_SERVICE_HOST
的环境变量)。如果没有,请重启 Pod。
运行结果如下:
进入到 MySQL 容器中查看:
<这里填写你的进入 MySQL 容器的命令>