I've installed SharDB but for some reason my main site displays this error after I installed it.
Warning: fsockopen() [function.fsockopen]: unable to connect to localhost:3306 (Operation timed out) in /usr/home/user1/domains/mysite.com/public_html/wp-content/db.php on line 521
I set the db-settings.php like this...
// 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 = 'user1_wpmu_';
// set a string to be used as an internal identifier for the dataset
$shardb_dataset = 'abc';
// do you want to put your primary blog (blog_id 1) in its own 'home' database?
$enable_home_db = false;
// how many, if any, VIP databases do you have?
$num_vipdbs = 0;
// 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);
I made the databases like this...
user1_wpmu_0 to user1_wpmu_9 then user1_wpmu_a user1_wpmu_f
I did everything else the instructions told me. I'm trying to use this on an existing wordpress site. I'd really appreciate any help with this.