MySQL/MariaDB/Percona數(shù)據(jù)庫升級腳本
更新時間：2016年12月27日 16:54:14 投稿：lqh
這篇文章主要介紹了MySQL/MariaDB/Percona數(shù)據(jù)庫升級腳本的相關資料,需要的朋友可以參考下
MySQL/MariaDB/Percona數(shù)據(jù)庫升級腳本
MySQL/MariaDB/Percona數(shù)據(jù)庫升級腳本截取《OneinStack》中upgrade_db.sh，一般情況下不建議升級數(shù)據(jù)庫版本，該腳本專提供給各位版本控們。為防止大版本之間兼容問題，腳本默認僅支持同一大版本之間的升級，如：MySQL-5.6.25升級到MySQL-5.6.26、MySQL-5.5.44升級到MySQL-5.5.45、MariaDB-10.0.20升級到MariaDB-10.0.21；不能跨分支版本且不能跨大版本，如從MySQL-5.5.44升級到PerconaL-5.5.44-37.3、MySQL-5.5.44升級到MySQL-5.6.25。
2015-07-16之前版本如何支持數(shù)據(jù)庫版本升級？
《OneinStack》：
cd /root/ cp oneinstack/options.conf ~ #備份options.conf rm -rf oneinstack #刪除舊版 wget http://mirrors.linuxeye.com/oneinstack-full.tar.gz #下載最新版 tar xzf oneinstack-full.tar.gz /bin/mv ~/options.conf ./oneinstack #還原options.conf, 必須使用舊版options.conf文件 cd oneinstack ./upgrade db #升級數(shù)據(jù)庫版本，如下圖：
《lnmp一鍵安裝包》：
cp lnmp/options.conf ~ #備份options.conf rm -rf lnmp #刪除舊版 wget http://mirrors.linuxeye.com/lnmp-full.tar.gz #下載最新版 tar xzf lnmp-full.tar.gz /bin/mv ~/options.conf ./lnmp #還原options.conf, 必須使用舊版options.conf文件 cd lnmp ./upgrade db #升級數(shù)據(jù)庫版本
PS：MySQL/MariaDB/Percona數(shù)據(jù)庫升級腳本內(nèi)容如下（cat upgrade_db.sh）：
#!/bin/bash
# Author: yeho <lj2007331 AT gmail.com>
# BLOG: https://blog.linuxeye.com
#
# Notes: OneinStack for CentOS/RadHat 5+ Debian 6+ and Ubuntu 12+
#
# Project home page:
# http://oneinstack.com
# https://github.com/lj2007331/oneinstack
Upgrade_DB()
{
cd $oneinstack_dir/src
[ ! -e "$db_install_dir/bin/mysql" ] && echo "${CWARNING}The MySQL/MariaDB/Percona is not installed on your system! ${CEND}" && exit 1
OLD_DB_version_tmp=`$db_install_dir/bin/mysql -V | awk '{print $5}' | awk -F, '{print $1}'`
DB_tmp=`echo $OLD_DB_version_tmp | awk -F'-' '{print $2}'`
if [ "$DB_tmp" == 'MariaDB' ];then
[ "$IPADDR_STATE"x == "CN"x ] && DOWN_ADDR=http://mirrors.aliyun.com/mariadb || DOWN_ADDR=https://downloads.mariadb.org/f
LIBC_VERSION=`getconf -a | grep GNU_LIBC_VERSION | awk '{print $NF}'`
LIBC_YN=`echo "$LIBC_VERSION < 2.14" | bc`
[ $LIBC_YN == '1' ] && GLIBC_FLAG=linux || GLIBC_FLAG=linux-glibc_214
DB=MariaDB
OLD_DB_version=`echo $OLD_DB_version_tmp | awk -F'-' '{print $1}'`
elif [ -n "$DB_tmp" -a "$DB_tmp" != 'MariaDB' ];then
DB=Percona
OLD_DB_version=$OLD_DB_version_tmp
else
DB=MySQL
OLD_DB_version=$OLD_DB_version_tmp
fi
#backup
while :
do
$db_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "quit" >/dev/null 2>&1
if [ $? -eq 0 ];then
break
else
echo
read -p "Please input the root password of database: " NEW_dbrootpwd
$db_install_dir/bin/mysql -uroot -p${NEW_dbrootpwd} -e "quit" >/dev/null 2>&1
if [ $? -eq 0 ];then
dbrootpwd=$NEW_dbrootpwd
sed -i "s+^dbrootpwd.*+dbrootpwd='$dbrootpwd'+" ../options.conf
break
else
echo "${CFAILURE}$DB root password incorrect,Please enter again! ${CEND}"
fi
fi
done
echo
echo "${CSUCCESS}Starting $DB backup${CEND}......"
$db_install_dir/bin/mysqldump -uroot -p${dbrootpwd} --opt --all-databases > DB_all_backup_$(date +"%Y%m%d").sql
[ -f "DB_all_backup_$(date +"%Y%m%d").sql" ] && echo "$DB backup success, Backup file: ${MSG}`pwd`/DB_all_backup_$(date +"%Y%m%d").sql${CEND}"
#upgrade
echo
echo "Current $DB Version: ${CMSG}$OLD_DB_version${CEND}"
[ -e /usr/local/lib/libtcmalloc.so ] && { je_tc_malloc=2; EXE_LINKER="-DCMAKE_EXE_LINKER_FLAGS='-ltcmalloc'"; }
[ -e /usr/local/lib/libjemalloc.so ] && { je_tc_malloc=1; EXE_LINKER="-DCMAKE_EXE_LINKER_FLAGS='-ljemalloc'"; }
while :
do
echo
read -p "Please input upgrade $DB Version(example: $OLD_DB_version): " NEW_DB_version
if [ `echo $NEW_DB_version | awk -F. '{print $1"."$2}'` == `echo $OLD_DB_version | awk -F. '{print $1"."$2}'` ]; then
if [ "$DB" == 'MariaDB' ];then
DB_name=mariadb-${NEW_DB_version}-${GLIBC_FLAG}-${SYS_BIT_b}
DB_URL=$DOWN_ADDR/mariadb-${NEW_DB_version}/bintar-${GLIBC_FLAG}-$SYS_BIT_a/$DB_name.tar.gz
elif [ "$DB" == 'Percona' ];then
DB_name=percona-server-$NEW_DB_version
DB_URL=http://www.percona.com/redir/downloads/Percona-Server-`echo $NEW_DB_version | awk -F. '{print $1"."$2}'`/LATEST/source/tarball/$DB_name.tar.gz
elif [ "$DB" == 'MySQL' ];then
DB_name=mysql-$NEW_DB_version
DB_URL=http://cdn.mysql.com/Downloads/MySQL-`echo $NEW_DB_version | awk -F. '{print $1"."$2}'`/$DB_name.tar.gz
fi
[ ! -e "$DB_name.tar.gz" ] && wget --no-check-certificate -c $DB_URL > /dev/null 2>&1
if [ -e "$DB_name.tar.gz" ];then
echo "Download [${CMSG}$DB_name.tar.gz${CEND}] successfully! "
else
echo "${CWARNING}$DB version does not exist! ${CEND}"
fi
break
else
echo "${CWARNING}input error! ${CEND}Please only input '${CMSG}${OLD_DB_version%.*}.xx${CEND}'"
fi
done
if [ -e "$DB_name.tar.gz" ];then
echo "[${CMSG}$DB_name.tar.gz${CEND}] found"
echo "Press Ctrl+c to cancel or Press any key to continue..."
char=`get_char`
if [ "$DB" == 'MariaDB' ];then
service mysqld stop
mv ${mariadb_install_dir}{,_old_`date +"%Y%m%d"`}
mv ${mariadb_data_dir}{,_old_`date +"%Y%m%d"`}
mkdir -p $mariadb_data_dir;chown mysql.mysql -R $mariadb_data_dir
tar xzf $DB_name.tar.gz
[ ! -d "$mariadb_install_dir" ] && mkdir -p $mariadb_install_dir
mv mariadb-${NEW_DB_version}-*-${SYS_BIT_b}/* $mariadb_install_dir
if [ "$je_tc_malloc" == '1' -a "`echo $OLD_DB_version_tmp | awk -F'.' '{print $1"."$2}'`" != '10.1' ];then
sed -i 's@executing mysqld_safe@executing mysqld_safe\nexport LD_PRELOAD=/usr/local/lib/libjemalloc.so@' $mariadb_install_dir/bin/mysqld_safe
elif [ "$je_tc_malloc" == '2' -a "`echo $OLD_DB_version_tmp | awk -F'.' '{print $1"."$2}'`" != '10.1' ];then
sed -i 's@executing mysqld_safe@executing mysqld_safe\nexport LD_PRELOAD=/usr/local/lib/libtcmalloc.so@' $mariadb_install_dir/bin/mysqld_safe
fi
$mariadb_install_dir/scripts/mysql_install_db --user=mysql --basedir=$mariadb_install_dir --datadir=$mariadb_data_dir
chown mysql.mysql -R $mariadb_data_dir
service mysqld start
$mariadb_install_dir/bin/mysql < DB_all_backup_$(date +"%Y%m%d").sql
service mysqld restart
$mariadb_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "drop database test;" >/dev/null 2>&1
$mariadb_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "reset master;" >/dev/null 2>&1
[ $? -eq 0 ] && echo "You have ${CMSG}successfully${CEND} upgrade from ${CMSG}$OLD_DB_version${CEND} to ${CMSG}$NEW_DB_version${CEND}"
elif [ "$DB" == 'Percona' ];then
tar zxf $DB_name.tar.gz
cd $DB_name
make clean
if [ "`echo $NEW_DB_version | awk -F. '{print $1"."$2}'`" == '5.5' ];then
cmake . -DCMAKE_INSTALL_PREFIX=$percona_install_dir \
-DMYSQL_DATADIR=$percona_data_dir \
-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 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLE_DTRACE=0 \
-DENABLED_LOCAL_INFILE=1 \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
$EXE_LINKER
else
cmake . -DCMAKE_INSTALL_PREFIX=$percona_install_dir \
-DMYSQL_DATADIR=$percona_data_dir \
-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 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
$EXE_LINKER
fi
make -j `grep processor /proc/cpuinfo | wc -l`
service mysqld stop
mv ${percona_install_dir}{,_old_`date +"%Y%m%d"`}
mv ${percona_data_dir}{,_old_`date +"%Y%m%d"`}
[ ! -d "$percona_install_dir" ] && mkdir -p $percona_install_dir
mkdir -p $percona_data_dir;chown mysql.mysql -R $percona_data_dir
make install
cd ..
$percona_install_dir/scripts/mysql_install_db --user=mysql --basedir=$percona_install_dir --datadir=$percona_data_dir
chown mysql.mysql -R $percona_data_dir
service mysqld start
$percona_install_dir/bin/mysql < DB_all_backup_$(date +"%Y%m%d").sql
service mysqld restart
$percona_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "drop database test;" >/dev/null 2>&1
$percona_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "reset master;" >/dev/null 2>&1
[ $? -eq 0 ] && echo "You have ${CMSG}successfully${CEND} upgrade from ${CMSG}$OLD_DB_version${CEND} to ${CMSG}$NEW_DB_version${CEND}"
elif [ "$DB" == 'MySQL' ];then
tar zxf $DB_name.tar.gz
cd $DB_name
make clean
if [ "`echo $NEW_DB_version | awk -F. '{print $1"."$2}'`" == '5.5' ];then
cmake . -DCMAKE_INSTALL_PREFIX=$mysql_install_dir \
-DMYSQL_DATADIR=$mysql_data_dir \
-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 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DENABLE_DTRACE=0 \
-DDEFAULT_CHARSET=utf8mb4 \
-DDEFAULT_COLLATION=utf8mb4_general_ci \
-DWITH_EMBEDDED_SERVER=1 \
$EXE_LINKER
else
cmake . -DCMAKE_INSTALL_PREFIX=$mysql_install_dir \
-DMYSQL_DATADIR=$mysql_data_dir \
-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=1 \
$EXE_LINKER
fi
make -j `grep processor /proc/cpuinfo | wc -l`
service mysqld stop
mv ${mysql_install_dir}{,_old_`date +"%Y%m%d"`}
mv ${mysql_data_dir}{,_old_`date +"%Y%m%d"`}
[ ! -d "$mysql_install_dir" ] && mkdir -p $mysql_install_dir
mkdir -p $mysql_data_dir;chown mysql.mysql -R $mysql_data_dir
make install
cd ..
$mysql_install_dir/scripts/mysql_install_db --user=mysql --basedir=$mysql_install_dir --datadir=$mysql_data_dir
chown mysql.mysql -R $mysql_data_dir
service mysqld start
$mysql_install_dir/bin/mysql < DB_all_backup_$(date +"%Y%m%d").sql
service mysqld restart
$mysql_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "drop database test;" >/dev/null 2>&1
$mysql_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "reset master;" >/dev/null 2>&1
[ $? -eq 0 ] && echo "You have ${CMSG}successfully${CEND} upgrade from ${CMSG}$OLD_DB_version${CEND} to ${CMSG}$NEW_DB_version${CEND}"
fi
fi
}
感謝閱讀，希望能幫助到大家，謝謝大家對本站的支持！
相關文章
本篇文章主要介紹了在 Ubuntu 中使用 NTP 進行時間同步設置，通?？蛻舳讼蚍掌髡埱螽斍暗臅r間，并根據(jù)結果來設置其時鐘。2017-04-04
Linux防火墻配置及iptables與firewalld的使用解讀
防火墻是一種網(wǎng)絡安全設備,通過規(guī)則控制進出網(wǎng)絡的訪問行為,它分為硬件防火墻和軟件防火墻兩大類,iptables是Linux系統(tǒng)中用于配置防火墻的工具,具有4個表和5個鏈,firewall命令用于配置和管理防火墻,有drop、block、public、external、dmz等不同的區(qū)域配置2025-01-01
這篇文章主要介紹了Linux 文件權限的詳細介紹，小編覺得挺不錯的，現(xiàn)在分享給大家，也給大家做個參考。一起跟隨小編過來看看吧2018-09-09
/etc/security/limits.conf詳解與配置過程
在Linux系統(tǒng)中,通過/etc/security/limits.conf文件和/etc/security/limits.d/目錄下的配置文件,可以設置用戶或用戶組的資源限制,配置文件中的soft和hard限制分別代表警告級別和硬性限制,它們需要匹配才能生效2024-10-10
大家都知道vim在Linux下使用很多，但是習慣了在Windows下的文本操作，在vim中進行文本操作會覺得很不方便，但是vim是一個很強大的工具，只是還不熟練去使用它，下面是一些常用的vim文本操作方法。2016-09-09
這篇文章主要介紹了Linux磁盤分區(qū)實現(xiàn)原理及方法解析,文中通過示例代碼介紹的非常詳細，對大家的學習或者工作具有一定的參考學習價值,需要的朋友可以參考下2020-08-08
這篇文章主要給大家介紹了關于Linux中RPM文件操作的常用命令，文中通過示例介紹的很詳細，對大家的理解和學習很有幫助，有需要的朋友們可以參考借鑒，下面來一起學習學習吧。2016-11-11
這篇文章主要介紹了Linux下部署springboot項目的方法步驟,由于springboot是內(nèi)嵌了tomcat，所以可以直接將項目打包上傳至服務器上，具體實例方法大家參考下本文2018-06-06
root權限相信對大家來說都不陌生，下面這篇文章主要給大家介紹了關于Ubuntu 16.04無法切換root權限問題的解決方法，文中通過示例代碼介紹的非常詳細，需要的朋友可以參考借鑒，下面隨著小編來一起學習學習吧。2018-04-04
這篇文章主要介紹了Linux中的ls -l命令展示信息,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教2023-11-11