MySQL数据库集群之PXC方案---centos安装percona数据库

素颜马尾好姑娘i 2021-12-10 04:02 434阅读 0赞

# 1. Percona数据库系统支持 #

Percona Server数据库只支持Linux系统，不能在其他系统上安装

# 2. 从官网下载Percona5.7 #

地址：[https://www.percona.com/downloads/Percona-Server-5.7/LATEST/][https_www.percona.com_downloads_Percona-Server-5.7_LATEST]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70]

# 3. 解压压缩包上传到服务器 #

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

# 4. 下载jemalloc包上传到服务器 #

我们还需要下载一个[jemalloc-3.6.0-8.el7.centos.x86\_64][jemalloc-3.6.0-8.el7.centos.x86_64]  
![在这里插入图片描述][20190715170036477.png]

# 5. RPM安装Percona Server #

yum localinstall *.rpm

# 6. 管理mysql服务 #

使用systemctl start mysqld命令启动percona

systemctl start mysqld
    
    systemctl stop mysqld
    
    systemctl restart mysqld

# 7. 系统开放3306端口 #

firewall-cmd --zone=public --add-port=3306/tcp --permanent
    firewall-cmd --reload

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

# 8. 修改mysql配置文件 #

我们查看一下percona的配置文件的路径在哪里，查看etc文件

cat /etc/my.cnf

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

进入 /etc/percona-server.conf.d/目录

cd /etc/percona-server.conf.d/

![在这里插入图片描述][20190715171511403.png]  
在mysqld.cnf文件中添加以下内容

[mysqld]
    character_set_server = utf8
    bind-address = 0.0.0.0
    #跳过DNS解析
    skip-name-resolve

重启mysql服务

systemctl restart mysqld

# 9. 禁止开机启动MySQL #

chkconfig mysqld off

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

# 10. 修改root用户默认密码 #

## 10.1 查看MySQL初始密码 ##

cat /var/log/mysqld.log | grep "A temporary password"

![在这里插入图片描述][20190715171914332.png]  
初始密码是)Oaa\*nghh5pw，复制这个密码，后边修改是会用到

## 10.2 修改MySQL密码 ##

mysql_secure_installation

![在这里插入图片描述][20190715172054100.png]  
输入新密码，新密码需要有大小写字母加数组，我们这里设置Abc\_123456  
![在这里插入图片描述][20190715172205254.png]  
后边有一些初始化的操作，所有都输入y  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 1]

# 11. 创建远程管理员账户 #

root账户默认不允许远程连接，所以我们创建一个可以远程连接的账户

进入mysql

mysql -u root -p

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 2]  
创建新用户赋予远程连接权限

CREATE USER 'admin'@'%' IDENTIFIED BY 'Abc_123456';
     GRANT all privileges ON *.* TO 'admin'@'%';
     FLUSH PRIVILEGES;

# 12. 测试连接 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 3]

# 13. 补充mysql找回root账户密码 #

# 1. 修改配置文件 #

修改配置文件添加skip-grant-tables

vi  /etc/percona-server.conf.d/mysqld.cnf

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 4]

# 2. 重启mysql服务 #

systemctl restart mysqld

# 3. 修改密码 #

进入mysql

mysql

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 5]

use mysql;
    update mysql.user set authentication_string=password('MLZ-pass123456') where user='root';
    FLUSH PRIVILEGES;

修改成功推出

exit

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

# 4. 删除配置文件中的skip-grant-tables #

删除配置文件中的skip-grant-tables

vi  /etc/percona-server.conf.d/mysqld.cnf

# 5. 重启mysql #

systemctl restart mysqld

# 6. 测试新密码 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 6]

这篇博客只是介绍一下percona的安装方法，在后续的pxc集群中，不需要安装percona数据库，因为pxc集群已经添加了percona的依赖。

[https_www.percona.com_downloads_Percona-Server-5.7_LATEST]: https://www.percona.com/downloads/Percona-Server-5.7/LATEST/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70]: /images/20211209/9055c81385fa45c59d499654413aa757.png
[20190715165538659.png]: /images/20211209/42f99a5bf64d48ddbb1fc493ca3e7c8a.png
[jemalloc-3.6.0-8.el7.centos.x86_64]: https://cbs.centos.org/koji/buildinfo?buildID=47
[20190715170036477.png]: /images/20211209/4c5c17a04cd14f6884ac52ff9c6bdb24.png
[20190715171025855.png]: /images/20211209/f732f65ea6034ab68b8cfc5a035e883d.png
[20190715171418999.png]: /images/20211209/c35c7faf8ab94da4ba6dec1d5419158a.png
[20190715171511403.png]: /images/20211209/965c16e60ecb40228dcbbe6476adf262.png
[20190715171741989.png]: /images/20211209/c17d0b54ef3a4b6da01ad119892d39af.png
[20190715171914332.png]: /images/20211209/48c56e8034354d05a8961b76f28fc3d7.png
[20190715172054100.png]: /images/20211209/eeab1a3de121444391c8173639a62171.png
[20190715172205254.png]: /images/20211209/e05e8d2dba4240099b333439dcd2dd37.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 1]: /images/20211209/a696cb13a86f40b89b6a660f328f32c1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 2]: /images/20211209/67a060e69ff049e2845c18fa81b58a2f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 3]: /images/20211209/13360f2aecff48a7a35f55a87a9c171e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 4]: /images/20211209/d6d64a0990f947848a7dce980a4a4deb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 5]: /images/20211209/81fa5678718e482295f95c7601bf414c.png
[20190715174235429.png]: /images/20211209/817e8ac54f344d4fb77bcb7b2e7b7698.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Bqc2RzZw_size_16_color_FFFFFF_t_70 6]: /images/20211209/c9569c9df9614c248703f9f400127ba4.png