1，部署confluence服务（略）

自行破解，或者公司有钱的更省事儿
所有confluence文件主组均为confluence用户

mysql配置文件添加

character-set-server=utf8mb4
collation-server=utf8mb4_bin
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB
transaction-isolation=READ-COMMITTED
binlog_format=row

2，部署mysql（略）

 部署完成后执行sql

MariaDB [(none)]> create database confluence default character set utf8 collate utf8_bin;
MariaDB [(none)]> grant all on confluence.* to 'confluence'@'%' identified by '***';
MariaDB[(none)]> grant all on confluence.* to 'confluence'@'localhost' identified by'***';
MariaDB [(none)]> flush privileges;

3，导入mysql数据

image.png

去备份服务器取最近时间备份的sql文件还原数据

image.png

还原后的数据

image.png

4，还原备份数据

准备工作：扩容

image.png

将最近时间备份发送到confluence服务器

image.png

将备份文件导入对应目录下此处会显示该备份文件

image.png

路径：/var/atlassian/application-data/confluence/restore

导入后此处会看到备份的文件点击导入

image.png

5，等着！！！

image.png
image.png

报错

Review of the Confluence Application logs

An optimization to avoid this warning will be to add the setting 'useSSL=false' in your MySQL connection string as I understand your are not using SSL here. I will get back to you with the steps to implement in the action plan below.

1.  Shut down Confluence
2.  Backup <tt>/var/atlassian/application-data/confluence/confluence.cfg.xml</tt> 
3.  Edit <tt>/var/atlassian/application-data/confluence/confluence.cfg.xml</tt>
4.  Look for the database connection string (line 26)
o   Replace from 
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/confluence</property>
o   To 
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/confluence?useSSL=false</property>

5.  Restart Confluence

image.png

优化Tomcat

vim /opt/atlassian/confluence/bin/setenv.sh

image.png