导读 今天小编跟大家讲解下有关科技常识：MySQL MariaDB Percona数据库升级脚本，相信小伙伴们对这个话题应该也很关注吧，小编也收集到了有关科
今天小编跟大家讲解下有关科技常识：MySQL/MariaDB/Percona数据库升级脚本，相信小伙伴们对这个话题应该也很关注吧，小编也收集到了有关科技常识：MySQL/MariaDB/Percona数据库升级脚本的相关资料，希望小伙伴会喜欢也能够帮助大家。
MySQL/MariaDB/Percona数据库升级脚本
MySQL/MariaDB/Percona数据库升级脚本截取《OneinStack》中upgrade_db.sh，一般情况下不建议升级数据库版本，该脚本专提供给各位版本控们。为防止大版本之间兼容问题，脚本默认仅支持同一大版本之间的升级，如：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之前版本如何支持数据库版本升级？
《OneinStack》：
cd /root/cp oneinstack/options.conf ~ #备份options.confrm -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 #升级数据库版本，如下图：《lnmp一键安装包》：
cp lnmp/options.conf ~ #备份options.confrm -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 #升级数据库版本PS：MySQL/MariaDB/Percona数据库升级脚本内容如下（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 }感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！
来源：爱蒂网