docker部署jira(8.0.0)和confluence(6.14.1)

yum update -y
reboot

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

[root@jt-jira ~]# yum list mysql-community-server --showduplicates | sort -r
 * updates: mirrors.aliyun.com
mysql-community-server.x86_645.7.9-1.el7mysql57-community
mysql-community-server.x86_645.7.25-1.el7mysql57-community
mysql-community-server.x86_645.7.24-1.el7mysql57-community
mysql-community-server.x86_645.7.23-1.el7mysql57-community
mysql-community-server.x86_645.7.22-1.el7mysql57-community
mysql-community-server.x86_645.7.21-1.el7mysql57-community
mysql-community-server.x86_645.7.20-1.el7mysql57-community
mysql-community-server.x86_645.7.19-1.el7mysql57-community
mysql-community-server.x86_645.7.18-1.el7mysql57-community
mysql-community-server.x86_645.7.17-1.el7mysql57-community
mysql-community-server.x86_645.7.16-1.el7mysql57-community
mysql-community-server.x86_645.7.15-1.el7mysql57-community
mysql-community-server.x86_645.7.14-1.el7mysql57-community
mysql-community-server.x86_645.7.13-1.el7mysql57-community
mysql-community-server.x86_645.7.12-1.el7mysql57-community
mysql-community-server.x86_645.7.11-1.el7mysql57-community
mysql-community-server.x86_645.7.10-1.el7mysql57-community

yum list mysql-community-server

cat>/etc/my.cnf.d/client.cnf<<EOF
[client]
default-character-set=utf8
EOF

cat>/etc/my.cnf.d/mysql-clients.cnf<<EOF
[mysql]
default-character-set=utf8
EOF

cat>>/etc/my.cnf<<EOF
default-storage-engine=INNODB# 將預設儲存引擎設定為InnoDB
character_set_server=utf8mb4# 指定資料庫伺服器使用的字符集
innodb_default_row_format=DYNAMIC # 將預設行格式設定為DYNAMIC
innodb_large_prefix=ON# 啟用大字首
innodb_file_format=Barracuda# 將InnoDB檔案格式設定為Barracuda
innodb_log_file_size=2G# innodb_log_file_size至少為2G
EOF

systemctl enable --now mysqld

[root@jt-jira ~]# grep 'temporary password' /var/log/mysqld.log 
2019-02-18T09:07:42.064502Z 1 [Note] A temporary password is generated for root@localhost: E#xxxxxxx9Od

[root@jt-jira ~]# mysql_secure_installation 

Securing the MySQL server deployment.

Enter password for user root: <–初次執行輸入log裡的root密碼

The existing password for the user account root has expired. Please set a new password.

New password: <– 設定root使用者的密碼,複雜度不夠可能會被再次要求輸入

Re-enter new password: <– 再輸入一次你設定的密碼
The 'validate_password' plugin is installed on the server.
The subsequent steps will run with the existing configuration
of the plugin.
Using existing password for root.

Estimated strength of the password: 100
Change the password for root ? ((Press y|Y for Yes, any other key for No) : No <– 輸入No,前面設定過root密碼了

 ... skipping.
By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y <– 是否刪除匿名使用者，輸入y回車
Success.


Normally, root should only be allowed to connect from
'localhost'. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y <–是否禁止root遠端登入,看需求,如果開發用得多就不禁止,這裡動得少我是直接禁止掉的
Success.

By default, MySQL comes with a database named 'test' that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.


Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y<– 是否刪除test資料庫，輸入y回車
 - Dropping test database...
Success.

 - Removing privileges on test database...
Success.

Reloading the privilege tables will ensure that all changes
made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y 是否重新載入許可權表，輸入y回車
Success.

All done!

sed -ri '/temporary password/d' /var/log/mysqld.log

mysql -uroot -p

mysql> create database jira default character set utf8 collate utf8_bin;
mysql> grant all on jira.* to 'jira'@'%' identified by 'v8xxxxxxx1';

sudo curl -L "https://github.com/docker/compose/releases/download/1.23.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
chmod +x /usr/local/bin/docker-compose

cp /usr/share/bash-completion/completions/docker /etc/bash_completion.d/
systemctl enable --now docker

+ '[' -r /opt/atlassian/jira/bin/setenv.sh ']'
+ . /opt/atlassian/jira/bin/setenv.sh


$ cat /opt/atlassian/jira/bin/setenv.sh
...
JAVA_OPTS="-Xms${JVM_MINIMUM_MEMORY} -Xmx${JVM_MAXIMUM_MEMORY} ${JVM_CODE_CACHE_ARGS} ${JAVA_OPTS} ${JVM_REQUIRED_ARGS} ${DISABLE_NOTIFICATIONS} ${JVM_SUPPORT_RECOMMENDED_ARGS} ${JVM_EXTRA_ARGS} ${JIRA_HOME_MINUSD} ${START_JIRA_JAVA_OPTS}"
...
export JAVA_OPTS

[root@jt-jira jira]# docker exec jira sh -c 'echo $LANG'
C.UTF-8

version: '3.7'
services:
jira:
image: zhangguanzhang/atlassian-jira-software:8.0.0
container_name: jira
hostname: jira
init: true
volumes:
- JIRA_HOME_data:/var/atlassian/jira
- JIRA_log_data:/opt/atlassian/jira/logs
- /etc/localtime:/etc/localtime:ro
ports:
- '8080:8080'
logging:
driver: json-file
options:
max-file: '3'
max-size: 100m
volumes:
JIRA_HOME_data: {}
JIRA_log_data: {}

cat>>/etc/my.cnf<<EOF
character-set-server=utf8
collation-server=utf8_bin# 將預設字符集指定為UTF-8
default-storage-engine=INNODB# 將預設儲存引擎設定為InnoDB
max_allowed_packet=256M# max_allowed_packet至少為256M
innodb_log_file_size=2GB# innodb_log_file_size 至少為2GB
transaction-isolation=READ-COMMITTED# 確保資料庫的全域性事務隔離級別已設定為READ-COMMITTED
binlog_format=row# 檢查二進位制日誌記錄格式是否配置為使用“基於行”的二進位制日誌記錄
EOF