Centos 7 部署 sqladvisor-web1

1、安装git、wget、Mysql和pip
yum install git
yum intall wget
2、安装mysql5.7
wget http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
sudo yum install mysql-community-server
查找mysql5.7的初始密码
cat /var/log/mysqld.log | grep "temporary password"
登录mysql更改root密码及远程权限
set global validate_password_policy=0; 关闭密码policy
select @@validate_password_length; 查看密码长度
alter user 'root'@'localhost' identified by '12345678'; 更改root密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345678' WITH GRANT OPTION;
flush privileges; 允许root任何主机上远程访问
创建sqladvisor库
CREATE DATABASE IF NOT EXISTS sqladvisor default charset utf8 COLLATE utf8_general_ci;
安装mysql
yum -y install epel-release
yum install python-pip
yum install gcc
3、配置项目
yum install python-devel mysql-community-devel -y

git clone https://github.com/zyw/sqladvisor-web.git
cd sqladvisor_web
安装依赖包
pip install -r requirements.txt
编辑配置文件
vim config.py 更换自己的root密码
SQLALCHEMY_DATABASE_URI = os.environ.get('DEV_DATABASE_URL') or 'mysql://root:111111@localhost/sqladvisor'
恢复数据库
python manage.py db init
python manage.py db migrate
python manage.py db upgrade
解压sqlparser.tar.gz
解压sqlparser.tar.gz到/usr/local
cp sqlparser.tar.gz /usr/local
cd /usr/local
tar -zxf sqlparser.tar.gz
启动服务
python manage.py runserver --host 0.0.0.0
访问http://127.0.0.1:5000

4、部署sqladvisor-web

安装gunicorn
pip install gunicorn
启动服务
gunicorn manage:app -p manage.pid -b 0.0.0.0:8000 -D