MHSQL主从复制系统服务

Amoeba服务：

ntpdate 192.168.12.1

yum -y remove java

chmod +x jdk-6u14-linux-x64.bin

./jdk-6u14-linux-x64.bin

mv jdk1.6.0_14/ /usr/local/jdk1.6

vim /etc/profile

export JAVA_HOME=/usr/local/jdk1.6
export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib:$JAVA_home/jre/lib
export PATH=$JAVA_HOME/lib:$JAVA_HOME/jre/bin:$PATH:$HOME/bin
export AMOWEBA_HOME=/usr/local/amoeba/
export PATH=$PATH:$AMOEBA_HOST/bin

source /etc/profile

java -version

mkdir /usr/local/amoeba

tar -zxf amoeba-mysql-binary-2.2.0.tar.gz -C /usr/local/amoeba

chmod -R 755 /usr/local/amoeba

/usr/local/amoeba/bin/amoeba

vim /usr/local/amoeba/conf/amoeba.xml

（注意删除注释）

vim /usr/local/amoeba/conf/dbServers.xml

/usr/local/amoeba/bin/amoeba start

MySQL主：

grant all on . to ‘lxn’@‘192.168.12.%’ identified by ‘abc123’;

mysql -u root -p abc123

MySQL客户机：

mysql -uamoeba -p123456 -h 192.168.12.6 -P 8066

create database benet;

create table benet.lxn(id char (10),user char(10));

MySQL从：

use benet;

show tables;

stop slave;

insert into benet.lxn values(‘2’,‘hhhh’);

MySQL主：

insert into benet.lxn values(‘1’,‘hhhhhhh’);

客户机：

select * from benet.lxn;

insert into benet.lxn values(‘333’,‘hhhhhhh’);

select * from benet.lxn;

MySQL主：

select * from benet.lxn;