一 搭建mysql主从复制
1.配置ntp时间同步
2,修改ntp主配置文件
restrict 192.168.100.0 mask 255.255.255.0 nomodify notrap
server 127.127.1.0
fudge 127.127.1.0 stratum 8
设置开机自启
[root@centos01 ~]# systemctl start ntpd
[root@centos01 ~]# systemctl enable ntpd
时间同步
[root@centos04 ~]# ntpdate 192.168.100.10
安装mysql
[root@centos01 ~]# yum -y install ncurses-devel cmake
配置mysql
[root@centos01 ~]# groupadd mysql
[root@centos01 ~]# useradd -M -s /sbin/nologin -g mysql mysql
[root@centos01 mysql-5.5.22]# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DSYSCONFDIR=/etc
4)编译安装mysql
[root@centos01 mysql-5.5.22]# make && make install
5)生成mysql服务配置文件
[root@centos01 mysql-5.5.22]# cp support-files/my-medium.cnf /etc/my.cnf
6)生成服务配置文件
[root@centos01 mysql-5.5.22]# cp support-files/mysql.server /etc/init.d/mysqld
[root@centos01 mysql-5.5.22]# chmod +x /etc/init.d/mysqld
7)添加系统服务设置开机自动启动
[root@centos01 mysql-5.5.22]# chkconfig --add mysqld
[root@centos01 mysql-5.5.22]# chkconfig --level 35 mysqld on
8)优化mysql命令
[root@centos01 ~]# vim /etc/profile# /etc/profile
PATH=$PATH:/usr/local/mysql/bin/
[root@centos01 ~]# source /etc/profile
启动mysql
修改mysql主配置文件
C1
16 log-bin=mysql-bin
18 server-id = 10
19 log-slave-update=true
C2
C3
创建主从复制分离
grant replication slave on . to ‘slave’@‘192.168.100.%’ identified by ‘pwd@123’;
查看主mysql状态
配置mysql数据库复制账户
change master to master_host=‘192.168.100.10’,master_user=‘slave’,master_password=‘pwd@123’,master_log_file=‘mysql-bin.000004’,master_log_pos=263;
C1创建benet验证
二。读写分离
1.配置hosts文件
安装JDK和amoeba
[root@centos04 ~]# ./jdk-6u14-linux-x64.bin
移动JDK位置
[root@centos04 ~]# mv jdk1.6.0_14/ /usr/local/java
创建amoeba配置文件
解压
[root@centos04 ~]# tar zxvf /mnt/amoeba-mysql-binary-2.2.0.tar.gz -C /usr/local/amoeba/
配置环境变量
export JAVA_HOME=/usr/local/java
export CLASSPATH=
C
L
A
S
S
P
A
T
H
:
CLASSPATH:
CLASSPATH:JAVA_HOME/lib:
J
A
V
A
H
O
M
E
/
j
r
e
/
l
i
b
e
x
p
o
r
t
P
A
T
H
=
JAVA_HOME/jre/lib export PATH=
JAVAHOME/jre/libexportPATH=JAVA_HOME/lib/:
J
A
V
A
H
O
M
E
/
j
r
e
/
b
i
n
:
JAVA_HOME/jre/bin:
JAVAHOME/jre/bin:PATH:
H
O
M
E
/
b
i
n
/
e
x
p
o
r
t
A
M
O
E
B
A
=
/
u
s
r
/
l
o
c
a
l
/
a
m
o
e
b
a
e
x
p
o
r
t
P
A
T
H
=
HOME/bin/ export AMOEBA=/usr/local/amoeba export PATH=
HOME/bin/exportAMOEBA=/usr/local/amoebaexportPATH=PATH:$AMOEBA/bin
C1创建amoeba访问数据库读写分离账户
mysql> grant all on . to ‘write’@‘192.168.100.%’ identified by ‘pwd@123’;
**修改amoeba配置文件登录amoeba账户
修改配置文件添加读写节点
[root@centos04 ~]# vim /usr/local/amoeba/conf/dbServers.xml
19 3306
22 write
23 pwd@123
启动amoeba服务
[root@centos04 ~]# /usr/local/am!oeba/bin/amoeba start&启动amoeba服务
安装mysql客户端
[root@centos05 ~]# yum -y install mariadb
登录amoeba
[root@centos05 ~]# mysql -h 192.168.100.40 -P 8066 -uamoeba -ppwd@123