MySQL Inception--安装

==========================================

安装依赖包

## 安装依赖包
yum -y install cmake libncurses5-dev libssl-dev g++

 

==========================================

安装BISON

##下载bison地址：http://ftp.gnu.org/gnu/bison/
## 解压安装
## 安装后路径在/usr/local/bison
cd bison-2.5
./configure
make && make install

 

==========================================

创建所需目录

## 创建工作目录

mkdir -p /export/data/mysql_inception/data/temp /export/data/mysql_inception/data/ /export/servers/mysql_inception/etc

 

==========================================

安装mysql_inception

## 安装mysql_inception
## 下载地址https://github.com/mysql-inception/inception
## 解压进入安装包

cmake -DWITH_DEBUG=OFF \
-DWITH_SSL=yes \
-DCMAKE_INSTALL_PREFIX=/export/servers/mysql_inception \
-DMYSQL_DATADIR=/export/data/mysql_inception \
-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

 

==========================================

创建配置文件

## 创建配置文件
echo "
[inception]
general_log=1
general_log_file=/export/data/mysql_inception/data/inception.log
port=6669
socket=/export/data/mysql_inception/inc.socket
character-set-client-handshake=0
character-set-server=utf8
inception_remote_system_password=inception_backup.com
inception_remote_system_user=inception_backup
inception_remote_backup_port=3358
inception_remote_backup_host=192.168.166.170
inception_support_charset=utf8mb4
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=/export/data/mysql_inception/data/temp
inception_osc_chunk_time=0.1
inception_ddl_support=1
inception_enable_blob_type=1
inception_check_column_default_value=1
" >/export/servers/mysql_inception/etc/inc.cnf

 

==========================================

启动服务

## 启动Inception服务
/export/servers/mysql_inception/bin/Inception --defaults-file=/export/servers/mysql_inception/etc/inc.cnf &