confluence备份和迁移
背景:由于confluence原机器上中了挖矿病毒,杀完病毒过几天又有了,考虑在三,绝对新找一台机器迁移。据评估数据量有100G,采用conference自带的备份迁移较慢。中间出现了导入到90%报错。决定采用数据库的迁移方案
备份
1.备份confluence的两个目录,即安装目录和数据主目录。
2.完整备份数据库
备份安装目录
#默认安装目录
/opt/atlassian/
tar czf atlassian.tar.gz atlassian
备份数据主目录
#默认数据目录
/var/atlassian/application-data/confluence
tar czf confluence.tar.gz /var/atlassian/application-data/confluence
备份数据库
mysqldump -u root -p confluence > confluence.sql
恢复
恢复数据库
Mysql>create database confluence character set UTF8mb3; #注意跟原先数据库类型必须一致
Mysql>grant all on confluence.* to confluence@"%"identified by "confluence";
Mysql>grant all on confluence.* to confluence@"localhost" identified by "confluence";
[root@localhost /]# mysql -uconfluence -p confluence < confluence.sql
恢复安装目录与家目录并修改文件夹用户与组
[root@confluence ~]# cd /opt/
[root@confluence opt]# tar zxf atlassian.tar.gz
[root@confluence opt]# cd atlassian/confluence/
[root@confluence confluence]# chown confluence:confluence -R work
[root@confluence confluence]# chown confluence:confluence -R temp
[root@confluence confluence]# chown confluence:confluence -R logs
[root@confluence confluence]# chown confluence:confluence -R conf
[root@confluence /]# cd /var/atlassian/
[root@confluence atlassian]# tar zxf confluence.tar.gz
[root@confluence atlassian]# chown confluence:confluence -R confluence
修改数据源
修改/var/atlassian/confluence/confluence.cfg.xml
启动confluence
[root@confluence ~]# cd /opt/atlassian/confluence/bin/
[root@confluenceT bin]# ./start-confluence.sh
查看日志报错
[root@confluence bin]# tail -f /var/atlassian/confluence/logs/atlassian-confluence.log
有出现这个报错
exception信息
MySQL session isolation level ‘REPEATABLE-READ’ is no longer supported. Session isolation level must be ‘READ-COMMITTED’. See http://confluence.atlassian.com/x/GAtmDg
数据库未设置隔离
#设置全局事务隔离级别
mysql> set global transaction isolation level read committed;