// Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS) // EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword'); // // Note: you can also place this section in a file called db-list.php in wp-content add_db_server('global', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_global', 'db_user_name', 'db_user_name_pass'); add_db_server('0', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_0', 'db_user_name', 'db_user_name_pass'); add_db_server('1', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_1', 'db_user_name', 'db_user_name_pass'); add_db_server('2', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_2', 'db_user_name', 'db_user_name_pass'); add_db_server('3', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_3', 'db_user_name', 'db_user_name_pass'); add_db_server('4', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_4', 'db_user_name', 'db_user_name_pass'); add_db_server('5', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_5', 'db_user_name', 'db_user_name_pass'); add_db_server('6', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_6', 'db_user_name', 'db_user_name_pass'); add_db_server('7', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_7', 'db_user_name', 'db_user_name_pass'); add_db_server('8', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_8', 'db_user_name', 'db_user_name_pass'); add_db_server('9', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_9', 'db_user_name', 'db_user_name_pass'); add_db_server('a', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_a', 'db_user_name', 'db_user_name_pass'); add_db_server('b', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_b', 'db_user_name', 'db_user_name_pass'); add_db_server('c', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_c', 'db_user_name', 'db_user_name_pass'); add_db_server('d', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_d', 'db_user_name', 'db_user_name_pass'); add_db_server('e', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_e', 'db_user_name', 'db_user_name_pass'); add_db_server('f', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_f', 'db_user_name', 'db_user_name_pass'); //------------------------------------------------------------------------// //---VIP Blogs------------------------------------------------------------// //------------------------------------------------------------------------// // Usage: add_vip_blog(BLOG_ID, DS) // EX: add_vip_blog(1, 'vip1'); // Only use VIP blogs if you meet 2 criteria, otherwise they are pointless: // 1. You have a specific blog that gets crazy crazy traffic to the point that it warrants it's own DB server // 2. You host it on it's own PHYSICAL db server add_db_server('vip1', 'dc1', 1, 1, '64.120.23.72', '192.168.0.101', 'wpmu_vip_1', 'db_user_name', 'db_user_name_pass'); add_vip_blog(1, 'vip1');
// in which to attempt communication (all locals, then all remotes) // // Usage: add_db_server(DS, DC, READ, WRITE, HOST, LAN_HOST, NAME, USER, PASS) // EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword'); // // Note: you can also place this section in a file called db-list.php in wp-content // EX: add_db_server('global', 'dc1', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509', 'global-db', 'globaluser', 'globalpassword'); add_db_server('global', 'dc1', 1, 1, 'localhost', 'localhost', 'wpglobal', 'root', 'root'); add_db_server('0', 'dc1', 1, 1, 'localhost', 'localhost', 'wp0', 'root', 'root'); add_db_server('1', 'dc1', 1, 1, 'localhost', 'localhost', 'wp1', 'root', 'root'); add_db_server('2', 'dc1', 1, 1, 'localhost', 'localhost', 'wp2', 'root', 'root'); add_db_server('3', 'dc1', 1, 1, 'localhost', 'localhost', 'wp3', 'root', 'root'); add_db_server('4', 'dc1', 1, 1, 'localhost', 'localhost', 'wp4', 'root', 'root'); add_db_server('5', 'dc1', 1, 1, 'localhost', 'localhost', 'wp5', 'root', 'root'); add_db_server('6', 'dc1', 1, 1, 'localhost', 'localhost', 'wp6', 'root', 'root'); add_db_server('7', 'dc1', 1, 1, 'localhost', 'localhost', 'wp7', 'root', 'root'); add_db_server('8', 'dc1', 1, 1, 'localhost', 'localhost', 'wp8', 'root', 'root'); add_db_server('9', 'dc1', 1, 1, 'localhost', 'localhost', 'wp9', 'root', 'root'); add_db_server('a', 'dc1', 1, 1, 'localhost', 'localhost', 'wpa', 'root', 'root'); add_db_server('b', 'dc1', 1, 1, 'localhost', 'localhost', 'wpb', 'root', 'root'); add_db_server('c', 'dc1', 1, 1, 'localhost', 'localhost', 'wpc', 'root', 'root'); add_db_server('d', 'dc1', 1, 1, 'localhost', 'localhost', 'wpd', 'root', 'root'); add_db_server('e', 'dc1', 1, 1, 'localhost', 'localhost', 'wpe', 'root', 'root'); add_db_server('f', 'dc1', 1, 1, 'localhost', 'localhost', 'wpf', 'root', 'root'); //------------------------------------------------------------------------// //---VIP Blogs------------------------------------------------------------// //------------------------------------------------------------------------// // Usage: add_vip_blog(BLOG_ID, DS) // VIP blogs are only useful if they have traffic that warrants them being put on a SEPARATE PHYSICAL SERVER. // If you do not plan to put them on their own server, don't use them, it's not worth it! // add_vip_blog(1, 'vip1');