自动化部署 - 定制化RPM包构建

yum -y install rpm-build redhat-rpm-config gcc gcc-c++ cmake make zlib-devel openssl-devel

mkdir -p ~/rpmbuild/{BUILD,RPMS,SOURCES,SPECS,SRPMS}
echo "%_topdir $HOME/rpmbuild" > ~/.rpmmacros

./configure
make
make install

Name: ifengkou-mysql
Version:5.7.20
Release: 18
License: GPL

Group: applications/database
URL: https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.20-18/source/tarball/percona-server-5.7.20-18.tar.gz
BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-root 
BuildRequires: cmake
Requires: coreutils,shadow-utils
Packager: [email protected]
Autoreq: no
Source: percona-server-5.7.20-18.tar.gz
prefix: /opt/soft/ifengkou_mysql-%{version}-%{release}
Summary: percona server 5.7.20-18

%description 
Percona Server is an enhanced, drop-in MySQL® replacement which has been downloaded more than 1,000,000 times.
A free open source solution, Percona Server is a MySQL alternative which offers breakthrough performance, scalability, features, and instrumentation. Self-tuning algorithms and support for extremely high-performance hardware make it the clear choice for organizations that demand excellent performance and reliability from their MySQL database server.

%define MYSQL_USER mysql
%define MYSQL_GROUP mysql
%define __os_install_post %{nil}

%prep
%setup -n %{name}-%{version}-%{release}

%build
#CFLAGS="-O3 -g -fno-exceptions -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing"
#CXX=g++
#CXXFLAGS="-O3 -g -fno-exceptions -fno-rtti -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing"
#export CFLAGS CXX CXXFLAGS

cmake .                                                  \
  -DSYSCONFDIR:PATH=%{prefix}                            \
  -DCMAKE_INSTALL_PREFIX:PATH=%{prefix}                  \
  -DCMAKE_BUILD_TYPE:STRING=Release                      \
  -DENABLE_PROFILING:BOOL=ON                             \
  -DWITH_DEBUG:BOOL=OFF                                  \
  -DWITH_VALGRIND:BOOL=OFF                               \
  -DENABLE_DEBUG_SYNC:BOOL=OFF                           \
  -DWITH_EXTRA_CHARSETS:STRING=all                       \
  -DWITH_SSL:STRING=bundled                              \
  -DWITH_UNIT_TESTS:BOOL=OFF                             \
  -DWITH_ZLIB:STRING=bundled                             \
  -DWITH_PARTITION_STORAGE_ENGINE:BOOL=ON                \
  -DWITH_INNOBASE_STORAGE_ENGINE:BOOL=ON                 \
  -DWITH_ARCHIVE_STORAGE_ENGINE:BOOL=ON                  \
  -DWITH_BLACKHOLE_STORAGE_ENGINE:BOOL=ON                \
  -DWITH_PERFSCHEMA_STORAGE_ENGINE:BOOL=ON               \
  -DDEFAULT_CHARSET=utf8                                 \
  -DDEFAULT_COLLATION=utf8_general_ci                    \
  -DENABLED_LOCAL_INFILE:BOOL=ON                         \
  -DWITH_EMBEDDED_SERVER=0                               \
  -DINSTALL_LAYOUT:STRING=STANDALONE                     \
  -DCOMMUNITY_BUILD:BOOL=ON                              \
  -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1                     \
  -DWITHOUT_NDBCLUSTER_STORAGE_ENGINE=1                  \
  -DENABLED_PROFILING=1                                  \
  -DINNODB_PAGE_ATOMIC_REF_COUNT=1                       \
  -DWITH_INNODB_MEMCACHED=1                              \
  -DDOWNLOAD_BOOST=1                                     \
  -DWITH_BOOST=/usr/local/boost_1_59_0;

make -j `cat /proc/cpuinfo | grep processor| wc -l`

%install
echo "-----------------"$RPM_BUILD_ROOT
make DESTDIR=$RPM_BUILD_ROOT install
cp %{_sourcedir}/my.cnf $RPM_BUILD_ROOT%{prefix}/

%clean
#rm -rf $RPM_BUILD_ROOT
rm -rf $RPM_BUILD_DIR/*

%files
%defattr(-, %{MYSQL_USER}, %{MYSQL_GROUP})
%attr(755, %{MYSQL_USER}, %{MYSQL_GROUP}) %{prefix}/*

%pre
if ! id %{MYSQL_USER} > /dev/null 2>&1;then
useradd -M -s /sbin/nologin %{MYSQL_USER}
fi

%post
if [ -f %{prefix}/support-files/mysql.server > /dev/null 2>&1 ]  && [ ! -f %{_initddir}/mysql > /dev/null 2>&1 ];then
cp -f %{prefix}/support-files/mysql.server %{_initddir}/mysql
chmod +x %{_initddir}/mysql
chkconfig --level 2345 %{_initddir}/mysql on
fi

if [ ! -f %{_sysconfdir}/my.cnf ];then
cp %{prefix}/my.cnf %{_sysconfdir}/my.cnf
else
cp %{prefix}/my.cnf %{_sysconfdir}/my.cnf.rpmnew
fi

%preun
if [ -f %{_sysconfdir}/my.cnf ];then
mv %{_sysconfdir}/my.cnf %{_sysconfdir}/my.cnf.rpmold
fi

if [ -f %{_initddir}/mysql ];then
mv %{_initddir}/mysql %{_initddir}/mysql.rpmold
fi

%postun
rm -rf %{prefix}
userdel -r %{MYSQL_USER} >/dev/null 2>&1

%changelog

cp percona-server-5.6.19-67.0.tar.gz ~/rpmbuild/SOURCES/
cp my.cnf ~/rpmbuild/SOURCES/ #拷贝模板配置文件
rpmbuild -bb mysql.spec

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz

tar -xvzf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.22-linux-glibc2.12-x86_64/* ifengkou-mysql-5.7.22/

tar czf ifengkou-mysql-5.7.22.tar.gz ifengkou-mysql-5.7.22

mv ifengkou-mysql-5.7.22.tar.gz  ~/rpmbuild/SOURCES/

Summary    : ifengkou mysql
Name       : ifengkou-mysql
Version    : 5.7.22
Release    : 1
License    : GPL
Source     : ifengkou-mysql-5.7.22.tar.gz
BuildArch  : x86_64
BuildRoot  : root
AutoReqProv: no
AutoReq: no
Packager   : [email protected]
%define debug_package %{nil}
%description
This package is just a mysql RPM.
%prep
rm -rf /opt/soft/ifengkou-mysql
%setup -q
%build
%install
echo $RPM_BUILD_ROOT
mkdir -p $RPM_BUILD_ROOT/opt/soft/ifengkou-mysql
install -d -m 755 $RPM_BUILD_ROOT/opt/soft/ifengkou-mysql
cp -rf *  $RPM_BUILD_ROOT/opt/soft/ifengkou-mysql
%post
rm -rf /etc/init.d/ifengkou-mysqld /etc/my.cnf
cp /opt/soft/ifengkou-mysql/support-files/mysql.server /etc/init.d/ifengkou-mysqld
cp /opt/soft/ifengkou-mysql/support-files/my.cnf /etc/my.cnf
rm -rf /etc/profile.d/ifengkou-mysql.sh
echo "export IFENGKOU_MYSQL_HOME=/opt/soft/ifengkou-mysql" >> /etc/profile.d/ifengkou-mysql.sh
echo "export PATH=\$IFENGKOU_MYSQL_HOME/bin:\$PATH"  >> /etc/profile.d/ifengkou-mysql.sh
chmod +x /etc/init.d/ifengkou-mysqld
useradd mysql
chown -R mysql:mysql /opt/soft/ifengkou-mysql/data
mkdir /var/log/ifengkou-mysql
touch /var/log/ifengkou-mysql/mysql.log
chown -R mysql.mysql /var/log/ifengkou-mysql
mkdir /var/run/ifengkou-mysql
chown -R mysql.mysql /var/run/ifengkou-mysql

%check
%files
/opt/soft/ifengkou-mysql
%postun
rm -rf /opt/soft/ifengkou-mysql
rm -rf /etc/my.cnf
rm -rf /etc/profile.d/ifengkou-mysql.sh
rm -rf /var/log/ifengkou-mysql
rm -rf /var/run/ifengkou-mysql

echo "安装新的mysql..."
	echo "yum -y install libaio libnuma* ifengkou-mysql -d 0 -e 0"
	yum -y install libaio libnuma* ifengkou-mysql -d 0 -e 0
	rsync -avvP ./tool/mysql-connector-java-5.1.37.jar /usr/share/java/
	if [ -h "/usr/share/java/mysql-connector-java.jar" ];then
		rm -f /usr/share/java/mysql-connector-java.jar
	fi
	ln -s  /usr/share/java/mysql-connector-java-5.1.37.jar /usr/share/java/mysql-connector-java.jar
	if [ $? = 0 ];then
		echo "install mysql sucess"
	else
		echo "install mysql failed"
	fi

sed -i '/innodb_buffer_pool_size/c\innodb_buffer_pool_size=32G' /etc/my.cnf
sed -i '/max_allowed_packet/c\max_allowed_packet=25M' /etc/my.cnf

/sbin/chkconfig --add ifengkou-mysqld
systemctl enable ifengkou-mysqld.service

/etc/init.d/ifengkou-mysqld start
if [ $? = 0 ];then
	echo "start  mysql sucess"
else
	echo "start mysql failed"
fi

. /etc/profile.d/ifengkou-mysql.sh