inception安装步骤

快来打我* 2024-02-18 21:07 11阅读 0赞

1. 下载：

https://github.com/mysql-inception/inception 选择下载：

Downloda ZIP

注意安装包：

yum -y install cmake libncurses5-dev libssl-dev g++ bison openssl-devel.x86\_64

`mkdir` `/usr/local/inception`

`mkdir` `-p` `/data/inception`

`mkdir` `/data/socket`

`mkdir` `/data/temp`

2. 下载后解压编译：

\# unzip inception-master.zip

\# cd inception-master

\# cmake .

\# cmake -DWITH\_DEBUG=OFF -DCMAKE\_INSTALL\_PREFIX=/usr/local/inception -DMYSQL\_DATADIR=/data/inception -DWITH\_SSL=yes -DCMAKE\_BUILD\_TYPE=RELEASE-DWITH\_ZLIB=bundled-DMY\_MAINTAINER\_CXX\_WARNINGS="-Wall -Wextra -Wunused -Wwrite-strings -Wno-strict-aliasing -Wno-unused-parameter -Woverloaded-virtual" -DMY\_MAINTAINER\_C\_WARNINGS="-Wall -Wextra -Wunused -Wwrite-strings -Wno-strict-aliasing -Wdeclaration-after-statement"

\# make && make install

\# sh -x inception\_build.sh debug

报错如下：

\-- Build files have been written to: /root/inception-master

\+ '\[' x '!=' Xcode '\]'

\+ make install

make: \*\*\* 没有规则可以创建目标“install”。 停止。

\# sh inception\_build.sh debug \[linux\]

make: \*\*\* 没有规则可以创建目标“install”。 停止。

解决办法：\# make -j6 && make install

## inception错误处理make\[2\]: \*\*\* \[sql/CMakeFiles/sql.dir/sql\_yacc.cc.o\] Error 1 ##

## 问题 ##

make\[2\]: *\** \[sql/CMakeFiles/sql.dir/sql\_yacc.cc.o\] Error 1  
make\[1\]: *\** \[sql/CMakeFiles/sql.dir/all\] Error 2  
make: *\** \[all\] Error 2

按照文档的提示  
[http://mysql-inception.github.io/inception-document/install/][http_mysql-inception.github.io_inception-document_install]  
仔细检查，发现bison的版本较高，使用apt-get install bison安装的版本为3.0.2，而手册建议的版本为2.6之前的。

## 解决方案 ##

下载、安装bison2.5.1后再重新安装inception

[http://ftp.gnu.org/gnu/bison/bison-2.5.1.tar.gz][http_ftp.gnu.org_gnu_bison_bison-2.5.1.tar.gz]

./configure

make && make install

另外，请注意建议通过sh执行inception\_build.sh，如  
*sh inception\_build.sh debug*

3、完成后添加配置文件

`[inception]`

`` `general_log=1` `#这个参数就是原生的MySQL的参数，用来记录在Inception服务上执行过哪些语句，用来定位一些问题等`

`` `general_log_file=` `/data/inception/inception` `.log` `#设置general log写入的文件路径`

`` `port=6669` `#Inception的服务端口`

`` `socket=` `/data/socket/inc` `.socket` `#Inception的套接字文件存放位置`

`` `character-` `set` `-client-handshake=0`

`` `character-` `set` `-server=utf8` `#mysql原生参数`

`` `#备份服务器信息`

`` `inception_remote_system_password=root`

`` `inception_remote_system_user=123456@`

`` `inception_remote_backup_port=3306`

`` `inception_remote_backup_host=127.0.0.1`

`` `inception_support_charset=utf8mb4` `#表示在建表或者建库时支持的字符集，如果需要多个，则用逗号分隔，影响的范围是建表、设置会话字符集、修改表字符集属性等`

`` `inception_enable_nullable=0` `#创建或者新增列时如果列为NULL，不报错`

`` `inception_check_primary_key=1` `#建表时，如果没有主键，则报错`

`` `inception_check_column_comment=1` `#建表时，列没有注释时报错`

`` `inception_check_table_comment=1` `#建表时，表没有注释时报错`

`` `inception_osc_min_table_size=1` `# 这个参数实际上是一个OSC的开关，如果设置为0，则全部ALTER语句都走OSC，如果设置为非0，则当这个表占用空间大小大于这个值时才使用OSC方式`

`` `inception_osc_bin_dir=` `/data/temp` `#用于指定pt-online-schema-change脚本的位置，不可修改，在配置文件中设置`

`` `inception_osc_chunk_time=0.1` `#对应OSC参数--chunk-time`

`` `inception_enable_blob_type=1` `#检查是不是支持BLOB字段，包括建表、修改列、新增列操作 默认开启`

`` `inception_check_column_default_value=1` `#检查在建表、修改列、新增列时，新的列属性是不是要有默认值`

注：inc.cnf 配置上的参数意义可以参考

[http://mysql-inception.github.io/inception-document/variables/][http_mysql-inception.github.io_inception-document_variables]

[http://blog.itpub.net/27808137/viewspace-1816388/][http_blog.itpub.net_27808137_viewspace-1816388]

注：启动Inception. 现在就到启动时间了，那么启动有两种方式，和MySQL是一样的   
1. Inception –defaults-file=inc.cnf  
2. Inception –port=6669

4、启动inception服务

/usr/local/inception/bin/Inception --defaults-file=/etc/inc.cnf //启动inception 有2种方式，在这采用配置文件启动方式。

`/use/local/inception/bin/Inception--port` `=6669 注：记得在防火墙开启6669 端口`

5、测试inception。

测试之前创建一个可以连接mysql的用户：用户名wwn 密码：123456 IP:127.0.0.1 保证能正常登陆mysql即可。

\# mysql -uroot -h127.0.0.1 -P6669 //登陆inception

登录上去之后，再执行一个命令：  
`inception get variables;`

`输出了所有的变量，恭喜你，已经启动成功了，都说了非常简单。`

root@wiki:\[/home/inception-master\]mysql -uroot -h127.0.0.1 -P6669  
Welcome to the MySQL monitor. Commands end with ; or \\g.  
Your MySQL connection id is 1  
Server version: Inception2.1.50 1  
  
Copyright (c) 2009-2018 Percona LLC and/or its affiliates  
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.  
  
Oracle is a registered trademark of Oracle Corporation and/or its  
affiliates. Other names may be trademarks of their respective  
owners.  
  
Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.  
  
mysql> inception get variables;  
\+------------------------------------------+-------------------------------------------+  
| Variable\_name | Value |  
\+------------------------------------------+-------------------------------------------+  
| autocommit | OFF |  
| bind\_address | \* |  
| character\_set\_system | utf8 |  
| character\_sets\_dir | /home/inception-master/share/charsets/ |  
| connect\_timeout | 10 |  
| date\_format | %Y-%m-%d |  
| datetime\_format | %Y-%m-%d %H:%i:%s |  
| general\_log | ON |  
| general\_log\_file | inc.log |  
| inception\_check\_autoincrement\_datatype | ON |  
| inception\_check\_autoincrement\_init\_value | ON |  
| inception\_check\_autoincrement\_name | ON |  
| inception\_check\_column\_comment | ON |  
| inception\_check\_column\_default\_value | ON |  
| inception\_check\_dml\_limit | ON |  
| inception\_check\_dml\_orderby | ON |  
| inception\_check\_dml\_where | ON |  
| inception\_check\_identifier | ON |  
| inception\_check\_index\_prefix | ON |  
| inception\_check\_insert\_field | ON |  
| inception\_check\_primary\_key | ON |  
| inception\_check\_table\_comment | ON |  
| inception\_check\_timestamp\_default | ON |  
| inception\_ddl\_support | ON |  
| inception\_enable\_autoincrement\_unsigned | ON |  
| inception\_enable\_blob\_type | ON |  
| inception\_enable\_column\_charset | OFF |  
| inception\_enable\_enum\_set\_bit | OFF |  
| inception\_enable\_foreign\_key | OFF |  
| inception\_enable\_identifer\_keyword | OFF |  
| inception\_enable\_not\_innodb | OFF |  
| inception\_enable\_nullable | OFF |  
| inception\_enable\_orderby\_rand | OFF |  
| inception\_enable\_partition\_table | OFF |  
| inception\_enable\_pk\_columns\_only\_int | OFF |  
| inception\_enable\_select\_star | OFF |  
| inception\_enable\_sql\_statistic | ON |  
| inception\_max\_char\_length | 16 |  
| inception\_max\_key\_parts | 5 |  
| inception\_max\_keys | 16 |  
| inception\_max\_primary\_key\_parts | 5 |  
| inception\_max\_update\_rows | 10000 |  
| inception\_merge\_alter\_table | ON |  
| inception\_osc\_alter\_foreign\_keys\_method | none |  
| inception\_osc\_bin\_dir | /usr/bin |  
| inception\_osc\_check\_alter | ON |  
| inception\_osc\_check\_interval | 5.000000 |  
| inception\_osc\_check\_replication\_filters | ON |  
| inception\_osc\_chunk\_size | 1000 |  
| inception\_osc\_chunk\_size\_limit | 4.000000 |  
| inception\_osc\_chunk\_time | 0.100000 |  
| inception\_osc\_critical\_thread\_connected | 1000 |  
| inception\_osc\_critical\_thread\_running | 80 |  
| inception\_osc\_drop\_new\_table | ON |  
| inception\_osc\_drop\_old\_table | ON |  
| inception\_osc\_max\_lag | 3.000000 |  
| inception\_osc\_max\_thread\_connected | 1000 |  
| inception\_osc\_max\_thread\_running | 80 |  
| inception\_osc\_min\_table\_size | 1 |  
| inception\_osc\_on | ON |  
| inception\_osc\_print\_none | ON |  
| inception\_osc\_print\_sql | ON |  
| inception\_osc\_recursion\_method | processlist |  
| inception\_password | |  
| inception\_read\_only | OFF |  
| inception\_remote\_backup\_host | 127.0.0.1 |  
| inception\_remote\_backup\_port | 3306 |  
| inception\_remote\_system\_password | \*CFF486455239DB377A8E258CD199C8F12DE10AB8 |  
| inception\_remote\_system\_user | thunder |  
| inception\_support\_charset | utf8 |  
| inception\_user | |  
| interactive\_timeout | 28800 |  
| max\_allowed\_packet | 1073741824 |  
| max\_connect\_errors | 100 |  
| max\_connections | 151 |  
| net\_buffer\_length | 16384 |  
| net\_read\_timeout | 30 |  
| net\_write\_timeout | 60 |  
| port | 6669 |  
| query\_alloc\_block\_size | 8192 |  
| query\_prealloc\_size | 8192 |  
| socket | /tmp/inc.socket |  
| thread\_handling | one-thread-per-connection |  
| thread\_stack | 262144 |  
| time\_format | %H:%i:%s |  
| version | Inception2.1.50 |  
| version\_comment | Source distribution |  
| version\_compile\_machine | x86\_64 |  
| version\_compile\_os | Linux |  
| wait\_timeout | 28800 |  
\+------------------------------------------+-------------------------------------------+  
90 rows in set (0.00 sec)  
  
mysql>

下面用脚本测试相关的审核语句：

1. 审核表创建语句测试：

\[root@localhost ~\]\# cat aa.py

\#!/usr/bin/python

\#-\\\*-coding: utf-8-\\\*-

import MySQLdb

sql='/\*--user=wwn;--password=123456;--host=127.0.0.1;--execute=1;--port=3306;\*/\\

inception\_magic\_start;\\

use test;\\

CREATE TABLE \`alifeba\_user\` (\\

\`ID\` int(11) unsigned NOT NULL auto\_increment comment"aaa",\\

\`username\` varchar(50) NOT NULL Default "" comment"aaa",\\

\`realName\` varchar(50) NOT NULL Default "" comment"aaa",\\

\`age\` int(11) NOT NULL Default 0 comment"aaa",\\

PRIMARY KEY (\`ID\`)\\

) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COMMENT="AAAA";\\

inception\_magic\_commit;'

try:

conn=MySQLdb.connect(host='127.0.0.1',user='wwn',passwd='123456',db='wwn',port=6669)

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\])

2. 审核增删改语句

\[root@localhost ~\]\# cat bb.py

\#!/usr/bin/python

\#-\\\*-coding: utf-8-\\\*-

import MySQLdb

sql='/\*--user=wwn;--password=123456;--host=127.0.0.1;--execute=1;--enable-remote-backup;--port=3306;\*/\\

inception\_magic\_start;\\

use wwn;\\

INSERT INTO v9\_wap(siteid,sitename,logo,domain,setting) VALUES ("12","aa","bb","cc","dd");\\

delete from v9\_wap where siteid=11;\\

update v9\_wap set sitename="haha" where siteid=10;\\

inception\_magic\_commit;'

try:

conn=MySQLdb.connect(host='127.0.0.1',user='wwn',passwd='123456',db='wwn',port=6669)

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\])

**安装 web封装的界面**

下载：[https://github.com/dbalihui/inception\_web][https_github.com_dbalihui_inception_web]

上传inception\_web-master.zip包到服务器

### 环境配置 ###

python2.7 + flask

先安装依赖模块

pip install flask\_wtf

pip install flask-script

pip install flask-debugtoolbar

pip install MySQL-python

### 使用方法 ###

先将app目录中的inception.py文件里的账号密码改成自己的

记得use sql\_check这里要改成自己的数据库名字

在inception\_web目录下运行./run.py runserver --host 0.0.0.0

使用浏览器访问你的IP [http://192.168.xx.xxx:5000/][http_192.168.xx.xxx_5000]

运行报错的话是因为没有安装flask组件，请使用pip install xx安装相关组件

所以先升级Python2.7

\# wget https://www.python.org/ftp/python/2.7.10/Python-2.7.10.tgz --no-check-certificate

\# tar -xvf Python-2.7.10.tar

\# cd Python-2.7.10

\# ./configure && make && make install

\# /usr/local/bin/python -V

\# mv /usr/bin/python /usr/bin/python2.6.6

\# ln -s /usr/local/bin/python /usr/bin/python

\# python -V //验证版本

\# vim /usr/bin/yum //修改\#!/usr/bin/python 为\#!/usr/bin/python2.6.6,因为yum安装依赖的是2.6版本的python

下面安装模块：

首先安装一个pip

\# yum -y install python-pip //这种安装处理是2.6版本的

\# wget https://bootstrap.pypa.io/ez\_setup.py --no-check-certificate //下载一个ez\_setup 安装pip2.7版本的

\# python2.7 ez\_setup.py

\# easy\_install-2.7 pip

\# pip2.7 install MySQL-python

\# yum install mysql-devel //如果报错看看是不是缺失mysql-devel包。

\# pip2.7 install flask\_wtf

\# pip2.7 install flask-script

\# pip2.7 install flask-debugtoolbar

安装步骤：

\# unzip inception\_web-master.zip

\# cd inception\_web-master

\# vim inception.py //修改配置文件

![70][]

在inception\_web-master目录下运行

\# ./run.py runserver --host 0.0.0.0 //启动服务

在浏览器输入http://192.168.\*\*:5000

![70 1][]

**解决：**

查看自身系统的Python 版本 python -V

先升级到Python 2.7 版本，下载[https://www.python.org/downloads/release/python-2711/][https_www.python.org_downloads_release_python-2711]

并上传到服务器、解压

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>tar</code>&nbsp; 
      <code>-zxvf&nbsp;Python-2.7.11.tgz&nbsp;</code> 
     </div> 
     <div> 
      <code>cd</code>&nbsp; 
      <code>Python-2.7.11/</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

编译安装

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>.</code> 
      <code>/configure</code> 
     </div> 
     <div> 
      <code>make</code>&nbsp; 
      <code>&amp;&amp;&nbsp;</code> 
      <code>make</code>&nbsp; 
      <code>install</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

查看版本信息

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>/usr/local/bin/python</code>&nbsp; 
      <code>-V</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

建立软连接，使系统默认的 python指向python2.7

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>mv</code>&nbsp; 
      <code>/usr/bin/python</code>&nbsp; 
      <code>/usr/bin/python2</code> 
      <code>.6.6</code> 
     </div> 
     <div> 
      <code>ln</code>&nbsp; 
      <code>-s&nbsp;</code> 
      <code>/usr/local/bin/python</code>&nbsp; 
      <code>/usr/bin/python</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

验证版本

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>python&nbsp;-V</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

注：

修改\#!/usr/bin/python 为\#!/usr/bin/python2.6.6,因为yum安装依赖的是2.6版本的python,否则yum 安装用不了

![70 2][]

下载一个ez\_setup 安装pip2.7版本的

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>wget&nbsp;https:</code> 
      <code>//bootstrap</code> 
      <code>.pypa.io</code> 
      <code>/ez_setup</code> 
      <code>.py&nbsp;&nbsp;--no-check-certificate</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div> 
    <div>
      2 
    </div> 
    <div>
      3 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>python2.7&nbsp;ez_setup.py</code> 
     </div> 
     <div> 
      <code>easy_install-2.7&nbsp;pip</code> 
     </div> 
     <div> 
      <code>pip2.7&nbsp;</code> 
      <code>install</code>&nbsp; 
      <code>MySQL-python</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

\* 出现报错的话是缺少相关的 mysql-devel 包：

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>yum&nbsp;</code> 
      <code>install</code>&nbsp; 
      <code>-y&nbsp;mysql-devel</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

pip 安装flask

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>pip2.7&nbsp;</code> 
      <code>install</code>&nbsp; 
      <code>flask_wtf</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>pip2.7&nbsp;</code> 
      <code>install</code>&nbsp; 
      <code>flask_script[object Object]</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>pip2.7&nbsp;</code> 
      <code>install</code>&nbsp; 
      <code>flask-debugtoolbar[object Object]</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

进入inception web的目录下运行 run.py

<table> 
 <tbody> 
  <tr> 
   <td> 
    <div>
      1 
    </div></td> 
   <td> 
    <div> 
     <div> 
      <code>.</code> 
      <code>/run</code> 
      <code>.py&nbsp;runserver&nbsp;--host&nbsp;0.0.0.0[object Object]</code> 
     </div> 
    </div></td> 
  </tr> 
 </tbody> 
</table>

注：记得在防火墙上面开启5000端口

\*参考文档：[http://blog.csdn.net/wulantian/article/details/48547711][http_blog.csdn.net_wulantian_article_details_48547711]

[http://mysql-inception.github.io/inception-document/chapter1/][http_mysql-inception.github.io_inception-document_chapter1]

[http_mysql-inception.github.io_inception-document_install]: http://mysql-inception.github.io/inception-document/install/
[http_ftp.gnu.org_gnu_bison_bison-2.5.1.tar.gz]: http://ftp.gnu.org/gnu/bison/bison-2.5.1.tar.gz
[http_mysql-inception.github.io_inception-document_variables]: http://mysql-inception.github.io/inception-document/variables/
[http_blog.itpub.net_27808137_viewspace-1816388]: http://blog.itpub.net/27808137/viewspace-1816388/
[https_github.com_dbalihui_inception_web]: https://github.com/dbalihui/inception_web
[http_192.168.xx.xxx_5000]: http://192.168.xx.xxx:5000/
[70]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/317958c94eba4851b2cf6a5fff87d4ac.png
[70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/4894e1782d8c452baf72a5230afb5d20.png
[https_www.python.org_downloads_release_python-2711]: https://www.python.org/downloads/release/python-2711/
[70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/e21d08be87fb4d2a8812cacf4c9b128c.png
[http_blog.csdn.net_wulantian_article_details_48547711]: http://blog.csdn.net/wulantian/article/details/48547711
[http_mysql-inception.github.io_inception-document_chapter1]: http://mysql-inception.github.io/inception-document/chapter1/