一、实验环境
master-masql192.168.83.132
slave-mysql192.168.83.133
mysql-proxy192.168.83.134
二、安装mysql
1、安装包所需环境
yum -y groupinstall "Development tools" "Server Platform Development"
yum -y install libxml2-devel ncurses-devel openssl*
2、创建mysql用户
# mkdir -pv /mydata/data
# mkdir -pv /mydata/binlogs (master上创建)
# mkdir -pv /mydata/realylogs (slave上创建)
# groupadd -r mysql
# useradd -g mysql -r -s /sbin/nologin -M -d /mydata/data mysql
# chown -R mysql:mysql /mydata/data
3、安装mysql
# tar xf mysql-5.5.33-linux2.6-i686.tar.gz -C /usr/local
# cd /usr/local/
# ln -sv mysql-5.5.33-linux2.6-i686 mysql
# cd mysql
# chown -R mysql:mysql ./*
# scripts/mysql_install_db --user=mysql --datadir=/mydata/data
# chown -R root ./*
4、为mysql提供主配置文件:
# cd /usr/local/mysql
# cp support-files/my-large.cnf /etc/my.cnf
5、修改配置文件
vim /etc/my.cnf (master服务器)
datadir = /mydata/data ##添加
log-bin=/mydata/binlogs/master-bin ##修改日志路径
vim /etc/my.cnf (slave服务器)
datadir = /mydata/data
relay-log = /mydata/realylogs/relay-log ##开启中继日志
#log-bin=mysql-bin ##禁用二进制日志
#binlog_format=mixed
server-id = 10
6、为mysql提供sysv服务脚本:
# cd /usr/local/mysql
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod +x /etc/rc.d/init.d/mysqld
7、添加至服务列表:
# chkconfig --add mysqld
# chkconfig mysqld on
8、输出mysql的库文件给系统库查找路径:
# echo '/usr/local/mysql/lib' > /etc/ld.so.conf.d/mysql.conf
9、修改PATH环境变量,让系统可以直接使用mysql的相关命令。具体实现过程这里不再给出。
vim /etc/profile.d/mysqld.sh
export PATH=/usr/local/mysql/bin:$PATH
]# source /etc/profile.d/mysqld.sh
# ldconfig
10、在master上创建具有复制权限的slave帐号并查看二进制日志起点
11、配置slave服务器
连接master:
MariaDB [(none)]> HELP CHANGE MASTER TO
Name: 'CHANGE MASTER TO'
Syntax:
CHANGE MASTER TO option [, option] ...
option:
MASTER_BIND = 'interface_name'
| MASTER_HOST = 'host_name' # 指明要连接的主节点,值类型字串</