Problem with wpmu_global in one server and the rest of the wpmu_XXX in other server

I have one server A with wpmu_global
another server B with other wpmu_NNN files

the problem is even after i've set in db-config.php
Global database is add_db_server('global', 'dc2', 1, 1,'....)
others add_db_server('000', 'dc1', 1, 1,....)

add_global_tables('bb_meta');
add_global_tables('usermeta');
add_global_tables('users');

only these three tables goes to server B instead of server A

What's the problem? I'm using 4096 scaling

Sam

  • drmike

    Please upload your db-config.php file someone as a text file and provide a link. Asking that instead of a copy and paste here to the forums because 1) bbpress eats code and 2) the number of databases involved. Please be sure to edit out your passwords.

    add_global_tables('usermeta');
    add_global_tables('users');

    Those do need to be removed from the config file. Those are the default globals and don;t need to be included. Any f those 8 can and should be removed.

    I have a feeling though that you;ve got a plugin somewhere hardcoded incorrectly that doesn;t use the standard wp->db calls. Kind of bad with database calls. Someone else is going to have to expand on this.

  • hwong

    The problem is, bb_meta, users_meta, users are updated on server MMM.MMM.MMM.MMM instead of NNN.NNN.NNN.NNN

    Please help. 500 timeout is what I get if I go to wp-admin using the admin account. Otherwise, normal accounts can access their respective wp-admin. I need to remove "buddypress" folder from "wp-content/plugins" folder to gain access into wp-admin. Error logs are timeout errors. I've set 300sec but it's still time out. How do I check for errors? Most ways have been considered.

    db-config.php as below. All help appreciated. Thanks.

    define ('DB_SCALING', '4096');
    //------------------------------------------------------------------------//
    //---DC IPs---------------------------------------------------------------//
    //------------------------------------------------------------------------//
    // Usage: add_dc_ip(IP, DC)
    // EX: add_dc_ip('123.123.123.', 'dc1');
    add_dc_ip('NNN.NNN.NNN.', 'dc1');
    add_dc_ip('MMM.MMM.MMM.', 'dc2');
    //------------------------------------------------------------------------//
    //---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('something');

    // BuddyPress
    add_global_table('bp_forums');
    add_global_table('bp_meta');
    add_global_table('bb_meta');
    add_global_table('bb_posts');
    add_global_table('bp_posts');
    add_global_table('bb_term_relationships');
    add_global_table('bb_term_taxonomy');
    add_global_table('bb_terms');
    add_global_table('bb_topics');
    add_global_table('bp_activity');
    add_global_table('bp_activity_meta');

    add_global_table('bp_activity_sitewide');
    add_global_table('bp_activity_user_activity');
    add_global_table('bp_activity_user_activity_cached');
    add_global_table('bp_friends');
    add_global_table('bp_groups');
    add_global_table('bp_groups_groupmeta');
    add_global_table('bp_groups_members');
    add_global_table('bp_groups_wire');
    add_global_table('bp_messages_messages');
    add_global_table('bp_messages_notices');
    add_global_table('bp_messages_recipients');
    //add_global_table('bp_messages_threads');
    add_global_table('bp_notifications');
    add_global_table('bp_user_blogs');
    add_global_table('bp_user_blogs_blogmeta');
    add_global_table('bp_user_blogs_comments');
    add_global_table('bp_user_blogs_posts');
    add_global_table('bp_xprofile_data');
    add_global_table('bp_xprofile_fields');
    add_global_table('bp_xprofile_groups');
    add_global_table('bp_xprofile_wire');

    add_global_table('wp_1_membership_levels');
    add_global_table('wp_1_membership_relationships');
    add_global_table('wp_1_membership_rules');
    add_global_table('wp_1_subscriptions');
    add_global_table('wp_1_membership_relationships');
    add_global_table('wp_1_membership_levels');

    add_global_table('usermeta');
    add_global_table('users');

    add_global_table('sitemeta');
    add_global_table('ust');
    add_global_table('autoblog');
    add_global_table('affiliatedata');
    add_global_table('affiliatereferrers');

    add_global_table('mass_mailer');
    add_global_table('tips');

    //BCZ Forums
    add_global_table('forums');
    add_global_table('forums_topics');
    add_global_table('forums_posts');

    //BCZ Upgrades
    add_global_table('upgrades_credits');
    add_global_table('upgrades_package_status');
    add_global_table('upgrades_log');
    add_global_table('upgrades_packages');
    add_global_table('upgrades_features');

    //BCZ Subscriptions
    add_global_table('x_subscriptions');

    //BCZ BP Groups Calendars
    add_global_table('bp_groups_calendars');
    add_global_table('classifieds_ads');
    add_global_table('classifieds_credits');
    add_global_table('classifieds_categories');

    //BCZ Supporter
    add_global_table('wp_supporters');
    add_global_table('wp_supporter_signup_stats');
    add_global_table('wp_supporter_daily_stats');
    add_global_table('wp_supporter_ads');

    add_db_server('global', 'dc2', 1, 1,'NNN.NNN.NNN.NNN','NNN.NNN.NNN.NNN', 'wpmu_global', 'sam', 'ABCDEFG');

    add_db_server('000', 'dc1', 1, 1,'MMM.MMM.MMM.MMM','MMM.MMM.MMM.MMM', 'wpmu_000', 'sam', 'ABCDEFG');

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.