mysql8.0.16 ndbcluster centos7 环境搭建

约定不等于承诺〃 2022-01-31 14:39 405阅读 0赞

## **mysql ndbcluster****集群搭建** ##

管理节点 （不需要mysql二进制文件）

配置文件/var/lib/mysql-cluster/config.ini

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70][]

ndb\_mgmd -f /var/lib/mysql-cluster/config.ini

ndb\_mgm

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70 1][]

数据节点（不需要mysql二进制文件）

ndbd

ndbmtd

sql节点

检查您的`/etc/passwd`和 `/etc/group`文件

**groupadd mysql**

**useradd -g mysql -s /bin/false mysql**

**chown -R root .**

**chown -R mysql data**

**chgrp -R mysql .**

**cp support-files/mysql.server /etc/rc.d/init.d/**

**chmod +x /etc/rc.d/init.d/mysql.server**

**chkconfig --add mysql.server**

配置文件在/etc/my.conf

在/usr/local/mysql/创建data文件夹

./mysqld –initialize 记录初始化密码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70 2][]

**chown mysql:mysql /usr/local/mysql/data**

**改变chown mysql:mysql /usr/local/mysql/mysql-cluster/权限**

**改变/usr/local/mysql/mysql-cluster/data/  权限 chgrp -R mysql .**

**配置路由：下载mysqlrouter二进制文件，新建conf、log、run、data文件夹，在conf中新建mysqlrouter.conf文件**

![20190517215956116.png][]

**配置内容：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70 4][]

启动路由

![20190517220436532.png][]

一、启动mysql服务

service mysql.server start

mysql -u root -p '密码'

更改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

更改访问权限

update user set host='%' where user='root';

flush privileges;

修改用户的加密方式

select user,plugin from user where user='root';

alter user 'root'@'%' identified with mysql\_native\_password by 'root';

flush privileges;

二、安装过程中遇到的坑Openssl，linux运行二进制文件没有libssl.so.1.0.0和libcrypto.so.1.0.0

Problem : error while loading shared libraries: libssl.so.1.0.0: cannot open shared object file: No such file or directory

解决：ln -s /usr/lib64/libssl.so.1.0.2k /usr/lib64/libssl.so.1.0.0

ln -s /usr/lib64/libcrypto.so.1.0.2k /usr/lib64/libcrypto.so.1.0.0

三、[MySQL提示:The server quit without updating PID file问题的解决办法][MySQL_The server quit without updating PID file]

1、ps -ef|grep mysqld 查看mysql是否启动，如果存在，kill -9 "端口号"杀掉线程

2、“chmod -R 755 /usr/local/mysql/data”  然后重新启动mysqld

3、查看/usr/local/mysql/mysql-cluster/data的权限

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70]: /images/20220131/47565525a5f34a4ab52ddb20f3287571.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70 1]: /images/20220131/5c15ffb2bb7a4ab8b252b9dd7ae6ff0c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70 2]: /images/20220131/c43a57e226344e1d9508e74d96571ff6.png
[20190517215956116.png]: /images/20220131/83cd811147c94bd9922cd05f4b7b89c5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70 3]: /images/20220131/7733d0906fd148b7b8c85d38494e296c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3l1XzVkeA_size_16_color_FFFFFF_t_70 4]: /images/20220131/7c3756293a134a219ec9c42723bdf565.png
[20190517220436532.png]: /images/20220131/52911c320bef4abc9c5c58fc62be7a6c.png
[MySQL_The server quit without updating PID file]: https://www.cnblogs.com/wangshaojun/p/5065298.html