1、拉取mysql镜像
docker pull mysql:5.7
2、创建mysql数据目录
mkdir /date/mysql/logs/
mkdir /date/mysql/conf/
mkdir /date/mysql/data/
3、mysql配置文件编写
vi /date/mysql/conf/mysql.cnf
[mysqld]
default-storage-engine=INNODB
character_set_server=utf8mb4
innodb_default_row_format=DYNAMIC
innodb_large_prefix=ON
innodb_file_format=Barracuda
innodb_log_file_size=2G
4、创建mysql容器
docker run -itd --name jireadb -p 3306:3306 -v /data/mysql/logs/:/dockerdate/log/mysql -v /data/mysql/data:/var/lib/mysql/ -v /data/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=xxx mysql:5.7
5、创建jira&confluence数据库
mysql -uroot -pxxx -h127.0.0.1
# 新建jiradb库 新建用户授权 jirauser,xxxxxx
CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE USER jirauser IDENTIFIED BY 'xxxxxx';
GRANT ALL ON jiradb.* to 'jirauser'@'%' ;
# 新建wikidb库 wikiuser , xxxxxx
CREATE DATABASE wikidb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
CREATE USER wikiuser IDENTIFIED BY 'xxxxxx';
GRANT ALL ON wikidb.* to 'wikiuser'@'%' ;
# 设置全局的事务隔离级别为 读取已提交
set global transaction_isolation='read-committed';