Mysql5.6 for Centos6.5原始碼編譯安裝

## 說明 不同伺服器需要改變 server_id ,同一臺機器上需要改變 port

1. 關閉防火牆
[root@mysql ~]# service iptables status --檢視防火牆狀態
[root@mysql ~]# service iptables stop --關閉防火牆
[root@mysql ~]# chkconfig iptables off --永久關閉
[root@mysql ~]# vim /etc/sysconfig/selinux
SELINUX=disabled

2. 配置sysctl.conf
生產環境下建議根據情況配置，虛擬機器安裝可以不設定

3. 檢查作業系統上是否已經安裝了mysql，如果有進行解除安裝
[root@mysql yum.repos.d]# rpm -qa |grep mysql
[root@mysql yum.repos.d]# yum remove mysql

4. 下載mysql原始碼包
https://dev.mysql.com/downloads/file/?id=469012

5. 新增使用者和組
[root@mysql u01]# userdel -r mysql --刪除原先的mysql使用者 -r會刪掉附帶的group
[root@mysql u01]# groupadd mysql
[root@mysql u01]# useradd -d /home/mysql -g mysql -m mysql
[root@mysql u01]# passwd mysql
Changing password for user mysql.
New password: 
BAD PASSWORD: it is based on a dictionary word
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@mysql u01]# id mysql
uid=500(mysql) gid=500(mysql) groups=500(mysql)

6. 配置mysql環境變數
[mysql@mysql ~]$ vim .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/u01/my3306/bin

export PATH
[mysql@mysql ~]$ source .bash_profile

7. 建立目錄及授權
[root@mysql u01]# cd /u01
[root@mysql u01]# mkdir -p /u01/my3306/data
[root@mysql u01]# mkdir -p /u01/my3306/log/iblog
[root@mysql u01]# mkdir -p /u01/my3306/log/binlog
[root@mysql u01]# mkdir -p /u01/my3306/run
[root@mysql u01]# mkdir -p /u01/my3306/tmp
[root@mysql u01]# chown -R mysql:mysql /u01/my3306
[root@mysql u01]# chmod 755 /u01/my3306

8. 解壓mysql
[root@mysql u01]# tar -xzvf mysql-5.6.36.tar.gz

9. 配置yum源，安裝cmakle及一些必備的包，要求2.6版本及以上
yum install -y cmake gcc gcc-c++ ncurses-devel bison zlib libxml openssl

10. 編譯並安裝
cmake \
-DCMAKE_INSTALL_PREFIX=/u01/my3306 \
-DINSTALL_DATADIR=/u01/my3306/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \ 
-DEXTRA_CHARSETS=all \ --
-DWITH_SSL=yes \ --安全套接字
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DSYSCONFDIR=/etc \
-DWITH_READLINE=on

[root@mysql mysql-5.6.36]# cd mysql-5.6.36
[root@mysql mysql-5.6.36]# cmake -DCMAKE_INSTALL_PREFIX=/u01/my3306 -DINSTALL_DATADIR=/u01/my3306/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=yes -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DSYSCONFDIR=/etc -DWITH_READLINE=on
[root@mysql mysql-5.6.36]# make
[root@mysql mysql-5.6.36]# make install

11. 配置mysql引數
[root@mysql my3306]# pwd
/u01/my3306
[root@mysql my3306]# cat my.cnf
[client]
port=3306
socket=/u01/my3306/mysql.sock

[mysql]
pid_file=/u01/my3306/run/mysqld.pid

[mysqld]
autocommit=1
general_log=off
explicit_defaults_for_timestamp=true

# system
basedir=/u01/my3306
datadir=/u01/my3306/data
max_allowed_packet=1g
max_connections=3000
max_user_connections=2800
open_files_limit=65535
pid_file=/u01/my3306/run/mysqld.pid
port=3306
server_id=101
skip_name_resolve=ON
socket=/u01/my3306/run/mysql.sock
tmpdir=/u01/my3306/tmp

#binlog
log_bin=/u01/my3306/log/binlog/binlog
binlog_cache_size=32768
binlog_format=row
expire_logs_days=7
log_slave_updates=ON
max_binlog_cache_size=2147483648
max_binlog_size=524288000
sync_binlog=100

#logging
log_error=/u01/my3306/log/error.log
slow_query_log_file=/u01/my3306/log/slow.log
log_queries_not_using_indexes=0
slow_query_log=1
log_slave_updates=ON
log_slow_admin_statements=1
long_query_time=1

#relay
relay_log=/u01/my3306/log/relaylog
relay_log_index=/u01/my3306/log/relay.index
relay_log_info_file=/u01/my3306/log/relay-log.info

#slave
slave_load_tmpdir=/u01/my3306/tmp
slave_skip_errors=OFF


#innodb
innodb_data_home_dir=/u01/my3306/log/iblog
innodb_log_group_home_dir=/u01/my3306/log/iblog
innodb_adaptive_flushing=ON
innodb_adaptive_hash_index=ON
innodb_autoinc_lock_mode=1
innodb_buffer_pool_instances=8

#default
innodb_change_buffering=inserts
innodb_checksums=ON
innodb_buffer_pool_size= 128M
innodb_data_file_path=ibdata1:32M;ibdata2:16M:autoextend
innodb_doublewrite=ON
innodb_file_format=Barracuda
innodb_file_per_table=ON
innodb_flush_log_at_trx_commit=1
innodb_flush_method=O_DIRECT
innodb_io_capacity=1000
innodb_lock_wait_timeout=10
innodb_log_buffer_size=67108864
innodb_log_file_size=1048576000
innodb_log_files_in_group=4
innodb_max_dirty_pages_pct=60
innodb_open_files=60000
innodb_purge_threads=1
innodb_read_io_threads=4
innodb_stats_on_metadata=OFF
innodb_support_xa=ON
innodb_use_native_aio=OFF
innodb_write_io_threads=10

[mysqld_safe]
[root@mysql my3306]# chown -R mysql:mysql /u01/my3306

12. 初始化mysql指令碼
[root@mysql my3306]# ./scripts/mysql_install_db --defaults-file=/u01/my3306/my.cnf --datadir=/u01/my3306/data --user=mysql

13. 啟動mysql
[mysql@mysql bin]$ ./mysqld_safe --defaults-file=/u01/my3306/my.cnf --user=mysql &
[1] 17237
[mysql@mysql bin]$ 170612 06:37:02 mysqld_safe Logging to '/u01/my3306/log/error.log'.
170612 06:37:02 mysqld_safe Starting mysqld daemon with databases from /u01/my3306/data

[mysql@mysql bin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.36-log Source distribution

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.10 sec)

## 說明 不同伺服器需要改變 server_id ,同一臺機器上需要改變 port

1. 關閉防火牆
[root@mysql ~]# service iptables status --檢視防火牆狀態
[root@mysql ~]# service iptables stop --關閉防火牆
[root@mysql ~]# chkconfig iptables off --永久關閉
[root@mysql ~]# vim /etc/sysconfig/selinux
SELINUX=disabled

2. 配置sysctl.conf
生產環境下建議根據情況配置，虛擬機器安裝可以不設定

3. 檢查作業系統上是否已經安裝了mysql，如果有進行解除安裝
[root@mysql yum.repos.d]# rpm -qa |grep mysql
[root@mysql yum.repos.d]# yum remove mysql

4. 下載mysql原始碼包
https://dev.mysql.com/downloads/file/?id=469012

5. 新增使用者和組
[root@mysql u01]# userdel -r mysql --刪除原先的mysql使用者 -r會刪掉附帶的group
[root@mysql u01]# groupadd mysql
[root@mysql u01]# useradd -d /home/mysql -g mysql -m mysql
[root@mysql u01]# passwd mysql
Changing password for user mysql.
New password: 
BAD PASSWORD: it is based on a dictionary word
Retype new password: 
passwd: all authentication tokens updated successfully.
[root@mysql u01]# id mysql
uid=500(mysql) gid=500(mysql) groups=500(mysql)

6. 配置mysql環境變數
[mysql@mysql ~]$ vim .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/u01/my3306/bin

export PATH
[mysql@mysql ~]$ source .bash_profile

7. 建立目錄及授權
[root@mysql u01]# cd /u01
[root@mysql u01]# mkdir -p /u01/my3306/data
[root@mysql u01]# mkdir -p /u01/my3306/log/iblog
[root@mysql u01]# mkdir -p /u01/my3306/log/binlog
[root@mysql u01]# mkdir -p /u01/my3306/run
[root@mysql u01]# mkdir -p /u01/my3306/tmp
[root@mysql u01]# chown -R mysql:mysql /u01/my3306
[root@mysql u01]# chmod 755 /u01/my3306

8. 解壓mysql
[root@mysql u01]# tar -xzvf mysql-5.6.36.tar.gz

9. 配置yum源，安裝cmakle及一些必備的包，要求2.6版本及以上
yum install -y cmake gcc gcc-c++ ncurses-devel bison zlib libxml openssl

10. 編譯並安裝
cmake \
-DCMAKE_INSTALL_PREFIX=/u01/my3306 \
-DINSTALL_DATADIR=/u01/my3306/data \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \ 
-DEXTRA_CHARSETS=all \ --
-DWITH_SSL=yes \ --安全套接字
-DWITH_EMBEDDED_SERVER=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DSYSCONFDIR=/etc \
-DWITH_READLINE=on

[root@mysql mysql-5.6.36]# cd mysql-5.6.36
[root@mysql mysql-5.6.36]# cmake -DCMAKE_INSTALL_PREFIX=/u01/my3306 -DINSTALL_DATADIR=/u01/my3306/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_SSL=yes -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/u01/my3306/run/mysql.sock -DMYSQL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DSYSCONFDIR=/etc -DWITH_READLINE=on
[root@mysql mysql-5.6.36]# make
[root@mysql mysql-5.6.36]# make install

11. 配置mysql引數
[root@mysql my3306]# pwd
/u01/my3306
[root@mysql my3306]# cat my.cnf
[client]
port=3306
socket=/u01/my3306/mysql.sock

[mysql]
pid_file=/u01/my3306/run/mysqld.pid

[mysqld]
autocommit=1
general_log=off
explicit_defaults_for_timestamp=true

# system
basedir=/u01/my3306
datadir=/u01/my3306/data
max_allowed_packet=1g
max_connections=3000
max_user_connections=2800
open_files_limit=65535
pid_file=/u01/my3306/run/mysqld.pid
port=3306
server_id=101
skip_name_resolve=ON
socket=/u01/my3306/run/mysql.sock
tmpdir=/u01/my3306/tmp

#binlog
log_bin=/u01/my3306/log/binlog/binlog
binlog_cache_size=32768
binlog_format=row
expire_logs_days=7
log_slave_updates=ON
max_binlog_cache_size=2147483648
max_binlog_size=524288000
sync_binlog=100

#logging
log_error=/u01/my3306/log/error.log
slow_query_log_file=/u01/my3306/log/slow.log
log_queries_not_using_indexes=0
slow_query_log=1
log_slave_updates=ON
log_slow_admin_statements=1
long_query_time=1

#relay
relay_log=/u01/my3306/log/relaylog
relay_log_index=/u01/my3306/log/relay.index
relay_log_info_file=/u01/my3306/log/relay-log.info

#slave
slave_load_tmpdir=/u01/my3306/tmp
slave_skip_errors=OFF


#innodb
innodb_data_home_dir=/u01/my3306/log/iblog
innodb_log_group_home_dir=/u01/my3306/log/iblog
innodb_adaptive_flushing=ON
innodb_adaptive_hash_index=ON
innodb_autoinc_lock_mode=1
innodb_buffer_pool_instances=8

#default
innodb_change_buffering=inserts
innodb_checksums=ON
innodb_buffer_pool_size= 128M
innodb_data_file_path=ibdata1:32M;ibdata2:16M:autoextend
innodb_doublewrite=ON
innodb_file_format=Barracuda
innodb_file_per_table=ON
innodb_flush_log_at_trx_commit=1
innodb_flush_method=O_DIRECT
innodb_io_capacity=1000
innodb_lock_wait_timeout=10
innodb_log_buffer_size=67108864
innodb_log_file_size=1048576000
innodb_log_files_in_group=4
innodb_max_dirty_pages_pct=60
innodb_open_files=60000
innodb_purge_threads=1
innodb_read_io_threads=4
innodb_stats_on_metadata=OFF
innodb_support_xa=ON
innodb_use_native_aio=OFF
innodb_write_io_threads=10

[mysqld_safe]
[root@mysql my3306]# chown -R mysql:mysql /u01/my3306

12. 初始化mysql指令碼
[root@mysql my3306]# ./scripts/mysql_install_db --defaults-file=/u01/my3306/my.cnf --datadir=/u01/my3306/data --user=mysql

13. 啟動mysql
[mysql@mysql bin]$ ./mysqld_safe --defaults-file=/u01/my3306/my.cnf --user=mysql &
[1] 17237
[mysql@mysql bin]$ 170612 06:37:02 mysqld_safe Logging to '/u01/my3306/log/error.log'.
170612 06:37:02 mysqld_safe Starting mysqld daemon with databases from /u01/my3306/data

[mysql@mysql bin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.36-log Source distribution

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.10 sec)