安装必要的系统工具:
yum install -y yum-utils device-mapper-persistent-data lvm2
添加软件源信息
yum-config-manager --add-repo https://mirrors.h****n.com/package/setting/docker-ce.repo
yum clean all
yum makecache fast
安装docker-CE
yum -y install docker-ce
安装docker-compose
yum -y install docker-compose
授予可执行权限
chmod +x /usr/bin/docker-compose
安装git
yum install -y git
systemctl start docker
mkdir -p /etc/docker
tee /etc/docker/daemon.json <<-'EOF'
{
"registry-mirrors":["https://docker.h****n.com"]
}
EOF
systemctl daemon-reload
systemctl restart docker
下载release文件(网比较慢)
https://archerydms.com/installation/docker/
解压
tar xf Archery-1.8.5.tar.gz
进入解压目录后,再进入src子目录,再进入docker-compose子目录
用docker部署archery:
docker-compose -f docker-compose.yml up -d
docker exec -ti archery /bin/bash
cd /opt/archery
source /opt/venv4archery/bin/activate
python3 manage.py makemigrations sql
python3 manage.py migrate
python3 manage.py dbshell<sql/fixtures/auth_group.sql
python3 manage.py dbshell<src/init_sql/mysql_slow_query_review.sql
python3 manage.py createsuperuser
exit回到linux
docker restart archery
docker logs archery -f --tail=10
logs/archery.log
网页访问
http://10.10.3.106:9123
注:本机本地运行的mysql和docker冲突,一个起需要关另一个
查看正在运行的docker会发现一共起了四个容器
docker ps
进入容器
docker exec -it deb0f28d9275 bash
SQL优化:
https://archerydms.com/modules/sql_optimize/
其他参考:
https://archerydms.com/modules/tools/