How To Mount DB's On Another Server?

Resolved DolphinGuy
(@sanyadolpins)

9 years, 10 months ago

Hi Ron,

Been a while… But, Shardb has worked like a charm, so no need to chime in.

I am about to split my DB’s to different servers. I know that Shardb has it’s own code to do this. However, I am hosted on DigitalOcean with a Private Network that I can set up an NFS Mount.

https://www.digitalocean.com/community/tutorials/how-to-set-up-an-nfs-mount-on-ubuntu-12-04

I was wondering if you had an opinion either way, as to the best approach. Of course, I’m interested in taking the path which would offer the best speed, reliability and simplicity in setup.

Would appreciate your feedback.

Thanks again for the great product!

DolphinGuy

https://wordpress.org/plugins/shardb/

Viewing 6 replies - 1 through 6 (of 6 total)

Plugin Author

Ron Rennick

(@wpmuguru)

9 years, 10 months ago

You have to replace the DB registration loop/code in db-settings.php with a registration line for each database.

Thread Starter

DolphinGuy

(@sanyadolpins)

9 years, 10 months ago

Hi Ron,

First I’ve had Shardb running successfully on WPMU for over a year locally. No problems. Have also made several setups of it, locally.

However, I am attempting to now move my databases to another server. I’m on DigitalOcean, so I just spun up a clone of my current server, renamed it, gave it a new IP, and SHAZAM I’m in business. All existing databases are now cloned and ready to connect, same everything, except the IP, right? Wrong!

First I’ll say, I run IDE PHP Storm and have no problem with connecting to the other server and corresponding databases. I’m at a loss.

Below are all my attempts, which have failed to work.

Any specific help would be appreciated.

DolphinGuy

add_db_server( 'drip_home', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','home','username','*********');
add_db_server( 'drip_global', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','global','username','*********');
add_db_server( 'drip_0', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','0','username','*********');
add_db_server( 'drip_1', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','1','username','*********');
add_db_server( 'drip_2', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','2','username','*********');
add_db_server( 'drip_3', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','3','username','*********');
add_db_server( 'drip_4', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','4','username','*********');
add_db_server( 'drip_5', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','5','username','*********');
add_db_server( 'drip_6', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','6','username','*********');
add_db_server( 'drip_7', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','7','username','*********');
add_db_server( 'drip_8', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','8','username','*********');
add_db_server( 'drip_9', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','9','username','*********');
add_db_server( 'drip_a', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','a','username','*********');
add_db_server( 'drip_b', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','b','username','*********');
add_db_server( 'drip_c', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','c','username','*********');
add_db_server( 'drip_d', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','d','username','*********');
add_db_server( 'drip_e', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','e','username','*********');
add_db_server( 'drip_f', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','f','username','*********');

error :
Unable to connect to : while querying table ‘dip_sitemeta’ (global_r)Unable to connect to : while querying table ‘dip_blogs’ (global_r)Unable to connect to : while querying table ‘dip_blogs’ (global_r)
Error establishing a database connection

OPTION 2

add_db_server( 'home', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','home','username','*********');
add_db_server( 'global', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','global','username','*********');
add_db_server( '0', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','0','username','*********');
add_db_server( '1', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','1','username','*********');
add_db_server( '2', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','2','username','*********');
add_db_server( '3', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','3','username','*********');
add_db_server( '4', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','4','username','*********');
add_db_server( '5', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','5','username','*********');
add_db_server( '6', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','6','username','*********');
add_db_server( '7', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','7','username','*********');
add_db_server( '8', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','8','username','*********');
add_db_server( '9', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','9','username','*********');
add_db_server( 'a', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','a','username','*********');
add_db_server( 'b', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','b','username','*********');
add_db_server( 'c', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','c','username','*********');
add_db_server( 'd', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','d','username','*********');
add_db_server( 'e', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','e','username','*********');
add_db_server( 'f', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','f','username','*********');

error :
Unable to connect to : while querying table ‘dip_sitemeta’ (global_r)Unable to connect to : while querying table ‘dip_blogs’ (global_r)Unable to connect to : while querying table ‘dip_blogs’ (global_r)
Error establishing a database connection

OPTION 3

add_db_server( 'home', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','home','username','*********');
add_db_server( 'global', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','global','username','*********');
add_db_server( '0', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','0','username','*********');
add_db_server( '1', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','1','username','*********');
add_db_server( '2', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','2','username','*********');
add_db_server( '3', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','3','username','*********');
add_db_server( '4', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','4','username','*********');
add_db_server( '5', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','5','username','*********');
add_db_server( '6', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','6','username','*********');
add_db_server( '7', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','7','username','*********');
add_db_server( '8', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','8','username','*********');
add_db_server( '9', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','9','username','*********');
add_db_server( 'a', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','a','username','*********');
add_db_server( 'b', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','b','username','*********');
add_db_server( 'c', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','c','username','*********');
add_db_server( 'd', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','d','username','*********');
add_db_server( 'e', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','e','username','*********');
add_db_server( 'f', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','f','username','*********');

error :

Unable to connect to : while querying table ‘dip_sitemeta’ (global_r)Unable to connect to : while querying table ‘dip_blogs’ (global_r)Unable to connect to : while querying table ‘dip_blogs’ (global_r)
Error establishing a database connection

OPTION 4

add_db_server( 'home', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_home','username','*********');
add_db_server( 'global', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_global','username','*********');
add_db_server( '0', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_0','username','*********');
add_db_server( '1', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_1','username','*********');
add_db_server( '2', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_2','username','*********');
add_db_server( '3', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_3','username','*********');
add_db_server( '4', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_4','username','*********');
add_db_server( '5', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_5','username','*********');
add_db_server( '6', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_6','username','*********');
add_db_server( '7', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_7','username','*********');
add_db_server( '8', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_8','username','*********');
add_db_server( '9', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_9','username','*********');
add_db_server( 'a', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_a','username','*********');
add_db_server( 'b', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_b','username','*********');
add_db_server( 'c', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_c','username','*********');
add_db_server( 'd', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_d','username','*********');
add_db_server( 'e', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_e','username','*********');
add_db_server( 'f', 0, '01.storm.', 1, 1,'xxx.xxx.xxx.xxx:3306','','drip_f','username','*********');

error :

404

OPTION 5

add_db_server( 'global', 0, '', 1, 1, DB_HOST, DB_HOST,$shardb_prefix .'global','username','*********');
add_db_server( $shardb_dataset, 1, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'1','username','*********');
add_db_server( $shardb_dataset, 2, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'2','username','*********');
add_db_server( $shardb_dataset, 3, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'3','username','*********');
add_db_server( $shardb_dataset, 4, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'4','username','*********');
add_db_server( $shardb_dataset, 5, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'5','username','*********');
add_db_server( $shardb_dataset, 6, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'6','username','*********');
add_db_server( $shardb_dataset, 7, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'7','username','*********');
add_db_server( $shardb_dataset, 8, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'8','username','*********');
add_db_server( $shardb_dataset, 9, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'9','username','*********');
add_db_server( $shardb_dataset, 10, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'a','username','*********');
add_db_server( $shardb_dataset, 11, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'b','username','*********');
add_db_server( $shardb_dataset, 12, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'c','username','*********');
add_db_server( $shardb_dataset, 13, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'d','username','*********');
add_db_server( $shardb_dataset, 14, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'e','username','*********');
add_db_server( $shardb_dataset, 15, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'f','username','*********');
add_db_server( $shardb_dataset, 16, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'home','username','*********');
add_db_server( $shardb_dataset, 17, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'0','username','*********');

* NOTE $shardb_dataset = 'drip';

Observaton :

Array(
	[global] => Array
			(
				[0] => Array
					(
						[0] => Array
							(
								[ds] => global
								[part] => 0
								[dc] =>
								[read] => 1
								[write] => 1
								[host] => localhost
								[lhost] => localhost
								[name] => drip_global
								[user] => username
								[password] => *********
							)

					)

			)

	[drip] => Array
			(
				[1] => Array
					(
						[0] => Array
							(
								[ds] => drip
								[part] => 1
								[dc] =>
								[read] => 1
								[write] => 1
								[host] => xxx.xxx.xxx.xxx:3306
								[lhost] => xxx.xxx.xxx.xxx:3306
								[name] => drip_1
								[user] => username
								[password] => *********
							)

						[1] => Array
							(
								[ds] => drip
								[part] => 1
								[dc] =>
								[read] => 1
								[write] => 1
								[host] => localhost
								[lhost] => localhost
								[name] => drip_1
								[user] => username
								[password] => *********
							)

					)
	.
	.
	.
	)
)

[Moderator Note: Please post code & markup between backticks or use the code button. Your posted code may now have been damaged by the forum’s parser.]

Thread Starter

DolphinGuy

(@sanyadolpins)

9 years, 10 months ago

Figured I might as well upload my entire settings file, so you could look.

<?php

// If you have multiple datacenters you can come up with your own datacenter
// detection logic (php_uname?). This helps ensure the web servers try to
// connect to the nearest database servers first, then distant ones.
define( 'DATACENTER', '' );

function add_slave($read, $host, $lhost = '', $user = DB_USER, $password = DB_PASSWORD) {
	global $slaves;
	$slaves[] = compact('read', 'host', 'lhost', 'user', 'password');
}

/* Add your configuration here */
$shardb_hash_length = 1;
$shardb_prefix = 'drip_';
$shardb_dataset = 'drip';
$enable_home_db = true;
$shardb_local_db = false;
//$num_vipdbs = 5;

/* Use this configuration for a hexidecimal based hash 

Ex. you have 256 databases that follow the naming convention acct_wpmuXX
where XX is the hexidecimal hash for the blog DB

// how many characters of hexidecimal hash
$shardb_hash_length = 2;
// what is the prefix of your blog database shards (everything before the hexidecimal hash)
$shardb_prefix = 'acct_wpmu';
// set a string to be used as an internal identifier for the dataset
$shardb_dataset = 'abc';
// 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 = 5;
// 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);

// instructions for adding vip blogs at the bottom of this confg filei
*/
/* That's all, stop editing! Happy blogging. */

if ( !defined('SAVEQUERIES') )
	define('SAVEQUERIES', false);

/**
 * A trick used by WordPress.com is .lan hostnames mapped to local IPs. Not required.
 *
 * @param unknown_type $hostname
 * @return unknown
 */
function localize_hostname($hostname) {
	return str_replace('.com', '.lan', $hostname);
}

function localize_hostnames($array) {
	return array_map('localize_hostname', $array);
}

/**
 * This generates the array of servers.
 *
 * @param string $ds Dataset: the name of the dataset. Just use "global" if you don't need horizontal partitioning.
 * @param int $part Partition: the vertical partition number (1, 2, 3, etc.). Use "0" if you don't need vertical partitioning.
 * @param string $dc Datacenter: where the database server is located. Airport codes are convenient. Use whatever.
 * @param int $read Read order: lower number means use this for more reads. Zero means no reads (e.g. for masters).
 * @param bool $write Write flag: is this server writable?
 * @param string $host Internet address: host:port of server on internet.
 * @param string $lhost Local address: host:port of server for use when in same datacenter. Leave empty if no local address exists.
 * @param string $name Database name.
 * @param string $user Database user.
 * @param string $password Database password.
 */
function add_db_server($ds, $part, $dc, $read, $write, $host, $lhost, $name, $user, $password) {
	global $db_servers, $db_ds_parts;

	if ( empty( $lhost ) )
		$lhost = $host;

	$server = compact('ds', 'part', 'dc', 'read', 'write', 'host', 'lhost', 'name', 'user', 'password');

	$db_servers[$ds][$part][] = $server;
	$db_ds_parts[$name] = "{$ds}_{$part}";
}

// Database servers grouped by dataset. (Totally tabular, dude!)
// R can be 0 (no reads) or a positive integer indicating the order
// in which to attempt communication (all locals, then all remotes)

//dataset, partition, datacenter, R, W,             internet host:port,     internal network host:port,   database,        user,        password

//add_db_server( 'global', 0,    '', 1, 1,    DB_HOST, DB_HOST, $shardb_prefix . 'global', DB_USER, DB_PASSWORD );
// Next line populates 'global' dataset from wp-config.php for instant compatibility. Remove it when you put your settings here.
// add_db_server('global', 0,    '', 1, 1,    DB_HOST, DB_HOST, DB_NAME, DB_USER, DB_PASSWORD);

// build the shard dataset
$have_slaves = is_array($slaves) && (count($slaves) > 0);
if(isset($shardb_hash_length) && $shardb_hash_length > 0 && $shardb_hash_length < 4 ) {
	$fmt = "{$shardb_prefix}%0{$shardb_hash_length}x";
	$shardb_num_db = 1 << ($shardb_hash_length*4);
	if(!$have_slaves || !isset( $shardb_master_read )) {
		$shardb_master_read = 1;
	}
	for($d=0;$d<$shardb_num_db;$d++) {
		$db_name = sprintf($fmt, $d);
		add_db_server($shardb_dataset, $d,  '', 1, $shardb_master_read,  DB_HOST,  DB_HOST, $db_name,  DB_USER,     DB_PASSWORD);
		if($have_slaves) {
			foreach($slaves as $s) {
				add_db_server($shardb_dataset, $d,  '', $s['read'], 0,  $s['host'],  $s['lhost'], $db_name,  $s['user'], $s['password']);
			}
		}
	}
	$numdbs_added = $shardb_num_db;

	// Enable home db?
    if ($enable_home_db === true) {
        add_db_server($shardb_dataset, $numdbs_added, '', 1, $shardb_master_read, DB_HOST, DB_HOST, $shardb_prefix .'home', DB_USER, DB_PASSWORD);
		if($have_slaves) {
			foreach($slaves as $s) {
				add_db_server($shardb_dataset, $numdbs_added,  '', $s['read'], 0,  $s['host'],  $s['lhost'], $shardb_prefix .'home',  $s['user'], $s['password']);
			}
		}
    }
    $numdbs_added++;
	// VIP databases
    if ( is_numeric($num_vipdbs) and $num_vipdbs > 0 ) {
        for($d=1;$d<=$num_vipdbs;$d++) {
            add_db_server($shardb_dataset, $numdbs_added, '', 1, $shardb_master_read, DB_HOST, DB_HOST, $shardb_prefix .'vip'. $d, DB_USER, DB_PASSWORD);
			if($have_slaves) {
				foreach($slaves as $s) {
					add_db_server($shardb_dataset, $numdbs_added,  '', $s['read'], 0,  $s['host'],  $s['lhost'], $db_name,  $s['user'], $s['password']);
				}
			}
		   $numdbs_added++;
        }
    }
}
/*
add_db_server(  'misc', 0, 'lax', 1, 1,     'misc.db.example.com:3722',     'misc.db.example.lan:3722',  'wp-misc',  'miscuser',  'miscpassword');
add_db_server('global', 0, 'nyc', 1, 1,'global.mysql.example.com:3509','global.mysql.example.lan:3509','global-db','globaluser','globalpassword');
*/

/**
 * Map a table to a partition.
 *
 * @param string $table
 * @param string $part
 */
function add_db_table( $table, $db ) {
	global $db_tables, $shardb_prefix;

	$db_tables[$table] = $shardb_prefix . $db;
}

// ** NO DUPLICATE TABLE NAMES ALLOWED **
// If running with the home DB enabled & a WP 3.0 single install converted to a network add any main site plugin tables here
// If you want tables to live in a specific database, you can add those here
// add_db_table( 'wp_misc', 'home' );
// add_db_table( 'wp_etc', 'vip1' );
// add_db_table( 'wp_extra', 'vip1' );

/**
 * Map a blog to a custom database. AKA: VIP
 *
 * @param string $blog_id
 * @param string $db
 */
function add_vip_blog( $blog_id, $db ) {
    global $vip_db, $shardb_prefix;
    $vip_db[$blog_id] = $shardb_prefix . $db;
}

// Adding a blog to a VIP database is simple.
// You can put it in whatever VIP DB you want, or even in
// another user db (like for a penalty box for low traffic blogs.

// Simply use this format:
// add_vip_blog($blog_id, 'db_name');

// For example, lets say your buddy John needs some extra db love,
// his blog_id is 24 and you want to put him in the vip3 database.
// You would add a line below like this:
//add_vip_blog(24,'vip3'); // John's blog

// That's all there is to it. Plus a comment at the end reminds you of who is who!

// VIP DB's
if ( $enable_home_db === true )
	add_vip_blog( 1, 'home' );    // home blog

add_db_server( 'global', 0, '', 1, 1, DB_HOST, DB_HOST,$shardb_prefix .'global','User_Name','************');
add_db_server( $shardb_dataset, 1, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'1','User_Name','************');
add_db_server( $shardb_dataset, 2, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'2','User_Name','************');
add_db_server( $shardb_dataset, 3, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'3','User_Name','************');
add_db_server( $shardb_dataset, 4, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'4','User_Name','************');
add_db_server( $shardb_dataset, 5, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'5','User_Name','************');
add_db_server( $shardb_dataset, 6, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'6','User_Name','************');
add_db_server( $shardb_dataset, 7, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'7','User_Name','************');
add_db_server( $shardb_dataset, 8, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'8','User_Name','************');
add_db_server( $shardb_dataset, 9, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'9','User_Name','************');
add_db_server( $shardb_dataset, 10, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'a','User_Name','************');
add_db_server( $shardb_dataset, 11, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'b','User_Name','************');
add_db_server( $shardb_dataset, 12, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'c','User_Name','************');
add_db_server( $shardb_dataset, 13, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'d','User_Name','************');
add_db_server( $shardb_dataset, 14, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'e','User_Name','************');
add_db_server( $shardb_dataset, 15, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'f','User_Name','************');
add_db_server( $shardb_dataset, 16, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'home','User_Name','************');
add_db_server( $shardb_dataset, 17, '', 1, 1, 'xxx.xxx.xxx.xxx:3306', 'xxx.xxx.xxx.xxx:3306',$shardb_prefix .'0','User_Name','************');
?>

Plugin Author

Ron Rennick

(@wpmuguru)

9 years, 9 months ago

I assume you posted this before I responded to your email.

Thread Starter

DolphinGuy

(@sanyadolpins)

9 years, 8 months ago

Ron,

Thanks, much appreciated the email! Problem solved! Still using Shardb and only good things to say. Stay healthy!

DolphinGuy