Skip to content

Instantly share code, notes, and snippets.

/db-config Secret

Created July 21, 2013 08:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/6fd66ae686bac41d5447 to your computer and use it in GitHub Desktop.
Save anonymous/6fd66ae686bac41d5447 to your computer and use it in GitHub Desktop.
<?php
// Plugin Name: Multi-DB
// Plugin URI: http://premium.wpmudev.org/project/Multiple-Databases
// Author: Andrew Billits (Incsub)
// Version: 2.9.2
//------------------------------------------------------------------------//
//---DB Scaling-----------------------------------------------------------//
//------------------------------------------------------------------------//
// 16,256,4096
define ('DB_SCALING', '256');
//------------------------------------------------------------------------//
//---DC IPs---------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_dc_ip(IP, DC)
// EX: add_dc_ip('174.122.xxx.xx', 'dc1');
add_dc_ip('localhost', 'dc1');
//--I have a complete IP address not xxx.xx-------------------------------//
//------------------------------------------------------------------------//
//---Global Tables--------------------------------------------------------//
//------------------------------------------------------------------------//
// Do not include default global tables
// Leave off base prefix (eg: wp_)
//
// Usage: add_global_table(TABLE_NAME)
// EX: add_global_table('something');
add_global_table('dbname_global');
//------------------------------------------------------------------------//
//---DB Servers-----------------------------------------------------------//
//------------------------------------------------------------------------//
// Database servers grouped by dataset.
// R can be 0 (no reads) or a positive integer indicating the order
// 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
add_db_server('global', 'dc1', 1, 1,'','localhost', 'dbname_global', 'username', 'password');
add_db_server('vip1', 'dc1', 1, 1,'','localhost', 'dbname_vip1', 'username', 'password');
add_db_server('vip2', 'dc1', 1, 1,'','localhost', 'dbname_vip2', 'username', 'password');
add_db_server('vip3', 'dc1', 1, 1,'','localhost', 'dbname_vip3', 'username', 'password');
add_db_server('vip4', 'dc1', 1, 1,'','localhost', 'dbname_vip4', 'username', 'password');
add_db_server('00', 'dc1', 1, 1,'','localhost', 'dbname_00', 'username', 'password');
add_db_server('01', 'dc1', 1, 1,'','localhost', 'dbname_01', 'username', 'password');
add_db_server('02', 'dc1', 1, 1,'','localhost', 'dbname_02', 'username', 'password');
add_db_server('03', 'dc1', 1, 1,'','localhost', 'dbname_03', 'username', 'password');
add_db_server('04', 'dc1', 1, 1,'','localhost', 'dbname_04', 'username', 'password');
add_db_server('05', 'dc1', 1, 1,'','localhost', 'dbname_05', 'username', 'password');
add_db_server('06', 'dc1', 1, 1,'','localhost', 'dbname_06', 'username', 'password');
add_db_server('07', 'dc1', 1, 1,'','localhost', 'dbname_07', 'username', 'password');
add_db_server('08', 'dc1', 1, 1,'','localhost', 'dbname_08', 'username', 'password');
add_db_server('09', 'dc1', 1, 1,'','localhost', 'dbname_09', 'username', 'password');
add_db_server('0a', 'dc1', 1, 1,'','localhost', 'dbname_0a', 'username', 'password');
add_db_server('0b', 'dc1', 1, 1,'','localhost', 'dbname_0b', 'username', 'password');
add_db_server('0c', 'dc1', 1, 1,'','localhost', 'dbname_0c', 'username', 'password');
add_db_server('0d', 'dc1', 1, 1,'','localhost', 'dbname_0d', 'username', 'password');
add_db_server('0e', 'dc1', 1, 1,'','localhost', 'dbname_0e', 'username', 'password');
add_db_server('0f', 'dc1', 1, 1,'','localhost', 'dbname_0f', 'username', 'password');
add_db_server('10', 'dc1', 1, 1,'','localhost', 'dbname_10', 'username', 'password');
add_db_server('11', 'dc1', 1, 1,'','localhost', 'dbname_11', 'username', 'password');
add_db_server('12', 'dc1', 1, 1,'','localhost', 'dbname_12', 'username', 'password');
add_db_server('13', 'dc1', 1, 1,'','localhost', 'dbname_13', 'username', 'password');
add_db_server('14', 'dc1', 1, 1,'','localhost', 'dbname_14', 'username', 'password');
add_db_server('15', 'dc1', 1, 1,'','localhost', 'dbname_15', 'username', 'password');
add_db_server('16', 'dc1', 1, 1,'','localhost', 'dbname_16', 'username', 'password');
add_db_server('17', 'dc1', 1, 1,'','localhost', 'dbname_17', 'username', 'password');
add_db_server('18', 'dc1', 1, 1,'','localhost', 'dbname_18', 'username', 'password');
add_db_server('19', 'dc1', 1, 1,'','localhost', 'dbname_19', 'username', 'password');
add_db_server('1a', 'dc1', 1, 1,'','localhost', 'dbname_1a', 'username', 'password');
add_db_server('1b', 'dc1', 1, 1,'','localhost', 'dbname_1b', 'username', 'password');
add_db_server('1c', 'dc1', 1, 1,'','localhost', 'dbname_1c', 'username', 'password');
add_db_server('1d', 'dc1', 1, 1,'','localhost', 'dbname_1d', 'username', 'password');
add_db_server('1e', 'dc1', 1, 1,'','localhost', 'dbname_1e', 'username', 'password');
add_db_server('1f', 'dc1', 1, 1,'','localhost', 'dbname_1f', 'username', 'password');
add_db_server('20', 'dc1', 1, 1,'','localhost', 'dbname_20', 'username', 'password');
add_db_server('21', 'dc1', 1, 1,'','localhost', 'dbname_21', 'username', 'password');
add_db_server('22', 'dc1', 1, 1,'','localhost', 'dbname_22', 'username', 'password');
add_db_server('23', 'dc1', 1, 1,'','localhost', 'dbname_23', 'username', 'password');
add_db_server('24', 'dc1', 1, 1,'','localhost', 'dbname_24', 'username', 'password');
add_db_server('25', 'dc1', 1, 1,'','localhost', 'dbname_25', 'username', 'password');
add_db_server('26', 'dc1', 1, 1,'','localhost', 'dbname_26', 'username', 'password');
add_db_server('27', 'dc1', 1, 1,'','localhost', 'dbname_27', 'username', 'password');
add_db_server('28', 'dc1', 1, 1,'','localhost', 'dbname_28', 'username', 'password');
add_db_server('29', 'dc1', 1, 1,'','localhost', 'dbname_29', 'username', 'password');
add_db_server('2a', 'dc1', 1, 1,'','localhost', 'dbname_2a', 'username', 'password');
add_db_server('2b', 'dc1', 1, 1,'','localhost', 'dbname_2b', 'username', 'password');
add_db_server('2c', 'dc1', 1, 1,'','localhost', 'dbname_2c', 'username', 'password');
add_db_server('2d', 'dc1', 1, 1,'','localhost', 'dbname_2d', 'username', 'password');
add_db_server('2e', 'dc1', 1, 1,'','localhost', 'dbname_2e', 'username', 'password');
add_db_server('2f', 'dc1', 1, 1,'','localhost', 'dbname_2f', 'username', 'password');
add_db_server('30', 'dc1', 1, 1,'','localhost', 'dbname_30', 'username', 'password');
add_db_server('31', 'dc1', 1, 1,'','localhost', 'dbname_31', 'username', 'password');
add_db_server('32', 'dc1', 1, 1,'','localhost', 'dbname_32', 'username', 'password');
add_db_server('33', 'dc1', 1, 1,'','localhost', 'dbname_33', 'username', 'password');
add_db_server('34', 'dc1', 1, 1,'','localhost', 'dbname_34', 'username', 'password');
add_db_server('35', 'dc1', 1, 1,'','localhost', 'dbname_35', 'username', 'password');
add_db_server('36', 'dc1', 1, 1,'','localhost', 'dbname_36', 'username', 'password');
add_db_server('37', 'dc1', 1, 1,'','localhost', 'dbname_37', 'username', 'password');
add_db_server('38', 'dc1', 1, 1,'','localhost', 'dbname_38', 'username', 'password');
add_db_server('39', 'dc1', 1, 1,'','localhost', 'dbname_39', 'username', 'password');
add_db_server('3a', 'dc1', 1, 1,'','localhost', 'dbname_3a', 'username', 'password');
add_db_server('3b', 'dc1', 1, 1,'','localhost', 'dbname_3b', 'username', 'password');
add_db_server('3c', 'dc1', 1, 1,'','localhost', 'dbname_3c', 'username', 'password');
add_db_server('3d', 'dc1', 1, 1,'','localhost', 'dbname_3d', 'username', 'password');
add_db_server('3e', 'dc1', 1, 1,'','localhost', 'dbname_3e', 'username', 'password');
add_db_server('3f', 'dc1', 1, 1,'','localhost', 'dbname_3f', 'username', 'password');
add_db_server('40', 'dc1', 1, 1,'','localhost', 'dbname_40', 'username', 'password');
add_db_server('41', 'dc1', 1, 1,'','localhost', 'dbname_41', 'username', 'password');
add_db_server('42', 'dc1', 1, 1,'','localhost', 'dbname_42', 'username', 'password');
add_db_server('43', 'dc1', 1, 1,'','localhost', 'dbname_43', 'username', 'password');
add_db_server('44', 'dc1', 1, 1,'','localhost', 'dbname_44', 'username', 'password');
add_db_server('45', 'dc1', 1, 1,'','localhost', 'dbname_45', 'username', 'password');
add_db_server('46', 'dc1', 1, 1,'','localhost', 'dbname_46', 'username', 'password');
add_db_server('47', 'dc1', 1, 1,'','localhost', 'dbname_47', 'username', 'password');
add_db_server('48', 'dc1', 1, 1,'','localhost', 'dbname_48', 'username', 'password');
add_db_server('49', 'dc1', 1, 1,'','localhost', 'dbname_49', 'username', 'password');
add_db_server('4a', 'dc1', 1, 1,'','localhost', 'dbname_4a', 'username', 'password');
add_db_server('4b', 'dc1', 1, 1,'','localhost', 'dbname_4b', 'username', 'password');
add_db_server('4c', 'dc1', 1, 1,'','localhost', 'dbname_4c', 'username', 'password');
add_db_server('4d', 'dc1', 1, 1,'','localhost', 'dbname_4d', 'username', 'password');
add_db_server('4e', 'dc1', 1, 1,'','localhost', 'dbname_4e', 'username', 'password');
add_db_server('4f', 'dc1', 1, 1,'','localhost', 'dbname_4f', 'username', 'password');
add_db_server('50', 'dc1', 1, 1,'','localhost', 'dbname_50', 'username', 'password');
add_db_server('51', 'dc1', 1, 1,'','localhost', 'dbname_51', 'username', 'password');
add_db_server('52', 'dc1', 1, 1,'','localhost', 'dbname_52', 'username', 'password');
add_db_server('53', 'dc1', 1, 1,'','localhost', 'dbname_53', 'username', 'password');
add_db_server('54', 'dc1', 1, 1,'','localhost', 'dbname_54', 'username', 'password');
add_db_server('55', 'dc1', 1, 1,'','localhost', 'dbname_55', 'username', 'password');
add_db_server('56', 'dc1', 1, 1,'','localhost', 'dbname_56', 'username', 'password');
add_db_server('57', 'dc1', 1, 1,'','localhost', 'dbname_57', 'username', 'password');
add_db_server('58', 'dc1', 1, 1,'','localhost', 'dbname_58', 'username', 'password');
add_db_server('59', 'dc1', 1, 1,'','localhost', 'dbname_59', 'username', 'password');
add_db_server('5a', 'dc1', 1, 1,'','localhost', 'dbname_5a', 'username', 'password');
add_db_server('5b', 'dc1', 1, 1,'','localhost', 'dbname_5b', 'username', 'password');
add_db_server('5c', 'dc1', 1, 1,'','localhost', 'dbname_5c', 'username', 'password');
add_db_server('5d', 'dc1', 1, 1,'','localhost', 'dbname_5d', 'username', 'password');
add_db_server('5e', 'dc1', 1, 1,'','localhost', 'dbname_5e', 'username', 'password');
add_db_server('5f', 'dc1', 1, 1,'','localhost', 'dbname_5f', 'username', 'password');
add_db_server('60', 'dc1', 1, 1,'','localhost', 'dbname_60', 'username', 'password');
add_db_server('61', 'dc1', 1, 1,'','localhost', 'dbname_61', 'username', 'password');
add_db_server('62', 'dc1', 1, 1,'','localhost', 'dbname_62', 'username', 'password');
add_db_server('63', 'dc1', 1, 1,'','localhost', 'dbname_63', 'username', 'password');
add_db_server('64', 'dc1', 1, 1,'','localhost', 'dbname_64', 'username', 'password');
add_db_server('65', 'dc1', 1, 1,'','localhost', 'dbname_65', 'username', 'password');
add_db_server('66', 'dc1', 1, 1,'','localhost', 'dbname_66', 'username', 'password');
add_db_server('67', 'dc1', 1, 1,'','localhost', 'dbname_67', 'username', 'password');
add_db_server('68', 'dc1', 1, 1,'','localhost', 'dbname_68', 'username', 'password');
add_db_server('69', 'dc1', 1, 1,'','localhost', 'dbname_69', 'username', 'password');
add_db_server('6a', 'dc1', 1, 1,'','localhost', 'dbname_6a', 'username', 'password');
add_db_server('6b', 'dc1', 1, 1,'','localhost', 'dbname_6b', 'username', 'password');
add_db_server('6c', 'dc1', 1, 1,'','localhost', 'dbname_6c', 'username', 'password');
add_db_server('6d', 'dc1', 1, 1,'','localhost', 'dbname_6d', 'username', 'password');
add_db_server('6e', 'dc1', 1, 1,'','localhost', 'dbname_6e', 'username', 'password');
add_db_server('6f', 'dc1', 1, 1,'','localhost', 'dbname_6f', 'username', 'password');
add_db_server('70', 'dc1', 1, 1,'','localhost', 'dbname_70', 'username', 'password');
add_db_server('71', 'dc1', 1, 1,'','localhost', 'dbname_71', 'username', 'password');
add_db_server('72', 'dc1', 1, 1,'','localhost', 'dbname_72', 'username', 'password');
add_db_server('73', 'dc1', 1, 1,'','localhost', 'dbname_73', 'username', 'password');
add_db_server('74', 'dc1', 1, 1,'','localhost', 'dbname_74', 'username', 'password');
add_db_server('75', 'dc1', 1, 1,'','localhost', 'dbname_75', 'username', 'password');
add_db_server('76', 'dc1', 1, 1,'','localhost', 'dbname_76', 'username', 'password');
add_db_server('77', 'dc1', 1, 1,'','localhost', 'dbname_77', 'username', 'password');
add_db_server('78', 'dc1', 1, 1,'','localhost', 'dbname_78', 'username', 'password');
add_db_server('79', 'dc1', 1, 1,'','localhost', 'dbname_79', 'username', 'password');
add_db_server('7a', 'dc1', 1, 1,'','localhost', 'dbname_7a', 'username', 'password');
add_db_server('7b', 'dc1', 1, 1,'','localhost', 'dbname_7b', 'username', 'password');
add_db_server('7c', 'dc1', 1, 1,'','localhost', 'dbname_7c', 'username', 'password');
add_db_server('7d', 'dc1', 1, 1,'','localhost', 'dbname_7d', 'username', 'password');
add_db_server('7e', 'dc1', 1, 1,'','localhost', 'dbname_7e', 'username', 'password');
add_db_server('7f', 'dc1', 1, 1,'','localhost', 'dbname_7f', 'username', 'password');
add_db_server('80', 'dc1', 1, 1,'','localhost', 'dbname_80', 'username', 'password');
add_db_server('81', 'dc1', 1, 1,'','localhost', 'dbname_81', 'username', 'password');
add_db_server('82', 'dc1', 1, 1,'','localhost', 'dbname_82', 'username', 'password');
add_db_server('83', 'dc1', 1, 1,'','localhost', 'dbname_83', 'username', 'password');
add_db_server('84', 'dc1', 1, 1,'','localhost', 'dbname_84', 'username', 'password');
add_db_server('85', 'dc1', 1, 1,'','localhost', 'dbname_85', 'username', 'password');
add_db_server('86', 'dc1', 1, 1,'','localhost', 'dbname_86', 'username', 'password');
add_db_server('87', 'dc1', 1, 1,'','localhost', 'dbname_87', 'username', 'password');
add_db_server('88', 'dc1', 1, 1,'','localhost', 'dbname_88', 'username', 'password');
add_db_server('89', 'dc1', 1, 1,'','localhost', 'dbname_89', 'username', 'password');
add_db_server('8a', 'dc1', 1, 1,'','localhost', 'dbname_8a', 'username', 'password');
add_db_server('8b', 'dc1', 1, 1,'','localhost', 'dbname_8b', 'username', 'password');
add_db_server('8c', 'dc1', 1, 1,'','localhost', 'dbname_8c', 'username', 'password');
add_db_server('8d', 'dc1', 1, 1,'','localhost', 'dbname_8d', 'username', 'password');
add_db_server('8e', 'dc1', 1, 1,'','localhost', 'dbname_8e', 'username', 'password');
add_db_server('8f', 'dc1', 1, 1,'','localhost', 'dbname_8f', 'username', 'password');
add_db_server('90', 'dc1', 1, 1,'','localhost', 'dbname_90', 'username', 'password');
add_db_server('91', 'dc1', 1, 1,'','localhost', 'dbname_91', 'username', 'password');
add_db_server('92', 'dc1', 1, 1,'','localhost', 'dbname_92', 'username', 'password');
add_db_server('93', 'dc1', 1, 1,'','localhost', 'dbname_93', 'username', 'password');
add_db_server('94', 'dc1', 1, 1,'','localhost', 'dbname_94', 'username', 'password');
add_db_server('95', 'dc1', 1, 1,'','localhost', 'dbname_95', 'username', 'password');
add_db_server('96', 'dc1', 1, 1,'','localhost', 'dbname_96', 'username', 'password');
add_db_server('97', 'dc1', 1, 1,'','localhost', 'dbname_97', 'username', 'password');
add_db_server('98', 'dc1', 1, 1,'','localhost', 'dbname_98', 'username', 'password');
add_db_server('99', 'dc1', 1, 1,'','localhost', 'dbname_99', 'username', 'password');
add_db_server('9a', 'dc1', 1, 1,'','localhost', 'dbname_9a', 'username', 'password');
add_db_server('9b', 'dc1', 1, 1,'','localhost', 'dbname_9b', 'username', 'password');
add_db_server('9c', 'dc1', 1, 1,'','localhost', 'dbname_9c', 'username', 'password');
add_db_server('9d', 'dc1', 1, 1,'','localhost', 'dbname_9d', 'username', 'password');
add_db_server('9e', 'dc1', 1, 1,'','localhost', 'dbname_9e', 'username', 'password');
add_db_server('9f', 'dc1', 1, 1,'','localhost', 'dbname_9f', 'username', 'password');
add_db_server('a0', 'dc1', 1, 1,'','localhost', 'dbname_a0', 'username', 'password');
add_db_server('a1', 'dc1', 1, 1,'','localhost', 'dbname_a1', 'username', 'password');
add_db_server('a2', 'dc1', 1, 1,'','localhost', 'dbname_a2', 'username', 'password');
add_db_server('a3', 'dc1', 1, 1,'','localhost', 'dbname_a3', 'username', 'password');
add_db_server('a4', 'dc1', 1, 1,'','localhost', 'dbname_a4', 'username', 'password');
add_db_server('a5', 'dc1', 1, 1,'','localhost', 'dbname_a5', 'username', 'password');
add_db_server('a6', 'dc1', 1, 1,'','localhost', 'dbname_a6', 'username', 'password');
add_db_server('a7', 'dc1', 1, 1,'','localhost', 'dbname_a7', 'username', 'password');
add_db_server('a8', 'dc1', 1, 1,'','localhost', 'dbname_a8', 'username', 'password');
add_db_server('a9', 'dc1', 1, 1,'','localhost', 'dbname_a9', 'username', 'password');
add_db_server('aa', 'dc1', 1, 1,'','localhost', 'dbname_aa', 'username', 'password');
add_db_server('ab', 'dc1', 1, 1,'','localhost', 'dbname_ab', 'username', 'password');
add_db_server('ac', 'dc1', 1, 1,'','localhost', 'dbname_ac', 'username', 'password');
add_db_server('ad', 'dc1', 1, 1,'','localhost', 'dbname_ad', 'username', 'password');
add_db_server('ae', 'dc1', 1, 1,'','localhost', 'dbname_ae', 'username', 'password');
add_db_server('af', 'dc1', 1, 1,'','localhost', 'dbname_af', 'username', 'password');
add_db_server('b0', 'dc1', 1, 1,'','localhost', 'dbname_b0', 'username', 'password');
add_db_server('b1', 'dc1', 1, 1,'','localhost', 'dbname_b1', 'username', 'password');
add_db_server('b2', 'dc1', 1, 1,'','localhost', 'dbname_b2', 'username', 'password');
add_db_server('b3', 'dc1', 1, 1,'','localhost', 'dbname_b3', 'username', 'password');
add_db_server('b4', 'dc1', 1, 1,'','localhost', 'dbname_b4', 'username', 'password');
add_db_server('b5', 'dc1', 1, 1,'','localhost', 'dbname_b5', 'username', 'password');
add_db_server('b6', 'dc1', 1, 1,'','localhost', 'dbname_b6', 'username', 'password');
add_db_server('b7', 'dc1', 1, 1,'','localhost', 'dbname_b7', 'username', 'password');
add_db_server('b8', 'dc1', 1, 1,'','localhost', 'dbname_b8', 'username', 'password');
add_db_server('b9', 'dc1', 1, 1,'','localhost', 'dbname_b9', 'username', 'password');
add_db_server('ba', 'dc1', 1, 1,'','localhost', 'dbname_ba', 'username', 'password');
add_db_server('bb', 'dc1', 1, 1,'','localhost', 'dbname_bb', 'username', 'password');
add_db_server('bc', 'dc1', 1, 1,'','localhost', 'dbname_bc', 'username', 'password');
add_db_server('bd', 'dc1', 1, 1,'','localhost', 'dbname_bd', 'username', 'password');
add_db_server('be', 'dc1', 1, 1,'','localhost', 'dbname_be', 'username', 'password');
add_db_server('bf', 'dc1', 1, 1,'','localhost', 'dbname_bf', 'username', 'password');
add_db_server('c0', 'dc1', 1, 1,'','localhost', 'dbname_c0', 'username', 'password');
add_db_server('c1', 'dc1', 1, 1,'','localhost', 'dbname_c1', 'username', 'password');
add_db_server('c2', 'dc1', 1, 1,'','localhost', 'dbname_c2', 'username', 'password');
add_db_server('c3', 'dc1', 1, 1,'','localhost', 'dbname_c3', 'username', 'password');
add_db_server('c4', 'dc1', 1, 1,'','localhost', 'dbname_c4', 'username', 'password');
add_db_server('c5', 'dc1', 1, 1,'','localhost', 'dbname_c5', 'username', 'password');
add_db_server('c6', 'dc1', 1, 1,'','localhost', 'dbname_c6', 'username', 'password');
add_db_server('c7', 'dc1', 1, 1,'','localhost', 'dbname_c7', 'username', 'password');
add_db_server('c8', 'dc1', 1, 1,'','localhost', 'dbname_c8', 'username', 'password');
add_db_server('c9', 'dc1', 1, 1,'','localhost', 'dbname_c9', 'username', 'password');
add_db_server('ca', 'dc1', 1, 1,'','localhost', 'dbname_ca', 'username', 'password');
add_db_server('cb', 'dc1', 1, 1,'','localhost', 'dbname_cb', 'username', 'password');
add_db_server('cc', 'dc1', 1, 1,'','localhost', 'dbname_cc', 'username', 'password');
add_db_server('cd', 'dc1', 1, 1,'','localhost', 'dbname_cd', 'username', 'password');
add_db_server('ce', 'dc1', 1, 1,'','localhost', 'dbname_ce', 'username', 'password');
add_db_server('cf', 'dc1', 1, 1,'','localhost', 'dbname_cf', 'username', 'password');
add_db_server('d0', 'dc1', 1, 1,'','localhost', 'dbname_d0', 'username', 'password');
add_db_server('d1', 'dc1', 1, 1,'','localhost', 'dbname_d1', 'username', 'password');
add_db_server('d2', 'dc1', 1, 1,'','localhost', 'dbname_d2', 'username', 'password');
add_db_server('d3', 'dc1', 1, 1,'','localhost', 'dbname_d3', 'username', 'password');
add_db_server('d4', 'dc1', 1, 1,'','localhost', 'dbname_d4', 'username', 'password');
add_db_server('d5', 'dc1', 1, 1,'','localhost', 'dbname_d5', 'username', 'password');
add_db_server('d6', 'dc1', 1, 1,'','localhost', 'dbname_d6', 'username', 'password');
add_db_server('d7', 'dc1', 1, 1,'','localhost', 'dbname_d7', 'username', 'password');
add_db_server('d8', 'dc1', 1, 1,'','localhost', 'dbname_d8', 'username', 'password');
add_db_server('d9', 'dc1', 1, 1,'','localhost', 'dbname_d9', 'username', 'password');
add_db_server('da', 'dc1', 1, 1,'','localhost', 'dbname_da', 'username', 'password');
add_db_server('db', 'dc1', 1, 1,'','localhost', 'dbname_db', 'username', 'password');
add_db_server('dc', 'dc1', 1, 1,'','localhost', 'dbname_dc', 'username', 'password');
add_db_server('dd', 'dc1', 1, 1,'','localhost', 'dbname_dd', 'username', 'password');
add_db_server('de', 'dc1', 1, 1,'','localhost', 'dbname_de', 'username', 'password');
add_db_server('df', 'dc1', 1, 1,'','localhost', 'dbname_df', 'username', 'password');
add_db_server('e0', 'dc1', 1, 1,'','localhost', 'dbname_e0', 'username', 'password');
add_db_server('e1', 'dc1', 1, 1,'','localhost', 'dbname_e1', 'username', 'password');
add_db_server('e2', 'dc1', 1, 1,'','localhost', 'dbname_e2', 'username', 'password');
add_db_server('e3', 'dc1', 1, 1,'','localhost', 'dbname_e3', 'username', 'password');
add_db_server('e4', 'dc1', 1, 1,'','localhost', 'dbname_e4', 'username', 'password');
add_db_server('e5', 'dc1', 1, 1,'','localhost', 'dbname_e5', 'username', 'password');
add_db_server('e6', 'dc1', 1, 1,'','localhost', 'dbname_e6', 'username', 'password');
add_db_server('e7', 'dc1', 1, 1,'','localhost', 'dbname_e7', 'username', 'password');
add_db_server('e8', 'dc1', 1, 1,'','localhost', 'dbname_e8', 'username', 'password');
add_db_server('e9', 'dc1', 1, 1,'','localhost', 'dbname_e9', 'username', 'password');
add_db_server('ea', 'dc1', 1, 1,'','localhost', 'dbname_ea', 'username', 'password');
add_db_server('eb', 'dc1', 1, 1,'','localhost', 'dbname_eb', 'username', 'password');
add_db_server('ec', 'dc1', 1, 1,'','localhost', 'dbname_ec', 'username', 'password');
add_db_server('ed', 'dc1', 1, 1,'','localhost', 'dbname_ed', 'username', 'password');
add_db_server('ee', 'dc1', 1, 1,'','localhost', 'dbname_ee', 'username', 'password');
add_db_server('ef', 'dc1', 1, 1,'','localhost', 'dbname_ef', 'username', 'password');
add_db_server('f0', 'dc1', 1, 1,'','localhost', 'dbname_f0', 'username', 'password');
add_db_server('f1', 'dc1', 1, 1,'','localhost', 'dbname_f1', 'username', 'password');
add_db_server('f2', 'dc1', 1, 1,'','localhost', 'dbname_f2', 'username', 'password');
add_db_server('f3', 'dc1', 1, 1,'','localhost', 'dbname_f3', 'username', 'password');
add_db_server('f4', 'dc1', 1, 1,'','localhost', 'dbname_f4', 'username', 'password');
add_db_server('f5', 'dc1', 1, 1,'','localhost', 'dbname_f5', 'username', 'password');
add_db_server('f6', 'dc1', 1, 1,'','localhost', 'dbname_f6', 'username', 'password');
add_db_server('f7', 'dc1', 1, 1,'','localhost', 'dbname_f7', 'username', 'password');
add_db_server('f8', 'dc1', 1, 1,'','localhost', 'dbname_f8', 'username', 'password');
add_db_server('f9', 'dc1', 1, 1,'','localhost', 'dbname_f9', 'username', 'password');
add_db_server('fa', 'dc1', 1, 1,'','localhost', 'dbname_fa', 'username', 'password');
add_db_server('fb', 'dc1', 1, 1,'','localhost', 'dbname_fb', 'username', 'password');
add_db_server('fc', 'dc1', 1, 1,'','localhost', 'dbname_fc', 'username', 'password');
add_db_server('fd', 'dc1', 1, 1,'','localhost', 'dbname_fd', 'username', 'password');
add_db_server('fe', 'dc1', 1, 1,'','localhost', 'dbname_fe', 'username', 'password');
add_db_server('ff', 'dc1', 1, 1,'','localhost', 'dbname_ff', 'username', 'password');
//------------------------------------------------------------------------//
//---VIP Blogs------------------------------------------------------------//
//------------------------------------------------------------------------//
// Usage: add_vip_blog(BLOG_ID, DS)
// EX: add_vip_blog(1, 'vip1');
add_vip_blog(1, 'vip1');
?>
<?php
/*
Plugin Name: Multi-DB (Conversion Tool)
Plugin URI: http://premium.wpmudev.org/project/Multiple-Databases
Description:
Author: Ron Dillehay - FanMail to rdillehay@hotmail.com (no tech support please) - Modified slightly by Andrew Billits (Incsub)
Version: 2.9.2
Author URI:
Descriptiom:
This script is to move blogs from a wordpress mu single database setup, to a wordpress mu multiple database setup using an MD5 hash to establish blog routing
Use this script at your own risk. My test setup uses php 5, mysql 5, and wordpress mu 1.2.5a
*/
//------------------------------------------------------------------------//
//---Config---------------------------------------------------------------//
//------------------------------------------------------------------------//
///DB Settings
$dbname = "dbname_wrdp1"; //This is your current database
$blog_table_prefix = 'wp_'; //Prefix of your wpmu blog tables, most likely this won't need to be changed
$newdb_prefix = 'dbname_'; //This is the prefix of the db's you're moving your tables into - we assume they are all the same, if not, you're in trouble
//We need info to connect to the databases
$dbhost = 'localhost';
$dbuname = 'dbname_username';
$dbpass = 'pwd';
//How many db's are you moving into (16, 256, or 4096)?
$db_scaling = '256';
//------------------------------------------------------------------------//
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Multiple Databases Conversion Tool</title>
<head>
<style type="text/css">
table.stats
{text-align: center; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif ; font-weight: normal;font-size: 12px;color: #fff;width: 750px;background-color: #666;border: 1px solid #555;border-collapse: collapse;border-spacing: 1px;}
table.stats td
{background-color: #CCC;color: #000;padding: 6px;text-align: left;border: 1px #fff solid;}
table.stats td.head
{background-color: #666;color: #fff;padding: 6px;text-align: center;border-bottom: 2px #fff solid;font-size: 12px;font-weight: bold;}
</style>
</head>
<?php
if ($db_scaling == '16'){
$newdbsize = '1';
} else if ($db_scaling == '256'){
$newdbsize = '2';
} else if ($db_scaling == '4096'){
$newdbsize = '3';
}
//Check to see if we are moving tables yet
$tabletomove = $_REQUEST["table"];
//Connect to SQL
if (!mysql_connect($dbhost, $dbuname, $dbpass)) {
echo 'Could not connect to mysql';
exit;
}
//Get our table list from the original db
$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);
if (!$result) {
echo "DB Error, could not list tables <br /> <b>Make sure you configure your original table in the dbname variable at the top of the script!</b><br />\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
echo "<table align='center' class='stats'><tr><td colspan='4' align='center'><br /><ol>
<li>Tested on PHP 5 & MySQL 5</li>
<li>Make sure all of your new db's exist (green text next to table name in db column below)</li>
<li>In the status section, each table should show <i>not in new db (unless you've already run this script)</i></li>
<li>To start the copy process <a href='move-blogs.php?table=copy'>click here</a> </li>
<li>Be patient, depending on how many blogs you have, this could take a while</li>
<li>Once completed, refresh this page by <a href='move-blogs.php'>clicking here</a></li>
<li>Check to make sure that in the status section all tables say <i>table in new db</i></li>
<li>Rejoice, I probably just saved you hours of your life!</li>
<li>If this didn't work, don't blame me. Sometimes life is just like that..</li></ol>
</td></tr><tr><td class='head' width='25%'>table name</td><td class='head' width='25%'>table info</td><td class='head' width='25%'>new db</td><td class='head' width='25%'>status</td></tr>";
while ($row = mysql_fetch_row($result)) {
//Here we find our blog id, hash it, and establish our new db names
$blogid_get = explode("_", $row[0]);
$blogid = $blogid_get[1];
$md5_hash = md5($blogid);
$md5_dbprefix = substr($md5_hash, 0, $newdbsize);
$this_blog_new_db = $newdb_prefix.$md5_dbprefix;
if ( !is_numeric($blogid) ) {
// this is a global table
$this_blog_new_db = $newdb_prefix."global";
}
/*
if ( $blogid == 1 ) {
$this_blog_new_db = $newdb_prefix."_home";
} elseif ( !is_numeric($blogid) ) {
// this is a global table
$this_blog_new_db = $newdb_prefix."_global";
}
*/
$db = mysql_connect($dbhost, $dbuname, $dbpass) or die("Houston, we have a problem! <br />Database Error: ".mysql_error());
mysql_select_db($this_blog_new_db, $db) or die("Houston, we have a problem! <br /><b> Looks like you need to create your new db's! If you're lucky, this link still works - <a href='http://calc.idtstudios.com/db.php'>click me</a> </b><br />Database Error: ".mysql_error());
if( mysql_num_rows( mysql_query("SHOW TABLES LIKE '".$row[0]."'"))) { $tabletest = "<font color='green'>table in new db</font>"; } else { $tabletest = "table not in new db"; }
//Filter out the nonblog tables
if ( is_numeric($blogid) ) {
//Next we check to see if we are actually moving anything yet
if ($tabletomove != "") {
//This is where the heavy lifting is done - amazing only four lines of code can save so much time! Tested on php 5 - mysql 5
$sql_table = "CREATE TABLE $row[0] LIKE $dbname.$row[0]";
$insert_info = "INSERT INTO $row[0] SELECT * FROM $dbname.$row[0]";
mysql_query($sql_table);
mysql_query($insert_info);
mysql_free_result($sql_table);
mysql_free_result($insert_info);
}
//Close the db and report db status
mysql_close($db); $testpass = "<font color='green'>&nbsp;exists</font>";
echo "<tr><td>{$row[0]}</td><td>blog {$blogid}</td><td>{$this_blog_new_db} <i>{$testpass}</i></td><td>{$tabletest}</td></tr>";
} else {
// this is a global db.
//Next we check to see if we are actually moving anything yet
if ($tabletomove != "") {
//This is where the heavy lifting is done - amazing only four lines of code can save so much time! Tested on php 5 - mysql 5
$sql_table = "CREATE TABLE $row[0] LIKE $dbname.$row[0]";
$insert_info = "INSERT INTO $row[0] SELECT * FROM $dbname.$row[0]";
mysql_query($sql_table);
mysql_query($insert_info);
mysql_free_result($sql_table);
mysql_free_result($insert_info);
}
//Close the db and report db status
mysql_close($db); $testpass = "<font color='green'>&nbsp;exists</font>";
echo "<tr><td>{$row[0]}</td><td>blog {$blogid}</td><td>{$this_blog_new_db} <i>{$testpass}</i></td><td>{$tabletest}</td></tr>";
}
} // end while
echo "</table>";
//Clean up after ourselves
echo "<center>Ignore any errors below this line</center>";
echo "<center>================================================================================</center>";
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment