![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql集群
YS·云舞之森·子书深云·YC
月色太美,饮风也醉
展开
-
centos7单机安装多个mysql8.0
CentOS7安装MySQL8上传下载地址:https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz上传mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz到服务器指定文件夹,如:/home/mysql解压cd /home/mysqltar -xvf mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz重原创 2021-06-29 15:50:36 · 953 阅读 · 0 评论 -
安装配置keepalived实现mysql高可用
安装配置keepalived实现mysql高可用在编译之前先安装OpenSSL,否则会报错yum -y install openssl-develyum -y install libnl libnl-develyum -y install libnfnetlink-devel安装keepalived# 下载keepalived-2.2.2.tar.gz,上传到服务器,如:/home/keepalived# 解压tar -xvf keepalived-2.2.2.tar.gz#原创 2021-06-29 16:00:17 · 185 阅读 · 0 评论 -
MySql集群配置-三主互从
MySql集群配置-三主互从在每台MySql服务器中创建从库用户#登录mysqlcd /home/mysql/mysql3306/bin/./mysql -uroot -p -h 127.0.0.1 --socket=../tmp/mysql.sock --port=3306CREATE USER 'his'@'%';ALTER USER 'his'@'%' IDENTIFIED WITH mysql_native_password BY 'suxia@backup2021';GRANT原创 2021-06-29 15:57:25 · 1504 阅读 · 0 评论