yum -y install make gcc-c++ cmake bison-devel ?ncurses-devel configure.sh: cmake \-dcmake_install_prefix=/usr/local/mysql \-dmysql_datadir=/data/mysql \-dsysconfdir=/etc \-dwith_myisam_storage_engine=1 \-dwith_innobase_storage_engine=1 \-d
yum -y install make gcc-c++ cmake bison-devel ?ncurses-devel
configure.sh:
cmake \-dcmake_install_prefix=/usr/local/mysql \-dmysql_datadir=/data/mysql \-dsysconfdir=/etc \-dwith_myisam_storage_engine=1 \-dwith_innobase_storage_engine=1 \-dwith_memory_storage_engine=1 \-dwith_readline=1 \-dmysql_unix_addr=/var/lib/mysql/mysql.sock \-dmysql_tcp_port=3306 \-denabled_local_infile=1 \-dwith_partition_storage_engine=1 \-dextra_charsets=all \-ddefault_charset=utf8 \-ddefault_collation=utf8_general_ci
useradd mysql
mkdir -p /data/mysql
./mysql_install_db –basedir=/usr/local/mysql –datadir=/data/mysql/ –user=mysql
ln -s /usr/local/mysql/bin/* /usr/sbin/
主从
master：
配置：
[mysqld]
log-bin=master-bin
log-bin-index=master-bin.index
innodb_file_per_table = 1
max_connections = 3000
socket=/var/lib/mysql/mysql.sock
log-bin=
binlog-format=row
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=table
relay-log-info-repository=table
sync-master-info=1
slave-parallel-workers=2
binlog-checksum=crc32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
report-port=3306
port=3306
report-host=125.210.*.*
server_id = 1
slow-query-log-file =/data/mysql/query-slow.log
long_query_time=5
explicit_defaults_for_timestamp = true
slave:
配置：
[mysqld]
log-bin=master-bin
log-bin-index=master-bin.index
innodb_file_per_table = 1
relay-log = relay-log
relay-log-index = relay-log.index
binlog-format=row
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=table
relay-log-info-repository=table
sync-master-info=1
slave-parallel-workers=2
binlog-checksum=crc32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
report-port=3306
port=3306
report-host=125.210.136.132
server_id = 10
控制台启动同步
change master to master_host=’125.210.*.*’,master_user=’repl’,master_password=’repl_pass’,master_auto_position=1;
query ok, 0 rows affected, 2 warnings (0.15 sec)
start slave;
本文出自：http://zacharyhu.org, 原文地址：http://zacharyhu.org/?p=536, 感谢原作者分享。