• 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 &
  • 相关阅读:
    【更新】Java发送邮件:个人邮箱(QQ & 网易163)+企业邮箱+Android
    git pull 出现 WARNING: POSSIBLE DNS SPOOFING DETECTED!
    Redis解决“重试次数”场景的实现思路
    IDEA更改JavaScript版本
    npm与yarn命令
    SpringBoot+Vue前后端分离项目,maven package自动打包整合
    Vue(九)使用Ant Design入门——环境搭建
    Git常用命令
    Vue(八)全局变量和全局方法
    笔记本电池怎样使用问题
  • 原文地址:https://www.cnblogs.com/gaogao67/p/10392051.html
Copyright © 2020-2023  润新知