mysql数据库升级脚本_MySQL/MariaDB/Percona数据库升级脚本

最新推荐文章于 2024-05-30 13:51:18 发布

alias e

最新推荐文章于 2024-05-30 13:51:18 发布

阅读量279

点赞数

文章标签： mysql数据库升级脚本

本文链接：https://blog.csdn.net/weixin_29543939/article/details/114863658

版权

$DB_version_tmp

else

DB=MySQL

Old_DB_version=$DB_version_tmp

#backup

while :

$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 -e "\033[31m$DB root password incorrect,Please enter again! \033[0m"

done

echo

echo -e "\033[32mStarting $DB backup......\033[0m"

$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 -e "$DB backup success, Backup file: \033[32m`pwd`/DB_all_backup_$(date +"%Y%m%d").sql\033[0m"

#upgrade

echo

echo -e "Current $DB Version: \033[32m$Old_DB_version\033[0m"

[ -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 :

echo

read -p "Please input upgrade $DB Version(example: 5.6.25): " DB_version

if [ `echo $DB_version | awk -F. '{print $1"."$2}'` == `echo $Old_DB_version | awk -F. '{print $1"."$2}'` ]; then

if [ "$DB" == 'MariaDB' ];then

DB_name=mariadb-${DB_version}-${GLIBC_FLAG}-${SYS_BIT_b}

DB_URL=$DOWN_ADDR/mariadb-${DB_version}/bintar-${GLIBC_FLAG}-$SYS_BIT_a/$DB_name.tar.gz

elif [ "$DB" == 'Percona' ];then

DB_name=percona-server-$DB_version

DB_URL=http://www.percona.com/redir/downloads/Percona-Server-`echo $DB_version | awk -F. '{print $1"."$2}'`/LATEST/source/tarball/$DB_name.tar.gz

elif [ "$DB" == 'MySQL' ];then

DB_name=mysql-$DB_version

DB_URL=http://cdn.mysql.com/Downloads/MySQL-`echo $DB_version | awk -F. '{print $1"."$2}'`/$DB_name.tar.gz

[ ! -e "$DB_name.tar.gz" ] && wget -c $DB_URL > /dev/null 2>&1

if [ -e "$DB_name.tar.gz" ];then

echo -e "Download \033[32m$DB_name.tar.gz\033[0m successfully! "

else

echo -e "\033[31mIt does not exist!\033[0m"

break

else

echo -e "\033[31minput error!\033[0m Please only input '\033[32m${Old_DB_version%.*}.xx' \033[0m"

done

if [ -e "$DB_name.tar.gz" ];then

echo -e "\033[32m$DB_name.tar.gz\033[0m [found]"

echo "Press Ctrl+c to cancel or Press any key to continue..."

char=`get_char`

if [ "$DB" == 'MariaDB' ];then

service mysqld stop

mv ${db_install_dir}{,_old_`date +"%Y%m%d"`}

mv ${db_data_dir}{,_old_`date +"%Y%m%d"`}

mkdir -p $db_data_dir;chown mysql.mysql -R $db_data_dir

tar xzf $DB_name.tar.gz

[ ! -d "$db_install_dir" ] && mkdir -p $db_install_dir

mv mariadb-${DB_version}-linux-${SYS_BIT_b}/* $db_install_dir

if [ "$je_tc_malloc" == '1' ];then

sed -i 's@executing mysqld_safe@executing mysqld_safe\nexport LD_PRELOAD=/usr/local/lib/libjemalloc.so@' $db_install_dir/bin/mysqld_safe

elif [ "$je_tc_malloc" == '2' ];then

sed -i 's@executing mysqld_safe@executing mysqld_safe\nexport LD_PRELOAD=/usr/local/lib/libtcmalloc.so@' $db_install_dir/bin/mysqld_safe

$db_install_dir/scripts/mysql_install_db --user=mysql --basedir=$db_install_dir --datadir=$db_data_dir

chown mysql.mysql -R $db_data_dir

service mysqld start

$db_install_dir/bin/mysql < DB_all_backup_$(date +"%Y%m%d").sql

service mysqld restart

$db_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "drop database test;" >/dev/null 2>&1

$db_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "reset master;" >/dev/null 2>&1

[ $? -eq 0 ] && echo -e "You have \033[32m$DB successfully\033[0m upgrade from \033[32m$Old_DB_version\033[0m to \033[32m$DB_version\033[0m"

elif [ "$DB" == 'Percona' ];then

tar zxf $DB_name.tar.gz

cd $DB_name

make clean

if [ "`echo $DB_version | awk -F. '{print $1"."$2}'`" == '5.5' ];then

cmake . -DCMAKE_INSTALL_PREFIX=$db_install_dir \

-DMYSQL_DATADIR=$db_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=$db_install_dir \

-DMYSQL_DATADIR=$db_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

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

service mysqld stop

mv ${db_install_dir}{,_old_`date +"%Y%m%d"`}

mv ${db_data_dir}{,_old_`date +"%Y%m%d"`}

[ ! -d "$db_install_dir" ] && mkdir -p $db_install_dir

mkdir -p $db_data_dir;chown mysql.mysql -R $db_data_dir

make install

$db_install_dir/scripts/mysql_install_db --user=mysql --basedir=$db_install_dir --datadir=$db_data_dir

chown mysql.mysql -R $db_data_dir

service mysqld start

$db_install_dir/bin/mysql < DB_all_backup_$(date +"%Y%m%d").sql

service mysqld restart

$db_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "drop database test;" >/dev/null 2>&1

$db_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "reset master;" >/dev/null 2>&1

[ $? -eq 0 ] && echo -e "You have \033[32m$DB successfully\033[0m upgrade from \033[32m$Old_DB_version\033[0m to \033[32m$DB_version\033[0m"

elif [ "$DB" == 'MySQL' ];then

tar zxf $DB_name.tar.gz

cd $DB_name

make clean

if [ "`echo $DB_version | awk -F. '{print $1"."$2}'`" == '5.5' ];then

cmake . -DCMAKE_INSTALL_PREFIX=$db_install_dir \

-DMYSQL_DATADIR=$db_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=$db_install_dir \

-DMYSQL_DATADIR=$db_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

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

service mysqld stop

mv ${db_install_dir}{,_old_`date +"%Y%m%d"`}

mv ${db_data_dir}{,_old_`date +"%Y%m%d"`}

[ ! -d "$db_install_dir" ] && mkdir -p $db_install_dir

mkdir -p $db_data_dir;chown mysql.mysql -R $db_data_dir

make install

$db_install_dir/scripts/mysql_install_db --user=mysql --basedir=$db_install_dir --datadir=$db_data_dir

chown mysql.mysql -R $db_data_dir

service mysqld start

$db_install_dir/bin/mysql < DB_all_backup_$(date +"%Y%m%d").sql

service mysqld restart

$db_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "drop database test;" >/dev/null 2>&1

$db_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "reset master;" >/dev/null 2>&1

[ $? -eq 0 ] && echo -e "You have \033[32m$DB successfully\033[0m upgrade from \033[32m$Old_DB_version\033[0m to \033[32m$DB_version\033[0m"

}

alias e

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
mysql数据库升级脚本_MySQL/MariaDB/Percona数据库升级脚本

$DB_version_tmpelseDB=MySQLOld_DB_version=$DB_version_tmpfi#backupwhile :do$db_install_dir/bin/mysql -uroot -p${dbrootpwd} -e "quit" >/dev/null 2>&1if [ $? -eq 0 ];thenbreakelseechoread -p "...
复制链接

扫一扫