MYSQL主从+amoeba读写分离（一）
1.首先介绍下我的实验环境。System： CentOS 6.0
Master mysql： 192.168.3.161
Slave mysql：192.168.3.162
Amoeba server：192.168.3.69
2.主从的配置
主服务器上添加同步用户
grant replication slave,file on *.* to 'replication'@'192.168.1.162'> flush privileges;
####修改master的my.cnf的配置
log-bin=mysql-bin #打开mysql二进制日志
server-id= 1 #设置mysql_id，主从不能相同
binlog-do-db=test #设置二进制日志记录的库
binlog-ignore-db=mysql ##设置二进制日志不记录的库
sync_binlog=1
####修改slave的my.cnf的配置
log-bin=mysql-bin
server-id= 2
replicate-do-db=test #设置同步的库
replicate-ignore-db=mysql #设置不同步的库
log-slave-updates #同步后记录二进制日志
slave-skip-errors=all
sync_binlog=1
slave-net-timeout=60
分别重启主从mysqld服务，登录主mysql，在主上执行flush tables with read lock;后将test数据库的数据copy到从上，并记录下主上show master status\G的结果：
如：
mysql> show master status\G;
*************************** 1. row ***************************
File: mysql-bin.000022
Position: 1237
Binlog_Do_DB: test
Binlog_Ignore_DB: mysql
然后执行unlock tables
登录从mysql，在从上执行：
stop slave;
change master to master_host='192.168.1.161',master_user='replication',master_password='123456',master_log_file='mysql-bin.000022',master_log_pos=1237;
start slave；
show slave status\G;
如果出现下面的情况，说明主从同步已经成功！
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
3.Amoeba的配置安装
1）JDK环境的安装
下载jdk1.5或者更新版本,地址 http://java.sun.com/javase/downloads/index.jsp
我用的是：jdk-6u25-linux-i586-rpm.bin
在Amoeba server上执行
chmod 755 jdk-6u25-linux-i586-rpm.bin
./ jdk-6u25-linux-i586-rpm.bin
mv jdk1.6.0_25 /usr/local/jdk
添加变量
# vim /etc/profile
启动#amoeba start (stop)
检查#ps aux | grep amoeba # netstat -lnp | grep java
添加如下内容：
export JAVA_HOME=/usr/local/jdk
export>
export PATH=$PATH:$JAVA_HOME/bin
#. /etc/profile
查看jdk #java -version
2)安装配置amoeba
# mkdir /usr/local/amoeba
# tar zxvf amoeba-mysql-binary-2.0.1-BETA.tar.gz -C /usr/local/amoeba/
主要改2个配置文件，配置文件路径 /usr/local/amoeba/conf/
amoeba.xml
[*]# vi amoeba.xml
[*]
[*]
[*]
[*]
[*]
[*]
[*] 8066
[*]
[*]
[*]
[*]
[*] ${clientConnectioneManager}
[*]
[*]
[*]
[*] 128
[*]
[*]
[*]
[*]
[*]
[*] zw
[*]
[*] 123456
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*] 30
[*]
[*]
[*] 30
[*]
[*]
[*] 500
[*]
[*]
[*] 60
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*] com.meidusa.amoeba.net.AuthingableConnectionManager
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*] ${amoeba.home}/conf/dbServers.xml
[*]
[*]
[*]
[*]
[*]
[*] ${amoeba.home}/conf/rule.xml
[*] ${amoeba.home}/conf/ruleFunctionMap.xml
[*]
[*]
[*] ${amoeba.home}/conf/functionMap.xml
[*] 1500
[*] WritePool
[*]
[*]
[*] WritePool
[*] ReadPool
[*]
[*] true
[*]
[*]
dbServer.xml
[*]# vi dbServers.xml
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*]
[*] ${defaultManager}
[*] 64
[*] 128
[*]
[*]
[*] 3306
[*]
[*]
[*] test
[*]
[*]
[*] zw
[*]
[*]
[*] 123456
[*]
[*]
[*]
[*]
[*] 500
[*] 500
[*] 10
[*] 600000
[*] 600000
[*] true
[*] true
[*]
[*]
[*]
[*]
[*]
[*]
[*] 192.168.3.161
[*]
[*]
[*]
[*]
[*]
[*] 192.168.3.162
[*]
[*]
[*]
[*]
[*]
[*]
[*] 1
[*]
[*]
[*] server1
[*]
[*]
[*]
[*]
[*]
[*]
[*] 1
[*]
[*]
[*] server2
[*]
[*]
[*]
[*]
页:
[1]