菜鸟教程手把手教你如何搭建mysql集群

潇湘秦（樊武振）

已于 2024-04-10 14:19:30 修改

阅读量1.8k

点赞数 21

文章标签：数据库 mysql

于 2024-02-28 09:31:59 首次发布

本文链接：https://blog.youkuaiyun.com/xiaofan23z/article/details/136337309

版权

本文详细介绍了在CentOS 7.9上搭建MySQL 8.0.33集群的步骤，包括下载安装、创建用户、配置数据存储、初始化数据库、配置my.cnf文件、设置权限、关闭防火墙、启动和验证主从同步状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

-------------------------------------------------------------------
欢迎关注作者分享更多数据库安装配置，troubleshooting，调优，备份恢复知识和案例
优快云：潇湘秦-优快云博客

公众号：潇湘秦

-------------------------------------------------------------------

1.下载mysql安装档

环境 os：centos 7.9 mysql 8.0.33

下载安装文档

官网下载地址 MySQL :: Download MySQL Community Server (Archived Versions) （需要MOS账号）

墨天伦下载：mysql-8.0.33-el7-x86_64.tar.gz - 墨天轮文档

本次使用的为mysql-8.0.33-el7-x86_64.tar.gz

2.上传安装包并解压

主从两节点

tar -xzvf mysql-8.0.33-el7-x86_64.tar.gz -C /usr/local/

tar -xzvf mysql-8.0.33-el7-x86_64.tar.gz  -C /usr/local/
mysql-8.0.33-el7-x86_64/bin/
mysql-8.0.33-el7-x86_64/bin/myisam_ftdump
mysql-8.0.33-el7-x86_64/bin/myisamchk
mysql-8.0.33-el7-x86_64/bin/myisamlog
mysql-8.0.33-el7-x86_64/bin/myisampack
mysql-8.0.33-el7-x86_64/bin/mysql
mysql-8.0.33-el7-x86_64/bin/mysql_config_editor
mysql-8.0.33-el7-x86_64/bin/mysql_migrate_keyring
mysql-8.0.33-el7-x86_64/bin/mysql_secure_installation
mysql-8.0.33-el7-x86_64/bin/mysql_ssl_rsa_setup
mysql-8.0.33-el7-x86_64/bin/mysql_tzinfo_to_sql
mysql-8.0.33-el7-x86_64/bin/mysql_upgrade
mysql-8.0.33-el7-x86_64/bin/mysqladmin
mysql-8.0.33-el7-x86_64/bin/mysqlbinlog
mysql-8.0.33-el7-x86_64/bin/mysqlcheck
mysql-8.0.33-el7-x86_64/bin/mysqldump
mysql-8.0.33-el7-x86_64/bin/mysqlimport
mysql-8.0.33-el7-x86_64/bin/mysqlpump
mysql-8.0.33-el7-x86_64/bin/mysqlshow
mysql-8.0.33-el7-x86_64/bin/mysqlslap
mysql-8.0.33-el7-x86_64/lib/
mysql-8.0.33-el7-x86_64/lib/plugin/
mysql-8.0.33-el7-x86_64/lib/plugin/authentication_fido_client.so
mysql-8.0.33-el7-x86_64/lib/plugin/authentication_kerberos_client.so
mysql-8.0.33-el7-x86_64/lib/plugin/authentication_ldap_sasl_client.so
mysql-8.0.33-el7-x86_64/lib/plugin/authentication_oci_client.so
mysql-8.0.33-el7-x86_64/bin/
mysql-8.0.33-el7-x86_64/bin/mysqld-debug
mysql-8.0.33-el7-x86_64/bin/
mysql-8.0.33-el7-x86_64/bin/mysql_config
mysql-8.0.33-el7-x86_64/include/
mysql-8.0.33-el7-x86_64/include/errmsg.h
mysql-8.0.33-el7-x86_64/include/field_types.h
mysql-8.0.33-el7-x86_64/include/my_command.h
mysql-8.0.33-el7-x86_64/include/my_compress.h
mysql-8.0.33-el7-x86_64/include/my_list.h
mysql-8.0.33-el7-x86_64/include/mysql/
mysql-8.0.33-el7-x86_64/include/mysql.h
mysql-8.0.33-el7-x86_64/include/mysql/client_plugin.h
mysql-8.0.33-el7-x86_64/include/mysql/plugin_auth_common.h
mysql-8.0.33-el7-x86_64/include/mysql/udf_registration_types.h
mysql-8.0.33-el7-x86_64/include/mysql_com.h
mysql-8.0.33-el7-x86_64/include/mysql_time.h
mysql-8.0.33-el7-x86_64/include/mysql_version.h
mysql-8.0.33-el7-x86_64/include/mysqld_error.h
mysql-8.0.33-el7-x86_64/include/mysqlx_ername.h
mysql-8.0.33-el7-x86_64/include/mysqlx_error.h
mysql-8.0.33-el7-x86_64/include/mysqlx_version.h
mysql-8.0.33-el7-x86_64/lib/
mysql-8.0.33-el7-x86_64/lib/libmysqlclient.a
mysql-8.0.33-el7-x86_64/lib/libmysqlservices.a
mysql-8.0.33-el7-x86_64/lib/pkgconfig/
mysql-8.0.33-el7-x86_64/lib/pkgconfig/mysqlclient.pc
mysql-8.0.33-el7-x86_64/share/
mysql-8.0.33-el7-x86_64/share/aclocal/
mysql-8.0.33-el7-x86_64/share/aclocal/mysql.m4
mysql-8.0.33-el7-x86_64/docs/
mysql-8.0.33-el7-x86_64/docs/ChangeLog
mysql-8.0.33-el7-x86_64/docs/INFO_SRC
mysql-8.0.33-el7-x86_64/docs/
mysql-8.0.33-el7-x86_64/docs/INFO_BIN
mysql-8.0.33-el7-x86_64/docs/INFO_SRC
mysql-8.0.33-el7-x86_64/man/
mysql-8.0.33-el7-x86_64/man/man1/
mysql-8.0.33-el7-x86_64/man/man1/comp_err.1
mysql-8.0.33-el7-x86_64/man/man1/ibd2sdi.1
mysql-8.0.33-el7-x86_64/man/man1/innochecksum.1
mysql-8.0.33-el7-x86_64/man/man1/lz4_decompress.1
mysql-8.0.33-el7-x86_64/man/man1/my_print_defaults.1
mysql-8.0.33-el7-x86_64/man/man1/myisam_ftdump.1
mysql-8.0.33-el7-x86_64/man/man1/myisamchk.1
mysql-8.0.33-el7-x86_64/man/man1/myisamlog.1
mysql-8.0.33-el7-x86_64/man/man1/myisampack.1
mysql-8.0.33-el7-x86_64/man/man1/mysql.1
mysql-8.0.33-el7-x86_64/man/man1/mysql.server.1
mysql-8.0.33-el7-x86_64/man/man1/mysql_config.1
mysql-8.0.33-el7-x86_64/man/man1/mysql_config_editor.1
mysql-8.0.33-el7-x86_64/man/man1/mysql_secure_installation.1
mysql-8.0.33-el7-x86_64/man/man1/mysql_ssl_rsa_setup.1
mysql-8.0.33-el7-x86_64/man/man1/mysql_tzinfo_to_sql.1
mysql-8.0.33-el7-x86_64/man/man1/mysql_upgrade.1
mysql-8.0.33-el7-x86_64/man/man1/mysqladmin.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlbinlog.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlcheck.1
mysql-8.0.33-el7-x86_64/man/man1/mysqld_multi.1
mysql-8.0.33-el7-x86_64/man/man1/mysqld_safe.1
mysql-8.0.33-el7-x86_64/man/man1/mysqldump.1
mysql-8.0.33-el7-x86_64/man/man1/mysqldumpslow.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlimport.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlman.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlpump.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlrouter.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlrouter_passwd.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlrouter_plugin_info.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlshow.1
mysql-8.0.33-el7-x86_64/man/man1/mysqlslap.1
mysql-8.0.33-el7-x86_64/man/man1/perror.1
mysql-8.0.33-el7-x86_64/man/man1/zlib_decompress.1
mysql-8.0.33-el7-x86_64/man/man8/
mysql-8.0.33-el7-x86_64/man/man8/mysqld.8
mysql-8.0.33-el7-x86_64/LICENSE
mysql-8.0.33-el7-x86_64/README
mysql-8.0.33-el7-x86_64/bin/
mysql-8.0.33-el7-x86_64/bin/ibd2sdi
mysql-8.0.33-el7-x86_64/bin/innochecksum
mysql-8.0.33-el7-x86_64/bin/lz4_decompress
mysql-8.0.33-el7-x86_64/bin/my_print_defaults
mysql-8.0.33-el7-x86_64/bin/mysqld
mysql-8.0.33-el7-x86_64/bin/mysqld_multi
mysql-8.0.33-el7-x86_64/bin/mysqld_safe
mysql-8.0.33-el7-x86_64/bin/mysqldumpslow
mysql-8.0.33-el7-x86_64/bin/perror
mysql-8.0.33-el7-x86_64/bin/zlib_decompress
mysql-8.0.33-el7-x86_64/lib/
mysql-8.0.33-el7-x86_64/lib/mecab/
mysql-8.0.33-el7-x86_64/lib/mecab/dic/
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/char.bin
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/dicrc
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/left-id.def
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/matrix.bin
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/pos-id.def
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/rewrite.def
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/right-id.def
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/sys.dic
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_euc-jp/unk.dic
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/char.bin
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/dicrc
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/left-id.def
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/matrix.bin
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/pos-id.def
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/rewrite.def
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/right-id.def
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/sys.dic
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_sjis/unk.dic
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_utf-8/
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_utf-8/char.bin
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_utf-8/dicrc
mysql-8.0.33-el7-x86_64/lib/mecab/dic/ipadic_utf-8/left-id.def
mysql-8.