MySQL读写分离

MySQL读写分离
一、配置读写分离
1、配置hosts文件
[[email protected] ~]# vim /etc/hosts
192.168.100.10 centoss01
192.168.100.20 centoss02
192.168.100.30 centoss03
192.168.100.40 centoss04
192.168.100.50 centoss05
[[email protected] ~]# scp /etc/hosts [email protected]:/etc/
[[email protected] ~]# scp /etc/hosts [email protected]:/etc/
[[email protected] ~]# scp /etc/hosts [email protected]:/etc/
[[email protected] ~]# scp /etc/hosts [email protected]:/etc/
2、在主机amoeba上安装java环境
[[email protected] ~]# cp /mnt/jdk-6u14-linux-x64.bin /usr/src/
[[email protected] ~]# cd /usr/src/
[[email protected] src]# sh jdk-6u14-linux-x64.bin
[[email protected] src]# mv jdk1.6.0_14/ /usr/local/jdk
[[email protected] ~]# vim /etc/profile.d/java
export JAVA_HOME=/usr/local/jdk
export CLASSPATH=$CLASSPATH:$CLASSPATH:JAVA_HOME/bin:$JAVA_HOME/jre/lib export PATH=$JAVAH​OME/jre/libexportPATH=JAVA_HOME/lib:$JAVA_HOME/jre/bin:$JAVAH​OME/jre/bin:PATH:$HOME/bin export AMOEBA_HOME=/usr/local/amoeba export PATH=$HOME/binexportAMOEBAH​OME=/usr/local/amoebaexportPATH=PATH:$AMOEBA_HOME/bin
[[email protected] ~]# source /etc/profile.d/java
[[email protected] ~]# java -version
java version “1.6.0_14”
Java™ SE Runtime Environment (build 1.6.0_14-b08)
Java HotSpot™ 64-Bit Server VM (build 14.0-b16, mixed mode)
3、配置读写分离
[[email protected] ~]# mkdir /usr/local/amoeba
[[email protected] ~]# tar zxvf /mnt/amoeba-mysql-binary-2.2.0.tar.gz -C /usr/local/amoeba/
配置amoeba访问账户和密码
[[email protected] ~]# mysql -uroot [email protected]
mysql> grant all on . to ‘tom’@‘192.168.100.%’ identified by ‘[email protected]’;
Query OK, 0 rows affected (0.00 sec)
编辑amoeba.xml配置文件
[[email protected] ~]# vim /usr/local/amoeba/conf/amoeba.xml
编辑dbServers.xml
[[email protected] ~]# vim /usr/local/amoeba/conf/dbServers.xml
启动amoeba软件默认端口为tcp8066
[email protected] ~]# /usr/local/amoeba/bin/amoeba start&
[2] 1817
[[email protected] ~]# remote application= .Amoeba:53964 response OK
amoeba server is running with port=53964
[2]+ 退出 255 /usr/local/amoeba/bin/amoeba start
4、客户端测试
安装mysql
[[email protected] ~]# mount /dev/cdrom /mnt
mount: /dev/sr0 写保护，将以只读方式挂载
[[email protected] ~]# yum -y install mysql
通过代理访问mysql
[[email protected] ~]# mysql -u amoeba -p -h 192.168.100.50 -P 8066
Enter password:
在master上创建一个数据库和表表格写入内容
MySQL [(none)]> create database bdqn;
Query OK, 1 row affected (0.01 sec)
MySQL [(none)]> use bdqn;
Database changed
MySQL [bdqn]> create table student(姓名 char(10),性别 char(3),年龄 char(5));
Query OK, 0 rows affected (0.08 sec)
MySQL [bdqn]> insert into student value (‘战三’,‘男’,‘39’);
Query OK, 1 row affected (0.05 sec)
在主服务器上查看表格数据
从服务器查看
在客户端上查看数据
从服务器停止slave服务
Amoeba上插入数据
主服务器查看

从服务器查看
客户端查看
启动从节点
从服务器查看

客户端查看