mysql主从同步

#yum install gcc gcc-c++ ncurses-devel bison -y

#tar -zxf cmake-2.8.4.tar.gz

#./configure

#gmake

#make install

#tar -zxf mysql-5.5.14.tar.gz

#cmake ./

#make

#make install

# useradd mysql -s /sbin/nologin
#mkdir -pv /data/mysql/data
#mkdir /data/mysql/binlog
#chown mysql.mysql /usr/local/mysql -R
#chown mysql.mysql /data/mysql/ -R


#cp mysql.server /etc/init.d/mysqld
#chmod +x /etc/init.d/mysqld
#cp my-medium.cnf /etc/my.cnf
#vim /etc/my.cnf 

basedir=/usr/local/mysql
datadir=/data/mysql/data
log-error=/data/mysql/error.log
pid-file=/data/mysql/mysql.pid
skip-name-resolve

slow_query_log = ON
long_query_time = 2
slow_query_log_file = /data/mysql/slow.log


log-bin=/data/mysql/binlog/mysql-binlog
binlog_format=mixed



#cd /usr/local/mysql/scripts/
#./mysql_install_db --user=mysql --datadir=/data/mysql/data/ --basedir=/usr/local/mysql/
#/etc/init.d/mysqld restart


#echo 'export PATH=$PATH:/usr/local/mysql/bin' >> /etc/profile
#echo "/etc/init.d/mysqld start" >> /etc/rc.local





主库
#vim /etc/my.cnf

server-id = 1
binlog-do-db = db1
binlog-do-db = db2

binlog-do-db = db3

mysql>grant replication slave on *.* to 'fbi'@'10.10.9.%' identified by 'fbi!#)!';


从库
#vim /etc/my.cnf

server-id = 2

skip-slave-start 

replicate-wild-ignore-table=mysql.%
replicate-wild-ignore-table=test.%
replicate-wild-ignore-table=information_schema.%

mysql>change master to MASTER_HOST='58.83.166.186',MASTER_PORT=9005,MASTER_USER='fbi', MASTER_PASSWORD='fbi!#)!',MASTER_LOG_FILE='mysql-binlog.000004', MASTER_LOG_POS=107;

mysql>slave start;

mysql> show slave status\G;