webraket

The code looks great on first inspection (can’t wait to use it).
However the select-list on super_admin screen fails with SharDB.
Even if it worked it will take too many resources with large networks.

$aryBlogs = $wpdb->get_results($wpdb->prepare('SELECT blog_id FROM '.$wpdb->prefix.'blogs ORDER BY blog_id'));
foreach ($aryBlogs as $aryBlog){
	$objBlog = get_blog_details($aryBlog->blog_id, true);
	$aryOptions[$objBlog->blogname.'#'.$objBlog->blog_id] = '<option value="'.$objBlog->blog_id.'"'.($blog_id == $objBlog->blog_id?' selected="selected"':'').'>'.$objBlog->blogname.'</option>'."\n";
}
ksort($aryOptions);
foreach ($aryOptions as $strOption) echo $strOption;

You should use $wpdb->blogs instead of $wpdb->prefix.’blogs’ to support SharDB/HyperDB/MultiDB etc.

Also please add a global setting to disable sitewide stats for super_admins since 20.000+ blogs in a select-list is trouble.
I can login to piwik itself (alternatively Analytics) to get a sitewide overview, and only need per-site stats for my users.

Thanks.

I’ve encountered the same problems.

I fixed the “unable to connect to localhost:3306” error by commenting
# skip-networking in my.cnf
Mysql was only listening to local connections, it still does (firewall rules), but somehow “skip-networking” doesn’t allow the fsockopen() connection in db.php.

The migration tool repeatedly returned an empty error after creating tables in the shards, this prevented the data from being inserted.
I fixed this by changing:

if( !$target_object->query( $create[1] ) ) {
$errors[] = $target_object->last_error;
continue;
}

to:

$target_object->query( $create[1] );
in shardb-admin.php

I also changed:

$sites = $wpdb->get_col( "SELECT blog_id FROM {$wpdb->blogs} ORDER BY blog_id ASC LIMIT {$next}, 5" );

to:

$sites = $wpdb->get_col( "SELECT blog_id FROM {$wpdb->blogs} ORDER BY blog_id ASC LIMIT {$next}, 1" );

To prevent memory problems, with large tables.