Inception介绍
MySQL Inception是数据库管理员的工具。它允许DBA构建好的SQL语句，在只读数据集上测试它们，并最终针对生产数据库运行这些SQL语句，并且能够在SQL语句出于某种原因未达到预期结果时进行回滚。
Inception下载
- github地址
获取git clone https://github.com/mysql-inception/inception.git
依赖环境安装
bison
⚠️ bison最好使用2.6以前的版本，不然会出现inception版本安装失败
获取
wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz
安装
./configure --prefix=/usr --docdir=/usr/local/bin/bison
meke
make check
make install
#查看当前系统是否自带2.6以上的bison版本
which bison
/opt/compiler/gcc-4.8.2/bin/bison
#切换默认的bison
mv /opt/compiler/gcc-4.8.2/bin/bison /opt/compiler/gcc-4.8.2/bin/bison.3.0
mv /usr/local/bin/bison /opt/compiler/gcc-4.8.2/bin/bison
cmake
获取
wget https://cmake.org/files/v3.11/cmake-3.11.1-Linux-x86_64.tar.gz
安装
tar -zxvf cmake-3.11.1-Linux-x86_64.tar.gz
cd cmake-3.11.1
./bootstrap
gmake
gmake install
cmake --version
curses5-dev
yum install ncurses-devel.x86_64
openssl
gcc g++
Inception安装
sh inception_build.sh debug
Inception验证
启动
vim inc.cnf
[inception]
general_log=1
general_log_file=inception.log
port=6669
socket=/data/workspace/inception_data/inc.socket
character-set-client-handshake=0
character-set-server=utf8
inception_remote_system_password=root
inception_remote_system_user=wzf1
inception_remote_backup_port=3306
inception_remote_backup_host=127.0.0.1
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=/data/temp
inception_osc_chunk_time=0.1
inception_enable_blob_type=1
inception_check_column_default_value=1
debug/mysql/bin/Inception --defaults-file=inc.cnf
debug为安装的目录
连接
mysql -uroot -h127.0.0.1 -P6669
inception get variables;
问题
装完之后，yum出现问题
There was a problem importing one of the Python modules required to run yum. The error leading to this problem was:/usr/lib64/libssl.so.10: symbol private_ossl_minimum_dh_bits, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference
Please install a package which provides this module, or verify that the module is installed correctly.
网上查询之后确定是openssl的硬连接出现问题，去目录/usr/lib64查看
ll libcrypto.*
lrwxrwxrwx 1 root root 14 Aug 24 2017 libcrypto.so.10 -> libcrypto.so.4
-rwxr-xr-x 1 root root 1971488 Mar 23 2017 libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 1967392 Aug 23 2017 libcrypto.so.4
发现 libcrypto.so.10链接的so版本不对，改为1.0.1.e
rm libcrypto.so.10
rm: remove symbolic link 'libcrypto.so.10'? yes
[root@gzhxy-bcc-init0000002774 lib64]# ll libcrypto.*
-rwxr-xr-x 1 root root 1971488 Mar 23 2017 libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 1967392 Aug 23 2017 libcrypto.so.4
ln -s libcrypto.so.1.0.1e libcrypto.so.10
[root@gzhxy-bcc-init0000002774 lib64]# ll libcrypto.*
lrwxrwxrwx 1 root root 19 Apr 26 11:25 libcrypto.so.10 -> libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 1971488 Mar 23 2017 libcrypto.so.1.0.1e
-rwxr-xr-x 1 root root 1967392 Aug 23 2017 libcrypto.so.4
重启sshd
service sshd restart
Stopping sshd: [ OK ]
Starting sshd: [ OK ]
验证成功
yum --version
3.2.29
Installed: rpm-4.8.0-37.el6.x86_64 at 2014-09-01 09:55
Built : CentOS BuildSystem <http://bugs.centos.org> at 2013-11-22 11:38
Committed: Panu Matilainen <pmatilai@redhat.com> at 2013-09-12
Installed: yum-3.2.29-81.el6.centos.noarch at 2017-08-16 09:27
Built : CentOS BuildSystem <http://bugs.centos.org> at 2017-03-22 05:32
Committed: Johnny Hughes <johnny@centos.org> at 2017-03-21
Installed: yum-plugin-fastestmirror-1.1.30-14.el6.noarch at 2014-09-01 09:55
Built : CentOS BuildSystem <http://bugs.centos.org> at 2012-06-22 12:23
Committed: Zdenek Pavlas <zpavlas@redhat.com> at 2012-04-26