OKD 3.11 提供了mysql数据库的catalog，以下为使用okd311从web console拉起mysql的步骤。
创建storage class
如果OKD集群刚装好，还没有设置storage class，需要先创建storage class，并将创建可用的storage class设置为默认。
- 创建storage class
本文使用glusterFS，首先需要编写storage class的描述文件如下：
apiVersion: storage.k8s.io/v1beta1
kind: StorageClass
metadata:
name: gluster-dyn
provisioner: kubernetes.io/glusterfs
parameters:
# since k8s 1.5, endpoint is not necessary for dynamic provisioning
# endpoint: "heketi-ep"
resturl: "http://x.x.x.x:8080"
restuser: "admin"
restuserkey: "storage secret"
secretName: "heketi-secret"
secretNameSpace: "default"
volumetype: "replicate:2"
---
apiVersion: v1
kind: Secret
metadata:
name: heketi-secret
namespace: default
data:
# base64 encoded password. E.g.: echo -n "mypassword" | base64
key: a0xkODM0ZGFkRXNmd2N2
type: kubernetes.io/glusterfs
使用命令创建storage class。
oc create -f storage-class.yaml
检查是否成功创建
[root@host-10-1-236-72 data]# oc get storageclass
NAME PROVISIONER AGE
gluster-dyn kubernetes.io/glusterfs 5d
- 将创建好的storage class设为默认值
因为在部署mysql过程中，会自动绑定默认的storage class创建pvc，因此首先需要将创建好的storage class设为默认值。
方法如下：
oc patch storageclass gluster-dyn -p '{"metadata": {"annotations":{"storageclass.kubernetes.io/is-default-class":"true"}}}'
如果执行成功，检查storage class，会在name后标注default。
[root@host-10-1-236-72 data]# oc get storageclass
NAME PROVISIONER AGE
gluster-dyn (default) kubernetes.io/glusterfs 5d
准备mysql镜像
- 查看Image streams
Openshift 提供了image streams管理镜像，"An image stream can be used to automatically perform an action, such as updating a deployment, when a new image, such as a new version of the base image that is used in that deployment, is created." - OpenShift Documentation
但是请注意，Image Streams并不是镜像仓库，只是镜像的一种映射，具体的镜像实体还需要自己准备。
OpenShift的默认的IS都在project openshift中
查看Image Streams
[root@host-10-1-236-72 data]# oc get is -n openshift
NAME DOCKER REPO TAGS UPDATED
dotnet docker-registry.default.svc:5000/openshift/dotnet 2.0
dotnet-runtime docker-registry.default.svc:5000/openshift/dotnet-runtime 2.0,2.1
httpd docker-registry.default.svc:5000/openshift/httpd 2.4
jenkins docker-registry.default.svc:5000/openshift/jenkins 2,1
mariadb docker-registry.default.svc:5000/openshift/mariadb 10.1,10.2
mongodb docker-registry.default.svc:5000/openshift/mongodb 2.4,2.6,3.2 + 2 more...
mysql docker-registry.default.svc:5000/openshift/mysql 5.7,latest,5.5 + 1 more... 6 days ago
nginx docker-registry.default.svc:5000/openshift/nginx 1.10,1.12,1.8
nodejs docker-registry.default.svc:5000/openshift/nodejs 8-RHOAR,0.10,10 + 3 more...
perl docker-registry.default.svc:5000/openshift/perl 5.16,5.20,5.24 + 1 more...
php docker-registry.default.svc:5000/openshift/php 5.5,5.6,7.0 + 1 more...
postgresql docker-registry.default.svc:5000/openshift/postgresql 9.2,9.4,9.5 + 2 more...
python docker-registry.default.svc:5000/openshift/python 3.4,3.5,3.6 + 2 more...
redis docker-registry.default.svc:5000/openshift/redis 3.2
ruby docker-registry.default.svc:5000/openshift/ruby 2.0,2.2,2.3 + 2 more...
wildfly docker-registry.default.svc:5000/openshift/wildfly 10.1,11.0,12.0 + 4 more...
使用describe查看mysql
oc describe is mysql
mysql使用的镜像为centos/mysql-57-centos7，下载镜像，并上传至私有仓库后，修改mysql的is.
修改IS tag命令如下：
oc tag 10.1.236.77:5000/centos/mysql-57-centos7:latest mysql:5.7
从openshift web console界面部署mysql
- 新建一个project，并进入到project中
-
在Catalog下 Database中选择mysql，进入到部署wizard。
image.png -
点击下一步，输入必须的参数后，点击create。创建成功后，在下方会显示mysql的基本信息如下
image.png
验证mysql
- 从web console查看Deployment的状态为active, pod的状态为Running.
- 登录mysql pods, 命令行连接mysql。
[root@host-10-1-236-72 data]# oc rsh mysql-1-8h297
sh-4.2$ mysql -ugeng -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 86772
Server version: 5.7.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| sampledb |
+--------------------+
2 rows in set (0.02 sec)
