MySql安装

安装参考https://juejin.cn/post/6844904157975953415
出现如下

Public key for mysql-community-common-5.7.43-1.el7.x86_64.rpm is not installed

 Failing package is: mysql-community-common-5.7.43-1.el7.x86_64
 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

执行一下即可

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

在日志文件中查找自动生成的密码：

[root@SuperMachine bin]# cat /var/mysql/log/error.log |grep 'A temporary password'

修改密码为123123

mysql> set password for 'root'@'localhost' =password('123123');

允许该数据库远程连接

GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123123';

Mysql集群安装
https://blog.51cto.com/u_16175509/6627207?u_atoken=ece07acc-282a-4fa9-86e6-fa19cbca18bd&u_asession=01ov6t2Vim1NmFfvvGkgKJiziYP6vyD828P7voGcsi0OCGHXWfgXLRb3ZdLPbqF-zhybCO3PYhaZayz7WflyhpuNsq8AL43dpOnCClYrgFm6o&u_asig=05EMpCYTQwkHLvyfViyF1-fPHim8gjqkbQYwuCI_t2Q2cvQyIzrS8AXFNyenjzpfDjp3ap5XKFIpnJOutZ6e7EzWxCJcJuOzNT1IoxzJduZyKhGSXCxd6niH1-D4g3AHpiBPZRJ9fcZKLSFJz6E1Ha88afN2R8jUz7otQAzCZtmUV6AKcykOJBqMax4KLQ01jwksmHjM0JOodanL5-M1Qs1QfW9TDKXoKB4sICSSDPGwdxXUxDP3wT9whQeVgPh3Cs9PMy6KdRZB-rrc6-Frr0H4Em9_hAZA1AP4FATZJXB3_Y94r_LXIIil3Y3aVPRGAe&u_aref=D1ZyMEomUiXkBVkw4Ktj3Syadd4%3D

2023-09-16T13:03:40.263401Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.43-log) starting as process 3843 ...
mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13 - Permission denied)

执行如下命令

chown -R mysql:mysql /var/log/mysql

Mysql Replication集群
如果从节点过多，会消耗主节点的网络资源，导致数据同步变慢

可以通过从节点作为中继节点。其他从节点从该从节点同步数据。