lSky's blog

rpm包制作之-mysql-5.7.16

发表于 | 分类于 |

从MySQL 5.7.5开始需要Boost库，也就是因为这个库纠结了好久 )~^~(
By the way，编译过程需要花的时间比较久，对内存和硬盘要求比较高
环境 VM：内存3G，硬盘30G 系统：CentOS release 6.5

mysql-5.7.16源码编译安装

相关依赖安装

yum -y install make gcc gcc-c++ cmake bison-devel ncurses ncurses-devel perl-JSON perl-devel perl-Time-HiRes

ntpdate cn.pool.ntp.org

useradd -M -s /sbin/nologin mysql

从MySQL 5.7.5开始Boost库是必需
Boost库编译安装

./bootstrap.sh
./b2 install threading=multi link=shared

Mysql编译安装

编译
cmake参数: http://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWIT

H_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DMYSQL_USER=mysql

make -j3 && make install

mkdir /var/lib/mysql/

chown -R mysql:mysql /var/lib/mysql/

mkdir -p /usr/local/mysql/data

chown -R mysql:mysql /usr/local/mysql/data

配置文件修改

vim /etc/my.cnf

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
[client]
default-character-set=utf8
[mysqld]
datadir=/usr/local/mysql/data
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server=utf8
collation-server=utf8_general_ci
#server-id=1
#log-bin=/tmp/binlog
#log-bin-index=/tmp/binlog.index
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

初始化mysql，记得初始化密码

bin/mysqld –initialize –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data

bin/mysqld –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data

bin/mysql_ssl_rsa_setup

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

service mysqld start

重置密码

mysql -uroot -p$passwd -e “set password = password(‘*‘)”;

boost_1_59_0 单独rpmbuild

#vim ~/rpmbuild/SPECS/boost.spec

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
Name:       boost
Version:    1_59_0
Release:    1%{?dist}
Summary:    boost_install
Group:      System Environment/Daemons
License:    GPLv2
URL:        http://www.boost.org/users/history/version_1_59_0.html
Source0:    boost-1_59_0.tar.gz
BuildRoot:   %{_topdir}/%{name}-%{version}-%{release}
BuildRequires:  gcc,make,gcc-c++,bzip2-devel,python-devel,python-libs,libicu-devel
Requires:	bzip2,python-libs  
%description
boost1_59_0 install
%prep
%setup -q
%build
BOOST_ROOT=`pwd`
export BOOST_ROOT
./bootstrap.sh --prefix=%{buildroot}/usr/ --with-toolset=gcc --with-icu
install -d -m 755 %{buildroot}/usr/
./b2 --layout=system install threading=multi link=shared
%clean
rm -rf %{buildroot}
%post -p /sbin/ldconfig
%postun -p /sbin/ldconfig
%files
%defattr(-,root,root,-)
#${_includedir}/boost
/usr/*
%doc
%changelog

mysql-5.7.16 包括boost

vim ~/rpmbuild/SPECS/mysql.spec

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
Name:       mysql
Version:    5.7.16
Release:    1%{?dist}
Summary:    mysql_install
Group:      System Environment/Daemons
License:    GPLv2
URL:    http://www.boost.org/users/history/version_1_59_0.html&&http://dev.mysql.com/downloads/mysql/
Source0:    boost_1_59_0.tar.gz
Source1:    %{name}-%{version}.tar.gz
Source2:    my.cnf
BuildRoot:  %(mktemp -ud %{_tmppath}/%{name}-%{version}-%{release}-XXXXXX)
BuildRequires:  gcc,make,gcc-c++,cmake,bison-devel,ncurses,ncurses-devel,bzip2-devel,python-devel,python-libs,bzip2,libicu-devel
Requires:   python-libs,bzip2,perl-JSON,perl-Time-HiRes
%description
Build mysql-5.7.16.tar.gz to mysql-5.7.16.rpm
%prep
%setup -q -b 0 -b 1
%build
cd ../boost_1_59_0
BOOST_ROOT=`pwd`
export BOOST_ROOT
./bootstrap.sh --prefix=%{buildroot}/usr/ --with-toolset=gcc --with-icu
install -d -m 755 %{buildroot}/usr/
./b2 install threading=multi link=shared
cd ../mysql-5.7.16
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWI
TH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_READLINE=1 -DMYSQL_USER=mysql
make -j3 %{?_smp_mflags}
%install
make install DESTDIR=%{buildroot}
install -d -m 755 %{buildroot}/usr/
%{__install} -p -D %{SOURCE2} %{buildroot}/etc/my.cnf
%pre
if [ $1 == 1 ];then
    /usr/sbin/useradd mysql -M -s /sbin/nologin 2>/dev/null
fi
%post
if [ $1 == 1 ];then
    mkdir -p /usr/local/mysql/data
    chown -R mysql:mysql /usr/local/mysql/data 2>/dev/null
    /usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 2>&1 | tee /usr/local/mysql/default-passwd
    #/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data 2>/dev/null
    /usr/local/mysql/bin/mysql_ssl_rsa_setup --datadir=/usr/local/mysql/data 2>/dev/null
    cp /usr/local/mysql/bin/* /usr/bin/ 2>/dev/null
    cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld 2>/dev/null
    /sbin/chkconfig --add mysqld
    /sbin/install-info %{_infodir}/%{name}.info %{_infodir}/dir 2> /dev/null || :
fi
%preun
if [ $1 == 0 ];then
    /usr/sbin/userdel -r mysql 2> /dev/null
    /etc/init.d/mysqld stop > /dev/null 2>&1
    /sbin/chkconfig --del mysqld 2> /dev/null
    /sbin/install-info --delete %{_infodir}/%{name}.info %{_infodir}/dir 2> /dev/null || :
fi
%postun
if [ $1 == 0 ];then
    rm -rf /usr/local/mysql 2> /dev/null
    rm -rf /usr/bin/mysql* 2> /dev/null
    rm -rf /etc/my.cnf 2> /dev/null
    rm -rf /etc/init.d/mysqld 2> /dev/null
fi
%clean
rm -rf %{buildroot}
%files
%defattr(-,root,root,-)
/usr/local/mysql/*
/usr/*
%config(noreplace) /etc/my.cnf
%doc
%changelog