First the wordpress blog is no longer using hyperDB which should really be used with wordpress-mu, but that is another story. Slave mySQL is configured to be ready-only and mediawiki Localsettings is updated with $wgDBservers{}; Seems in order to get this working you have you normal account to read/write to the database on both servers but you also need grant SUPER,REPLICATION CLIENT on *.* to <username>@’<ip>’ identified by ‘somepassword’; also allied to both servers. This way the wiki config doesn’t try to write to the slave although read-only prevents this. Either way I have a working wiki on two DB servers replicated. Next up is to replicate to my Vegas Data Center and Tacoma Data Center.
update here is my LocalSettings.php Config
$wgDisableCounters = true;
## Database settings
##$wgDBtype = “mysql”;
##$wgDBserver = “ipaddress”;
##$wgDBname = “dbname”;
##$wgDBuser = “username”;
##$wgDBpassword = “”;
$wgDBServers = true;
$wgMasterWaitTimeOut=1;
$wgClusterTimeOut=1;
$wgDBerrorLog=”/var/log/apache2/wikidberrors.log”;
$wgDBservers = array(
array(
‘host’ => ‘ipaddress’,
‘dbname’ => ‘dbname’,
‘user’ => ‘username’,
‘password’ => ‘password’,
‘type’ => ‘mysql’,
‘load’ => 0,
),
array(
‘host’ => ‘ipaddress’,
‘dbname’ => ‘dbname’,
‘user’ => ‘username’,
‘password’ => ‘password’,
‘type’ => ‘mysql’,
‘load’ => 1,
),
);
