繁依Fanyi0

这个屌丝很懒，什么也没留下！

热门标签

helm安装mysql_helm 安装mysql git工程

作者：繁依Fanyi0 | 2024-05-02 10:46:06

踩

helm 安装mysql git工程

一.版本信息

[root@node-16 ~]# kubectl get nodes

NAME STATUS ROLES AGE VERSION

node-16 Ready master 6d18h v1.16.0

node-17 Ready worker 6d18h v1.16.0

node-18 Ready worker 6d18h v1.16.0

[root@node-16 ~]# docker version

Client: Docker Engine - Community

Version: 18.09.6

API version: 1.39

Go version: go1.10.8

Git commit: 481bc77

Built: Sat May 4 02:33:34 2019

OS/Arch: linux/amd64

Experimental: false

Server: Docker Engine - Community

Engine:

Version: 18.09.6

API version: 1.39 (minimum version 1.12)

Go version: go1.10.8

Git commit: 481bc77

Built: Sat May 4 02:41:08 2019

OS/Arch: linux/amd64

Experimental: false

[root@node-16 ~]# helm version

version.BuildInfo{Version:"v3.0.0", GitCommit:"e29ce2a54e96cd02ccfce88bee4f58bb6e2a28b6", GitTreeState:"clean", GoVersion:"go1.13.4"}

[root@node-16 ~]#

2: 查看集群状态

[root@node-16 ~]#

[root@node-16 ~]# kubectl get nodes

NAME STATUS ROLES AGE VERSION

node-16 Ready master 6d18h v1.16.0

node-17 Ready worker 6d18h v1.16.0

node-18 Ready worker 6d18h v1.16.0

[root@node-16 ~]#

二、安装部署helm

使用helm的v3版本，v3版本不用配置服务端组件 Tiller。

2.1 下载软件包

#git clone https://github.com/doitroot/helm.git

2.2.安装helm

将二进制文件复制到$PATH路径下即可使用。

2.3:添加存储库：

helm repo add stable http://mirror.azure.cn/kubernetes/charts

[root@node-16 ~]# helm repo update

[root@node-16 ~]#

三、使用helm安装mysql

3.1 下载镜像

使用helm安装有状态应用mysql，使用到的docker镜像有：

准备docker image

在安装mysql的helm包时需要mysql与xtrabackup的docker镜像。

[root@node-16 script]# docker pull docker.io/mysql:latest

[root@node-17 ~]# docker pull docker.io/mysql:latest

[root@node-18 ~]# docker pull docker.io/mysql:latest

[root@node-16 script]#

[root@node-16 script]# docker images|grep mysql

mysql latest 0c27e8e5fcfa 4 days ago 546MB

mysql 5.7.28 db39680b63ac 4 months ago 437MB

[root@node-17 ~]#

[root@node-17 ~]# docker images|grep mysql

mysql latest 0c27e8e5fcfa 4 days ago 546MB

mysql 5.7.28 db39680b63ac 4 months ago 437MB

[root@node-18 ~]# docker images|grep mysql

mysql latest 0c27e8e5fcfa 4 days ago 546MB

mysql 5.7.28 db39680b63ac 4 months ago 437MB

[root@node-18 ~]#

#######################################################################################

3.2 搜索mysql的helm包

[root@node-16 script]# helm search repo mysql

NAME CHART VERSION APP VERSION DESCRIPTION

aliyun01/mysql 6.8.0 8.0.19 Chart to create a Highly available MySQL cluster

aliyun01/mysqldump 2.6.0 2.4.1 A Helm chart to help backup MySQL databases usi...

aliyun01/mysqlha 1.0.0 5.7.13 MySQL cluster with a single master and zero or ...

aliyun01/prometheus-mysql-exporter 0.5.2 v0.11.0 A Helm chart for prometheus mysql exporter with...

aliyun02/mysql 0.3.5 Fast, reliable, scalable, and easy to use open-...

stable/mysql 1.6.3 5.7.28 Fast, reliable, scalable, and easy to use open-...

stable/mysqldump 2.6.0 2.4.1 A Helm chart to help backup MySQL databases usi...

stable/prometheus-mysql-exporter 0.5.2 v0.11.0 A Helm chart for prometheus mysql exporter with...

aliyun01/percona 1.2.0 5.7.17 free, fully compatible, enhanced, open source d...

aliyun01/percona-xtradb-cluster 1.0.3 5.7.19 free, fully compatible, enhanced, open source d...

aliyun01/phpmyadmin 4.2.12 5.0.1 phpMyAdmin is an mysql administration frontend

aliyun02/percona 0.3.0 free, fully compatible, enhanced, open source d...

aliyun02/percona-xtradb-cluster 0.0.2 5.7.19 free, fully compatible, enhanced, open source d...

stable/percona 1.2.1 5.7.26 free, fully compatible, enhanced, open source d...

stable/percona-xtradb-cluster 1.0.3 5.7.19 free, fully compatible, enhanced, open source d...

stable/phpmyadmin 4.3.5 5.0.1 DEPRECATED phpMyAdmin is an mysql administratio...

aliyun01/mariadb 7.3.9 10.3.22 Fast, reliable, scalable, and easy to use open-...

aliyun01/mariadb-galera 0.8.1 10.4.12 MariaDB Galera is a multi-master database clust...

aliyun02/gcloud-sqlproxy 0.2.3 Google Cloud SQL Proxy

aliyun02/mariadb 2.1.6 10.1.31 Fast, reliable, scalable, and easy to use open-...

stable/gcloud-sqlproxy 0.6.1 1.11 DEPRECATED Google Cloud SQL Proxy

stable/mariadb 7.3.14 10.3.22 DEPRECATED Fast, reliable, scalable, and easy t...

[root@node-16 script]#

3.4 安装mysql的helm包

[root@node-16 ~]# cat values.yaml

#mysqlRootPassword:

#mysqlUser:

#mysqlPassword:

#mysqlDatabase:

persistence:

enabled: true

storageClass: "managed-nfs-storage"

accessMode: ReadWriteOnce

size: 3Gi

[root@node-16 ~]#

[root@node-16 ~]# helm install mysql -f values.yaml stable/mysql

NAME: mysql

LAST DEPLOYED: Tue Apr 28 12:36:30 2020

NAMESPACE: default

STATUS: deployed

REVISION: 1

NOTES:

MySQL can be accessed via port 3306 on the following DNS name from within your cluster:

mysql.default.svc.cluster.local

To get your root password run:

MYSQL_ROOT_PASSWORD=$(kubectl get secret --namespace default mysql -o jsonpath="{.data.mysql-root-password}" | base64 --decode; echo)

To connect to your database:

1. Run an Ubuntu pod that you can use as a client:

kubectl run -i --tty ubuntu --image=ubuntu:16.04 --restart=Never -- bash -il

2. Install the mysql client:

$ apt-get update && apt-get install mysql-client -y

3. Connect using the mysql cli, then provide your password:

$ mysql -h mysql -p

To connect to your database directly from outside the K8s cluster:

MYSQL_HOST=127.0.0.1

MYSQL_PORT=3306

# Execute the following command to route the connection:

kubectl port-forward svc/mysql 3306

mysql -h ${MYSQL_HOST} -P${MYSQL_PORT} -u root -p${MYSQL_ROOT_PASSWORD}

[root@node-16 ~]#

[root@node-16 ~]# helm list

NAME NAMESPACE REVISION UPDATED STATUS CHART APP VERSION

db01 default 1 2020-04-26 13:56:58.07831662 +0800 CST deployed mysql-1.6.3 5.7.28

db02 default 1 2020-04-27 18:03:05.493881703 +0800 CST deployed mysql-1.6.3 5.7.28

mysql default 1 2020-04-28 12:36:30.893187638 +0800 CST deployed mysql-1.6.3 5.7.28

[root@node-16 ~]#

3.5.查看mysql的有状态应用、pod、svc、pvc等k8s资源

[root@node-16 ~]# kubectl get pv

NAME CAPACITY ACCESS MODES RECLAIM POLICY STATUS CLAIM STORAGECLASS REASON AGE

pvc-d5623ae6-d4d5-4993-b00f-6b3bed4994ee 3Gi RWO Delete Bound default/mysql managed-nfs-storage 11s

[root@node-16 ~]#

[root@node-16 ~]# kubectl get pvc

NAME STATUS VOLUME CAPACITY ACCESS MODES STORAGECLASS AGE

mysql Bound pvc-d5623ae6-d4d5-4993-b00f-6b3bed4994ee 3Gi RWO managed-nfs-storage 46s

[root@node-16 ~]#

[root@node-16 ~]# kubectl get deployment

NAME READY UP-TO-DATE AVAILABLE AGE

mysql 1/1 1 1 83s

root@node-16 ~]# kubectl get service|grep mysql

db01-mysql ClusterIP 10.0.0.206 <none> 3306/TCP 46h

db02-mysql ClusterIP 10.0.0.141 <none> 3306/TCP 18h

mysql ClusterIP 10.0.0.66 <none> 3306/TCP 107s

[root@node-16 ~]#

四.客户端验证

[root@node-16 ~]# kubectl get secret --namespace default mysql -o jsonpath="{.data.mysql-root-password}" | base64 --decode; echo

F43URG4Fln

[root@node-16 ~]#

[root@node-16 ~]# kubectl get pod|grep mysql

db01-mysql-6ff46d6ccb-6whjz 1/1 Running 0 46h

db02-mysql-59976896d-fj28z 1/1 Running 0 18h

mysql-5b59c4cd99-7dmk6 1/1 Running 0 3m6s

[root@node-16 ~]#

[root@node-16 ~]# kubectl exec mysql-5b59c4cd99-7dmk6 -it /bin/bash

root@mysql-5b59c4cd99-7dmk6:/#

root@mysql-5b59c4cd99-7dmk6:/# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 67

Server version: 5.7.28 MySQL Community Server (GPL)

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>

mysql> CREATE TABLE test.messages (message VARCHAR(1024));

Query OK, 0 rows affected (0.01 sec)

mysql>

mysql> INSERT INTO test.messages VALUES ('hello');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

| test |

+--------------------+

5 rows in set (0.00 sec)

mysql>

mysql> use test;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> select * from messages;

+---------+

| message |

+---------+

| hello |

+---------+

1 row in set (0.00 sec)

mysql> exit

Bye

root@mysql-5b59c4cd99-7dmk6:/#

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/繁依Fanyi0/article/detail/523654