Multi-db version 3.0.2 beta tests

Hi all

I'm doing some work on the multi-db plugin to:
a) make it's error reporting friendlier
b) making it more failover ready for sites with multiple servers / replication
c) fixing some little bugs people have come across

I have a few different approaches I can take with the rewrites so I'm going to release a couple and hopefully get your opinion on whether certain versions speed up / slow down your site, cause additional errors / remove any errors you have.

The first beta test is attached to this post, it is only the db.php file - you will need to already have / or set up a db-config.php file to test this (it is primarily for those who already have a multi-db set up and working configuration).

Just replace the db.php file here with the existing one and things should carry on working as before.

Thanks
Barry

  • turkon

    I got the following error when I upload your db php. And website has completely down.
    Then I upload the normal db file it is ok again.

    Warning: mysql_get_server_info(): supplied argument is not a valid MySQL-Link resource in /home/ra6org1/public_html/wp-content/db.php on line 656

    Warning: Cannot modify header information - headers already sent by (output started at /home/ra6org1/public_html/wp-content/db.php:656) in /home/ra6org1/public_html/wp-includes/functions.php on line 3125

    Error establishing a database connection

  • turkon

    Here it is.

    <?php
    // Plugin Name: Multi-DB
    // Plugin URI: https://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('123.123.123.', 'dc1');
    add_dc_ip('174.123.140.120', 'dc1');
    //------------------------------------------------------------------------//
    //---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('ra6org1_global');
    add_global_table('autoblog');

    add_global_table('blog_versions');
    add_global_table('commentmeta');
    add_global_table('comments');
    add_global_table('links');
    add_global_table('options');
    add_global_table('postmeta');
    add_global_table('posts');
    add_global_table('registration_log');
    add_global_table('scaptcha');
    add_global_table('scaptcha_logs');
    add_global_table('signups');
    add_global_table('signup_language');
    add_global_table('site');
    add_global_table('sitemeta');
    add_global_table('site_posts');
    add_global_table('support_faq');
    add_global_table('support_faq_cats');
    add_global_table('support_tickets');
    add_global_table('support_tickets_cats');
    add_global_table('support_tickets_messages');
    add_global_table('terms');
    add_global_table('term_counts');
    add_global_table('term_relationships');
    add_global_table('term_taxonomy');
    add_global_table('usermeta');
    add_global_table('ust');
    add_global_table('supporters');
    add_global_table('supporter_signup_stats');
    add_global_table('supporter_daily_stats');
    add_global_table('supporter_ads');

    //------------------------------------------------------------------------//
    //---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
    // 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,'174.123.140.120','localhost', 'ra6org1_global', 'ra6org1_new', 'somepassword');

    add_db_server('00', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_00', 'ra6org1_new', 'somepassword');
    add_db_server('01', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_01', 'ra6org1_new', 'somepassword');
    add_db_server('02', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_02', 'ra6org1_new', 'somepassword');
    add_db_server('03', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_03', 'ra6org1_new', 'somepassword');
    add_db_server('04', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_04', 'ra6org1_new', 'somepassword');
    add_db_server('05', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_05', 'ra6org1_new', 'somepassword');
    add_db_server('06', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_06', 'ra6org1_new', 'somepassword');
    add_db_server('07', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_07', 'ra6org1_new', 'somepassword');
    add_db_server('08', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_08', 'ra6org1_new', 'somepassword');
    add_db_server('09', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_09', 'ra6org1_new', 'somepassword');
    add_db_server('0a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_0a', 'ra6org1_new', 'somepassword');
    add_db_server('0b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_0b', 'ra6org1_new', 'somepassword');
    add_db_server('0c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_0c', 'ra6org1_new', 'somepassword');
    add_db_server('0d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_0d', 'ra6org1_new', 'somepassword');
    add_db_server('0e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_0e', 'ra6org1_new', 'somepassword');
    add_db_server('0f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_0f', 'ra6org1_new', 'somepassword');
    add_db_server('10', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_10', 'ra6org1_new', 'somepassword');
    add_db_server('11', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_11', 'ra6org1_new', 'somepassword');
    add_db_server('12', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_12', 'ra6org1_new', 'somepassword');
    add_db_server('13', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_13', 'ra6org1_new', 'somepassword');
    add_db_server('14', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_14', 'ra6org1_new', 'somepassword');
    add_db_server('15', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_15', 'ra6org1_new', 'somepassword');
    add_db_server('16', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_16', 'ra6org1_new', 'somepassword');
    add_db_server('17', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_17', 'ra6org1_new', 'somepassword');
    add_db_server('18', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_18', 'ra6org1_new', 'somepassword');
    add_db_server('19', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_19', 'ra6org1_new', 'somepassword');
    add_db_server('1a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_1a', 'ra6org1_new', 'somepassword');
    add_db_server('1b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_1b', 'ra6org1_new', 'somepassword');
    add_db_server('1c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_1c', 'ra6org1_new', 'somepassword');
    add_db_server('1d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_1d', 'ra6org1_new', 'somepassword');
    add_db_server('1e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_1e', 'ra6org1_new', 'somepassword');
    add_db_server('1f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_1f', 'ra6org1_new', 'somepassword');
    add_db_server('20', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_20', 'ra6org1_new', 'somepassword');
    add_db_server('21', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_21', 'ra6org1_new', 'somepassword');
    add_db_server('22', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_22', 'ra6org1_new', 'somepassword');
    add_db_server('23', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_23', 'ra6org1_new', 'somepassword');
    add_db_server('24', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_24', 'ra6org1_new', 'somepassword');
    add_db_server('25', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_25', 'ra6org1_new', 'somepassword');
    add_db_server('26', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_26', 'ra6org1_new', 'somepassword');
    add_db_server('27', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_27', 'ra6org1_new', 'somepassword');
    add_db_server('28', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_28', 'ra6org1_new', 'somepassword');
    add_db_server('29', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_29', 'ra6org1_new', 'somepassword');
    add_db_server('2a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_2a', 'ra6org1_new', 'somepassword');
    add_db_server('2b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_2b', 'ra6org1_new', 'somepassword');
    add_db_server('2c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_2c', 'ra6org1_new', 'somepassword');
    add_db_server('2d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_2d', 'ra6org1_new', 'somepassword');
    add_db_server('2e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_2e', 'ra6org1_new', 'somepassword');
    add_db_server('2f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_2f', 'ra6org1_new', 'somepassword');
    add_db_server('30', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_30', 'ra6org1_new', 'somepassword');
    add_db_server('31', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_31', 'ra6org1_new', 'somepassword');
    add_db_server('32', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_32', 'ra6org1_new', 'somepassword');
    add_db_server('33', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_33', 'ra6org1_new', 'somepassword');
    add_db_server('34', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_34', 'ra6org1_new', 'somepassword');
    add_db_server('35', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_35', 'ra6org1_new', 'somepassword');
    add_db_server('36', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_36', 'ra6org1_new', 'somepassword');
    add_db_server('37', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_37', 'ra6org1_new', 'somepassword');
    add_db_server('38', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_38', 'ra6org1_new', 'somepassword');
    add_db_server('39', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_39', 'ra6org1_new', 'somepassword');
    add_db_server('3a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_3a', 'ra6org1_new', 'somepassword');
    add_db_server('3b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_3b', 'ra6org1_new', 'somepassword');
    add_db_server('3c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_3c', 'ra6org1_new', 'somepassword');
    add_db_server('3d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_3d', 'ra6org1_new', 'somepassword');
    add_db_server('3e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_3e', 'ra6org1_new', 'somepassword');
    add_db_server('3f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_3f', 'ra6org1_new', 'somepassword');
    add_db_server('40', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_40', 'ra6org1_new', 'somepassword');
    add_db_server('41', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_41', 'ra6org1_new', 'somepassword');
    add_db_server('42', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_42', 'ra6org1_new', 'somepassword');
    add_db_server('43', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_43', 'ra6org1_new', 'somepassword');
    add_db_server('44', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_44', 'ra6org1_new', 'somepassword');
    add_db_server('45', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_45', 'ra6org1_new', 'somepassword');
    add_db_server('46', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_46', 'ra6org1_new', 'somepassword');
    add_db_server('47', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_47', 'ra6org1_new', 'somepassword');
    add_db_server('48', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_48', 'ra6org1_new', 'somepassword');
    add_db_server('49', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_49', 'ra6org1_new', 'somepassword');
    add_db_server('4a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_4a', 'ra6org1_new', 'somepassword');
    add_db_server('4b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_4b', 'ra6org1_new', 'somepassword');
    add_db_server('4c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_4c', 'ra6org1_new', 'somepassword');
    add_db_server('4d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_4d', 'ra6org1_new', 'somepassword');
    add_db_server('4e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_4e', 'ra6org1_new', 'somepassword');
    add_db_server('4f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_4f', 'ra6org1_new', 'somepassword');
    add_db_server('50', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_50', 'ra6org1_new', 'somepassword');
    add_db_server('51', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_51', 'ra6org1_new', 'somepassword');
    add_db_server('52', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_52', 'ra6org1_new', 'somepassword');
    add_db_server('53', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_53', 'ra6org1_new', 'somepassword');
    add_db_server('54', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_54', 'ra6org1_new', 'somepassword');
    add_db_server('55', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_55', 'ra6org1_new', 'somepassword');
    add_db_server('56', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_56', 'ra6org1_new', 'somepassword');
    add_db_server('57', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_57', 'ra6org1_new', 'somepassword');
    add_db_server('58', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_58', 'ra6org1_new', 'somepassword');
    add_db_server('59', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_59', 'ra6org1_new', 'somepassword');
    add_db_server('5a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_5a', 'ra6org1_new', 'somepassword');
    add_db_server('5b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_5b', 'ra6org1_new', 'somepassword');
    add_db_server('5c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_5c', 'ra6org1_new', 'somepassword');
    add_db_server('5d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_5d', 'ra6org1_new', 'somepassword');
    add_db_server('5e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_5e', 'ra6org1_new', 'somepassword');
    add_db_server('5f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_5f', 'ra6org1_new', 'somepassword');
    add_db_server('60', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_60', 'ra6org1_new', 'somepassword');
    add_db_server('61', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_61', 'ra6org1_new', 'somepassword');
    add_db_server('62', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_62', 'ra6org1_new', 'somepassword');
    add_db_server('63', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_63', 'ra6org1_new', 'somepassword');
    add_db_server('64', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_64', 'ra6org1_new', 'somepassword');
    add_db_server('65', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_65', 'ra6org1_new', 'somepassword');
    add_db_server('66', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_66', 'ra6org1_new', 'somepassword');
    add_db_server('67', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_67', 'ra6org1_new', 'somepassword');
    add_db_server('68', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_68', 'ra6org1_new', 'somepassword');
    add_db_server('69', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_69', 'ra6org1_new', 'somepassword');
    add_db_server('6a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_6a', 'ra6org1_new', 'somepassword');
    add_db_server('6b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_6b', 'ra6org1_new', 'somepassword');
    add_db_server('6c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_6c', 'ra6org1_new', 'somepassword');
    add_db_server('6d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_6d', 'ra6org1_new', 'somepassword');
    add_db_server('6e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_6e', 'ra6org1_new', 'somepassword');
    add_db_server('6f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_6f', 'ra6org1_new', 'somepassword');
    add_db_server('70', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_70', 'ra6org1_new', 'somepassword');
    add_db_server('71', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_71', 'ra6org1_new', 'somepassword');
    add_db_server('72', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_72', 'ra6org1_new', 'somepassword');
    add_db_server('73', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_73', 'ra6org1_new', 'somepassword');
    add_db_server('74', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_74', 'ra6org1_new', 'somepassword');
    add_db_server('75', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_75', 'ra6org1_new', 'somepassword');
    add_db_server('76', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_76', 'ra6org1_new', 'somepassword');
    add_db_server('77', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_77', 'ra6org1_new', 'somepassword');
    add_db_server('78', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_78', 'ra6org1_new', 'somepassword');
    add_db_server('79', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_79', 'ra6org1_new', 'somepassword');
    add_db_server('7a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_7a', 'ra6org1_new', 'somepassword');
    add_db_server('7b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_7b', 'ra6org1_new', 'somepassword');
    add_db_server('7c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_7c', 'ra6org1_new', 'somepassword');
    add_db_server('7d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_7d', 'ra6org1_new', 'somepassword');
    add_db_server('7e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_7e', 'ra6org1_new', 'somepassword');
    add_db_server('7f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_7f', 'ra6org1_new', 'somepassword');
    add_db_server('80', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_80', 'ra6org1_new', 'somepassword');
    add_db_server('81', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_81', 'ra6org1_new', 'somepassword');
    add_db_server('82', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_82', 'ra6org1_new', 'somepassword');
    add_db_server('83', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_83', 'ra6org1_new', 'somepassword');
    add_db_server('84', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_84', 'ra6org1_new', 'somepassword');
    add_db_server('85', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_85', 'ra6org1_new', 'somepassword');
    add_db_server('86', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_86', 'ra6org1_new', 'somepassword');
    add_db_server('87', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_87', 'ra6org1_new', 'somepassword');
    add_db_server('88', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_88', 'ra6org1_new', 'somepassword');
    add_db_server('89', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_89', 'ra6org1_new', 'somepassword');
    add_db_server('8a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_8a', 'ra6org1_new', 'somepassword');
    add_db_server('8b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_8b', 'ra6org1_new', 'somepassword');
    add_db_server('8c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_8c', 'ra6org1_new', 'somepassword');
    add_db_server('8d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_8d', 'ra6org1_new', 'somepassword');
    add_db_server('8e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_8e', 'ra6org1_new', 'somepassword');
    add_db_server('8f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_8f', 'ra6org1_new', 'somepassword');
    add_db_server('90', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_90', 'ra6org1_new', 'somepassword');
    add_db_server('91', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_91', 'ra6org1_new', 'somepassword');
    add_db_server('92', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_92', 'ra6org1_new', 'somepassword');
    add_db_server('93', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_93', 'ra6org1_new', 'somepassword');
    add_db_server('94', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_94', 'ra6org1_new', 'somepassword');
    add_db_server('95', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_95', 'ra6org1_new', 'somepassword');
    add_db_server('96', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_96', 'ra6org1_new', 'somepassword');
    add_db_server('97', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_97', 'ra6org1_new', 'somepassword');
    add_db_server('98', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_98', 'ra6org1_new', 'somepassword');
    add_db_server('99', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_99', 'ra6org1_new', 'somepassword');
    add_db_server('9a', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_9a', 'ra6org1_new', 'somepassword');
    add_db_server('9b', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_9b', 'ra6org1_new', 'somepassword');
    add_db_server('9c', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_9c', 'ra6org1_new', 'somepassword');
    add_db_server('9d', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_9d', 'ra6org1_new', 'somepassword');
    add_db_server('9e', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_9e', 'ra6org1_new', 'somepassword');
    add_db_server('9f', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_9f', 'ra6org1_new', 'somepassword');
    add_db_server('a0', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a0', 'ra6org1_new', 'somepassword');
    add_db_server('a1', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a1', 'ra6org1_new', 'somepassword');
    add_db_server('a2', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a2', 'ra6org1_new', 'somepassword');
    add_db_server('a3', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a3', 'ra6org1_new', 'somepassword');
    add_db_server('a4', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a4', 'ra6org1_new', 'somepassword');
    add_db_server('a5', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a5', 'ra6org1_new', 'somepassword');
    add_db_server('a6', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a6', 'ra6org1_new', 'somepassword');
    add_db_server('a7', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a7', 'ra6org1_new', 'somepassword');
    add_db_server('a8', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a8', 'ra6org1_new', 'somepassword');
    add_db_server('a9', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_a9', 'ra6org1_new', 'somepassword');
    add_db_server('aa', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_aa', 'ra6org1_new', 'somepassword');
    add_db_server('ab', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ab', 'ra6org1_new', 'somepassword');
    add_db_server('ac', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ac', 'ra6org1_new', 'somepassword');
    add_db_server('ad', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ad', 'ra6org1_new', 'somepassword');
    add_db_server('ae', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ae', 'ra6org1_new', 'somepassword');
    add_db_server('af', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_af', 'ra6org1_new', 'somepassword');
    add_db_server('b0', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b0', 'ra6org1_new', 'somepassword');
    add_db_server('b1', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b1', 'ra6org1_new', 'somepassword');
    add_db_server('b2', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b2', 'ra6org1_new', 'somepassword');
    add_db_server('b3', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b3', 'ra6org1_new', 'somepassword');
    add_db_server('b4', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b4', 'ra6org1_new', 'somepassword');
    add_db_server('b5', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b5', 'ra6org1_new', 'somepassword');
    add_db_server('b6', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b6', 'ra6org1_new', 'somepassword');
    add_db_server('b7', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b7', 'ra6org1_new', 'somepassword');
    add_db_server('b8', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b8', 'ra6org1_new', 'somepassword');
    add_db_server('b9', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_b9', 'ra6org1_new', 'somepassword');
    add_db_server('ba', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ba', 'ra6org1_new', 'somepassword');
    add_db_server('bb', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_bb', 'ra6org1_new', 'somepassword');
    add_db_server('bc', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_bc', 'ra6org1_new', 'somepassword');
    add_db_server('bd', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_bd', 'ra6org1_new', 'somepassword');
    add_db_server('be', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_be', 'ra6org1_new', 'somepassword');
    add_db_server('bf', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_bf', 'ra6org1_new', 'somepassword');
    add_db_server('c0', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c0', 'ra6org1_new', 'somepassword');
    add_db_server('c1', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c1', 'ra6org1_new', 'somepassword');
    add_db_server('c2', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c2', 'ra6org1_new', 'somepassword');
    add_db_server('c3', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c3', 'ra6org1_new', 'somepassword');
    add_db_server('c4', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c4', 'ra6org1_new', 'somepassword');
    add_db_server('c5', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c5', 'ra6org1_new', 'somepassword');
    add_db_server('c6', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c6', 'ra6org1_new', 'somepassword');
    add_db_server('c7', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c7', 'ra6org1_new', 'somepassword');
    add_db_server('c8', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c8', 'ra6org1_new', 'somepassword');
    add_db_server('c9', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_c9', 'ra6org1_new', 'somepassword');
    add_db_server('ca', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ca', 'ra6org1_new', 'somepassword');
    add_db_server('cb', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_cb', 'ra6org1_new', 'somepassword');
    add_db_server('cc', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_cc', 'ra6org1_new', 'somepassword');
    add_db_server('cd', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_cd', 'ra6org1_new', 'somepassword');
    add_db_server('ce', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ce', 'ra6org1_new', 'somepassword');
    add_db_server('cf', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_cf', 'ra6org1_new', 'somepassword');
    add_db_server('d0', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d0', 'ra6org1_new', 'somepassword');
    add_db_server('d1', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d1', 'ra6org1_new', 'somepassword');
    add_db_server('d2', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d2', 'ra6org1_new', 'somepassword');
    add_db_server('d3', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d3', 'ra6org1_new', 'somepassword');
    add_db_server('d4', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d4', 'ra6org1_new', 'somepassword');
    add_db_server('d5', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d5', 'ra6org1_new', 'somepassword');
    add_db_server('d6', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d6', 'ra6org1_new', 'somepassword');
    add_db_server('d7', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d7', 'ra6org1_new', 'somepassword');
    add_db_server('d8', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d8', 'ra6org1_new', 'somepassword');
    add_db_server('d9', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_d9', 'ra6org1_new', 'somepassword');
    add_db_server('da', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_da', 'ra6org1_new', 'somepassword');
    add_db_server('db', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_db', 'ra6org1_new', 'somepassword');
    add_db_server('dc', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_dc', 'ra6org1_new', 'somepassword');
    add_db_server('dd', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_dd', 'ra6org1_new', 'somepassword');
    add_db_server('de', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_de', 'ra6org1_new', 'somepassword');
    add_db_server('df', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_df', 'ra6org1_new', 'somepassword');
    add_db_server('e0', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e0', 'ra6org1_new', 'somepassword');
    add_db_server('e1', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e1', 'ra6org1_new', 'somepassword');
    add_db_server('e2', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e2', 'ra6org1_new', 'somepassword');
    add_db_server('e3', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e3', 'ra6org1_new', 'somepassword');
    add_db_server('e4', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e4', 'ra6org1_new', 'somepassword');
    add_db_server('e5', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e5', 'ra6org1_new', 'somepassword');
    add_db_server('e6', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e6', 'ra6org1_new', 'somepassword');
    add_db_server('e7', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e7', 'ra6org1_new', 'somepassword');
    add_db_server('e8', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e8', 'ra6org1_new', 'somepassword');
    add_db_server('e9', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_e9', 'ra6org1_new', 'somepassword');
    add_db_server('ea', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ea', 'ra6org1_new', 'somepassword');
    add_db_server('eb', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_eb', 'ra6org1_new', 'somepassword');
    add_db_server('ec', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ec', 'ra6org1_new', 'somepassword');
    add_db_server('ed', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ed', 'ra6org1_new', 'somepassword');
    add_db_server('ee', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ee', 'ra6org1_new', 'somepassword');
    add_db_server('ef', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ef', 'ra6org1_new', 'somepassword');
    add_db_server('f0', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f0', 'ra6org1_new', 'somepassword');
    add_db_server('f1', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f1', 'ra6org1_new', 'somepassword');
    add_db_server('f2', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f2', 'ra6org1_new', 'somepassword');
    add_db_server('f3', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f3', 'ra6org1_new', 'somepassword');
    add_db_server('f4', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f4', 'ra6org1_new', 'somepassword');
    add_db_server('f5', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f5', 'ra6org1_new', 'somepassword');
    add_db_server('f6', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f6', 'ra6org1_new', 'somepassword');
    add_db_server('f7', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f7', 'ra6org1_new', 'somepassword');
    add_db_server('f8', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f8', 'ra6org1_new', 'somepassword');
    add_db_server('f9', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_f9', 'ra6org1_new', 'somepassword');
    add_db_server('fa', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_fa', 'ra6org1_new', 'somepassword');
    add_db_server('fb', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_fb', 'ra6org1_new', 'somepassword');
    add_db_server('fc', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_fc', 'ra6org1_new', 'somepassword');
    add_db_server('fd', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_fd', 'ra6org1_new', 'somepassword');
    add_db_server('fe', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_fe', 'ra6org1_new', 'somepassword');
    add_db_server('ff', 'dc1', 1, 1,'174.123.140.120','localhost', 'ra6org1_ff', 'ra6org1_new', 'somepassword');

    //------------------------------------------------------------------------//
    //---VIP Blogs------------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Usage: add_vip_blog(BLOG_ID, DS)
    // EX: add_vip_blog(1, 'vip1');

    ?>

  • turkon

    I also get the following error in admin area when I upload the neb db.php

    Warning: mysql_get_server_info(): supplied argument is not a valid MySQL-Link resource in /home/ra6org1/public_html/wp-content/db.php on line 656

    Can’t select database

    We were able to connect to the database server (which means your username and password is okay) but not able to select the ra6org1_global database.

    * Are you sure it exists?
    * Does the user ra6org1_new have permission to use the ra6org1_global database?
    * On some systems the name of your database is prefixed with your username, so it would be like username_ra6org1_global. Could that be the problem?

  • turkon

    ra6org1_global
    Users in global
    ra6org1_new (Privileges: ALL PRIVILEGES)

    This is from cpanel. So the user has all privileges for the database.

    Can you check the errors in my admin control panel if it is possible to send my passwords. There are users who use my website. So I don't want to make any mistake.

    When I click to the users section in super admin panel, I got the error only in the third page.

    There are also the same error near the avatar edit section for some users in this 3rd page.

    Warning: mysql_real_escape_string(): 16 is not a valid MySQL-Link resource in /home/ra6org1/public_html/wp-includes/wp-db.php on line 785

  • Nu Eranet

    Hi Turkon,

    Just jumped into the membership with wpmudev. Running MS and the idea is to create a system whereby I can have a main wordpress site running and then replicate the other site using the network setup. What I am looking for is for a way to limit the pages the the sites have compared to the main site. Is this possible with your plugin?

    This is extremely useful is you are running a membership site using WishList as the membership site plugin and then allowing people to sign up for a free, or premium membership. Once they do that we can either automatically create a blog site or manually create it but from within the MS Network I would like the ability to choose what content will appear on that site blog, (pages, posts, plugins, etc.)

    Thanks

    Peter