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目录下,且已被废弃
! a6 U. b( R  Q5 x7 m“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
7 W% J3 X, |5 _. F–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

1 m. U; b( t- q0 Y; T

9 W4 c7 \) T3 _/ b9 v3 Z$ g$ `) o) ~; YMysql5.7版本更新后有很多变化，比如json等，连安装都有变化，他安装必须要BOOST库，不过mysql的官网源码有带boost库的源码和不带boost库的源码两种，因此有两种安装方式，其实都是一样的，仅仅是不带boost库源码的需要单独安装boost，还有后续文章percona-xtrabackup需要用到boost库
. I3 Q& k! l8 H# X) J& H# e5 }. b
下载软件
: l1 P& D" h3 X# a到usr/local目录下：

+ ?& I+ P" }2 l& V7 _cd /usr/local
# G! J; Y. R: a% l: Hwget http://downloads.sourceforge.net ... boost_1_59_0.tar.gz
5 p: N. [1 o. B3 p, ^8 owget http://cdn.mysql.com//Downloads/ ... boost-5.7.11.tar.gz
wget http://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.11.tar.gz
( _2 F, Y8 |  ^$ z! `5 l6 Z5 ]) b$ ]安装boost
注:此处如果只为安装mysql其实可以不用安装的，解压就好，到时安装mysql时引用目录，不过percona-xtrabackup需要用到，所以我安装了。
( o( ~  ?1 R- G: B" X4 }/ S
" `5 |" U% r6 `- {: f* P. V! Z9 Ntar xzf boost_1_59_0.tar.gz
cd boost_1_59_0
./bootstrap.sh
./b2 install
6 U9 s& P8 }* u& K$ ?* |* S* @9 S7 G3 R不带boost的mysql源码安装
5 ~! B. |) g, m. A, j+ p1、安装依赖包
" \) \9 F$ @2 k. {- _
' w1 H' S- V6 o5 Q! R/ A$ ]. j1 U) \1 qyum -y install gcc gcc-c++ ncurses ncurses-devel cmake
2、添加禁止登陆的mysql用户
- f; ]5 x7 \. P9 h) w7 [
groupadd mysql
8 I: C  c/ a) I3 ]' quseradd -r -g mysql -s /bin/false mysql
3、编译安装
$ c, G9 \" G# |; f3 N3 d
5 i, a& s- ?: L( D; o从MySQL 5.7.5开始Boost库是必需的
- @% ^, \) ~2 C
复制代码
mkdir -p /data/mysql
tar xzf mysql-5.7.11.tar.gz
cd mysql-5.7.11
' F- O( U( l: r5 K2 _/ H cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
6 F! G" b  l3 Y8 s -DMYSQL_DATADIR=/data/mysql \
) B7 U& m: d! `  A- h% O' A' Z8 M -DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/boost_1_59_0 \
; j; M; R. }: _- Z -DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
$ I) J& a6 a8 A -DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
% O! `. Q/ o: z1 ?+ U7 G$ ^ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8mb4 \
4 U0 T" i1 ]# i% f  v -DDEFAULT_COLLATION=utf8mb4_general_ci \
9 p' {2 \' Y5 j6 Z2 u: m6 ?5 I -DWITH_EMBEDDED_SERVER=1
' ^# I3 F) C( C+ W* A: \
make
+ V% F( x/ c5 w" \' M* dmake install
7 U, H$ P1 q8 \+ @# Z7 b复制代码

! n" p# Y7 J* c' O0 Q2 L
4、配置开机启动项

% Y  V% b" A! y* Xcp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
8 }+ A, Z/ g7 `chkconfig --add mysqld
chkconfig mysqld on
+ f6 h9 q! w5 C: r4 {1 K. t5、配置/etc/my.cnf 仅供参考，可以不配，用默认的。
9 E5 s* N1 X' R( r7 R5 }! s6 X% x, Y
$ K. }% S) M' a! J, K( Z复制代码
cat > /etc/my.cnf << EOF
. x5 n9 I" {# Y% T  c* E[client]
port = 3306
5 b& P; A- V6 Y+ p# Fsocket = /tmp/mysql.sock
: o( \4 s5 E. O6 Y9 Ddefault-character-set = utf8mb4

0 c+ G+ L+ h  P5 ^[mysqld]
7 v6 {  C9 R& X4 r; v$ M. ~, C/ eport = 3306
( M9 M7 g! V4 i; n( K2 A, Ssocket = /tmp/mysql.sock
( Q# I! s" M0 f
basedir = /usr/local/mysql
+ z8 I6 P+ }, F" vdatadir = /data/mysql
pid-file = /data/mysql/mysql.pid
user = mysql
/ u+ A1 u, ]( \1 ^bind-address = 0.0.0.0
server-id = 1
- A5 `8 R5 Y' w% Z
5 r2 b  l0 n- l0 ainit-connect = 'SET NAMES utf8mb4'
character-set-server = utf8mb4

#skip-name-resolve
#skip-networking
back_log = 300
6 l( _5 N% _" d$ B8 `) G, U
7 @# Q# {9 x/ _$ r3 i9 }max_connections = 1000
! u# k; ?8 g4 y; {* Omax_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
* B! {8 y5 E3 u! P3 {max_allowed_packet = 4M
$ ]0 _- I4 _5 dbinlog_cache_size = 1M
+ X+ s6 o6 f% g5 N6 n# }9 c! Q* a$ dmax_heap_table_size = 8M
tmp_table_size = 16M

read_buffer_size = 2M
( t# h6 _4 z1 Tread_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
1 R" d$ m* M: ?3 M8 Bkey_buffer_size = 4M
- {$ _) Y" F# O
thread_cache_size = 8

; f& K- ^1 R1 _/ Z# Gquery_cache_type = 1
query_cache_size = 8M
' n2 R. N% X' q% r5 J! H/ gquery_cache_limit = 2M

7 v- y0 Q3 {3 e' e2 wft_min_word_len = 4
/ U- u. X' k- y1 ]: _, [
log_bin = mysql-bin
% }' L1 D. E6 N: f) `" abinlog_format = mixed
expire_logs_days = 30

. T: u8 z7 |; p! V7 Vlog_error = /data/mysql/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/mysql-slow.log

: I7 O4 d4 I+ r5 zperformance_schema = 0
explicit_defaults_for_timestamp
7 w) U' D" ^) `7 ]6 k
  Y2 c4 ]' v$ l* g% P#lower_case_table_names = 1

7 \/ b6 h/ b5 _8 ^' X& Fskip-external-locking

' y+ n# }, J$ n6 V" Ndefault_storage_engine = InnoDB
, o! h4 T7 x8 }2 N0 A$ C+ v( e* z#default-storage-engine = MyISAM
8 I8 C* |; V( m* t6 ~& U- }: Ainnodb_file_per_table = 1
, I  W3 H/ i: L0 `1 n6 ^innodb_open_files = 500
8 D( c" {: q3 Ginnodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
3 l6 u* ?, V1 B: ]innodb_read_io_threads = 4
innodb_thread_concurrency = 0
. O  m$ o$ j- ]7 ^( ]innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
; r- h  N/ r( R( Z, ^innodb_lock_wait_timeout = 120
. y8 i) h* |+ E) D. A3 q. Q  C. T
4 o7 T6 R( n. K8 F  A# }bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
. G( c. Q: w6 ^- cmyisam_repair_threads = 1

# S$ t6 D( F1 D, Y+ L2 kinteractive_timeout = 28800
wait_timeout = 28800

1 F$ d: X3 }* r[mysqldump]
quick
, P& M# i7 A- B0 i* Z% jmax_allowed_packet = 16M
+ L* g5 n* x! p, Y; @/ Z
8 d4 ?4 a9 l! P; j* h[myisamchk]
* }7 h& R! O1 l: p/ Jkey_buffer_size = 8M
5 P  y) n; Y/ Y. E# O% C  z  z3 wsort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M
$ v! o* S2 T# _9 h- `: IEOF
, i1 t& c' C* E, Z# @6 h! ^复制代码
, B3 e; J' K5 w: p$ ^, |6、初始化数据

: o- }. B( B0 P4 f) d1 [/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目录下,且已被废弃
+ v1 d1 c! w0 z9 p“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
–datadir目标目录下不能有数据文件

! W  l. ~- R9 S( X' H' I4 F7、启动数据库

8 f, v' M3 X$ o  j1 b3 K: q! bservice mysqld start
: x  i5 ~( m! H! V

带boost的mysql源码安装
3 \% ?6 [8 L+ K: I3 l, o# Z. A4 e; t1、安装依赖包
* X8 M/ B3 J, s# g4 j5 i0 K
1 N1 h* H6 S: ]$ i. q) Vyum -y install make gcc-c++ cmake bison-devel  ncurses-devel   bison perl perl-devel  perl perl-devel
2、解压到/usr/local目录下

4 V4 n  u% X/ i2 D! Z0 atar -zxvf mysql-boost-5.7.11.tar.gz -C /usr/local
0 H. m- r7 x, M3、创建mysql组和用户
/ n) a7 u) K9 F$ C" d
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
4、编译mysql

cd /usr/local/mysql-5.7.11/
, O( A8 S3 ^# c- Acmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
make
make install
( [3 S* c0 Z; B# L0 y5、把原来的/etc/my.cnf备份
# e1 _/ `$ r: d1 ]9 n1 [: X+ M5 x
cp /etc/my.cnf /etc/my.cnf.bak
( A7 ~+ {$ |: d: ^6 Drm -f /etc/my.cnf
3 @( }4 q5 i; T7 U% H" m6 X6、把安装目录用户和组更改为mysql

" X0 f+ l7 }. U2 H8 `! Ccd /usr/local/mysql
chown -R mysql .
* }8 p) a1 K( ?) P) ?- R% }chgrp -R mysql .
9 W9 ]1 _' `' d' |" z% M8 h7、创建一个数据目录

" C: L7 N$ C% q. o* amkdir -p /data/mysql/data/
3 t" d- i$ ]2 H6 A: Y3 x" V8、初始化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是为了防止普通用户不小心删除数据库

; ?% v7 I: x. s' i: k0 f4 x+ c3 b; fchown -R root .
( X1 s3 i; ?1 y1 Pchown -R mysql /data
# K* j' b7 k* i% q10、拷贝配置文件
5 ~+ U0 j2 m9 x' e
9 i1 ?% O, d" \, `! z. H2 Kcp support-files//my-default.cnf /etc/my.cnf
# P7 R: u8 p: t& e3 U7 {! Ccp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
9 d2 k. U- K: \9 j0 `0 ?( i+ K$ h11、修改环境变量

( `8 L$ i) d4 F复制代码
vi /etc/profile
# 在profile文件末尾增加两行
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
export PATH
# 使PATH搜索路径立即生效：
source /etc/profile
( O" z7 A2 ], m1 D' B) P复制代码
12、修改配置文件
+ W. g$ d7 C, r  @
+ c. W2 Q4 y! e, [vi /etc/my.cnf
#修改第19行(取消注释且修改为)   datadir = /data/mysql/data/
# K" k# D& O) E# G) h13、启动
/ u: K" x7 v. ^6 Z; k/ k" A9 b, N7 {
  s$ m6 I8 A$ @- E+ a: C( K1 @service mysql start