Thread Starter
eritos
(@eritos)
hello above you can check my db-settings.php please help me, thanks.
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.
Glad you got it sorted out 🙂