MySQL主从安装

安装
rpm -ivh MySQL-server-5.6.15-1.el6.x86_64.rpm
rpm -ivh MySQL-client-5.6.15-1.el6.x86_64.rpm
rpm -ivh MySQL-devel-5.6.15-1.el6.x86_64.rpm
MySQL的几个重要目录
（1）数据库目录　　 /var/lib/mysql/
（2）配置文件  　　 /usr/share/mysql（mysql.server命令及配置文件）
（3）相关命令  　　 /usr/bin(mysqladmin mysqldump等命令)
（4）启动脚本  　　 /etc/rc.d/init.d/（启动脚本文件mysql的目录）


若想查看MySQL安装到哪个目录，可使用“whereis mysql”命令查看，参考执行结果如下所示：
>whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/include/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz


启动
service mysql start  或  /etc/init.d/mysql start


主从配置master--slave
master：
my.cnf
log-bin=mysql-bin
server-id=1
binlog-do-db=biz
binlog-do-db=uc
binlog-do-db=cms
expire-logs-days=7


CREATE USER 'jsdb_w'@'%' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'jsdb_w'@'%';


复制帐号
GRANT REPLICATION SLAVE ON *.* TO 'mysqlRepl'@'%' IDENTIFIED BY '123456';




slave：
my.cnf 
relay_log=mysql-relay-bin
log_slave_updates=1

port=3306
sock=/var/lib/mysql/mysql.sock
log_bin=mysql-bin
server-id=2
binlog-do-db=biz
binlog-do-db=uc
binlog-do-db=cms
binlog-ignore-db=mysql
replicate-do-db=biz
replicate-do-db=cms
replicate-do-db=uc
replicate-ignore-db=mysql,information_schema
#log-slave-updates
sync_binlog=1
auto_increment_increment=2
auto_increment_offset=2


CREATE USER 'jsdb_r'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON *.* TO 'jsdb_r'@'%';


STOP SLAVE;
CHANGE MASTER TO MASTER_HOST='192.168.44.81',MASTER_USER='mysqlRepl',MASTER_PASSWORD='123456',MASTER_LOG_FILE='mysql-bin.000022',MASTER_LOG_POS=120;
start slave；


show slave status \G
跳过复制错误（有几个sql未同步就要跳过几个）
stop slave;
set global sql_slave_skip_counter=1;

start slave;

master mysql> FLUSH TABLES WITH READ LOCK; 阻止更新
master mysql> SHOW MASTER STATUS; 查看复制状态
slave mysql> SELECT MASTER_POS_WAIT('log_name', log_pos);
slave mysql> UNLOCK TABLES;