February 4, 2012

You are here: Home / Plugins / SharDB update

SharDB update

January 24, 2010 By

I updated SharDB (Download) for WordPress MU 2.9.1.1 and added support for the comment meta table.

Filed Under: Plugins Tagged With: , , , ,

Get 3 for the price of 2 in the Network Home Bundle

Includes 3 ebooks with plugins -
Network Home Pages: aggregate global content, set up sitewide tags, create a huge tags cloud like the one seen on WordPress.com, global footers and menus, setting defaults & more
Custom Registration: sign up on sub sites, multilingual signup pages, stop spam blogs
WP Curator: pick and choose posts from sub sites to feature on the main home page of your network

Network Home Pages, Custom Registration & WP Curator – $35.90 for all three. Purchase

Comments

  1. windhamdavid says:
    January 24, 2010 at 2:06 pm

    Ron.. you are great! thk U.

  2. John Bacon says:
    January 28, 2010 at 2:26 am

    Woot! Thx Ron!

  3. michael says:
    February 24, 2010 at 7:33 pm

    Thanks for your great work.

    I have recently come to use SharDB to scale out our WordPress MU installs. Am currently trying to get it working on one of our sites.

    Our database setup is Master -> Slave via replication. It works great when I don’t use the add_slave function in db-settings.php, eg going to the master server as defined in wp-config.php.

    When I use add_slave, all functions seem to send back “Array”, eg in the html title of the site, search box. Also, it just keeps printing out “Sorry, no posts matched your criteria” regardless.

    Do you have any suggestions? This is on a completely new install of WordPress 2.9.1.1. I believe I have sharded the DB ok as it works fine connecting to the master only.

    Here’s my db-settings.php config:

    $shardb_hash_length = 1;
    $shardb_prefix = ‘wpmu_’;
    $shardb_dataset = ‘dbset’;
    $enable_home_db = false;
    $num_vipdbs = 0;
    //$shardb_master_read = 99;
    $shardb_local_db = true;
    add_slave(1, ’192.168.0.20′, ’192.168.0.20′, USER***, PASS***);

    Many thanks for any comments/suggestions!

  4. michael says:
    February 24, 2010 at 7:59 pm

    Forgot to subscribe via email.

  5. Mohini Bisht says:
    April 20, 2010 at 12:53 pm

    dear sir, i’m using free hosting service which allows only 50 mb per database.

    can i use multiple databases for my blog.
    so that if one gets filled, other will be automatically start filling by the posts.

  6. Scott says:
    June 24, 2010 at 7:31 pm

    Hi Ron,
    Do you have a script to partition an existing DB in multiple DB’s?

  7. Ron says:
    June 26, 2010 at 9:18 pm

    I’ll be adding that with the 3.0 update.