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