1.基础环境配置
(1)修改主机名
Mysql1:
[root@localhost ~]# hostnamectl set-hostname mysql1
[root@localhost ~]# bash
[root@mysql1 ~]# hostnamectl
Static hostname: mysql1
Icon name: computer-vm
Chassis: vm
Machine ID: 2c685687b1764506aada31a39c8926f3
Boot ID: 72c432fafcdf491a8385cd0438840b49
Virtualization: vmware
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-327.el7.x86_64
Architecture: x86-64
Mysql2:
[root@localhost ~]# hostnamectl set-hostname mysql2
[root@localhost ~]# bash
[root@mysql2 ~]# hostnamectl
Static hostname: mysql2
Icon name: computer-vm
Chassis: vm
Machine ID: 41f5d1c66e3a4552abec4d27eaeb5d2a
Boot ID: 55d08ddda2a04c98b4f940879c6f6c49
Virtualization: vmware
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-327.el7.x86_64
Architecture: x86-64
(2)关闭防火墙及SELinux服务
两个节点关闭防火墙firewalld及SELinux服务,命令如下:
[root@mysql1 ~]# systemctl stop firewalld
[root@mysql1 ~]# setenforce 0
[root@mysql1 ~]# getenforce
Permissive
(3)配置hosts文件
两个节点配置/etc/hosts文件,命令如下
[root@mysql1 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.200.30 mysql1
192.168.200.40 mysql2
Mysql2节点与mysql1一样。
(4)配置YUM源并安装数据库服务
使用项目3中配置YUM源的方法自行配置。配置完毕后,两个节点安装数据库服务。
命令如下:
[root@mysql1 ~]# yum install -y mariadb mariadb-server
两个节点启动数据库服务并设置开机自启,命令如下:
[root@mysql1 ~]# systemctl start mariadb
[root@mysql1 ~]# systemctl enable mariadb
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
2.初始化数据库并配置主从服务。
(1)初始化数据库
两个节点初始化数据库,配置数据库root密码为000000,命令如下:
[root@mysql1 ~]# mysql_secure_installation
/usr/bin/mysql_secure_installation:行379: find_mysql_client: 未找到命令
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
SERVERS IN