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目录下,且已被废弃
2 G0 H1 a7 z7 k“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
! z/ A( \! T7 _( e8 z; }–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
+ l0 B( _2 m9 n# m/ q% I
, T/ x( d; h# @& C
- N" B- ]' _4 f- R$ V5 u8 S- F# U
Mysql5.7版本更新后有很多变化，比如json等，连安装都有变化，他安装必须要BOOST库，不过mysql的官网源码有带boost库的源码和不带boost库的源码两种，因此有两种安装方式，其实都是一样的，仅仅是不带boost库源码的需要单独安装boost，还有后续文章percona-xtrabackup需要用到boost库
1 H. G% U3 X: p  j3 o
下载软件
0 w9 N  h: x& _( Z到usr/local目录下：
7 q9 Q1 s9 x1 R
' h* M2 ~* j" s8 scd /usr/local
- x2 r2 V4 `' A! D# Fwget http://downloads.sourceforge.net ... boost_1_59_0.tar.gz
# k) ~% d7 ?. }4 C: _; d4 e- Iwget 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
5 A- H& a& ^$ f, X" M5 ]% V安装boost
注:此处如果只为安装mysql其实可以不用安装的，解压就好，到时安装mysql时引用目录，不过percona-xtrabackup需要用到，所以我安装了。
- }9 n9 s" t. y- a: K$ U1 w
tar xzf boost_1_59_0.tar.gz
cd boost_1_59_0
./bootstrap.sh
3 u; W0 g  h# v4 I1 G8 L5 L./b2 install
不带boost的mysql源码安装
1、安装依赖包

+ e9 s' n/ P/ t) B. v, ~  u) R; C' oyum -y install gcc gcc-c++ ncurses ncurses-devel cmake
2、添加禁止登陆的mysql用户

groupadd mysql
useradd -r -g mysql -s /bin/false mysql
3、编译安装
5 L$ w7 O: A2 P, L. h
从MySQL 5.7.5开始Boost库是必需的

% t5 D! p" \- l4 G) t( Q复制代码
" a$ x& n2 l, U, C: U! Hmkdir -p /data/mysql
tar xzf mysql-5.7.11.tar.gz
: [9 Y4 t. z! a8 B& M+ ~; z6 ]' acd mysql-5.7.11
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/mysql \
& x4 k1 E. _7 e+ _3 r5 D -DDOWNLOAD_BOOST=1 \
  H+ }. Y. y0 V" t -DWITH_BOOST=/usr/local/boost_1_59_0 \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
  K0 ~+ Z& {. F( X: ~/ ~ -DWITH_PARTITION_STORAGE_ENGINE=1 \
/ ?" \1 B7 [+ @ -DWITH_FEDERATED_STORAGE_ENGINE=1 \
0 L# q0 _3 R: S1 K6 x% \+ [7 r -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
$ |# l0 S% P) b, ]2 |( E -DWITH_MYISAM_STORAGE_ENGINE=1 \
: N1 D$ q7 H' }7 `' F8 T# S3 p( x -DENABLED_LOCAL_INFILE=1 \
2 ?1 c9 Z& B; K* v -DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8mb4 \
! y3 p( r: n0 y. o6 p -DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1

make
make install
- N$ R" }4 ^) Q/ m2 l; U复制代码


4、配置开机启动项

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
, s! t( Z' @0 B8 G4 ~  y' ?/ U8 [chkconfig --add mysqld
chkconfig mysqld on
5、配置/etc/my.cnf 仅供参考，可以不配，用默认的。

( z" q: u5 ?, |  ~2 n复制代码
8 M4 }* c: H  Q- Icat > /etc/my.cnf << EOF
$ i- \/ E) D* L" N3 X- \# n[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8mb4

[mysqld]
- W3 {3 x- k( r  s! \! Gport = 3306
socket = /tmp/mysql.sock

( a) v: H; }# R/ i: r8 Q" z  @basedir = /usr/local/mysql
datadir = /data/mysql
  `8 B, X4 A$ G  }- ]pid-file = /data/mysql/mysql.pid
1 T8 R4 W  L/ c5 Wuser = mysql
$ [5 `; B2 M( \bind-address = 0.0.0.0
server-id = 1
, d" E7 j0 Y4 ]8 l
/ {7 w: F  x7 iinit-connect = 'SET NAMES utf8mb4'
character-set-server = utf8mb4

9 N. m7 Q' f( J1 S#skip-name-resolve
#skip-networking
back_log = 300
: l: u" R. W) C% d; _( T
- V" _5 A, D) Q0 F" a  wmax_connections = 1000
) b; i+ d9 M2 J2 h+ Y- }% qmax_connect_errors = 6000
# z: B# [  V8 o0 I( {0 K3 z4 {open_files_limit = 65535
table_open_cache = 128
* Y( I- C& Z4 Cmax_allowed_packet = 4M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M

  |) r5 Y0 U! J0 aread_buffer_size = 2M
. O% E. a0 v9 xread_rnd_buffer_size = 8M
. v% X+ E3 @5 Q4 x) |sort_buffer_size = 8M
3 J4 P: A3 B6 E' G  Qjoin_buffer_size = 8M
. R8 C' @4 v5 r" I  H1 x. ukey_buffer_size = 4M
9 M5 }% d3 |* U) Z, K: }# v( \
  u8 D3 E+ j% Z3 I; z, [* O" nthread_cache_size = 8

query_cache_type = 1
3 W# e3 I. V) [: ]( `query_cache_size = 8M
query_cache_limit = 2M

ft_min_word_len = 4

9 s, M3 l  J1 {/ T$ Glog_bin = mysql-bin
binlog_format = mixed
) w5 O6 E# D2 Aexpire_logs_days = 30
1 q( R8 e! v" U6 I7 ^! G( P1 V
; ^3 P4 t( q' |* b. hlog_error = /data/mysql/mysql-error.log
slow_query_log = 1
- Y% j8 p* m8 d$ q8 ulong_query_time = 1
slow_query_log_file = /data/mysql/mysql-slow.log

9 K# K, t( p7 a$ w' cperformance_schema = 0
( G7 R& C$ S) A( I# G# p$ oexplicit_defaults_for_timestamp

) H; D; G- e. S#lower_case_table_names = 1

skip-external-locking

9 |4 S8 Q6 U/ }$ }0 hdefault_storage_engine = InnoDB
#default-storage-engine = MyISAM
& M, o& G5 X8 Z! L3 R& V% Ninnodb_file_per_table = 1
$ i& E; e' r9 Linnodb_open_files = 500
6 s  ~2 h2 W$ r3 Linnodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
5 j! x( @! }: L* Y, S: [innodb_thread_concurrency = 0
+ @) M  d( Y8 q# N7 `innodb_purge_threads = 1
/ R8 A" e( A. J0 z, Jinnodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
9 E4 D4 M# Z# }! ]+ O  J1 r- Pinnodb_log_file_size = 32M
: _3 h2 t  j# f( ~* l9 n! l9 t. qinnodb_log_files_in_group = 3
. G1 h9 l& m/ s: G7 Xinnodb_max_dirty_pages_pct = 90
) ^& X' n& n8 i/ |innodb_lock_wait_timeout = 120
$ N: b! Q" H7 }  o3 B7 |' d9 i
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
) P, Z* R; q+ Smyisam_repair_threads = 1

8 X; f; N+ a  }) ]interactive_timeout = 28800
wait_timeout = 28800

: k% g) l/ R2 B, P0 b[mysqldump]
, a# h6 ~$ z6 c1 n6 Tquick
8 V2 U9 F5 ~6 n+ ymax_allowed_packet = 16M
4 g4 V" ]7 o; U- s
4 \" D. l. A0 W; t( A[myisamchk]
key_buffer_size = 8M
, V, w9 o; I/ csort_buffer_size = 8M
read_buffer = 4M
1 b  @3 x1 m; h& ?0 R% nwrite_buffer = 4M
& {: M, g- u1 O. x4 CEOF
复制代码
7 O; i7 W# |  u) }, B' z6、初始化数据

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
1 m$ k; r- N4 u( R& h注： 之前版本mysql_install_db是在mysql_basedir/script下，5.7放在了mysql_install_db/bin目录下,且已被废弃
“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
- m/ W5 n& a$ a+ [. }, _–datadir目标目录下不能有数据文件

. T$ J0 h& ]# R1 H2 u7、启动数据库
% C8 j7 V& V2 y
service mysqld start

) M: O, Q, W6 a3 B9 q8 i
% K9 D1 m. `  ]  T% y/ t! ]) W带boost的mysql源码安装
1、安装依赖包

1 C) G: e/ G% p6 [yum -y install make gcc-c++ cmake bison-devel  ncurses-devel   bison perl perl-devel  perl perl-devel
2、解压到/usr/local目录下

; f" d. S- Z( I. ^" ?' Q: @2 Btar -zxvf mysql-boost-5.7.11.tar.gz -C /usr/local
3、创建mysql组和用户

) R- }0 w6 H: E& E1 R& wgroupadd mysql
& D( y3 l( ^9 G2 e2 @7 Suseradd -r -g mysql -s /bin/false mysql
! x; b  t; ]3 q, N. V( z+ g4、编译mysql

  p2 f* C- `( ?! scd /usr/local/mysql-5.7.11/
, A1 J/ e1 L1 i8 Acmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
0 g% N4 J$ a7 L* u2 W% C* dmake
make install
8 [  p& O) S% n+ A/ g. J9 x, F% x5、把原来的/etc/my.cnf备份
8 A; h( E2 ^7 l4 H# P# p
! R# A& D6 C1 @cp /etc/my.cnf /etc/my.cnf.bak
9 ^( d3 m0 ]0 k- f' A1 Jrm -f /etc/my.cnf
6、把安装目录用户和组更改为mysql

cd /usr/local/mysql
% a; R4 \6 O; _: W2 i( pchown -R mysql .
chgrp -R mysql .
7、创建一个数据目录
4 J: X8 q3 I0 q3 |- r. ~6 y9 Z/ l
mkdir -p /data/mysql/data/
4 [) H: I4 I5 b6 k) g8、初始化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是为了防止普通用户不小心删除数据库
. A) I+ a. n* _
6 P/ m0 d) V. v( A6 Ichown -R root .
chown -R mysql /data
10、拷贝配置文件
+ m" z; [9 i9 Y  ]- A" E
cp support-files//my-default.cnf /etc/my.cnf
% ?5 N& Z3 r# u7 h. A" mcp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
11、修改环境变量
+ W! }' R( A; s' y4 C7 ]
复制代码
vi /etc/profile
( k! p8 W! U  _# 在profile文件末尾增加两行
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
4 u6 h8 c( R1 v% v0 m7 j) |export PATH
4 t& v# B5 J, e* L' }5 C # 使PATH搜索路径立即生效：
source /etc/profile
8 M8 P- x  p5 @/ d# O+ J复制代码
: h7 _" T+ y3 ~2 N, ^' D# T12、修改配置文件

+ S, W" N8 [+ avi /etc/my.cnf
#修改第19行(取消注释且修改为)   datadir = /data/mysql/data/
13、启动
* i% |9 M# u; j( L& G
0 Y: d/ q+ E  T2 oservice mysql start