Kubesphere手把手教你轻松打造高可用MySQL集群！

秒速五厘米 2024-03-17 16:02 56阅读 0赞

### 1 创建密钥 ###

![f6fc4d77c5ed4b5581a78b2a3a639ef7.png][]

![c3b789ad334944f5820a45a55f22e85c.png][]

### 2 配置字典 ###

毕竟做的是主从集群，自然有一些必要的配置。进入[配置字典][Link 1]：

#### MySQL 主库配置 ####

![d4d11ed1b47445c7b64181ceacb61a84.png][]

![da55b8ca622a43538edd58f3ab6ca2c3.png][]

[client]
    default-character-set=utf8
    [mysql]
    default-character-set=utf8
    [mysqld]
    init_connect='SET collation_connection = utf8_unicode_ci'
    init_connect='SET NAMES utf8'
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve
    
    server_id=1
    log-bin=mysql-bin
    read-only=0
    binlog-do-db=car_receiver_pre

![在这里插入图片描述][8f7b47625eb942678adc812b13a44af8.png]

#### MySQL 从库配置 ####

![89fd0ac9d394484ebd770f8860587c88.png][]

[client]
    default-character-set=utf8
    [mysql]
    default-character-set=utf8
    [mysqld]
    init_connect='SET collation_connection = utf8_unicode_ci'
    init_connect='SET NAMES utf8'
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve
    
    server_id=2
    log-bin=mysql-bin
    read-only=1
    binlog-do-db=car_receiver_pre
    
    replicate-ignore-db=mysql
    replicate-ignore-db=sys
    replicate-ignore-db=information_schema
    replicate-ignore-db=performance_schema

![723b210877884e02a6f7b925a85cbff4.png][]

### 3 pvc ###

我们还需要存储空间对吧，数据要存在哪里，那就造个 pvc。

[创建持久卷声明][Link 2]：

#### 基本信息 ####

![0e1b83b296124e14b47f6d4568b982f4.png][]

#### 存储设置 ####

![f58f5c54be3140a79f0d471e1d6f5ead.png][]

同理，再创建一个从节点的：

![1a1c24a20aaf4f44a16263547a66454f.png][]

### 4 创建服务 ###

[创建服务][Link 3]：

![a6fd1e4467e94978a1c7cc5bce729d18.png][]

#### 4.1 基本信息 ####

![e1eec2988af640d3917ecf9497c3b1c5.png][]

#### 4.2 添加容器 ####

![629cecde88ef4c3eab80cc6916bf0c0d.png][]

默认端口设置：

![1854e6d1c6f74271a944c3792d6d46bb.png][]

资源配置：

![53717c1da98841a1a7ee6093a7c3ef56.png][]

环境变量：

![21f8323124674ff0940566823099f12c.png][]

容器组调度规则：

![4d57d069ab704a728e5350e2907a6353.png][]

#### 4.3 存储设置 ####

先点击这个：

![41bea79a2255442d80393276c17d559e.png][]

选择对应的配置字典：

![0051fe078e654d8cba9d7e03e227fc15.png][]

挂载配置：

![b13a50cf168744c0a292f548fd5e2156.png][]

之后点击✅：

![7aa5e6bfbdd04db1921661b6f7184670.png][]

再点击这个：

![296dc8ed0c344c0ea33c7f0349cdf25b.png][]

选择持久卷：

![0fd32d2d37824f61a6369c190d482b53.png][]

![a4a34687350b465fa341810c3d6a7214.png][]

点击✅：

![b09cc859961e4df999547557a9c028e4.png][]

点击“下一步”。

#### 4.4 高级设置 ####

保持默认：

![289d0f9dad3648688dad8d66cc4fbd4d.png][]

服务创建成功：

![8160498daaee4cb482cbbf5ef0772381.png][]

### 5 终端验证配置是否正确 ###

进入[mysql-master-v1-0][]容器组

![58b4c8b899ae44c1aed352db0dffa327.png][]

进入容器终端，验证配置文件没问题：

![f129c0b7e5e542469f598bc8fb59cc50.png][]

### 6 创建从库 ###

同理的操作。

回到[服务][Link 3]：

#### 创建服务 ####

基本信息：

![fd53cc50c76d4882b738dbf7dd1070bf.png][]

容器组设置：

![326dcc41cff84f2f90dcc3e9c31f9f49.png][]

资源配置：

![1570d08858d242609f5bde2cc7521e3b.png][]

环境变量，MYSQL\_ROOT\_PASSWORD：

![2b52b88513284d1a840ad3eb74557c57.png][]

调度规则：

![9d150b3c626d4138af2e86b34f22a6d2.png][]

#### 存储设置 ####

挂载配置字典：

![408ef12107184949bc309f70e1e6b0ba.png][]

挂载路径，/etc/mysql/conf.d：

![7c92f151ef3143879c78ede8a3d2bcaf.png][]

挂载卷：

![259f149dfab54dffa124626cac56d215.png][]

挂载路径，/var/lib/mysql：

![9be4a7ee0bf249da9b5187cd45945cb1.png][]

打钩，并下一步。

保持默认，点击创建：

![fb723aca8085487e8ccb7d2c48260844.png][]

#### 终端验证 ####

sh-4.4# cd /etc/mysql/conf.d
    sh-4.4# ls
    my.cnf
    sh-4.4# cat my.cnf
    [client]
    default-character-set=utf8
    [mysql]
    default-character-set=utf8
    [mysqld]
    init_connect='SET collation_connection = utf8_unicode_ci'
    init_connect='SET NAMES utf8'
    character-set-server=utf8
    collation-server=utf8_unicode_ci
    skip-character-set-client-handshake
    skip-name-resolve
    
    server_id=2
    log-bin=mysql-bin
    read-only=1
    binlog-do-db=car_receiver_pre
    
    replicate-ignore-db=mysql
    replicate-ignore-db=sys
    replicate-ignore-db=information_schema
    replicate-ignore-db=performance_schemash-4.4#

[f6fc4d77c5ed4b5581a78b2a3a639ef7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/1f90e934e20b460d865f987bf5b7c14f.png
[c3b789ad334944f5820a45a55f22e85c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/1f67fd338597425a94b53630312d73ed.png
[Link 1]: http://10.51.51.46:30880/clusters/default/configmaps
[d4d11ed1b47445c7b64181ceacb61a84.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/c4f8b6682a3c4eb9a2a8308a2547f34a.png
[da55b8ca622a43538edd58f3ab6ca2c3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/be1887a4556b4e8d83e79a8662d13c76.png
[8f7b47625eb942678adc812b13a44af8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/ab2852e96c72422fa0076ad6906626e7.png
[89fd0ac9d394484ebd770f8860587c88.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/9b0d2220393d41baa9a038b92819d713.png
[723b210877884e02a6f7b925a85cbff4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/6965181e42834373bcb7478bb1830646.png
[Link 2]: http://10.51.51.46:30880/clusters/default/volumes/Volumes
[0e1b83b296124e14b47f6d4568b982f4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b267a52d6f8841b99f14da250ed3a7fc.png
[f58f5c54be3140a79f0d471e1d6f5ead.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/d1a0397c18eb42b7af29a44783120ead.png
[1a1c24a20aaf4f44a16263547a66454f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/536862eecce64e1eb6d1b1297e8b4fa2.png
[Link 3]: http://10.51.51.46:30880/system-workspace/clusters/default/projects/default/services
[a6fd1e4467e94978a1c7cc5bce729d18.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/ef6c56d5d80642a09c93b963899401c2.png
[e1eec2988af640d3917ecf9497c3b1c5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b9ccd4ea14d34ff5a8a1314d7fe2e2f6.png
[629cecde88ef4c3eab80cc6916bf0c0d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/adc4c3ec94084b8ba9a8ba0afd7e9b3d.png
[1854e6d1c6f74271a944c3792d6d46bb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b30298170c904c88876404dfa83d0f41.png
[53717c1da98841a1a7ee6093a7c3ef56.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/230cc0d92ef04ebb9dd871170ddf53e0.png
[21f8323124674ff0940566823099f12c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/aa9834c312da4279a8bca10b7be7fca0.png
[4d57d069ab704a728e5350e2907a6353.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/48ea02e055c24b0ea7be7ae71dcae341.png
[41bea79a2255442d80393276c17d559e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/f3faf40d2a1f4e538ad1b39ce89ceb70.png
[0051fe078e654d8cba9d7e03e227fc15.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/ab50a93f5e134fffa3937e4c8b6ae5ae.png
[b13a50cf168744c0a292f548fd5e2156.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/d531be75d8ca4d30b9e79b26c88c055b.png
[7aa5e6bfbdd04db1921661b6f7184670.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/aeb2f9a665ed447984ab781fcf6ea60d.png
[296dc8ed0c344c0ea33c7f0349cdf25b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/e72d53eeb2814a46a35ce95287d21c37.png
[0fd32d2d37824f61a6369c190d482b53.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/a9f393f04bc444b5a8cf9732d1edf0f3.png
[a4a34687350b465fa341810c3d6a7214.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/308506f996ab44b8bb5a2daa80cb363b.png
[b09cc859961e4df999547557a9c028e4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/473b1f62a2984acab9bf53b8f5611d15.png
[289d0f9dad3648688dad8d66cc4fbd4d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/244a8edb88a84564a092f68b1516ae37.png
[8160498daaee4cb482cbbf5ef0772381.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/65bdef0ed11f433383fe26a296dadea9.png
[mysql-master-v1-0]: http://10.51.51.46:30880/system-workspace/clusters/default/projects/default/pods/mysql-master-v1-0
[58b4c8b899ae44c1aed352db0dffa327.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/800c5381aa654adfb9b177ab0e61553b.png
[f129c0b7e5e542469f598bc8fb59cc50.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/f3a3a74b5f524e96ab7bea1d9200c995.png
[fd53cc50c76d4882b738dbf7dd1070bf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/18d005b1f1b14f9d83d9c5c26a5a9006.png
[326dcc41cff84f2f90dcc3e9c31f9f49.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b1e662ba3e2443adb8f7fa28729877f8.png
[1570d08858d242609f5bde2cc7521e3b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/fc815b6209a54cb59d3727697a1acc51.png
[2b52b88513284d1a840ad3eb74557c57.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/aca4126a6687444f868db7c294f60231.png
[9d150b3c626d4138af2e86b34f22a6d2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/77ed170394e847dbb1cde037d05e0a62.png
[408ef12107184949bc309f70e1e6b0ba.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/ffe87cb3a2954c03983b2192b7e740ff.png
[7c92f151ef3143879c78ede8a3d2bcaf.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/818af7d44b25467f98afe8b7e6742d50.png
[259f149dfab54dffa124626cac56d215.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/9699ba5f8131447b9f3895d4165aa0b8.png
[9be4a7ee0bf249da9b5187cd45945cb1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b1a480700c4e40b28fca3725ff8b116f.png
[fb723aca8085487e8ccb7d2c48260844.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/15eed3b0fa484161956f6ef9acc31b62.png