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 E) f7 l7 J/ d5 E8 j“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
+ `2 B9 x) O/ y+ c5 r/ F1 }& x; ]–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
- X; s- O- x! u2 K; ]
( R! m! S, A1 Q

% b7 a2 x2 L& v4 a6 G: HMysql5.7版本更新后有很多变化，比如json等，连安装都有变化，他安装必须要BOOST库，不过mysql的官网源码有带boost库的源码和不带boost库的源码两种，因此有两种安装方式，其实都是一样的，仅仅是不带boost库源码的需要单独安装boost，还有后续文章percona-xtrabackup需要用到boost库
" p- R3 X& ~; @) v6 m: l: [
下载软件
到usr/local目录下：

cd /usr/local
wget http://downloads.sourceforge.net ... boost_1_59_0.tar.gz
wget http://cdn.mysql.com//Downloads/ ... boost-5.7.11.tar.gz
: s; @4 \! k, r7 o* C3 M( b0 o7 N  `wget 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.gz
cd boost_1_59_0
./bootstrap.sh
2 @" u( @7 {6 z./b2 install
不带boost的mysql源码安装
1、安装依赖包
9 `! b: |" i+ s, p; v3 u
yum -y install gcc gcc-c++ ncurses ncurses-devel cmake
2、添加禁止登陆的mysql用户
0 F; u2 Y( c4 U
groupadd mysql
useradd -r -g mysql -s /bin/false mysql
# u& R8 q  c2 t3 T3、编译安装

: w) _2 W! c  j0 ?# [9 T! g4 H从MySQL 5.7.5开始Boost库是必需的
( c7 j4 x& T/ \. f* d6 D( Q
' o. _* u8 }( {复制代码
8 m7 ]- A  c/ p2 O7 S1 S2 \mkdir -p /data/mysql
+ g9 U/ o( q) Q, L# D7 vtar xzf mysql-5.7.11.tar.gz
: J2 E, j3 {3 b  ccd mysql-5.7.11
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/data/mysql \
-DDOWNLOAD_BOOST=1 \
1 y/ ?% |* j8 N3 R. h( X -DWITH_BOOST=/usr/local/boost_1_59_0 \
8 v# }6 v& e2 Y  V' Q; ?: A- O$ P -DSYSCONFDIR=/etc \
4 {# A. g% O7 B+ C5 Y! q -DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
) P/ C# n$ Y( e: P- F -DWITH_FEDERATED_STORAGE_ENGINE=1 \
) r' B: Q2 U. }4 f& c( \7 { -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
! H2 n( R) @% r- G$ D8 V -DWITH_MYISAM_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
, K( T4 u* d+ X! b: G -DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1

) q+ u  j# v1 u4 v/ H/ r9 Emake
make install
复制代码
( ?3 s2 W$ i1 U7 k% W9 P( d/ P

. s4 C0 B6 i+ w- a& V5 {4、配置开机启动项

& M, Y- Y6 Y) _% x/ \& w% f- Icp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
5、配置/etc/my.cnf 仅供参考，可以不配，用默认的。

2 }, K2 i3 A# ?复制代码
: ?$ W7 [" y+ E* Ocat > /etc/my.cnf << EOF
! \9 S7 `# P' z[client]
port = 3306
/ C& j, ?  c. Jsocket = /tmp/mysql.sock
) B: a& ~9 j& [  Z- q; H/ _8 mdefault-character-set = utf8mb4
$ O/ U4 d/ F9 I
4 S6 p! X' e+ g) |0 u[mysqld]
port = 3306
socket = /tmp/mysql.sock
, d2 p( g3 n- j' w6 e
basedir = /usr/local/mysql
datadir = /data/mysql
: F5 W9 F: O, k8 d. @0 I6 dpid-file = /data/mysql/mysql.pid
user = mysql
# }3 K9 P! u* u' G/ F$ V; V# T0 D, d! p' wbind-address = 0.0.0.0
server-id = 1

init-connect = 'SET NAMES utf8mb4'
) i* i# `! a/ f( vcharacter-set-server = utf8mb4

#skip-name-resolve
#skip-networking
back_log = 300

max_connections = 1000
9 W7 T5 r5 A$ w! ^7 h$ l' N( p* t7 Umax_connect_errors = 6000
open_files_limit = 65535
; I  a! Z: j# x9 W8 Btable_open_cache = 128
max_allowed_packet = 4M
binlog_cache_size = 1M
7 W4 }! y( Q( [' t' E) D& fmax_heap_table_size = 8M
tmp_table_size = 16M
0 _6 }( b0 P. z4 b
# O: d+ \* M! d% o2 Lread_buffer_size = 2M
: S" P4 Q% Y( a. o9 fread_rnd_buffer_size = 8M
, J7 Q/ l) F* b7 X1 n8 ksort_buffer_size = 8M
+ }/ T0 w' N  r: e! mjoin_buffer_size = 8M
2 x  q  K4 K/ _$ n4 y/ ?0 ~) Z2 bkey_buffer_size = 4M

thread_cache_size = 8

query_cache_type = 1
query_cache_size = 8M
2 S, I9 R. z$ g7 y  bquery_cache_limit = 2M

3 ]4 }3 M' k% ~ft_min_word_len = 4

8 d! n  o5 u, B4 j5 H, B2 blog_bin = mysql-bin
; \/ Y. D/ l; ~binlog_format = mixed
' u0 ]0 \( B8 E. N% ]expire_logs_days = 30

log_error = /data/mysql/mysql-error.log
; X9 a0 {- ^4 j+ d+ K/ p( yslow_query_log = 1
long_query_time = 1
1 O7 L, k8 A! g9 b( N* \6 Aslow_query_log_file = /data/mysql/mysql-slow.log
3 e0 Z1 p: C, w) g; c  _' q; G
5 R0 e1 P$ n6 R+ Gperformance_schema = 0
& q' g5 h2 N. Z8 f7 _explicit_defaults_for_timestamp

( G% ]: W: Z  c5 W#lower_case_table_names = 1
. `, s; \% x' S1 W/ L, }
skip-external-locking

default_storage_engine = InnoDB
#default-storage-engine = MyISAM
innodb_file_per_table = 1
innodb_open_files = 500
. }+ m' S7 H9 A1 g+ A' C. |innodb_buffer_pool_size = 64M
$ b& t3 _# G/ O$ Rinnodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 0
+ g  \5 \; N/ b  _- \innodb_purge_threads = 1
, M' u& a" E9 j) ^. \* K" j" J8 oinnodb_flush_log_at_trx_commit = 2
+ x' |" |6 r. {/ Ninnodb_log_buffer_size = 2M
; T' r: o# D+ ^) H9 L  Minnodb_log_file_size = 32M
1 Q- _- \! R1 W+ P! N3 [innodb_log_files_in_group = 3
9 J8 a! d( v- J% b2 o; t$ jinnodb_max_dirty_pages_pct = 90
/ s8 X0 X4 I4 W6 o* Winnodb_lock_wait_timeout = 120
% D$ X( b% N) j! J
bulk_insert_buffer_size = 8M
6 U7 x  C7 _) z$ mmyisam_sort_buffer_size = 8M
& m+ d+ c3 r/ k* n* \myisam_max_sort_file_size = 10G
0 |* }  ^  p9 Gmyisam_repair_threads = 1
4 w# o; G/ `6 _% q3 u
" i1 H8 [7 I, o$ L1 dinteractive_timeout = 28800
wait_timeout = 28800
3 L8 Z1 \" h& V. ^" T/ v3 f( y
[mysqldump]
8 Z3 B  J# w' D/ R1 Lquick
+ u/ Z% Z) B: ^8 a( L' X' ?- Gmax_allowed_packet = 16M

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
! T, Q$ W  }& I# P) e( |read_buffer = 4M
1 e. I% ]1 \5 Q8 b% }write_buffer = 4M
2 u) y! ^" O9 X( bEOF
& p" W% K, f0 }% s! q; l/ E复制代码
8 L: h/ F5 H! R! W: y6、初始化数据
8 C  F( ^1 P* l9 }* s
+ Q. J+ M# L) U/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目录下,且已被废弃
4 e$ I) o% |, W6 k- H5 u6 _“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
–datadir目标目录下不能有数据文件

1 Y4 K* p& c! A1 Q7 q7、启动数据库

- e" B( {' _; Bservice mysqld start


& f6 u  G( G+ }! V0 u: ~带boost的mysql源码安装
: L. A6 t* V/ W1、安装依赖包

- P7 Q8 _$ S7 p8 y# oyum -y install make gcc-c++ cmake bison-devel  ncurses-devel   bison perl perl-devel  perl perl-devel
! k/ f) Q, y, |1 ]" H% B2、解压到/usr/local目录下
* Z7 r$ h4 x$ e9 f7 V/ L7 W
tar -zxvf mysql-boost-5.7.11.tar.gz -C /usr/local
! `1 a8 d8 `+ X$ z' `3、创建mysql组和用户

groupadd mysql
useradd -r -g mysql -s /bin/false mysql
4、编译mysql
& @: h7 u$ S8 ~6 E3 b# d6 a8 ?! A
cd /usr/local/mysql-5.7.11/
2 H- V+ Y2 E  k3 x5 d) ^cmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
make
make install
5、把原来的/etc/my.cnf备份
1 [/ F" g7 e) a# d# ?
$ |7 G6 w* U0 Q& U/ C5 gcp /etc/my.cnf /etc/my.cnf.bak
rm -f /etc/my.cnf
6、把安装目录用户和组更改为mysql
3 d8 D0 U; z) J$ u. h0 {
, A4 a% G' A- C/ k' Jcd /usr/local/mysql
. G" q- x( J+ W* ?8 ?" ]1 F, s6 Mchown -R mysql .
2 t; `" R* }  N+ Bchgrp -R mysql .
7、创建一个数据目录
$ d# M8 ?% R% I
/ G9 q  N% q! Umkdir -p /data/mysql/data/
8、初始化mysql，及开启ssl新功能

bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
/ z1 l/ e( n1 d/ n  R( K( y: obin/mysql_ssl_rsa_setup  --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
/ n1 h2 B0 T* @$ W9、 设为root是为了防止普通用户不小心删除数据库

chown -R root .
, Q. O( ?; A9 U- Achown -R mysql /data
; {4 Q; P4 M% X/ d10、拷贝配置文件
0 y& ]8 }0 @. D- D& o/ g+ B6 N
+ ^! z4 f- i) W& c( {& j& wcp support-files//my-default.cnf /etc/my.cnf
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
11、修改环境变量
) s  c! I  k0 \9 r) K% {
复制代码
( G: i" F# d! fvi /etc/profile
# 在profile文件末尾增加两行
  [) J" b2 P( b! z# YPATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
export PATH
& q; _6 X/ H% ~& _& E* Q3 B" c: c # 使PATH搜索路径立即生效：
. p4 ?$ w" C4 [* ~3 C, asource /etc/profile
6 d6 N- N3 N( F; H) Z复制代码
: f9 r! T: ]# s12、修改配置文件

9 r( e) R4 ~! Pvi /etc/my.cnf
#修改第19行(取消注释且修改为)   datadir = /data/mysql/data/
13、启动

service mysql start