CENTOS6.6下mysql5.7.11带boost和不带boost的源码安装

admin

本文来自我的github pages博客http://galengao.github.io/ 即www.gaohuirong.cn Mysql5.7版本更新后有很多变化，比如json等，连安装都有变化，他安装必须要BOOST库，不过mysql的官网源码有带boost库的源码和不带boost库的源码两种，因此有两种安装方式，其实都是一样的，仅仅是不带boost库源码的需要单独安装boost，还有后续文章percona-xtrabackup需要用到boost库下载软件到usr/local目录下：cd /usr/localwget http://downloads.sourceforge.net ... t_1_59_0.tar.gzwget http://cdn.mysql.com//Downloads/ ... t-5.7.11.tar.gzwget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11.tar.gz安装boost注:此处如果只为安装mysql其实可以不用安装的，解压就好，到时安装mysql时引用目录，不过percona-xtrabackup需要用到，所以我安装了。tar xzf boost_1_59_0.tar.gzcd boost_1_59_0./bootstrap.sh./b2 install 不带boost的mysql源码安装1、安装依赖包yum -y install gcc gcc-c++ ncurses ncurses-devel cmake2、添加禁止登陆的mysql用户groupadd mysqluseradd -r -g mysql -s /bin/false mysql3、编译安装从MySQL 5.7.5开始Boost库是必需的mkdir -p /data/mysqltar xzf mysql-5.7.11.tar.gzcd mysql-5.7.11 cmake . \ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/data/mysql \ -DDOWNLOAD_BOOST=1 \ -DWITH_BOOST=/usr/local/boost_1_59_0 \ -DSYSCONFDIR=/etc \ -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=1makemake install 4、配置开机启动项cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqldchmod +x /etc/init.d/mysqldchkconfig --add mysqldchkconfig mysqld on5、配置/etc/my.cnf 仅供参考，可以不配，用默认的。cat > /etc/my.cnf << EOF[client]port = 3306socket = /tmp/mysql.sockdefault-character-set = utf8mb4 [mysqld]port = 3306socket = /tmp/mysql.sock basedir = /usr/local/mysqldatadir = /data/mysqlpid-file = /data/mysql/mysql.piduser = mysqlbind-address = 0.0.0.0server-id = 1 init-connect = 'SET NAMES utf8mb4'character-set-server = utf8mb4 #skip-name-resolve#skip-networkingback_log = 300 max_connections = 1000max_connect_errors = 6000open_files_limit = 65535table_open_cache = 128max_allowed_packet = 4Mbinlog_cache_size = 1Mmax_heap_table_size = 8Mtmp_table_size = 16M read_buffer_size = 2Mread_rnd_buffer_size = 8Msort_buffer_size = 8Mjoin_buffer_size = 8Mkey_buffer_size = 4M thread_cache_size = 8 query_cache_type = 1query_cache_size = 8Mquery_cache_limit = 2M ft_min_word_len = 4 log_bin = mysql-binbinlog_format = mixedexpire_logs_days = 30 log_error = /data/mysql/mysql-error.logslow_query_log = 1long_query_time = 1slow_query_log_file = /data/mysql/mysql-slow.log performance_schema = 0explicit_defaults_for_timestamp #lower_case_table_names = 1 skip-external-locking default_storage_engine = InnoDB#default-storage-engine = MyISAMinnodb_file_per_table = 1innodb_open_files = 500innodb_buffer_pool_size = 64Minnodb_write_io_threads = 4innodb_read_io_threads = 4innodb_thread_concurrency = 0innodb_purge_threads = 1innodb_flush_log_at_trx_commit = 2innodb_log_buffer_size = 2Minnodb_log_file_size = 32Minnodb_log_files_in_group = 3innodb_max_dirty_pages_pct = 90innodb_lock_wait_timeout = 120 bulk_insert_buffer_size = 8Mmyisam_sort_buffer_size = 8Mmyisam_max_sort_file_size = 10Gmyisam_repair_threads = 1 interactive_timeout = 28800wait_timeout = 28800 [mysqldump]quickmax_allowed_packet = 16M [myisamchk]key_buffer_size = 8Msort_buffer_size = 8Mread_buffer = 4Mwrite_buffer = 4MEOF6、初始化数据/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql注： 之前版本mysql_install_db是在mysql_basedir/script下，5.7放在了mysql_install_db/bin目录下,且已被废弃
“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
- ]. m6 _( |3 X- g( o$ L–datadir目标目录下不能有数据文件7、启动数据库service mysqld start 带boost的mysql源码安装1、安装依赖包yum -y install make gcc-c++ cmake bison-devel  ncurses-devel   bison perl perl-devel  perl perl-devel 2、解压到/usr/local目录下tar -zxvf mysql-boost-5.7.11.tar.gz -C /usr/local3、创建mysql组和用户groupadd mysqluseradd -r -g mysql -s /bin/false mysql4、编译mysqlcd /usr/local/mysql-5.7.11/cmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boostmakemake install5、把原来的/etc/my.cnf备份cp /etc/my.cnf /etc/my.cnf.bakrm -f /etc/my.cnf6、把安装目录用户和组更改为mysqlcd /usr/local/mysqlchown -R mysql .chgrp -R mysql .7、创建一个数据目录mkdir -p /data/mysql/data/8、初始化mysql，及开启ssl新功能bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data bin/mysql_ssl_rsa_setup  --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data 9、 设为root是为了防止普通用户不小心删除数据库chown -R root .chown -R mysql /data10、拷贝配置文件cp support-files//my-default.cnf /etc/my.cnfcp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql11、修改环境变量vi /etc/profile # 在profile文件末尾增加两行 PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH export PATH  # 使PATH搜索路径立即生效：source /etc/profile12、修改配置文件vi /etc/my.cnf#修改第19行(取消注释且修改为)   datadir = /data/mysql/data/ 13、启动service mysql start

admin

本文来自我的github pages博客http://galengao.github.io/ 即www.gaohuirong.cn


3 o. S  r# r6 J5 q6 B
. e3 N$ S  _6 H, ?Mysql5.7版本更新后有很多变化，比如json等，连安装都有变化，他安装必须要BOOST库，不过mysql的官网源码有带boost库的源码和不带boost库的源码两种，因此有两种安装方式，其实都是一样的，仅仅是不带boost库源码的需要单独安装boost，还有后续文章percona-xtrabackup需要用到boost库
2 L. U. F% b) Z2 ~9 c6 e; ^3 j
下载软件
到usr/local目录下：
% z' K" l+ U& }
8 ?: B8 V6 S2 A1 ^+ |% n4 r0 Ocd /usr/local
wget http://downloads.sourceforge.net ... boost_1_59_0.tar.gz
. g6 _* j/ V3 `' h8 \wget http://cdn.mysql.com//Downloads/ ... boost-5.7.11.tar.gz
2 U0 g( ?9 ]( V8 b( h4 \0 L' wwget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11.tar.gz
/ ~0 a9 Q* p# v. S安装boost
注:此处如果只为安装mysql其实可以不用安装的，解压就好，到时安装mysql时引用目录，不过percona-xtrabackup需要用到，所以我安装了。

tar xzf boost_1_59_0.tar.gz
7 ~' ]' F0 ~( @4 a% G. C. z  ^cd boost_1_59_0
( m$ S# T! O; {% x$ _6 P3 n./bootstrap.sh
- P% p1 H! ~! R1 W3 Y/ s./b2 install
不带boost的mysql源码安装
7 U5 [; L: W7 G; q+ Z0 j1、安装依赖包
( k; d! N$ Q* P" S6 s
yum -y install gcc gcc-c++ ncurses ncurses-devel cmake
2、添加禁止登陆的mysql用户
3 W* N! E( L  Q" K7 N( `
' X6 u+ f7 d7 {groupadd mysql
+ N7 W# A/ {! j$ l& R. @& m4 @useradd -r -g mysql -s /bin/false mysql
3、编译安装

从MySQL 5.7.5开始Boost库是必需的
9 O4 I; F& l; R; Y) Z
复制代码
mkdir -p /data/mysql
. R; _8 H4 X6 m; ]' a- p1 I8 gtar xzf mysql-5.7.11.tar.gz
cd mysql-5.7.11
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/mysql \
-DDOWNLOAD_BOOST=1 \
1 K% r* W9 o, Q3 t. C& E -DWITH_BOOST=/usr/local/boost_1_59_0 \
& J& n# c5 R- P$ B, a6 j -DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
! Y& A* N4 G: R/ Q -DWITH_PARTITION_STORAGE_ENGINE=1 \
+ m4 m/ U" m9 w: r5 t+ C -DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
& C7 A6 x. \$ v' \7 | -DENABLED_LOCAL_INFILE=1 \
$ U, e% b, a1 k4 c! v6 ~1 s -DENABLE_DTRACE=0 \
( Z( G! I3 e  r7 C$ G% @/ d -DDEFAULT_CHARSET=utf8mb4 \
% x5 I. y& }, u$ G -DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1
& u2 ?. O, b$ [
make
make install
复制代码


& N! u. R9 M; V0 c. O4、配置开机启动项
6 U  _* [' W5 }4 F4 D' H  `
8 y- \* G0 t+ _& g' }. j' gcp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
1 h$ w2 F' ?" ]% _' z4 d4 dchmod +x /etc/init.d/mysqld
# a& [0 p( ~1 R7 ?$ ]chkconfig --add mysqld
chkconfig mysqld on
8 @; E& K" {2 I4 ~: h0 T) j- Q5、配置/etc/my.cnf 仅供参考，可以不配，用默认的。
6 ~2 a! l+ z! d9 O) }8 U" ~2 ~: B
0 e/ _  a2 q1 \" E3 z" r6 h, D复制代码
" H* C$ ]" f; X: S8 {; Y1 z1 i# Qcat > /etc/my.cnf << EOF
[client]
port = 3306
" z" m, D$ ]( Q( ~! Zsocket = /tmp/mysql.sock
, E4 Z) Q1 l* E: |2 Ndefault-character-set = utf8mb4

[mysqld]
- h2 @6 e0 p" h8 U+ c0 ~. E/ ]port = 3306
socket = /tmp/mysql.sock
. A1 ?: F7 _  c% |+ K' _
* b& x9 K* X( h- \* x4 Kbasedir = /usr/local/mysql
datadir = /data/mysql
pid-file = /data/mysql/mysql.pid
; T; Y( Y, V& v4 A* ]user = mysql
( j* s* C4 X" T9 m  ^bind-address = 0.0.0.0
server-id = 1
1 Y6 Y, B  Y, I8 Y+ J
! z" _6 C$ T$ K, L9 @init-connect = 'SET NAMES utf8mb4'
character-set-server = utf8mb4
+ o6 f& P: g: r  e
7 U% W& I" h5 E8 E+ [  s5 S# Z#skip-name-resolve
. x/ O9 Q, K& X' D9 V#skip-networking
0 q# N: U  V5 u* {4 K, L# ]back_log = 300
$ p' Y: L  S+ e% I# h1 U1 A% B8 p- c
max_connections = 1000
max_connect_errors = 6000
! B  i9 {* v9 y8 \1 s4 b: Topen_files_limit = 65535
6 ]8 @3 P/ c  u. ^/ V4 ntable_open_cache = 128
max_allowed_packet = 4M
binlog_cache_size = 1M
; @. o% A  Z& `" amax_heap_table_size = 8M
tmp_table_size = 16M
1 H7 q) U) P  r, w# o
read_buffer_size = 2M
$ A7 C- i+ d( v8 F" oread_rnd_buffer_size = 8M
sort_buffer_size = 8M
) [) ]& {& L8 ?join_buffer_size = 8M
key_buffer_size = 4M
5 Q8 V" A, W& r* Y
thread_cache_size = 8

* P' z; i' |! {+ J+ |. v# a+ L& rquery_cache_type = 1
- m- U1 `0 e9 h  x4 \query_cache_size = 8M
query_cache_limit = 2M
, P$ O$ T9 _0 {8 S8 J( R
* z( g) n/ |/ g( u9 Y. Uft_min_word_len = 4
/ p: [+ Y# l! p. W/ N; W! {! I; c
3 _2 \4 V, a; \9 [5 V% wlog_bin = mysql-bin
" t' k8 v8 C* N) Sbinlog_format = mixed
expire_logs_days = 30

log_error = /data/mysql/mysql-error.log
* `) v7 R# L( n; f( bslow_query_log = 1
7 ?9 O9 ]' b: j1 u1 _long_query_time = 1
slow_query_log_file = /data/mysql/mysql-slow.log
" h( w2 S- e/ O' Y7 u/ K9 W
# |% B$ Z+ J* ]- E4 `performance_schema = 0
explicit_defaults_for_timestamp

2 Q! Q) H2 _# {9 I! s( q#lower_case_table_names = 1

skip-external-locking

: t# J( \0 @4 [, w7 B: p0 }default_storage_engine = InnoDB
+ i( p5 h. Z* U; i#default-storage-engine = MyISAM
( B# ~% P* c3 R3 R0 L5 ~) [innodb_file_per_table = 1
) g/ I9 x. M. ~. Z  i/ o# x, ainnodb_open_files = 500
innodb_buffer_pool_size = 64M
8 h9 U: x+ p) w" ^innodb_write_io_threads = 4
6 n& |- Q- I4 @0 P' Pinnodb_read_io_threads = 4
innodb_thread_concurrency = 0
9 {, K6 b, I* d% Jinnodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
& p% q) B- G1 a  r  xinnodb_log_file_size = 32M
innodb_log_files_in_group = 3
* d6 S* w! ^9 w, A0 @innodb_max_dirty_pages_pct = 90
& O# O) `; f: }& o4 |innodb_lock_wait_timeout = 120
- ~+ t4 t# w6 `" R
% K4 ^5 k& Y& R. h5 w; Qbulk_insert_buffer_size = 8M
6 _, z; t/ v( z9 p* B# dmyisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
( c& J) p) W2 I* ~5 j/ U7 _, C
interactive_timeout = 28800
" k0 j/ L% c+ W- q" _5 w% Jwait_timeout = 28800
; [; `7 G4 d8 c8 A+ C1 _! k3 J7 E
' w9 d+ r9 ^5 s5 B[mysqldump]
quick
max_allowed_packet = 16M

: f6 ^/ N0 V: x0 Z, B/ R5 a* W$ B6 Z& F[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
0 }! p( E! C0 {4 u. t* ~% Vread_buffer = 4M
8 J% q2 N5 ^7 p. M; m% Qwrite_buffer = 4M
5 m* h, H9 j, |) ^! Y( WEOF
- J$ d9 b" \8 q4 h! ]2 k3 Q" b  j复制代码
6、初始化数据

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
6 h5 M' L% i: V* e6 k4 f0 Y1 s注： 之前版本mysql_install_db是在mysql_basedir/script下，5.7放在了mysql_install_db/bin目录下,且已被废弃
“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
–datadir目标目录下不能有数据文件
- @( ]1 F) [0 F1 }# ?4 a: e% r$ O
# w6 Z. l" m" Z# Q7、启动数据库

" |* S. B$ G1 `6 Yservice mysqld start

* }, t+ Y6 ~; q0 r% @& \
7 ]7 i6 S0 N: A/ f9 l带boost的mysql源码安装
1、安装依赖包
+ G# |6 {5 T/ t  c% C& C0 S
yum -y install make gcc-c++ cmake bison-devel  ncurses-devel   bison perl perl-devel  perl perl-devel
6 ]+ e( O* _' B. k0 m! b; }7 @2、解压到/usr/local目录下
" R2 x8 y, T& d% S1 E
tar -zxvf mysql-boost-5.7.11.tar.gz -C /usr/local
$ N0 B& H. ~7 K0 T* [3、创建mysql组和用户

; s8 K+ ]) G5 V- D( N& w& rgroupadd mysql
useradd -r -g mysql -s /bin/false mysql
4、编译mysql
9 H0 v* x" ]0 |
- P& _- n+ @* ^, z! E' _9 Acd /usr/local/mysql-5.7.11/
& g& F5 z! y( ]4 Dcmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
7 k8 A% ]! j* Emake
# d8 ^4 _0 _2 {; Wmake install
5、把原来的/etc/my.cnf备份

cp /etc/my.cnf /etc/my.cnf.bak
rm -f /etc/my.cnf
6、把安装目录用户和组更改为mysql

cd /usr/local/mysql
# X; W# X2 E1 E6 L% Echown -R mysql .
chgrp -R mysql .
2 _) ?+ |& z  b9 F7、创建一个数据目录

mkdir -p /data/mysql/data/
( @' l, P( V# @8 ?8、初始化mysql，及开启ssl新功能
' q. n, F" T  A
bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
bin/mysql_ssl_rsa_setup  --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
6 i1 {5 Y  T4 g  y8 o! E  d9、 设为root是为了防止普通用户不小心删除数据库

2 j3 [4 t( U4 [2 y- j8 Fchown -R root .
. f) E4 z  Q7 S2 \- C6 M5 Schown -R mysql /data
6 r7 ?: J8 B1 N6 `1 }" C. r0 H7 h10、拷贝配置文件
8 O; S2 c& b& N+ s8 ?$ R/ g
cp support-files//my-default.cnf /etc/my.cnf
9 T3 E0 A, K& F! [( Y0 s9 v( p; f: Pcp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
11、修改环境变量

复制代码
vi /etc/profile
# 在profile文件末尾增加两行
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
export PATH
# 使PATH搜索路径立即生效：
source /etc/profile
复制代码
12、修改配置文件

1 x+ q+ V$ V$ A% u# [" s; nvi /etc/my.cnf
4 ^1 o% J8 ^0 B0 r/ p3 y2 ~7 k#修改第19行(取消注释且修改为)   datadir = /data/mysql/data/
13、启动
+ C( P* p8 @- M
service mysql start