yum -y install cmake libncurses5-dev libssl-dev g++ bison openssl-devel.x86_64
make -j6 && make install
wget https://github.com/mysql-inception/inception/archive/master.zip
yum remove bison -y
wget http://ftp.gnu.org/gnu/bison/bison-2.5.tar.gz
yum remove bison -y
tar -zxvf bison-2.5.tar.gz
cd bison-2.5/
./configure
vim ./lib/stdio.in.h
/_GL_WARN_ON_USE (gets, âgets is a security hole - use fgets insteadâ); /
make && make install
unzip master.zip
mv inception-master/ inception
cd /usr/local/inception
sh -x inception_build.sh builddir linux
vim /usr/local/inception/inc.cnf
[inception]
general_log=1
general_log_file=inception.log
port=6669
socket=/tmp/mysql.sock
character-set-client-handshake=0
character-set-server=utf8
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
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
cd builddir/mysql/bin
nohup /usr/local/inception/builddir/mysql/bin/Inception âdefaults-file=/usr/local/inception/inc.cnf >/dev/null 2>&1 &
mysql -uroot -h127.0.0.1 -P6669
===================================================================================================
vim /etc/inc.cnf
[inception]
general_log=1 #è¿ä¸ªåæ°å°±æ¯åççMySQLçåæ°ï¼ç¨æ¥è®°å½å¨Inceptionæå¡ä¸æ§è¡è¿åªäºè¯å¥ï¼ç¨æ¥å®ä½ä¸äºé®é¢ç
general_log_file=/usr/local/inception/data/inception.log #设置general logåå ¥çæ件路å¾
port=6669 #Inceptionçæå¡ç«¯å£
socket=/usr/local/inception/data/inc.socket #Inceptionçå¥æ¥åæ件åæ¾ä½ç½®
character-set-server=utf8 #mysqlåçåæ°
Inception å®¡æ ¸è§å
inception_check_autoincrement_datatype=1 #å½å»ºè¡¨æ¶èªå¢åçç±»åä¸ä¸ºintæè bigintæ¶æ¥é
inception_check_autoincrement_init_value=1 #å½å»ºè¡¨æ¶èªå¢åçå¼æå®çä¸ä¸º1ï¼åæ¥é
inception_check_autoincrement_name=1 #建表æ¶ï¼å¦ææå®çèªå¢åçååä¸ä¸ºIDï¼åæ¥éï¼è¯´ææ¯ææä¹çï¼ç»æ示
inception_check_column_comment=1 #建表æ¶ï¼å没æ注éæ¶æ¥é
inception_check_column_default_value=0 #æ£æ¥å¨å»ºè¡¨ãä¿®æ¹åãæ°å¢åæ¶ï¼æ°çåå±æ§æ¯ä¸æ¯è¦æé»è®¤å¼
inception_check_dml_limit=1 #å¨DMLè¯å¥ä¸ä½¿ç¨äºLIMITæ¶ï¼æ¯ä¸æ¯è¦æ¥é
inception_check_dml_orderby=1 #å¨DMLè¯å¥ä¸ä½¿ç¨äºOrder Byæ¶ï¼æ¯ä¸æ¯è¦æ¥é
inception_check_dml_where=1 #å¨DMLè¯å¥ä¸æ²¡æWHEREæ¡ä»¶æ¶ï¼æ¯ä¸æ¯è¦æ¥é
inception_check_identifier=1 #æå¼ä¸å ³éInception对SQLè¯å¥ä¸åç§ååçæ£æ¥ï¼å¦æ设置为ONï¼åå¦æåç°ååä¸åå¨é¤æ°åãåæ¯ãä¸å线ä¹å¤çå符æ¶ï¼ä¼æ¥Identifier âinvalidnameâ is invalid, valid options: [a-z,A-Z,0-9,_].
inception_check_index_prefix=1 #æ¯ä¸æ¯è¦æ£æ¥ç´¢å¼åååç¼ä¸ºâidx_âï¼æ£æ¥å¯ä¸ç´¢å¼åç¼æ¯ä¸æ¯âuniq_â
inception_check_insert_field=1 #æ¯ä¸æ¯è¦æ£æ¥æå ¥è¯å¥ä¸çåé¾è¡¨çåå¨æ§
inception_check_primary_key=1 #建表æ¶ï¼å¦æ没æ主é®ï¼åæ¥é
inception_check_table_comment=0 #建表æ¶ï¼è¡¨æ²¡æ注éæ¶æ¥é
inception_check_timestamp_default=0 #建表æ¶ï¼å¦æ没æ为timestampç±»åæå®é»è®¤å¼ï¼åæ¥é
inception_enable_autoincrement_unsigned=1 #èªå¢åæ¯ä¸æ¯è¦ä¸ºæ 符å·å
inception_enable_blob_type=0 #æ£æ¥æ¯ä¸æ¯æ¯æBLOBå段ï¼å æ¬å»ºè¡¨ãä¿®æ¹åãæ°å¢åæä½ é»è®¤å¼å¯
inception_enable_column_charset=0 #å 许åèªå·±è®¾ç½®å符é
inception_enable_enum_set_bit=0 #æ¯ä¸æ¯æ¯æenum,set,bitæ°æ®ç±»å
inception_enable_foreign_key=0 #æ¯ä¸æ¯æ¯æå¤é®
inception_enable_identifer_keyword=0 #æ£æ¥å¨SQLè¯å¥ä¸ï¼æ¯ä¸æ¯ææ è¯ç¬¦è¢«åæMySQLçå ³é®åï¼é»è®¤å¼ä¸ºæ¥è¦ã
inception_enable_not_innodb=0 #建表æå®çåå¨å¼æä¸ä¸ºInnodbï¼ä¸æ¥é
inception_enable_nullable=0 #å建æè æ°å¢åæ¶å¦æå为NULLï¼ä¸æ¥é
inception_enable_orderby_rand=0 #order by randæ¶æ¯ä¸æ¯æ¥é
inception_enable_partition_table=0 #æ¯ä¸æ¯æ¯æååºè¡¨
inception_enable_select_star=0 #Select*æ¶æ¯ä¸æ¯è¦æ¥é
inception_enable_sql_statistic=1 #设置æ¯ä¸æ¯æ¯æç»è®¡Inceptionæ§è¡è¿çè¯å¥ä¸ï¼åç§è¯å¥åå«å å¤å¤§æ¯ä¾ï¼å¦ææå¼è¿ä¸ªåæ°ï¼åæ¯æ¬¡æ§è¡çæ åµé½ä¼å¨å¤ä»½æ°æ®åºå®ä¾ä¸çinceptionåºçstatistic表ä¸ä»¥ä¸å½åå¨è¿æ¬¡æä½çç»è®¡æ åµï¼æ¯æ¬¡æä½å¯¹åºä¸æ¡è®°å½ï¼è¿æ¡è®°å½ä¸å«æçä¿¡æ¯æ¯åç§ç±»åçè¯å¥æ§è¡æ¬¡æ°æ åµã
inception_max_char_length=16 #å½charç±»åçé¿åº¦å¤§äºè¿ä¸ªå¼æ¶ï¼å°±æ示å°å ¶è½¬æ¢ä¸ºVARCHAR
inception_max_key_parts=5 #ä¸ä¸ªç´¢å¼ä¸ï¼åçæ大个æ°ï¼è¶ è¿è¿ä¸ªæ°ç®åæ¥é
inception_max_keys=16 #ä¸ä¸ªè¡¨ä¸ï¼æ大çç´¢å¼æ°ç®ï¼è¶ è¿è¿ä¸ªæ°åæ¥é
inception_max_update_rows=10000 #å¨ä¸ä¸ªä¿®æ¹è¯å¥ä¸ï¼é¢è®¡å½±åçæ大è¡æ°ï¼è¶ è¿è¿ä¸ªæ°å°±æ¥é
inception_merge_alter_table=1 #å¨å¤ä¸ªæ¹åä¸ä¸ªè¡¨çè¯å¥åºç°æ¯ï¼æ¥éï¼æ示åæä¸ä¸ª
inception æ¯æ OSC åæ°
inception_osc_bin_dir=/user/bin #ç¨äºæå®pt-online-schema-changeèæ¬çä½ç½®ï¼ä¸å¯ä¿®æ¹ï¼å¨é ç½®æ件ä¸è®¾ç½®
inception_osc_check_interval=5 #对åºOSCåæ°âcheck-intervalï¼æä¹æ¯Sleep time between checks for âmax-lag.
inception_osc_chunk_size=1000 #对åºOSCåæ°âchunk-size
inception_osc_chunk_size_limit=4 #对åºOSCåæ°âchunk-size-limit
inception_osc_chunk_time=0.1 #对åºOSCåæ°âchunk-time
inception_osc_critical_thread_connected=1000 #对åºåæ°âcritical-loadä¸çthread_connectedé¨å
inception_osc_critical_thread_running=80 #对åºåæ°âcritical-loadä¸çthread_runningé¨å
inception_osc_drop_new_table=1 #对åºåæ°â[no]drop-new-table
inception_osc_drop_old_table=1 #对åºåæ°â[no]drop-old-table
inception_osc_max_lag=3 #对åºåæ°âmax-lag
inception_osc_max_thread_connected=1000 #对åºåæ°âmax-loadä¸çthread_connectedé¨å
inception_osc_max_thread_running=80 #对åºåæ°âmax-loadä¸çthread_runningé¨å
inception_osc_min_table_size=0 # è¿ä¸ªåæ°å®é ä¸æ¯ä¸ä¸ªOSCçå¼å ³ï¼å¦æ设置为0ï¼åå ¨é¨ALTERè¯å¥é½èµ°OSCï¼å¦æ设置为é0ï¼åå½è¿ä¸ªè¡¨å ç¨ç©ºé´å¤§å°å¤§äºè¿ä¸ªå¼æ¶æ使ç¨OSCæ¹å¼ãåä½ä¸ºMï¼è¿ä¸ªè¡¨å¤§å°ç计ç®æ¹å¼æ¯éè¿è¯å¥ï¼âselect (DATA_LENGTH + INDEX_LENGTH)/1024/1024 from information_schema.tables where table_schema = âdbnameâ and table_name = âtablenameââæ¥å®ç°ç
inception_osc_on=0 #ä¸ä¸ªå ¨å±çOSCå¼å ³ï¼é»è®¤æ¯æå¼çï¼å¦ææ³è¦å ³éå设置为OFFï¼è¿æ ·å°±ä¼ç´æ¥ä¿®æ¹
inception_osc_print_none=1 #ç¨æ¥è®¾ç½®å¨Inceptionè¿åç»æéä¸ï¼å¯¹äºåæ¥OSCå¨æ§è¡è¿ç¨çæ åè¾åºä¿¡æ¯æ¯ä¸æ¯è¦æå°å°ç»æé对åºçé误信æ¯åä¸ï¼å¦æ设置为1ï¼å°±ä¸æå°ï¼å¦æ设置为0ï¼å°±æå°ãèå¦æåºç°é误äºï¼åé½ä¼æå°
inception_osc_print_sql=1 #对åºåæ°âprint
###å¤ä»½æå¡å¨ä¿¡æ¯ï¼æ³¨ææ¹æä½ çæºå¨.ç¨äºåæ»ã
[email protected]
inception_remote_system_user=incep_rw
inception_remote_backup_port=3306
inception_remote_backup_host=10.10.3.70
inception_support_charset=utf8 #表示å¨å»ºè¡¨æè 建åºæ¶æ¯æçå符éï¼å¦æéè¦å¤ä¸ªï¼åç¨éå·åéï¼å½±åçèå´æ¯å»ºè¡¨ã设置ä¼è¯å符éãä¿®æ¹è¡¨å符éå±æ§ç
docker run -d -e HOST=172.16.4.197 -e MYSQL_ADDR=172.16.4.197 -e MYSQL_USER=root -e MYSQL_PASSWORD=qwe123 -p8080:80 -p8000:8000 registry.cn-hangzhou.aliyuncs.com/cookie/yearning:v1.3.0
docker run -d -e HOST=172.16.4.197 -e MYSQL_ADDR=172.16.4.197 -e MYSQL_USER=yearning -e [email protected] -p8080:80 -p8000:8000 registry.cn-hangzhou.aliyuncs.com/cookie/yearning:v1.3.0
[inception]
general_log=1
general_log_file=inception.log
port=6669
socket=/mnt/mysql/data/mysqld.sock
character-set-client-handshake=0
character-set-server=utf8
backup the info of the server to rollback
inception_remote_system_user=inception
inception_remote_system_password=Qwer!234
inception_remote_backup_port=3309
inception_remote_backup_host=172.16.4.197
inception_support_charset=utf8
inception rule
inception_check_autoincrement_datatype=1
inception_check_autoincrement_init_value=1
inception_check_autoincrement_name=1
inception_check_column_comment=1
inception_check_column_default_value=1
inception_check_dml_limit=0
inception_check_dml_orderby=0
inception_check_dml_where=1
inception_check_identifier=1
inception_check_index_prefix=1
inception_check_insert_field=1
inception_check_primary_key=1
inception_check_table_comment=1
inception_check_timestamp_default=0
inception_enable_autoincrement_unsigned=1
inception_enable_blob_type=0
inception_enable_column_charset=0
inception_enable_enum_set_bit=0
inception_enable_foreign_key=0
inception_enable_identifer_keyword=1
inception_enable_not_innodb=0
inception_enable_nullable=0
inception_enable_orderby_rand=0
inception_enable_partition_table=1
inception_enable_select_star=1
inception_enable_sql_statistic=1
inception_max_char_length=20
inception_max_key_parts=5
inception_max_keys=16
inception_max_update_rows=1000000
inception_merge_alter_table=1
OSC
inception_osc_check_interval=5
inception_osc_min_table_size=1
inception_osc_chunk_size=1000
inception_osc_chunk_size_limit=4
inception_osc_critical_thread_connected=1000
inception_osc_bin_dir=/data/temp
inception_osc_chunk_time=0.1
inception_osc_critical_thread_running=80
inception_osc_drop_new_table=1
inception_osc_drop_old_table=1
inception_osc_max_lag=3
inception_osc_max_thread_connected=1000
inception_osc_max_thread_running=80
inception_osc_min_table_size=0
inception_osc_on=0
inception_osc_print_none=1
inception_osc_print_sql=1
åèææ¡£ï¼
https://supermancookie.com/Yearning-document/
http://mysql-inception.github.io/inception-document/