依赖软件说明
cx_Oracle cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm virtualenv virtualenv-15.2.0.tar.gz (通过互联网安装'pip2.7 install virtualenv'的版本是最新版) pip setuptools-19.6.tar.gz pip-8.0.2.tar.gz PyH PyH-0.1.1.tar.gz Celery celery-4.1.1.zip WTForms WTForms-JSON-0.3.3.tar.gz Themis themis-master.zip
软件获取链接
Themis https://github.com/CreditEaseDBA/Themis cx_Oracle https://sourceforge.net/projects/cx-oracle/files/5.1.2/ virtualenv https://virtualenv.pypa.io/en/latest/installation pyh https://github.com/hanxiaomax/pyh Celery https://github.com/celery/celery/tree/v4.1.1 wtforms https://github.com/kvesteri/wtforms-json WTForms https://pypi.org/project/WTForms-JSON/#files PyH https://code.google.com/archive/p/pyh/downloads
创建账户
useradd sqltuning
passwd sqltuning
sqltuning
后面的操作除了virtualenv安装需要切换到root用户,其他的都默认在sqltuning用户下安装
安装cx_Oracle
rpm -Uvh cx_Oracle-5.1.2-11g-py27-1.x86_64.rpm
rpm -Uvh oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
rpm -Uvh oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
python
import cx_Oracle
安装pip
cd /opt/media
tar -zxvf setuptools-19.6.tar.gz
cd /opt/media/setuptools-19.6
python2.7 setup.py build
python2.7 setup.py install
tar -zxvf pip-8.0.2.tar.gz
cd /opt/media/pip-8.0.2
python2.7 setup.py build
python2.7 setup.py install
互联网安装 virtualenv
pip2.7 install virtualenv
注:此部需要开通互联网访问权限
本地安装virtualenv
cd /opt/media
tar -zxvf virtualenv-15.2.0.tar.gz
cd /opt/media/virtualenv-15.2.0
python2.7 setup.py build
python2.7 setup.py install
安装其他依赖
初始化虚拟环境
su - sqltuning
cd /home/sqltuning
virtualenv python-project --python=python2.7
source /home/sqltuning/python-project/bin/activate
解释一下上面的命令:virtualenv的第二个参数python-project是我们建立的虚拟环境的名称,这个名称我们虽然可以随便定义,但是后面supervisor的配置中使用了此名称,建议使用默认的,大家如果对python比较熟悉,可以随意定义。后面我们指定了python的版本,--python可以不加,默认会使用系统自带的python版本构建虚拟环境,当有多个版本的python时,可以使用此命令指定版本
下面使用source初始化虚拟环境,以后安装的包依赖等都会被装到/home/sqltuning/python-project/home/themis-test/python2.7/lib/python2.7/site-packages这里。
如果可以联网,进入源代码目录使用如下命令
cp /opt/media/Themis-master.zip /home/sqltuning/Themis-master.zip
chown sqltuning.sqltuning /home/sqltuning/Themis-master.zip
su - sqltuning
unzip Themis-master.zip
cd Themis-master
pip2.7 install -r requirement.txt
注:pip2.7 install -r requirement.txt 报错
安装pyh
cp /opt/media/pyh-master.zip /home/sqltuning/pyh-master.zip
cd /home/sqltuning
chown sqltuning.sqltuning pyh-master.zip
su - sqltuning
unzip pyh-master.zip
cd /home/sqltuning/pyh-master
python2.7 setup.py install
注:/usr/lib/python2.7/site-packages和/usr/lib64/python2.7/site-packages中均没有pyh.py,而且没有编译成pyh.pyc
安装pyh-0.1.1
cd /opt/media
tar -zxvf PyH-0.1.1.tar.gz
cd PyH-0.1.1
python2.7 setup.py install
安装celery
cp /opt/media/celery-4.1.1.zip /home/sqltuning/celery-4.1.1.zip
cd /home/sqltuning
chown sqltuning.sqltuning celery-4.1.1.zip
su - sqltuning
unzip celery-4.1.1.zip
cd /home/sqltuning/celery-4.1.1
python2.7 setup.py build
su -
cd /home/sqltuning/celery-4.1.1
python2.7 setup.py install #root执行安装
本地安装MySQL-Python
cd /opt/media
cp /opt/media/MySQL-python-1.2.3.tar.gz /home/sqltuning/MySQL-python-1.2.3.tar.gz
chown sqltuning.sqltuning /home/sqltuning/MySQL-python-1.2.3.tar.gz
su - sqltuning
tar -zxvf /home/sqltuning/MySQL-python-1.2.3.tar.gz
cd /home/sqltuning/MySQL-python-1.2.3
vi site.cfg
python2.7 setup.py build
su -
python2.7 setup.py install
vi /home/sqltuning/MySQL-python-1.2.3/site.cfg
注:报错未解决
互联网安装MySQL-python(本次安装方式)
pip2.7 install mysql-python
本地安装 WTForms-JSON (本次安装未验证,采用"pip2.7 install WTForms-JSON")
cd /opt/media
chown sqltuning.sqltuning WTForms-JSON-0.3.3.tar.gz
cp /opt/media/WTForms-JSON-0.3.3.tar.gz /home/sqltuning/WTForms-JSON-0.3.3.tar.gz
su - sqltuning
tar -zxvf WTForms-JSON-0.3.3.tar.gz
cd WTForms-JSON-0.3.3
python2.7 setup.py build
su -
python2.7 setup.py install
安装percona-toolkit
至此所有软件安装完毕