• Resolved eritos

    (@eritos)


    Hello ron when I press the button Migrate Global Tables in shardb plugin, the site load but dont migrate the tables, I make this process for the button “Migrate Sites” and work Fine all the tables from the blogs in my site was copied, are you know why happen this? or could you tell me the name about the tables that must be in the global database? sorry for my english, thanks…

Viewing 4 replies - 16 through 19 (of 19 total)
  • Thread Starter eritos

    (@eritos)

    hello above you can check my db-settings.php please help me, thanks.

    Plugin Author Ron Rennick

    (@wpmuguru)

    All I was looking for was the configuration settings (the part you edited) not the entire file:

    // how many characters of hexidecimal hash
    $shardb_hash_length = 1;
    // what is the prefix of your blog database shards (everything before the hexidecimal hash)
    $shardb_prefix = ‘publibrn_’;
    // set a string to be used as an internal identifier for the dataset
    $shardb_dataset = ‘pub’;
    // do you want to put your primary blog (blog_id 1) in its own ‘home’ database?
    $enable_home_db = true;
    // how many, if any, VIP databases do you have?
    $num_vipdbs = 1;
    // add this to set the write master read priority (default 1)
    $shardb_master_read = 99;
    // add this if all of your databases are on a local server
    $shardb_local_db = true;
    // use this function to add a read slave host
    add_slave($read_priority, $hostname, $local_hostname, $user, $password);

    Most likely your problem is one or more of the following

    $num_vipdbs = 1;
    // add this to set the write master read priority (default 1)
    $shardb_master_read = 99;
    // use this function to add a read slave host
    add_slave($read_priority, $hostname, $local_hostname, $user, $password);

    Don’t tell SharDB you have VIP databases if you don’t. The home DB is not counted as a VIP one.

    Don’t tell SharDB you have MySQL read slaves if you don’t have MySQL set up with write masters and read slaves.

    Thread Starter eritos

    (@eritos)

    Thanks Friend, you help me, I just put the // to the Read Slaves and my site now is working, Excellent help.

    Plugin Author Ron Rennick

    (@wpmuguru)

    Glad you got it sorted out 🙂

Viewing 4 replies - 16 through 19 (of 19 total)

The topic ‘Problems with button Migrate Global Tables’ is closed to new replies.