节点规划
| IP | 主机名 | 节点 |
| 100.111.8.88 | db1 | MariaDB数据库集群主节点 |
| 100.111.8.131 | db2 | MariaDB数据库集群从节点 |
基础环境配置
修改主机名：
[root@test-1 ~]# hostnamectl set-hostname db1 #修改主机名 [root@test-1 ~]# bash #刷新 [root@db1 ~]# [root@test-2 ]# hostnamectl set-hostname db2 [root@test-2 ]# bash [root@db2 ]#
关闭防火墙、selinux
db1、db2两节点：
[root@db1 ~]# systemctl stop firewalld #关闭防火墙 [root@db1 ~]# setenforce 0 #临时关闭selinux，永久关闭selinux修改配置文件/etc/selinux/config [root@db2 ~]# systemctl stop firewalld [root@db2 ~]# setenforce 0
配置hosts
db1、db2两节点：配置一样
[root@db1 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 10.43.8.88 db1 10.43.8.131 db2
配置yum源
db1、db2两节点：配置一样
[root@db1 ~]# cat /etc/yum.repos.d/local.repo [centos] name=centos baseurl=http://10.120.11.15/centos/ gpgcheck=0 enabled=1
安装mariadb数据库并启动
db1、db2两节点：
[root@db1 ~]# yum install -y mariadb mariadb-server Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile Resolving Dependencies --> Running transaction check ---> Package mariadb.x86_64 1:5.5.56-2.el7 will be installed ---> Package mariadb-server.x86_64 1:5.5.56-2.el7 will be installed --> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.56-2.el7.x86_64 .... .... [root@db1 ~]# systemctl start mariadb [root@db1 ~]# systemctl enable mariadb Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
初始化数据库
db1、db2两节点：
一直按 y 就行
[root@db1 ~]# mysql_secure_installation #初始化数据库 NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! .... .... Set root password? [Y/n] y New password: #输入数据库root密码 Re-enter new password: #重复输入密码 Password updated successfully! Reloading privilege tables.. ... Success! .... .... Remove anonymous users? [Y/n] y #是否删除匿名用户 ... Success! Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? [Y/n] y #是否开启远程登陆数据库 ... Success! By default, MariaDB comes with a database named 'test' that anyone can 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! .... .... Reload privilege tables now? [Y/n] y #是否重新加载特权表 ... Success!
修改配置文件并重启
db1、db2两节点：
[root@db1 ~]# cat /etc/my.cnf.d/server.cnf ... ... [mysqld] log_bin = mysql-bin #记录操作日志 binlog_ignore_db = mysql #不同步mysql系统数据库 server_id = 88 #数据库集群中的每个节点id都要不同，一般使用IP地址的最后段的数字，例如172.30.11.12，server_id就写88 ... ... [root@db1 ~]# systemctl restart mariadb [root@db2 ~]# cat /etc/my.cnf.d/server.cnf ... ... [mysqld] log_bin = mysql-bin binlog_ignore_db = mysql server_id = 131 ... ... [root@db2 ~]# systemctl restart mariadb
数据库授权
db1:
[root@db1 ~]# mysql -uroot -p #root用户登录数据库 Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.56-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> MariaDB [(none)]> grant all privileges on *.* to root@'%' identified by "000000"; #赋予所以远程访问数据库权限 Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> grant replication slave on *.* to "user"@'db2' identified by "000000"; #赋予从节点同步主节点数据库的权限 Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> Ctrl-C -- exit! Aborted [root@db1 ~]#
db2:
[root@db2 ~]# mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.56-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> MariaDB [(none)]> change master to master_host='db1',master_user='user',master_password='000000'; #配置从节点连接主节点 Query OK, 0 rows affected (0.14 sec) MariaDB [(none)]> start slave; #开启从节点服务 Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> show slave status\G #检查Slave_IO_Running、Slave_SQL_Running字段是否为Yes，如果是那么主从数据库搭建成功 *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: db1 Master_User: user Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000001 Read_Master_Log_Pos: 526 Relay_Log_File: mariadb-relay-bin.000002 Relay_Log_Pos: 810 Relay_Master_Log_File: mysql-bin.000001 Slave_IO_Running: Yes #检查字段是否为Yes Slave_SQL_Running: Yes #检查字段是否为Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 526 Relay_Log_Space: 1106 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 88 1 row in set (0.00 sec) MariaDB [(none)]>
至此mariadb主从数据库搭建完毕！！！！
总结
- 配置环境：修改主机名
添加hosts映射
配置yum源
关闭防火墙
selinux - 安装mariadb：启动mariadb
初始化mariadb
修改配置文件/etc/my.cnf.d/server.cnf
重启mariadb - 登录授权：开启root用户远程访问所有数据库
开启赋予从节点同步主节点数据库的权限
配置从节点连接主节点
开启从节点服务
检查Slave_IO_Running、Slave_SQL_Running字段状态
