Discuz!-分库一主多从数据库分离-config_global.php-文件范例

discuz教程
  1. <?php/** [Discuz!] (C) 2001-2099 Comsenz Inc. config_global.php Build at 2012-07-06 10:16:22*/$_config = array();// ---------------------------- CONFIG DB ----------------------------- //$db = array( 'dbhost' => 'localhost', 'dbuser' => 'root', 'dbpw' => '111111', 'dbcharset' => 'gbk', 'pconnect' => '0', 'dbname' => 'ultrax', 'tablepre' => 'pre_');$_config['db']['1'] = $db;//$_config['db']['1']['slave']['1'] = $db;//$_config['db']['1']['slave']['1']['weight'] = '0';//$_config['db']['1']['slave']['2'] = $db;//$_config['db']['1']['slave']['2']['weight'] = '0';//$_config['db']['1']['slave']['3'] = $db;//$_config['db']['1']['slave']['3']['weight'] = '0';$_config['db']['2'] = $db;$_config['db']['2']['slave']['1'] = $db;$_config['db']['2']['slave']['1']['weight'] = '5';$_config['db']['2']['slave']['2'] = $db;$_config['db']['2']['slave']['3'] = $db;$_config['db']['3'] = $db;$_config['db']['3']['dbname'] = 'ultrax';$_config['db']['3']['slave']['1'] = $db;$_config['db']['3']['slave']['2'] = $db;$_config['db']['3']['slave']['3'] = $db;$_config['db']['3']['slave']['3']['weight'] = '5';$_config['db']['slave'] = 1;$dbthread = '2';$dbpost = '3';$_config['db']['map']['forum_debatepost'] = $dbpost;$_config['db']['map']['forum_post_moderate'] = $dbpost;$_config['db']['map']['forum_post_tableid'] = $dbpost;$_config['db']['map']['forum_post'] = $dbpost;$_config['db']['map']['forum_tradelog'] = $dbthread;$_config['db']['map']['forum_tradecomment'] = $dbthread;$_config['db']['map']['forum_trade'] = $dbthread;$_config['db']['map']['forum_threadmod'] = $dbthread;$_config['db']['map']['forum_activity'] = $dbthread;$_config['db']['map']['forum_poll'] = $dbthread;$_config['db']['map']['forum_thread_moderate'] = $dbthread;$_config['db']['map']['forum_threadimage'] = $dbthread;$_config['db']['map']['forum_forumrecommend'] = $dbthread;$_config['db']['map']['forum_moderator'] = $dbthread;$_config['db']['map']['common_tagitem'] = $dbthread;$_config['db']['map']['forum_access'] = $dbthread;$_config['db']['map']['forum_forumfield'] = $dbthread;$_config['db']['map']['forum_forum'] = $dbthread;$_config['db']['map']['forum_thread'] = $dbthread;$_config['db']['map']['forum_statlog'] = $dbthread;/** //X876 的测试配置文件$_config['db']['1']['dbhost'] = 'localhost';$_config['db']['1']['dbuser'] = 'root';$_config['db']['1']['dbpw'] = 'root';$_config['db']['1']['dbcharset'] = 'gbk';$_config['db']['1']['pconnect'] = '0';$_config['db']['1']['dbname'] = 'superbase';$_config['db']['1']['tablepre'] = 'pre_';$_config['db']['common']['slave_except_table'] = '';$_config['db']['2']['dbhost'] = '2.cn';$_config['db']['2']['dbuser'] = 'root';$_config['db']['2']['dbpw'] = 'root';$_config['db']['2']['dbcharset'] = 'gbk';$_config['db']['2']['pconnect'] = '0';$_config['db']['2']['dbname'] = 'superbase_2';$_config['db']['2']['tablepre'] = 'pre_';$_config['db']['3']['dbhost'] = '3.cn';$_config['db']['3']['dbuser'] = 'root';$_config['db']['3']['dbpw'] = 'root';$_config['db']['3']['dbcharset'] = 'gbk';$_config['db']['3']['pconnect'] = '0';$_config['db']['3']['dbname'] = 'superbase_3';$_config['db']['3']['tablepre'] = 'pre_';$_config['db']['4']['dbhost'] = '4.cn';$_config['db']['4']['dbuser'] = 'root';$_config['db']['4']['dbpw'] = 'root';$_config['db']['4']['dbcharset'] = 'gbk';$_config['db']['4']['pconnect'] = '0';$_config['db']['4']['dbname'] = 'superbase_4';$_config['db']['4']['tablepre'] = 'pre_';$_config['db']['5']['dbhost'] = '5.cn';$_config['db']['5']['dbuser'] = 'root';$_config['db']['5']['dbpw'] = 'root';$_config['db']['5']['dbcharset'] = 'gbk';$_config['db']['5']['pconnect'] = '0';$_config['db']['5']['dbname'] = 'superbase_5';$_config['db']['5']['tablepre'] = 'pre_';$_config['db']['6']['dbhost'] = '6.cn';$_config['db']['6']['dbuser'] = 'root';$_config['db']['6']['dbpw'] = 'root';$_config['db']['6']['dbcharset'] = 'gbk';$_config['db']['6']['pconnect'] = '0';$_config['db']['6']['dbname'] = 'superbase_6';$_config['db']['6']['tablepre'] = 'pre_';$_config['db']['7']['dbhost'] = '7.cn';$_config['db']['7']['dbuser'] = 'root';$_config['db']['7']['dbpw'] = 'root';$_config['db']['7']['dbcharset'] = 'gbk';$_config['db']['7']['pconnect'] = '0';$_config['db']['7']['dbname'] = 'superbase_7';$_config['db']['7']['tablepre'] = 'pre_';$_config['db']['8']['dbhost'] = '8.cn';$_config['db']['8']['dbuser'] = 'root';$_config['db']['8']['dbpw'] = 'root';$_config['db']['8']['dbcharset'] = 'gbk';$_config['db']['8']['pconnect'] = '0';$_config['db']['8']['dbname'] = 'superbase_8';$_config['db']['8']['tablepre'] = 'pre_';$_config['db']['9']['dbhost'] = '9.cn';$_config['db']['9']['dbuser'] = 'root';$_config['db']['9']['dbpw'] = 'root';$_config['db']['9']['dbcharset'] = 'gbk';$_config['db']['9']['pconnect'] = '0';$_config['db']['9']['dbname'] = 'superbase_9';$_config['db']['9']['tablepre'] = 'pre_';$_config['db']['10']['dbhost'] = '10.cn';$_config['db']['10']['dbuser'] = 'root';$_config['db']['10']['dbpw'] = 'root';$_config['db']['10']['dbcharset'] = 'gbk';$_config['db']['10']['pconnect'] = '0';$_config['db']['10']['dbname'] = 'superbase_10';$_config['db']['10']['tablepre'] = 'pre_';$_config['db']['11']['dbhost'] = '11.cn';$_config['db']['11']['dbuser'] = 'root';$_config['db']['11']['dbpw'] = 'root';$_config['db']['11']['dbcharset'] = 'gbk';$_config['db']['11']['pconnect'] = '0';$_config['db']['11']['dbname'] = 'superbase_11';$_config['db']['11']['tablepre'] = 'pre_';$_config['db']['12']['dbhost'] = '12.cn';$_config['db']['12']['dbuser'] = 'root';$_config['db']['12']['dbpw'] = 'root';$_config['db']['12']['dbcharset'] = 'gbk';$_config['db']['12']['pconnect'] = '0';$_config['db']['12']['dbname'] = 'superbase_12';$_config['db']['12']['tablepre'] = 'pre_';$_config['db']['13']['dbhost'] = '13.cn';$_config['db']['13']['dbuser'] = 'root';$_config['db']['13']['dbpw'] = 'root';$_config['db']['13']['dbcharset'] = 'gbk';$_config['db']['13']['pconnect'] = '0';$_config['db']['13']['dbname'] = 'superbase_13';$_config['db']['13']['tablepre'] = 'pre_';$_config['db']['14']['dbhost'] = '14.cn';$_config['db']['14']['dbuser'] = 'root';$_config['db']['14']['dbpw'] = 'root';$_config['db']['14']['dbcharset'] = 'gbk';$_config['db']['14']['pconnect'] = '0';$_config['db']['14']['dbname'] = 'superbase_14';$_config['db']['14']['tablepre'] = 'pre_';$_config['db']['15']['dbhost'] = '15.cn';$_config['db']['15']['dbuser'] = 'root';$_config['db']['15']['dbpw'] = 'root';$_config['db']['15']['dbcharset'] = 'gbk';$_config['db']['15']['pconnect'] = '0';$_config['db']['15']['dbname'] = 'superbase_15';$_config['db']['15']['tablepre'] = 'pre_';$_config['db']['16']['dbhost'] = '16.cn';$_config['db']['16']['dbuser'] = 'root';$_config['db']['16']['dbpw'] = 'root';$_config['db']['16']['dbcharset'] = 'gbk';$_config['db']['16']['pconnect'] = '0';$_config['db']['16']['dbname'] = 'superbase_16';$_config['db']['16']['tablepre'] = 'pre_';$_config['db']['17']['dbhost'] = '17.cn';$_config['db']['17']['dbuser'] = 'root';$_config['db']['17']['dbpw'] = 'root';$_config['db']['17']['dbcharset'] = 'gbk';$_config['db']['17']['pconnect'] = '0';$_config['db']['17']['dbname'] = 'superbase_17';$_config['db']['17']['tablepre'] = 'pre_';$_config['db']['18']['dbhost'] = '18.cn';$_config['db']['18']['dbuser'] = 'root';$_config['db']['18']['dbpw'] = 'root';$_config['db']['18']['dbcharset'] = 'gbk';$_config['db']['18']['pconnect'] = '0';$_config['db']['18']['dbname'] = 'superbase_18';$_config['db']['18']['tablepre'] = 'pre_';$_config['db']['19']['dbhost'] = '19.cn';$_config['db']['19']['dbuser'] = 'root';$_config['db']['19']['dbpw'] = 'root';$_config['db']['19']['dbcharset'] = 'gbk';$_config['db']['19']['pconnect'] = '0';$_config['db']['19']['dbname'] = 'superbase_19';$_config['db']['19']['tablepre'] = 'pre_';$_config['db']['20']['dbhost'] = '20.cn';$_config['db']['20']['dbuser'] = 'root';$_config['db']['20']['dbpw'] = 'root';$_config['db']['20']['dbcharset'] = 'gbk';$_config['db']['20']['pconnect'] = '0';$_config['db']['20']['dbname'] = 'superbase_20';$_config['db']['20']['tablepre'] = 'pre_';$_config['db']['map']['common_admincp_perm'] = '2';$_config['db']['map']['common_admincp_member'] = '2';$_config['db']['map']['common_mailqueue'] = '3';$_config['db']['map']['common_mailcron'] = '3';$_config['db']['map']['common_member_verify_info'] = '4';$_config['db']['map']['common_member_verify'] = '4';$_config['db']['map']['common_member_validate'] = '4';$_config['db']['map']['common_member_field_home_archive'] = '4';$_config['db']['map']['common_member_field_home'] = '4';$_config['db']['map']['common_member_field_forum_archive'] = '4';$_config['db']['map']['common_member_field_forum'] = '4';$_config['db']['map']['common_member_profile_archive'] = '4';$_config['db']['map']['common_member_profile'] = '4';$_config['db']['map']['common_member_status_archive'] = '4';$_config['db']['map']['common_member_status'] = '4';$_config['db']['map']['common_member_count_archive'] = '4';$_config['db']['map']['common_member_count'] = '4';$_config['db']['map']['common_member_archive'] = '4';$_config['db']['map']['home_specialuser'] = '4';$_config['db']['map']['home_show'] = '4';$_config['db']['map']['common_member'] = '4';$_config['db']['map']['common_pluginvar'] = '5';$_config['db']['map']['common_plugin'] = '5';$_config['db']['map']['forum_imagetype'] = '6';$_config['db']['map']['common_smiley'] = '6';$_config['db']['map']['common_stylevar'] = '7';$_config['db']['map']['common_template'] = '7';$_config['db']['map']['common_style'] = '7';$_config['db']['map']['forum_attachment_unused'] = '8';$_config['db']['map']['forum_attachment'] = '8';$_config['db']['map']['forum_debatepost'] = '9';$_config['db']['map']['forum_post_moderate'] = '9';$_config['db']['map']['forum_post_tableid'] = '9';$_config['db']['map']['forum_post'] = '9';$_config['db']['map']['forum_tradelog'] = '10';$_config['db']['map']['forum_tradecomment'] = '10';$_config['db']['map']['forum_trade'] = '10';$_config['db']['map']['forum_threadmod'] = '10';$_config['db']['map']['forum_activity'] = '10';$_config['db']['map']['forum_poll'] = '10';$_config['db']['map']['forum_thread_moderate'] = '10';$_config['db']['map']['forum_threadimage'] = '10';$_config['db']['map']['forum_forumrecommend'] = '10';$_config['db']['map']['forum_moderator'] = '10';$_config['db']['map']['common_tagitem'] = '10';$_config['db']['map']['forum_access'] = '10';$_config['db']['map']['forum_forumfield'] = '10';$_config['db']['map']['forum_forum'] = '10';$_config['db']['map']['forum_thread'] = '10';$_config['db']['map']['forum_statlog'] = '10';$_config['db']['map']['forum_threadtype'] = '11';$_config['db']['map']['forum_typeoption'] = '11';$_config['db']['map']['forum_typevar'] = '11';$_config['db']['map']['home_blogfield'] = '12';$_config['db']['map']['home_blog_moderate'] = '12';$_config['db']['map']['home_blog'] = '12';$_config['db']['map']['home_pic_moderate'] = '13';$_config['db']['map']['home_album'] = '13';$_config['db']['map']['home_picfield'] = '13';$_config['db']['map']['home_pic'] = '13';$_config['db']['map']['common_mytask'] = '14';$_config['db']['map']['common_task'] = '14';$_config['db']['map']['home_comment_moderate'] = '15';$_config['db']['map']['home_comment'] = '15';$_config['db']['map']['home_doing_moderate'] = '16';$_config['db']['map']['home_doing'] = '16';$_config['db']['map']['home_share_moderate'] = '17';$_config['db']['map']['home_share'] = '17';$_config['db']['map']['portal_article_moderate'] = '18';$_config['db']['map']['portal_article_title'] = '18';$_config['db']['map']['portal_article_count'] = '18';$_config['db']['map']['portal_comment_moderate'] = '19';$_config['db']['map']['portal_comment'] = '19';*/// -------------------------- CONFIG MEMORY --------------------------- //$_config['memory']['prefix'] = 'Yd1234_';$_config['memory']['eaccelerator'] = '0';$_config['memory']['xcache'] = 1;$_config['memory']['memcache']['server'] = '';$_config['memory']['memcache']['port'] = 11211;$_config['memory']['memcache']['pconnect'] = 1;$_config['memory']['memcache']['timeout'] = 1;$_config['memory']['apc'] = 1;$_config['memory']['redis']['server'] = '';$_config['memory']['redis']['port'] = 6379;$_config['memory']['redis']['pconnect'] = 1;$_config['memory']['redis']['timeout'] = '0';$_config['memory']['redis']['serializer'] = 1;// --------------------------- CONFIG CACHE --------------------------- //$_config['cache']['main']['type'] = '';$_config['cache']['main']['file']['path'] = 'data/ultraxcache';$_config['cache']['type'] = 'sql';// -------------------------- CONFIG OUTPUT --------------------------- //$_config['output']['charset'] = 'gbk';$_config['output']['forceheader'] = 1;$_config['output']['gzip'] = '1';$_config['output']['tplrefresh'] = 1;$_config['output']['language'] = 'zh_cn';$_config['output']['staticurl'] = 'static/';$_config['output']['ajaxvalidate'] = '0';$_config['output']['iecompatible'] = '0';// -------------------------- CONFIG COOKIE --------------------------- //$_config['cookie']['cookiepre'] = 'DlWe_';$_config['cookie']['cookiedomain'] = '';$_config['cookie']['cookiepath'] = '/';// ------------------------- CONFIG SECURITY -------------------------- //$_config['security']['authkey'] = '1dab222dvEFEtjZA';$_config['security']['urlxssdefend'] = '0';$_config['security']['attackevasive'] = '0';$_config['security']['querysafe']['status'] = 1;$_config['security']['querysafe']['dfunction']['0'] = 'load_file';$_config['security']['querysafe']['dfunction']['1'] = 'hex';$_config['security']['querysafe']['dfunction']['2'] = 'substring';$_config['security']['querysafe']['dfunction']['3'] = 'if';$_config['security']['querysafe']['dfunction']['4'] = 'ord';$_config['security']['querysafe']['dfunction']['5'] = 'char';$_config['security']['querysafe']['daction']['0'] = 'intooutfile';$_config['security']['querysafe']['daction']['1'] = 'intodumpfile';$_config['security']['querysafe']['daction']['2'] = 'unionselect';$_config['security']['querysafe']['daction']['3'] = '(select';$_config['security']['querysafe']['daction']['4'] = 'unionall';$_config['security']['querysafe']['daction']['5'] = 'uniondistinct';$_config['security']['querysafe']['dnote']['0'] = '/*';$_config['security']['querysafe']['dnote']['1'] = '*/';$_config['security']['querysafe']['dnote']['2'] = '#';$_config['security']['querysafe']['dnote']['3'] = '--';$_config['security']['querysafe']['dnote']['4'] = '"';$_config['security']['querysafe']['dlikehex'] = 1;$_config['security']['querysafe']['afullnote'] = 1;// -------------------------- CONFIG ADMINCP -------------------------- //// -------- Founders: $_config['admincp']['founder'] = '1,2,3'; --------- //$_config['admincp']['founder'] = '859,776,80629';$_config['admincp']['forcesecques'] = '0';$_config['admincp']['checkip'] = 1;$_config['admincp']['runquery'] = 1;$_config['admincp']['dbimport'] = 1;// --------------------------- CONFIG DEBUG --------------------------- //$_config['debug'] = 'discuz';// -------------------------- CONFIG SERVER --------------------------- //$_config['server']['id'] = 1;// ------------------------- CONFIG DOWNLOAD -------------------------- //$_config['download']['readmod'] = 2;$_config['download']['xsendfile']['type'] = '0';$_config['download']['xsendfile']['dir'] = '/down/';// -------------------------- CONFIG REMOTE --------------------------- //$_config['remote']['on'] = 1;$_config['remote']['dir'] = 'remote';$_config['remote']['appkey'] = '62cf0b3c3e6a4c9468e7216839721d8e';$_config['remote']['cron'] = 1;// --------------------------- CONFIG INPUT --------------------------- //$_config['input']['compatible'] = '0';// ------------------- THE END -------------------- //?>

Discuz!-分库一主多从-config_global.php-文件范例

标签: