數(shù)據(jù)庫(kù)運(yùn)維平臺(tái)Inception_web 版安裝
武漢網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián),武漢網(wǎng)站設(shè)計(jì)制作,有大型網(wǎng)站制作公司豐富經(jīng)驗(yàn)。已為武漢數(shù)千家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\成都外貿(mào)網(wǎng)站建設(shè)公司要多少錢,請(qǐng)找那個(gè)售后服務(wù)好的武漢做網(wǎng)站的公司定做!
前言
Inception是集審核SQL、執(zhí)行SQL、回滾于一體的一個(gè)自動(dòng)化數(shù)據(jù)庫(kù)運(yùn)維系統(tǒng)
環(huán)境:
系統(tǒng): centos 6.8
Ip: 192.168.137.38
Python:Python2.7
部署步驟:
# cd /usr/src/
#wgethttps://github.com/MySQL-inception/inception/archive/master.zip
#unzip master.zip
#yum -y install gcc gcc-c++ cmake bison openssl-devel ncurses-devel mysql-devel
#cd inception-master
#./inception_build.sh debug [Xcode] #[Xcode] 指定平臺(tái) 默認(rèn)linux
#echo $? #返回0,則為成功
#編輯配置文件,如果沒有就創(chuàng)建
#vim /etc/inc.cnf
[inception]
general_log=1
general_log_file=inc.log
port=6669
socket=/tmp/inc.socket
character-set-client-handshake=0
character-set-server=utf8
inception_remote_system_password=admin
inception_remote_system_user=myadmin
inception_remote_backup_port=3308
inception_remote_backup_host=127.0.0.1
inception_support_charset=utf8
inception_enable_nullable=0
inception_check_primary_key=1
inception_check_column_comment=1
inception_check_table_comment=1
inception_osc_min_table_size=1
inception_osc_bin_dir=/usr/bin
inception_osc_chunk_time=0.1
inception_ddl_support=1
inception_enable_blob_type=1
inception_check_column_default_value=1
#先按esc,然后同時(shí)按shift跟:輸入wq!保存退出
#下面的要根據(jù)自己解壓壓縮包文件目錄進(jìn)行運(yùn)行,加載文件
#/usr/src/inception-master/debug/mysql/bin/Inception --defaults-file=/etc/inc.cnf &
#登錄mysql
#mysql -uroot -h227.0.0.1 -P 6669
#在mysql里面輸入以下命令
#inception get variables;
#升級(jí)Python為2.7
#cd /usr/src/
#wgethttp://www.python.org/ftp/python/2.7.3/Python-2.7.3.tgz
#tar -xf Python-2.7.3.tgz
#cd Python-2.7.3
#./configure --prefix=/usr/local/python27
#echo $?
#make && make install
#echo $?
#mv /usr/bin/python /usr/bin/python26
#ln -s /usr/local/python27/bin/python2.7 /usr/bin/python
#vim /usr/bin/yum
#把#!/usr/bin/python改為#!/usr/bin/python26
#輸入Python看是不是2.7 ,然后exit()退出,輸入yum list,看看yum源是否正常
#cd /usr/src/
#wget https://bootstrap.pypa.io/ez_setup.py --no-check-certificate
#python ez_setup.py
#[root@localhost ~]# find / -name easy_install-2.7
/usr/local/python27/bin/easy_install-2.7
#cd /usr/local/python27/bin/
#./easy_install-2.7 pip
#echo $?
#[root@localhost bin]# find / -name pip2.7
/usr/local/python27/bin/pip2.7
#./pip2.7 install flask_wtf
#./pip2.7 install flask-script
#./pip2.7 install flask-debugtoolbar
#./pip2.7 install MySQL-python
#cd /usr/src/
#yum install git
#git clonehttps://github.com/dbalihui/inception_web.git
#cd inception_web/app/
#vim inception.py #(注意:紅色部分為自己定義部分)
coding=utf-8
import MySQLdb
def table_structure(mysql_structure):
sql1='/*--user=root;--password=root;--host=127.0.0.1;--execute=1;--port=3306;*/\
inception_magic_start;\
usetest_3;'
sql2='inception_magic_commit;'
sql = sql1 + mysql_structure + sql2
try:
conn=MySQLdb.connect(host='127.0.0.1',user='root',passwd='root',db='test_3',port=6669,use_unicode=True, charset="utf8")
cur=conn.cursor()
ret=cur.execute(sql)
result=cur.fetchall()
num_fields = len(cur.description)
field_names = [i[0] for i in cur.description]
print field_names
for row in result:
print row[0], "|",row[1],"|",row[2],"|",row[3],"|",row[4],"|",row[5],"|",row[6],"|",row[7],"|",row[8],"|",row[9],"|",row[10]
cur.close()
conn.close()
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
return result[1][4].split("\n")
#cd .. #返回上一層
# ./run.py runserver --host192.168.137.38 & #自己的服務(wù)器ip
瀏覽器輸入:ip:5000 例如:192.168.137.38:5000
#vim /etc/sysconfig/iptables #開放3306,5000端口
-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 5000 -j ACCEPT
#service iptables restart