yum -y install gcc gcc-c++ ncurses ncurses-devel cmake

cd /data/
#wget http://downloads.sourceforge.NET/project/boost/boost/1.59.0/boost_1_59_0.tar.gz
#wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.16.tar.gz
wget -N http://36.110.160.219:/software/mysql/mysql-5.7.16.tar.gz
wget -N http://36.110.160.219:/software/mysql/boost_1_59_0.tar.gz

useradd -M -s /sbin/nologin mysql
groupadd mysql
useradd -r -g mysql mysql

tar xzf boost_1_59_0.tar.gz
tar xzf mysql-5.7.16.tar.gz

mkdir -p /data/db/mysql/

cd /data/mysql-5.7.16
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/db/mysql \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=../boost_1_59_0 \
-DSYSCONFDIR=/usr/local/mysql \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1

make -j `grep processor /proc/cpuinfo | wc -l`
make install

/bin/cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

#cd /usr/local/mysql && rm -f my.cnf && wget -N http://211.103.207.119:81/mysql/5.7.16/my.cnf 
cd /usr/local/mysql && rm -f my.cnf &&  wget -N http://36.110.160.219/config/mysql/my.cnf 

mkdir /var/log/mariadb
chown mysql:mysql -R /var/log/mariadb


chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
ln -sf /usr/local/mysql/bin/* /usr/bin/

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/db/mysql

service mysqld start
mysqladmin -uroot password '!qazxdr%2013'
/usr/local/mysql/bin/mysql_upgrade -uroot -p'!qazxdr%2013'



#Master-Master 
#db1: 
#  /usr/local/mysql/my.cnf 
#server-id               = 100
#log_bin                 = mysql-bin
#log-slave-updates
#auto_increment_offset    = 1 
#auto_increment_increment = 2

#db2: 
#  /usr/local/mysql/my.cnf
#server-id               = 200 
#log_bin                 = mysql-bin
#log-slave-updates
#auto_increment_offset    = 2 
#auto_increment_increment = 2

#GRANT REPLICATION SLAVE ON *.* TO 'm2m'@'10.70.62.%' IDENTIFIED BY 'iseeyoo130716';

#change master to master_host='10.168.20.131',
#master_port=3306,
#master_user='m2m',
#master_password='iseeyoo130716';