安装
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;
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;