1# Use default setting for mysqld processes 2!include include/default_mysqld.cnf 3 4[mysqld.1.1] 5log-bin= master-bin 6loose_handlersocket_port= 20000 7loose_handlersocket_port_wr= 20001 8loose_handlersocket_threads= 2 9loose_handlersocket_threads_wr= 1 10loose_handlersocket_support_merge_table= 0 11loose_handlersocket_direct_update_mode= 2 12loose_handlersocket_unlimited_boundary= 65536 13loose_handlersocket_bulk_insert= 0 14loose_handlersocket_bulk_insert_timeout= 0 15loose_handlersocket_general_log= 1 16loose_handlersocket_timeout= 30 17loose_handlersocket_close_table_interval=2 18open_files_limit= 4096 19loose_partition= 1 20 21[mysqld.3.1] 22loose_partition= 1 23 24[mysqld.3.2] 25loose_partition= 1 26 27[mysqld.3.3] 28loose_partition= 1 29 30[mysqld.4.1] 31loose_partition= 1 32 33 34[ENV] 35USE_GEOMETRY_TEST= 0 36USE_FULLTEXT_TEST= 0 37USE_HA_TEST= 1 38USE_GENERAL_LOG= 1 39USE_REPLICATION= 0 40MASTER_1_MYPORT= @mysqld.1.1.port 41MASTER_1_HSRPORT= 20000 42MASTER_1_HSWPORT= 20001 43MASTER_1_MYSOCK= @mysqld.1.1.socket 44MASTER_1_ENGINE_TYPE= Spider 45#MASTER_1_ENGINE_TYPE= MyISAM 46MASTER_1_ENGINE= ENGINE=Spider 47MASTER_1_CHARSET= DEFAULT CHARSET=utf8 48MASTER_1_ENGINE2= ENGINE=MyISAM 49MASTER_1_CHARSET2= DEFAULT CHARSET=utf8 50MASTER_1_CHARSET3= DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 51SLAVE1_1_MYPORT= @mysqld.4.1.port 52SLAVE1_1_MYSOCK= @mysqld.4.1.socket 53SLAVE1_1_ENGINE_TYPE= MyISAM 54SLAVE1_1_ENGINE= ENGINE=MyISAM 55SLAVE1_1_CHARSET= DEFAULT CHARSET=utf8 56USE_CHILD_GROUP2= 1 57OUTPUT_CHILD_GROUP2= 0 58CHILD2_1_MYPORT= @mysqld.1.1.port 59CHILD2_1_MYSOCK= @mysqld.1.1.socket 60CHILD2_1_ENGINE_TYPE= InnoDB 61CHILD2_1_ENGINE= ENGINE=InnoDB 62CHILD2_1_CHARSET= DEFAULT CHARSET=utf8 63CHILD2_1_CHARSET2= DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci 64CHILD2_2_MYPORT= @mysqld.1.1.port 65CHILD2_2_MYSOCK= @mysqld.1.1.socket 66CHILD2_2_ENGINE_TYPE= InnoDB 67CHILD2_2_ENGINE= ENGINE=InnoDB 68CHILD2_2_CHARSET= DEFAULT CHARSET=utf8 69CHILD2_3_MYPORT= @mysqld.1.1.port 70CHILD2_3_MYSOCK= @mysqld.1.1.socket 71CHILD2_3_ENGINE_TYPE= InnoDB 72CHILD2_3_ENGINE= ENGINE=InnoDB 73CHILD2_3_CHARSET= DEFAULT CHARSET=utf8 74CHILD2_1_FT_MYPORT= @mysqld.1.1.port 75CHILD2_1_FT_MYSOCK= @mysqld.1.1.socket 76CHILD2_1_FT_ENGINE_TYPE= MyISAM 77CHILD2_1_FT_ENGINE= ENGINE=MyISAM 78CHILD2_1_FT_CHARSET= DEFAULT CHARSET=utf8 79CHILD2_2_FT_MYPORT= @mysqld.1.1.port 80CHILD2_2_FT_MYSOCK= @mysqld.1.1.socket 81CHILD2_2_FT_ENGINE_TYPE= MyISAM 82CHILD2_2_FT_ENGINE= ENGINE=MyISAM 83CHILD2_2_FT_CHARSET= DEFAULT CHARSET=utf8 84CHILD2_1_GM_MYPORT= @mysqld.1.1.port 85CHILD2_1_GM_MYSOCK= @mysqld.1.1.socket 86CHILD2_1_GM_ENGINE_TYPE= MyISAM 87CHILD2_1_GM_ENGINE= ENGINE=MyISAM 88CHILD2_1_GM_CHARSET= DEFAULT CHARSET=utf8 89CHILD2_2_GM_MYPORT= @mysqld.1.1.port 90CHILD2_2_GM_MYSOCK= @mysqld.1.1.socket 91CHILD2_2_GM_ENGINE_TYPE= MyISAM 92CHILD2_2_GM_ENGINE= ENGINE=MyISAM 93CHILD2_2_GM_CHARSET= DEFAULT CHARSET=utf8 94USE_CHILD_GROUP3= 1 95OUTPUT_CHILD_GROUP3= 0 96CHILD3_1_MYPORT= @mysqld.3.1.port 97CHILD3_1_MYSOCK= @mysqld.3.1.socket 98CHILD3_1_ENGINE_TYPE= InnoDB 99CHILD3_1_ENGINE= ENGINE=InnoDB 100CHILD3_1_CHARSET= DEFAULT CHARSET=utf8 101CHILD3_2_MYPORT= @mysqld.3.2.port 102CHILD3_2_MYSOCK= @mysqld.3.2.socket 103CHILD3_2_ENGINE_TYPE= InnoDB 104CHILD3_2_ENGINE= ENGINE=InnoDB 105CHILD3_2_CHARSET= DEFAULT CHARSET=utf8 106CHILD3_3_MYPORT= @mysqld.3.3.port 107CHILD3_3_MYSOCK= @mysqld.3.3.socket 108CHILD3_3_ENGINE_TYPE= InnoDB 109CHILD3_3_ENGINE= ENGINE=InnoDB 110CHILD3_3_CHARSET= DEFAULT CHARSET=utf8 111ORACLE_HOST= xe 112ORACLE_PORT= 1521 113ORACLE_USER= system 114ORACLE_PASSWORD= oracle 115ORACLE_DATABASE= SYSTEM 116 117STR_SEMICOLON= ; 118 119#The followings are set in include/init_xxx.inc files 120# MASTER_1_COMMENT_2_1 121# MASTER_1_COMMENT2_2_1 122# MASTER_1_COMMENT3_2_1 123# MASTER_1_COMMENT4_2_1 124# MASTER_1_COMMENT5_2_1 125# MASTER_1_COMMENT_P_2_1 126# CHILD2_1_DROP_TABLES 127# CHILD2_1_CREATE_TABLES 128# CHILD2_1_SELECT_TABLES 129# CHILD2_1_DROP_TABLES2 130# CHILD2_1_CREATE_TABLES2 131# CHILD2_1_SELECT_TABLES2 132# CHILD2_1_DROP_TABLES3 133# CHILD2_1_CREATE_TABLES3 134# CHILD2_1_SELECT_TABLES3 135# CHILD2_1_DROP_TABLES4 136# CHILD2_1_CREATE_TABLES4 137# CHILD2_1_SELECT_TABLES4 138# CHILD2_1_DROP_TABLES5 139# CHILD2_1_CREATE_TABLES5 140# CHILD2_1_SELECT_TABLES5 141# CHILD2_1_DROP_TABLES6 142# CHILD2_1_CREATE_TABLES6 143# CHILD2_1_SELECT_TABLES6 144# CHILD2_2_DROP_TABLES 145# CHILD2_2_CREATE_TABLES 146# CHILD2_2_SELECT_TABLES 147