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.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 #升级数据库版本，如下图：

《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 #升级数据库版本

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 
} 

感谢阅读，希望能帮助到大家，谢谢大家对本站的支持！

# MySQL/MariaDB/Percona数据库升级脚本  # 数据库升级脚本  # MySQL数据库升级脚本  # Mysql升级到5.7后遇到的group by查询问题解决  # mysql5.x升级到mysql5.7后导入之前数据库date出错的快速解决方法  # Mysql从5.6.14安全升级至mysql5.6.25的方法  # linux下安装升级mysql到新版本(5.1-5.7)  # Mysql5升级到Mysql5.5的方法  # mysql版本5.5.x升级到5.6.x步骤分享  # 实战MySQL升级的最佳方法  # 升级到  # 旧版  # 一大  # 希望能  # 谢谢大家  # 提供给  # 一键  # 如下图  # 安装包  # 为防止  # echo  # CWARNING  # installed  # db_install_dir  # mysql  # amp  # system  # exit  # OLD_DB_version_tmp  # awk 

相关栏目： 【 网站优化151355 】 【 网络推广146373 】 【 网络技术251813 】 【 AI营销90571 】

相关推荐： 家族网站制作贴纸教程视频,用豆子做粘帖画怎么制作？  独立制作一个网站多少钱,建立网站需要花多少钱？  Laravel事件监听器怎么写_Laravel Event和Listener使用教程  用v-html解决Vue.js渲染中html标签不被解析的问题  香港服务器如何优化才能显著提升网站加载速度？  电视网站制作tvbox接口,云海电视怎样自定义添加电视源？  如何用景安虚拟主机手机版绑定域名建站？  无锡营销型网站制作公司,无锡网选车牌流程？  昵图网官网入口 昵图网素材平台官方入口  浅谈javascript alert和confirm的美化  Linux安全能力提升路径_长期防护思维说明【指导】  绝密ChatGPT指令：手把手教你生成HR无法拒绝的求职信  如何彻底删除建站之星生成的Banner？  如何快速生成凡客建站的专业级图册？  网站制作怎么样才能赚钱,用自己的电脑做服务器架设网站有什么利弊，能赚钱吗？  百度浏览器网页无法复制文字怎么办 百度浏览器复制修复  如何制作公司的网站链接,公司想做一个网站，一般需要花多少钱？  如何在云服务器上快速搭建个人网站？  浏览器如何快速切换搜索引擎_在地址栏使用不同搜索引擎【搜索】  Python结构化数据采集_字段抽取解析【教程】  Laravel如何使用集合（Collections）进行数据处理_Laravel Collection常用方法与技巧  Laravel如何优化应用性能？（缓存和优化命令）  php中::能调用final静态方法吗_final修饰静态方法调用规则【解答】  JavaScript如何实现音频处理_Web Audio API如何工作？  Android实现代码画虚线边框背景效果  Laravel如何清理系统缓存命令_Laravel清除路由配置及视图缓存的方法【总结】  Laravel怎么进行数据库回滚_Laravel Migration数据库版本控制与回滚操作  深入理解Android中的xmlns:tools属性  ,在苏州找工作，上哪个网站比较好？  5种Android数据存储方式汇总  Laravel怎么解决跨域问题_Laravel配置CORS跨域访问  ChatGPT怎么生成Excel公式_ChatGPT公式生成方法【指南】  Laravel如何处理跨站请求伪造（CSRF）保护_Laravel表单安全机制与令牌校验  Claude怎样写约束型提示词_Claude约束提示词写法【教程】  Laravel如何使用Gate和Policy进行权限控制_Laravel权限判定与策略规则配置  如何在局域网内绑定自建网站域名？  *服务器网站为何频现安全漏洞？  详解Android中Activity的四大启动模式实验简述  html5的keygen标签为什么废弃_替代方案说明【解答】  大学网站设计制作软件有哪些,如何将网站制作成自己app？  在线制作视频网站免费,都有哪些好的动漫网站？  Edge浏览器如何截图和滚动截图_微软Edge网页捕获功能使用教程【技巧】  制作网站软件推荐手机版,如何制作属于自己的手机网站app应用？  如何用PHP工具快速搭建高效网站？  实例解析Array和String方法  什么是javascript作用域_全局和局部作用域有什么区别？  如何快速搭建二级域名独立网站？  JS经典正则表达式笔试题汇总  ChatGPT回答中断怎么办 引导AI继续输出完整内容的方法  微信推文制作网站有哪些,怎么做微信推文，急？