MySQL 5.5双机热备份 master-master

一，系统环境CentOS 6.3 ,master A IP:192.168.1.28,master B ip:192.168.1.29。 二，安装cmake与mysql 1，安装cmake #tar xf c

一，系统环境CentOS 6.3 ,master A IP:192.168.1.28,master B ip:192.168.1.29。

二，安装cmake与mysql

1，安装cmake

#tar xf cmake-2.8.8.tar.gz

#cd cmake-2.8.8

# ./bootstrap

# gmake && gmake install

2，，安装mysql

#useradd -r mysql -s /sbin/nologin

#mkdir -p /data/mysql/{data,binlog,relaylog}

#chown mysql:mysql -R /data/mysql

# tar xf mysql-5.5.27.tar.gz

#cd mysql-5.5.27

#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/data/mysql/data -DWITH_DEBUG=0 -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306

#会编译不过去，提示需要安装ncurses-devel,yum -y install ncurses-devel

#rm -f CMakeCache.txe 重新执行./configure

# make && make install

#cd /usr/local/mysql

#chown -R mysql:mysql *

# cp support-files/mysql.server /etc/rc.d/init.d/mysqld

#chmod +x /etc/init.d/mysqld

#chkconfig mysqld on

# vim /etc/profile 添加PATH=$PATH:/usr/local/mysql/bin

# . /etc/profile(或者export PATH=$PATH:/usr/local/mysql/bin)

# ln -sv /usr/local/mysql/include/ /usr/include/mysql

# echo '/usr/local/mysql/lib' > /etc/ld.so.conf.d/mysql.conf 加载库文件

# ldconfig -v |grep mysql

# vim /etc/man.config 添加一行MANPATH /usr/local/mysql/man

环境已经基本Ok

# cd /usr/local/mysql

scripts/mysql_install_db --user=mysql --datadir=/data/mysql

将主服务器克隆一份，并修改IP与MAC地址，保证两台机器能够互相ping通。