DB.php

<?php
# WARNING: This file is publically viewable on the web. Do not put private data here.
#
# This file contains database related includes and settings.
#
# It is included by LocalSettings.php.
#

## Database settings
$wgDBtype = "mysql";
$wgDBname = $sfWikiDB . $sfwikiLanguageSuffix;

# $wgDBserver = $UESP_SERVER_DB1;
# $wgDBuser = $sfWikiUser;
# $wgDBpassword = $sfWikiPW;

# MySQL specific settings
$wgDBprefix = "";

# MySQL table options to use during installation or update
$wgDBTableOptions = "ENGINE=InnoDB, DEFAULT CHARSET=binary";

$sfWikiDBName = $sfWikiDB . $sfwikiLanguageSuffix;

if ($sfwikiIsDev)
{
	$wgDBname = "sfwiki_dev" . $sfwikiLanguageSuffix;
	$sfWikiDBName = $wgDBname;
	
	$wgDBservers = array(
		array(          # backup1 is the only dev wiki database
				'host' => $UESP_SERVER_BACKUP1,
				'dbname' => $sfWikiDBName,
				'user' => $sfWikiUser,
				'password' => $sfWikiPW,
				'type' => "mysql",
				'flag' => DBO_DEFAULT,
				'load' => 1,
			),
		);
}
else
{
	$wgDBservers = array(
			array(          # db1 - Write Master
					'host' => $UESP_SERVER_DB1,
					'dbname' => $sfWikiDBName,
					'user' => $sfWikiUser,
					'password' => $sfWikiPW,
					'type' => "mysql",
					'flag' => DBO_DEFAULT,
					'load' => 1,
			),
			array(          # db2 - Primary Read
					'host' => $UESP_SERVER_DB2,
					'dbname' => $sfWikiDBName,
					'user' => $sfWikiUser,
					'password' => $sfWikiPW,
					'type' => "mysql",
					'flag' => DBO_DEFAULT,
					'load' => 10,
					'max lag' => 1000,
			)
		);
	
		// Special case where we want to disable the read DB server
	if ($UESP_SERVER_DBWRITE == $UESP_SERVER_DBREAD)
	{
		unset($wgDBservers[1]);
	}
	
	$sfWikiBackup1Db = 
		array(          # backup1 - Backup Read
				'host' => $UESP_SERVER_BACKUP1,
				'dbname' => $sfWikiDBName,
				'user' => $sfWikiUser,
				'password' => $sfWikiPW,
				'type' => "mysql",
				'flag' => DBO_DEFAULT,
				'load' => 10,
		);
		
		/* Don't include by default as backup lag can affect production servers */	
	//$wgDBservers[] = $sfWikiBackup1Db;
	
		# Special settings for translation wikis
	$wgSharedDB = $sfWikiDB;
	$wgSharedPrefix = '';
	$wgSharedTables[] = "actor";
	$wgSharedTables[] = 'ipblocks';
	$wgSharedTables[] = 'interwiki';
}

if ($sfwikiLanguageSuffix != "")
{
	$wgLocalDatabases[] = $sfWikiDB;
}