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”不会生成密码
–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
  R9 t+ K) h% `1 p4 t0 O

/ d1 G. W+ ?3 W* ]) x! `
( z( G& G& s) E7 JMysql5.7版本更新后有很多变化，比如json等，连安装都有变化，他安装必须要BOOST库，不过mysql的官网源码有带boost库的源码和不带boost库的源码两种，因此有两种安装方式，其实都是一样的，仅仅是不带boost库源码的需要单独安装boost，还有后续文章percona-xtrabackup需要用到boost库

下载软件
- i) e. j* I* E# w; V( ?到usr/local目录下：
3 ?2 R) q% g5 U; |( h1 s( R+ I
cd /usr/local
wget http://downloads.sourceforge.net ... boost_1_59_0.tar.gz
! E. b/ V' r( @& _wget 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
& Z) |! ]' v  l& q# C安装boost
' R5 f/ s7 J4 Z3 B) p注:此处如果只为安装mysql其实可以不用安装的，解压就好，到时安装mysql时引用目录，不过percona-xtrabackup需要用到，所以我安装了。

tar xzf boost_1_59_0.tar.gz
5 Z+ @( J- t2 I2 Q$ o# _( ^  Vcd boost_1_59_0
./bootstrap.sh
; j; L+ X* S6 ?6 B./b2 install
不带boost的mysql源码安装
( @* l3 t1 A; X4 T: ?4 \1、安装依赖包
2 S4 x6 a/ x$ Y5 n+ b1 }. t
; u% C" B* y  z% D# {8 O3 l+ C3 dyum -y install gcc gcc-c++ ncurses ncurses-devel cmake
2、添加禁止登陆的mysql用户

" w  @% G1 B( q9 K: h7 \5 m5 s  Ogroupadd mysql
useradd -r -g mysql -s /bin/false mysql
3、编译安装
1 f9 ~3 _3 b; \( ~8 o
" A# r# s# E: V. z* y  d! k3 t" k从MySQL 5.7.5开始Boost库是必需的
$ U0 ^. a, a" B3 ~
1 l3 L9 C- y; A5 `1 m复制代码
- |+ h4 a! F& amkdir -p /data/mysql
tar xzf mysql-5.7.11.tar.gz
4 d! z+ h/ S% N7 M! Ncd mysql-5.7.11
cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
0 o: m/ R$ `& j* M& x -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 \
/ {4 \" Y) _! w: G! R -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 \
( A3 ~2 g8 s7 n  _3 T1 z -DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1

make
make install
2 N& }1 \, n% i( l- w复制代码
; P+ W, }5 p- P
* ^. [- ?8 T# w3 X0 f& u, m# Z  B
' [* c6 C% m5 e; K. _$ w. }4、配置开机启动项
1 p5 L! }8 v' M$ W
2 b+ A( V$ y7 d; I2 Gcp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
! x9 ^; O/ ~4 P% E; Nchmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
/ ^+ r. n! b' s) m4 s5、配置/etc/my.cnf 仅供参考，可以不配，用默认的。
  B, g! I) ?+ }# k5 |: I
7 i5 C$ S6 A1 \. B8 K复制代码
cat > /etc/my.cnf << EOF
9 `3 N! E7 B. n* m% ~/ w" q[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8mb4
! c7 ^# A0 L9 h' X0 i4 a% J+ I' A
[mysqld]
port = 3306
socket = /tmp/mysql.sock

: j+ i3 q( K7 t7 C( [basedir = /usr/local/mysql
/ i. X( I! X+ N- }datadir = /data/mysql
1 O; B, H( V! H' Q, B& K9 U0 i( {: Tpid-file = /data/mysql/mysql.pid
! ~3 \  L; i% B3 Juser = mysql
bind-address = 0.0.0.0
; `. N/ o3 t; j5 Z* vserver-id = 1

! I8 M- C& n  s! P" m8 D' s; Winit-connect = 'SET NAMES utf8mb4'
5 l6 @* Z7 ?$ I$ p- f8 p- C- F8 }character-set-server = utf8mb4
' C4 A, g; r, A- [! m$ I( q- s3 q, C
#skip-name-resolve
( ]/ W: X, e# B#skip-networking
back_log = 300

4 J) U. X3 U  D( u6 T, rmax_connections = 1000
4 K. p1 @* T) U! U  O$ }* W# n$ mmax_connect_errors = 6000
# i: q' @2 {9 I- x6 j+ g9 Dopen_files_limit = 65535
) t+ T7 Y8 r: t/ P* y! stable_open_cache = 128
max_allowed_packet = 4M
7 W) @& p( O. Y0 _( Z+ y& wbinlog_cache_size = 1M
: [1 E- ~* |+ u' P( `" c1 e* L. bmax_heap_table_size = 8M
tmp_table_size = 16M
9 \4 }+ U# c. C8 d+ D1 K7 Y
read_buffer_size = 2M
1 g  J4 M* T1 L) C6 N! w6 Pread_rnd_buffer_size = 8M
% c% a! t: u2 v3 Wsort_buffer_size = 8M
0 p' d" W/ ^& Q9 @. ejoin_buffer_size = 8M
key_buffer_size = 4M

thread_cache_size = 8

query_cache_type = 1
query_cache_size = 8M
0 z  j) \6 J+ d% z# \/ g& N& c8 wquery_cache_limit = 2M

ft_min_word_len = 4
+ l6 Y" p  u& w* k2 Q+ w9 f
9 D( [3 \4 P7 k8 t; |) t) Nlog_bin = mysql-bin
binlog_format = mixed
+ W& k" k) R% L, ?! k, z1 R0 r" Uexpire_logs_days = 30
4 |# k4 n" g% C, R
log_error = /data/mysql/mysql-error.log
slow_query_log = 1
$ t% v8 w, {4 _% h. I. b1 along_query_time = 1
slow_query_log_file = /data/mysql/mysql-slow.log

" G$ l1 Q9 ~$ {9 Rperformance_schema = 0
. |) R/ V: G/ _4 u3 Eexplicit_defaults_for_timestamp

4 P; ?- a- |: `& Y8 f' T9 l#lower_case_table_names = 1
9 k( \" ]8 o9 Z" T' R
0 J$ {9 N$ F' ]skip-external-locking
* E' I9 C% M8 w" `; g+ Q- G% w
' s  t" o! q9 ddefault_storage_engine = InnoDB
% Q4 S8 O$ ?# f#default-storage-engine = MyISAM
& Z+ I8 X, ]) D: finnodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
* K7 f9 k; y7 O/ w% c# Ginnodb_read_io_threads = 4
+ B; X4 ]  a; \! Dinnodb_thread_concurrency = 0
# ]/ a* _0 Y1 Winnodb_purge_threads = 1
( }8 M" Y" `' Ainnodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
" S+ ]  M- u: u4 }3 q2 @innodb_log_file_size = 32M
+ t, i# r* N) S5 i' \. W, Qinnodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
. y2 L% O' D6 h9 _4 Linnodb_lock_wait_timeout = 120
4 Y: S, g9 N& Z- w
! @9 _- ?) f( P; L/ c" rbulk_insert_buffer_size = 8M
& m% q( O9 ^3 Hmyisam_sort_buffer_size = 8M
" A+ }/ x) l, y; t1 y' g+ P1 tmyisam_max_sort_file_size = 10G
myisam_repair_threads = 1
3 b6 P) ^; m/ K, ?* f
interactive_timeout = 28800
- I6 R: ^' y8 k) M5 n8 j! j- }& y6 Iwait_timeout = 28800
; H- g+ p- C8 ~1 k; p
[mysqldump]
quick
max_allowed_packet = 16M
" s) h. H' Q: t* y
[myisamchk]
key_buffer_size = 8M
1 ^, }/ B0 k, ~  `sort_buffer_size = 8M
" D* Y6 e5 }5 n& `" cread_buffer = 4M
write_buffer = 4M
EOF
复制代码
  T; V5 k& K; N% u# o6、初始化数据

/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
& `4 l# f  U* s注： 之前版本mysql_install_db是在mysql_basedir/script下，5.7放在了mysql_install_db/bin目录下,且已被废弃
“–initialize”会生成一个随机密码(~/.mysql_secret)，而”–initialize-insecure”不会生成密码
$ u; ?( c# u' L* \–datadir目标目录下不能有数据文件

9 ^: w4 b! Z3 ^0 T2 M7、启动数据库

service mysqld start

% ?5 Z2 f1 [1 Q
带boost的mysql源码安装
1、安装依赖包

9 K3 T9 N9 B3 Y0 S$ ~! ]* W( ryum -y install make gcc-c++ cmake bison-devel  ncurses-devel   bison perl perl-devel  perl perl-devel
# L( r7 |) e$ j9 o2、解压到/usr/local目录下

tar -zxvf mysql-boost-5.7.11.tar.gz -C /usr/local
3、创建mysql组和用户
2 |8 Q$ p6 i4 F' b( x+ ]9 r
( q5 \: I1 J$ Igroupadd mysql
useradd -r -g mysql -s /bin/false mysql
4、编译mysql
3 o2 n3 g! |% M8 t4 X; d
cd /usr/local/mysql-5.7.11/
& i, R' F0 t; \: ]& tcmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
make
; Q& Z, k5 `# H2 ^5 smake install
$ I4 q5 d7 u6 Y# J5、把原来的/etc/my.cnf备份

cp /etc/my.cnf /etc/my.cnf.bak
5 i* J" U, {! [( w3 t! _rm -f /etc/my.cnf
4 n  A- J7 @, [5 S6、把安装目录用户和组更改为mysql

( B+ E# o% v4 X1 z/ P* B& H7 g# K! S: ?8 tcd /usr/local/mysql
- F& C. S. V6 _' N- Achown -R mysql .
! W4 S/ P) B* t  V. l; P; schgrp -R mysql .
7、创建一个数据目录
0 G  K. ?  Q& k1 ~
mkdir -p /data/mysql/data/
8、初始化mysql，及开启ssl新功能

bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
  K% C3 b3 u, g$ Q9 lbin/mysql_ssl_rsa_setup  --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
9、 设为root是为了防止普通用户不小心删除数据库

chown -R root .
chown -R mysql /data
4 l7 N( Z* r* D, g  U10、拷贝配置文件
8 S2 B  G1 f4 [7 T" P) p7 r0 p
cp support-files//my-default.cnf /etc/my.cnf
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
4 `5 E  f/ s3 Y2 \11、修改环境变量

复制代码
vi /etc/profile
$ O; g$ \2 u* L3 B7 i# Z# 在profile文件末尾增加两行
PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH
' ^, J* m! Q$ b3 f0 P" xexport PATH
$ Q! l: p' L' N; [4 l # 使PATH搜索路径立即生效：
+ k( k4 W/ T4 m7 ?source /etc/profile
& T* [. S4 n' ?3 T3 t0 G+ s" x& d  M复制代码
2 P$ R/ @+ Y& Y3 C8 Z/ v12、修改配置文件

5 b4 ~5 n- ^5 x+ M* t3 \9 B2 A% pvi /etc/my.cnf
, s0 L+ r$ t# h+ i6 K1 F+ W#修改第19行(取消注释且修改为)   datadir = /data/mysql/data/
$ |: F, V  O) `$ f% }& Y0 Q% n13、启动

3 ]5 u% e8 X6 e5 Gservice mysql start