mysql搭建rac_新环境搭建Mysql主从

环境信息：

用途

IP

OS

Mysql

主

10.163.84.16

RHEL

6.5_X64

mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz

从

10.163.84.17

RHEL

6.5_X64

mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz

1、Mysql安装

2、主节点配置

(1)修改配置文件

[root@dbrac16 ~]# vim /etc/my.cnf

[mysqld]

datadir=/usr/local/mysql/data

socket=/usr/local/mysql/mysql.sock

user=mysql

symbolic-links=0

character-set-server=utf8

server-id = 8416

log-bin=/usr/local/mysql/data/mysql-bin

binlog_format=mixed

slow-query-log

long_query_time=3

log-output=TABLE

expire_logs_days = 7

event_scheduler=1

innodb_file_per_table=1

innodb_log_file_size=536870912

innodb_buffer_pool_size=1073741824

max_binlog_size=1073741824

log_bin_trust_function_creators=1

innodb_stats_on_metadata=0

max_connect_errors = 1000000

max_connections = 5000

skip_name_resolve = 1

explicit_defaults_for_timestamp=true

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/usr/local/mysql/my.pid

[client]

socket=/usr/local/mysql/mysql.sock

[mysql]