rancher mysql部署

🧙 Questions

mysql8.0.34 rancher安装

☄️ Ideas

上传镜像

scp /Users/ispong/OneDrive/Packages/docker/mysql/mysql-8.0.34-amd64.tar root@8.160.166.205:/data/downloads

cd /data/downloads
nerdctl load -i mysql-8.0.34-amd64.tar
nerdctl tag mysql:8.0.34 isxcode-data-center:30003/library/mysql:8.0.34
nerdctl push isxcode-data-center:30003/library/mysql:8.0.34

创建namespace

kubectl create namespace isxcode-space

创建pvc

kubectl get nodes

• Storage - PersistentVolumneClaims

1. namespace: isxcode-space
2. name: mysql-pvc
3. Storage Class: local-path
4. Request Storage: 100GB
5. Annotations: volume.kubernetes.io/selected-node: isxcode-data-center

配置configMap

• Storage - ConfigMaps

1. namespace: isxcode-space
2. name: mysql-config
3. key: my.cnf
4. value: 复制下面

[mysqld]
pid-file  = /var/run/mysqld/mysqld.pid
socket    = /var/run/mysqld/mysqld.sock
datadir   = /var/lib/mysql

# mysql binlog 7天自动归档
binlog_expire_logs_seconds=604800

# 默认服务器字符集
character_set_server = utf8mb4

# 数据库时区
default-time-zone='+08:00'

# 最大连接数
max_connections = 1000

# 任何文件目录禁止导出
# 为空 任何都可以导入
# 指定路径，则是某个路径可以导入
secure-file-priv= NULL

# 开启 binlog
log_bin = /var/lib/mysql/mysql-bin
binlog_format = ROW # 选择 ROW 模式
expire_logs_days = 30
server_id = 1 # 配置 MySQL replaction需要定义，不要和canal的slaveId 重复

# 0：区分大小写（Linux 默认）
# 1：不区分大小写（Windows 默认）
# 2：按创建时的大小写保存，但查询时转为小写
lower_case_table_names=1
  
[mysql]

# 建表默认字符集
default-character-set = utf8mb4
 
# Custom config should go here
!includedir /etc/mysql/conf.d/

配置harbor账号

• Storage - Secrets

1. Registry
2. namespace: isxcode-space
3. name: harbor
4. domain: isxcode-data-center:30003
5. username: admin
6. password: MySecurePass123!

新建mysql的deployment

• Workloads - Deployments

1. namespace: isxcode-space
2. name: isxcode-mysql
3. image: isxcode-data-center:30003/library/mysql:8.0.34
4. IfNotPresent
5. secret: harbor
6. Node Port: mysql-p 3306 -> 30102
7. Environment Variables
8. MYSQL_ROOT_PASSWORD -> root123

磁盘挂载

• Pod - Storage

1. Persistent Volume Claim
2. mysql-data -> mysql-pvc
3. ConfigMap
4. mysql-config -> mysql-config

磁盘映射

• Isxcode-mysql - Storage

1. mysql-data (Persistent Volume Claim)
2. /var/lib/mysql -> 空
3. mysql-config (ConfigMap)
4. /etc/mysql/conf.d -> 空

命令连接

kubectl get pod -A | grep isxcode-mysql
kubectl exec -it -n isxcode-space isxcode-mysql-5f96b4d748-lc7kp -- bash
mysql -u root -proot123

🔗 Links

• rancher website