Arthur Guy wrote:
You say it doesn't have failover support. If you configure a master and a salve in the settings and the master goes down won't it detect this and just use the slave until the master is available?
No. Loss of the master will produce a connection error. It's possible to switch the wiki to read-only mode and use a slave temporarily, but it's important that you never write to a slave directly. The read_only setting in MySQL should be used for extra safety. The reasons for this, and the procedure for permanently switching the master, are described in the MySQL manual.
If a slave goes down, long connection timeouts will cause poor performance until the load ratios are adjusted.
I found the options in the defaultsettings file but it doesn't provide an example, how do you write a suitable instruction containing the database information?
http://wikimedia.org/conf/db.php.html
-- Tim Starling