我的init.sql (脚本)没有复制到docker-entrypoint-initdb.d。请注意,当我尝试在本地或在我的服务器上运行它时,问题不会发生。只有在通过创建构建和发布管道来使用azure devops时才会发生这种情况。
在将持久卷YAML文件放在azure repos中的情况下,该文件的主机路径(包含sql脚本)中似乎存在错误。
mysqlpersistantvolume.yaml
kind: PersistentVolume
apiVersion: v1
metadata:
name: mysql-initdb-pv-volume
labels:
type: local
app: mysql
spec:
storageClassName: manual
capacity:
storage: 1Mi
accessModes:
- ReadOnlyMany
hostPath:
path: "/devops-sample" // main project folder in azure repos which
contains all files including sql script.
---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
name: mysql-initdb-pv-claim
labels:
app: mysql
spec:
storageClassName: manual
accessModes:
- ReadOnlyMany
resources:
requests:
storage: 1Mimysql.yaml
apiVersion: v1
kind: Service
metadata:
name: mysql
spec:
ports:
- port: 3306
protocol: TCP
targetPort: 3306
selector:
app: mysql
---
apiVersion: apps/v1
kind: Deployment
metadata:
name: mysql
spec:
selector:
matchLabels:
app: mysql
strategy:
type: Recreate
template:
metadata:
labels:
app: mysql
spec:
containers:
- image: mysql:5.6
name: mysql
imagePullPolicy: "IfNotPresent"
env:
- name: MYSQL_ROOT_PASSWORD
value: root
- name: MYSQL_PASSWORD
value: kovaion
- name: MYSQL_USER
value: vignesh
- name: MYSQL_DATABASE
value: data-core
ports:
- containerPort: 3306
name: mysql
volumeMounts:
- name: mysql-persistent-storage
mountPath: /docker-entrypoint-initdb.d
volumes:
- name: mysql-persistent-storage
persistentVolumeClaim:
claimName: mysql-initdb-pv-claim目前,文件夹docker-entrypoint-initdb.d似乎是空的(没有复制任何内容)。如果sql脚本放在devops-sample文件夹内的azure repos中,如何在mysql持久卷中设置完整的主机路径??
发布于 2019-06-07 01:56:24
Mysql数据目录存储位置错误。您应该将持久性存储挂载到/var/lib/mysql/data
https://stackoverflow.com/questions/56477615
复制相似问题