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
