cdh mysql高可用

1.将主节点的mysql 和数据拷贝到从节点,并配置主节点

[mysqld]
basedir=/var/lib/mysql
datadir=/data/mysql/data
socket=/var/lib/mysql/mysql.sock
user=mysql
character_set_server=utf8
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# [主主同步]
# id
server-id=1
# MySQL的日志文件的名字
log-bin=mysql_master
# 作为从库时,更新操作是否写入日志 on:写入
log-slave-updates=on
auto-increment-increment=2
auto-increment-offset=1
# 忽略系统库
replicate-ignore-db=information_schema
replicate-ignore-db=mysql
replicate-ignore-db=performance_schema
replicate-ignore-db=sys
# 使用通配符忽略MySQL系统库的表  这样在create user时也不会进行同步了
replicate_wild_ignore_table=information_schema.%
replicate_wild_ignore_table=mysql.%
replicate_wild_ignore_table=performance_schema.%
replicate_wild_ignore_table=sys.%
# MySQL系统库的日志不计入binlog 这样更加保险了
binlog-ignore-db=information_schema
binlog-ignore-db=mysql
binlog-ignore-db=performance_schema
binlog-ignore-db=sys

binlog_format=MIXED


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

2.配置从节点

[mysqld]
basedir=/var/lib/mysql
datadir=/data/mysql/data
socket=/var/lib/mysql/mysql.sock
user=mysql
character_set_server=utf8
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# [主主同步]
# id
server-id=2
# MySQL的日志文件的名字
log-bin=mysql_slave
# 作为从库时,更新操作是否写入日志 on:写入
log-slave-updates=on
auto-increment-increment=2
auto-increment-offset=2
# 忽略系统库
replicate-ignore-db=information_schema
replicate-ignore-db=mysql
replicate-ignore-db=performance_schema
replicate-ignore-db=sys
# 使用通配符忽略MySQL系统库的表  这样在create user时也不会进行同步了
replicate_wild_ignore_table=information_schema.%
replicate_wild_ignore_table=mysql.%
replicate_wild_ignore_table=performance_schema.%
replicate_wild_ignore_table=sys.%
# MySQL系统库的日志不计入binlog 这样更加保险了
binlog-ignore-db=information_schema
binlog-ignore-db=mysql
binlog-ignore-db=performance_schema
binlog-ignore-db=sys

binlog_format=MIXED

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

3.关闭两台机器上的mysql,

scp拷贝数据从主导从节点

进入mysql数据目录

scp -r * m-cdh5-node4:$PWD

去从节点修改刚刚拷贝过来的文件数据权限

chown -R mysql:mysql *

修改auto.cnf

更改uuid和主节点不一样

4.启动从节点mysql

service mysql start

5.在从节点配置主节点参数

进入从节点mysql

change master to master_host='m-cdh5-node5',master_user='root',master_password='root',master_log_file='mysql_master.000001',master_log_pos=0;

 查看信息是否有报错:

show slave status\G

 启动同步

START SLAVE;

再次查看状态: 

show slave status\G

 

主要观察这两个参数

 

6.启动主节点mysql

service mysql start

进入mysql

配置复制源
change master to master_host='m-cdh5-node4',master_user='root',master_password='root',master_log_file='mysql_slave.000001',master_log_pos=0;


启动
start slave;

查看状态
show slave status\G

7.创建个表测试一下.