HyperDB config examples

db-config.php

<?php

// MASTER machine
$wpdb->add_database(array(
	'host'     => DB_HOST,     
	'user'     => DB_USER,
	'password' => DB_PASSWORD,
	'name'     => DB_NAME,
	'write'    => 1,
	'read'     => 0,
));

// SLAVE 1
$wpdb->add_database(array(
	'host'     => '192.168.1.2',   
	'user'     => DB_USER,
	'password' => DB_PASSWORD,
	'name'     => DB_NAME,
	'write'    => 0,
	'read'     => 1,
	'dataset'  => 'global',
	'timeout'  => 0.4,
));

// SLAVE 2
$wpdb->add_database(array(
	'host'     => '192.168.1.3',    
	'user'     => DB_USER,
	'password' => DB_PASSWORD,
	'name'     => DB_NAME,
	'write'    => 0,
	'read'     => 1,
	'dataset'  => 'global',
	'timeout'  => 0.4,
));