cent7离线装mariadb10.1-galera集群-详细笔记总结

cent7 离线 rpm 包安装 mariadb10.1-galera 集群

机器规划：mariadb1：192.168.27.143 mariadb2：192.168.27.144 mariadb3：192.168.27.145

1.三台机器先分别独立安装自己的数据库并设置 root 密码：123（都为 123）

mariadb1 机器：

[root@mariadb1 ~]# cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.27.143 mariadb1

192.168.27.144 mariadb2

[root@mariadb1 ~]# tar -zxf mariadb-rpms-10.1.30.tar.gz

[root@mariadb1 ~]# ls

mariadb-rpms mariadb-rpms-10.1.30.tar.gz

[root@mariadb1 ~]# cd mariadb-rpms

[root@mariadb1 mariadb-rpms]# ls

boost-program-options-1.53.0-26.el7.x86_64.rpm MariaDB-10.1.30-centos73-x86_64-common.rpm

perl-DBI-1.627-4.el7.x86_64.rpm

galera-25.3.22-1.rhel7.el7.centos.x86_64.rpm MariaDB-10.1.30-centos73-x86_64-server.rpm

perl-IO-Compress-2.061-2.el7.noarch.rpm

jemalloc-3.6.0-1.el7.x86_64.rpm perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm

[root@mariadb1 mariadb-rpms]# cd

[root@mariadb1 ~]# systemctl start mariadb

[root@mariadb1 ~]# systemctl enable mariadb

[root@mariadb1 ~]# systemctl status mariadb

● mariadb.service - MariaDB 10.1.30 database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)

Drop-In: /etc/systemd/system/mariadb.service.d

└─migrated-from-my.cnf-settings.conf

Active: active (running) since Thu 2019-06-27 13:54:12 CST; 22s ago

接下来进行 MariaDB 的相关简单配置，并设置 root 登录密码：123，否则无密码即可登录，使用命令： mysql_secure_installation

you haven't set the root password yet, the password will be blank,

so you should just press enter here.

Enter current password for root (enter for none):

OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB

root user without the proper authorisation.

Set root password? [Y/n] y

to log into MariaDB without having to have a user account created for

them. This is intended only for testing, and to make the installation

go a bit smoother. You should remove them before moving into a

production environment.

Remove anonymous users? [Y/n] y

... Success!

ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y

access. This is also intended only for testing, and should be removed

before moving into a production environment.

Remove test database and access to it? [Y/n] y

- Dropping test database...

... Success!

- Removing privileges on test database...

... Success!

Reloading the privilege tables will ensure that all changes made so far

will take effect immediately.

[root@mariadb1 ~]# mysql -uroot -p123

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

+--------------------+

3 rows in set (0.00 sec)

192.168.27.144 mariadb2

192.168.27.145 mariadb3

[root@mariadb2 ~]# systemctl stop firewalld

[root@mariadb2 ~]# rz

上传包

[root@mariadb2 ~]# ls

[root@mariadb2 ~]# tar -zxf mariadb-rpms-10.1.30.tar.gz

[root@mariadb2 ~]# ls

mariadb-rpms mariadb-rpms-10.1.30.tar.gz

boost-program-options-1.53.0-26.el7.x86_64.rpm MariaDB-10.1.30-centos73-x86_64-common.rpm

galera-25.3.22-1.rhel7.el7.centos.x86_64.rpm MariaDB-10.1.30-centos73-x86_64-server.rpm

perl-IO-Compress-2.061-2.el7.noarch.rpm

jemalloc-3.6.0-1.el7.x86_64.rpm perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm

perl-Net-Daemon-0.48-5.el7.noarch.rpm

lsof-4.87-4.el7.x86_64.rpm perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm

perl-PlRPC-0.2020-14.el7.noarch.rpm

MariaDB-10.1.30-centos73-x86_64-client.rpm perl-Data-Dumper-2.145-3.el7.x86_64.rpm

rsync-3.0.9-17.el7.x86_64.rpm

[root@mariadb2 mariadb-rpms]# rpm -ivh * --nodeps --force

[root@mariadb2 mariadb-rpms]# cd

[root@mariadb2 ~]# systemctl start mariadb

[root@mariadb2 ~]# systemctl enable mariadb