测试开发技术网站

[TOC]
## 一、CentOS7系统安装MySQL数据库
### 1.1 进入/opt/ 目录下，下载mysql-server的源安装包
```bash
cd /opt
wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
```

### 1.2 安装下载的rpm包
```bash
yum localinstall mysql57-community-release-el7-11.noarch.rpm
```

### 1.3 通过yum 安装mysql-server
```bash
yum -y install mysql-community-server
```

### 1.4 启动mysql服务
```bash
systemctl start mysqld
systemctl status  mysqld
```

### 1.5 将mysql服务添加开机自启动

```bash
systemctl enable mysqld
```

### 1.6 查看默认密码
```bash
grep 'temporary password' /var/log/mysqld.log
```

### 1.7 使用查找到的默认密码登录mysql
```bash
mysql -uroot -p
```
### 1.8 设置新密码
```bash
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password'
```

### 1.9 若需要远程链接数据库，则需要使用如下命令开启远程访问
```bash
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'new password';
flush privileges;
```

此时，即可以通过root和设置的新密码远程连接mysql数据库了

## 三、使用Kubernetes安装MySQL数据库
### 3.1 编写 mysql.yaml文件
编写yaml如下

```yaml
apiVersion: v1
kind: Namespace
metadata:
  name: devops   # Namespace 的名称

---

apiVersion: apps/v1
kind: Deployment
metadata:
  name: devops-mysql   # deployment控制器名称
  namespace: devops
spec:
  replicas: 1
  revisionHistoryLimit: 5
  strategy:
    type: RollingUpdate
  selector:
    matchLabels:
      app: devops-mysql
  template:
    metadata:
      labels:
        app: devops-mysql
    spec:
      volumes:
        - name: devops-mysql
          nfs:
            server: xx.xx.xx.xx  # 修改为挂载存储的服务器ip
            path: /root/data/nfs/mysql/devops   # 修改为存储服务器的存储挂载路径
      containers:
        - name: devops-mysql
          image: mysql:5.7
          env:
            - name: MYSQL_ROOT_PASSWORD
              value: xxxxxxxx     # 设置MySQL数据库登录密码
          imagePullPolicy: Always
          ports:
            - containerPort: 3306
          volumeMounts:
            - name: devops-mysql
              mountPath: /var/lib/mysql

---

apiVersion: v1
kind: Service
metadata:
  name: devops-mysql    # 数据库服务的名称
  namespace: devops
spec:
  ports:
    - port: 3306
      protocol: TCP
      targetPort: 3306
      nodePort: 30001    # 对外访问的端口
  selector:
    app: devops-mysql
  type: NodePort
  sessionAffinity: ClientIP   
```

### 3.2 执行如下命令创建

```bash
kubectl apply -f mysql.yaml
```

### 3.3 通过如下命令查看创建结果
使用如下命令查看
```bash
kubectl get pod -n devops | grep mysql
```

如：
```bash
[root@master ~]# kubectl get pod -n devops | grep mysql
devops-mysql-59b68c47d4-ttbng               1/1     Running   0          23h
[root@master ~]#
```

### 3.4 命令行进入Pod并登录mysql
如下;
```bash
[root@master ~]# kubectl exec -it devops-mysql-59b68c47d4-ttbng bash -n devops
kubectl exec [POD] [COMMAND] is DEPRECATED and will be removed in a future version. Use kubectl exec [POD] -- [COMMAND] instead.
root@devops-mysql-59b68c47d4-ttbng:/# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.7.36 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>
```

### 3.5 至此，数据库已经安装完成，然后即可通过ip+端口，这里是30001，进行数据库链接了

测试开发技术网站

博客