跳转至

了解飞致云旗下开源产品

数据库迁移⚓︎

迁移前请一定要做好备份

  • 从 v2.5 开始，要求 MySQL >= 5.7
  • 推荐使用外置 数据库，方便日后扩展升级
DB Version Cache Version
MySQL >= 5.7 Redis >= 5.0
MariaDB >= 10.2

备份数据库

cd /opt/koko
./koko -s stop
# 更老的版本使用的 coco
# cd /opt/coco
# ./cocod stop

/etc/init.d/guacd stop
sh /config/tomcat9/bin/shutdown.sh

cd /opt/jumpserver
source /opt/py3/bin/activate
./jms stop

cd /opt
mv /opt/jumpserver /opt/jumpserver_bak

mysqldump -h127.0.0.1 -P3306 -ujumpserver -p jumpserver > /opt/jumpserver.sql


docker stop jms_koko jms_lion     
docker rm jms_koko jms_lion     
# 更老的版本使用的 coco
# docker stop jms_coco
# docker rm jms_coco

cd /opt/jumpserver
source /opt/py3/bin/activate
./jms stop

cd /opt
mv /opt/jumpserver /opt/jumpserver_bak

mysqldump -h127.0.0.1 -P3306 -ujumpserver -p jumpserver > /opt/jumpserver.sql


cd /opt/setuptools
./jmsctl.sh stop
docker rm jms_koko jms_lion     
systemctl disable jms_core
mv /opt/jumpserver /opt/jumpserver_bak

mysqldump -h127.0.0.1 -P3306 -ujumpserver -p jumpserver > /opt/jumpserver.sql


docker cp jms_all:/opt/jumpserver /opt/jumpserver_bak
docker exec -it jms_all env | egrep "SECRET_KEY|BOOTSTRAP_TOKEN"

docker exec -it jms_all /bin/bash
mysqldump -h$DB_HOST -P$DB_PORT -u$DB_USER -p$DB_PASSWORD $DB_NAME > /opt/jumpserver.sql
exit

docker cp jms_all:/opt/jumpserver.sql /opt
docker stop jms_all


docker cp jms_core:/opt/jumpserver /opt/jumpserver_bak
docker exec -it jms_core env | egrep "SECRET_KEY|BOOTSTRAP_TOKEN"

docker exec -it jms_mysql /bin/bash
mysqldump -uroot jumpserver > /opt/jumpserver.sql
exit

docker cp jms_mysql:/opt/jumpserver.sql /opt
cd /opt/Dockerfile
docker-compose stop


cd /opt/jumpserver-installer-v2.28.8
./jmsctl.sh stop

./jmsctl.sh backup_db

# 如果是 gz 格式的需要先解压: gunzip /opt/jumpserver/db_backup/jumpserver-2021-01-22_19:28:24.sql.gz
mv /opt/jumpserver/db_backup/jumpserver-2021-01-22_19:28:24.sql /opt/jumpserver.sql

修改数据库字符集

if grep -q 'COLLATE=utf8_bin' /opt/jumpserver.sql; then
    cp /opt/jumpserver.sql /opt/jumpserver_bak.sql
    sed -i 's@COLLATE=utf8_bin@@g' /opt/jumpserver.sql
    sed -i 's@COLLATE utf8_bin@@g' /opt/jumpserver.sql
else
    echo "备份数据库字符集正确";
fi

迁移到新服务器

  • 将导出的 /opt/jumpserver.sql 拷贝要新的服务器上面
  • 下面以迁移到其他 CentOS7 服务器为例，实际操作过程中请自行替换对应的命令

vi /etc/yum.repos.d/MariaDB.repo

[mariadb]
name = MariaDB
baseurl = http://mirrors.ustc.edu.cn/mariadb/yum/10.6/centos7-amd64
gpgkey=http://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

yum clean all

yum -y install MariaDB-server
systemctl enable mariadb
systemctl start mariadb

mysql -uroot

create database jumpserver default charset 'utf8';
create user 'jumpserver'@'%' identified by 'rBi41SrDqlX4zsx9e1L0cqTP';
grant all on jumpserver.* to 'jumpserver'@'%';
flush privileges;
use jumpserver;
source /opt/jumpserver.sql;
exit;
mysql_upgrade -uroot


yum -y localinstall http://mirrors.ustc.edu.cn/mysql-repo/mysql57-community-release-el7.rpm
yum -y install mysql-community-server mysql-community-devel

sed -i "s@--initialize @--initialize-insecure @g" /usr/bin/mysqld_pre_systemd
systemctl enable mysqld
systemctl start mysqld

mysql -uroot

create database jumpserver default charset 'utf8';
set global validate_password_policy=LOW;
create user 'jumpserver'@'%' identified by 'rBi41SrDqlX4zsx9e1L0cqTP';
grant all on jumpserver.* to 'jumpserver'@'%';
flush privileges;
use jumpserver;
source /opt/jumpserver.sql;
exit;
mysql_upgrade -uroot


yum -y localinstall http://mirrors.ustc.edu.cn/mysql-repo/mysql80-community-release-el7.rpm
yum -y install mysql-community-server mysql-community-devel

if ! grep -q "sql_mode=" /etc/my.cnf; then
  echo "sql_mode=''" >> /etc/my.cnf
fi

sed -i "s@--initialize @--initialize-insecure @g" /usr/bin/mysqld_pre_systemd
systemctl enable mysqld
systemctl start mysqld

mysql -uroot

create database jumpserver default charset 'utf8';
set global validate_password.policy=LOW;
create user 'jumpserver'@'%' identified with mysql_native_password by 'rBi41SrDqlX4zsx9e1L0cqTP';
grant all on jumpserver.* to 'jumpserver'@'%';
flush privileges;
use jumpserver;
source /opt/jumpserver.sql;
exit;


vi /opt/jumpserver/config/config.txt

## MySQL数据库配置
DB_ENGINE=mysql
DB_HOST=mysql
DB_PORT=3306
DB_USER=root
DB_PASSWORD=rBi41SrDqlX4zsx9e1L0cqTP
DB_NAME=jumpserver

cd /opt/jumpserver-installerer-v2.28.8
./jmsctl.sh start

./jmsctl.sh stop

docker exec -it jms_mysql /bin/bash
# 如果变量 $MARIADB_ROOT_PASSWORD 不存在，请使用 $MYSQL_ROOT_PASSWORD
mysql -uroot -p$MARIADB_ROOT_PASSWORD

drop database jumpserver;
create database jumpserver default charset 'utf8';
exit
exit

./jmsctl.sh restore_db /opt/jumpserver.sql

  • 启动 jms_core 看 jumpserver.log 是否有报错

启动报错 Cannot add foreign key constraint

if grep -q 'COLLATE=utf8_bin' /opt/jumpserver.sql; then
    cp /opt/jumpserver.sql /opt/jumpserver_bak.sql
    sed -i 's@COLLATE=utf8_bin@@g' /opt/jumpserver.sql
    sed -i 's@COLLATE utf8_bin@@g' /opt/jumpserver.sql
else
    echo "备份数据库字符集正确";
fi

drop database jumpserver;
create database jumpserver default charset 'utf8';
source /opt/jumpserver.sql;