WordPress.org

Support

Support » Multisite » HyperDB with separate databases

HyperDB with separate databases

  • Hello,

    I’m stuck with this, please help me :

    I have a Multiste with 500 blogs as subdomains. It’s been slowing down and the number of tables in this is about 15000+ .

    I decided to separate this database into 10 databases and moveving the tables from the original databases accordingly. Then I used HyperDB for this model.

    It seams OK when I create new site and it create new tables in different databases. But the problem is when I open a blog, it can not find the right databases and cause “Error database connection”. With some press of F5 button, it show the correct blog but back to error again.

    Anyone had faced this issue ? Please help me to solve it.

    I have config like this in the db-config.php file :


    $wpdb->add_database(array(
    'host' => 'xxx.127',
    'user' => 'wordpress',
    'password' => 'wordpress',
    'name' => 'wordpress_host3',
    'dataset' => 'global',
    'write' => 1,
    'read' => 0,
    ));

    $wpdb->add_database(array(
    'host' => 'xxx.127',
    'user' => 'wordpress',
    'password' => 'wordpress',
    'name' => 'wordpress_blog003',
    'dataset' => 'blog',
    'write' => 1,
    'read' => 0,
    ));

  • The topic ‘HyperDB with separate databases’ is closed to new replies.