New to the community? Start here

Multi-DB Plugin | DB downsize?

Hello,

I have two questions:

1) Has anyone had performance probs with 4096-Multi-DB?

2) Has anyone downgraded 4096-Multi-DB to 256-Multi-DB, and have a helpful tutorial and/or script?

Awaiting your inputs…

Thanks & Regards

Thu, 30 Jun 2011 9:59:43
  • Barry
    • DEV MAN’s Mascot

    1) Has anyone had performance probs with 4096-Multi-DB?

    I haven’t personally, but it all depends on your server set-up really. 4096 on shared may take a hit, because there will be a lot of other people also accessing the db server. Dedicated or VPS, more than likely you’ll be ok.

    Has anyone downgraded 4096-Multi-DB to 256-Multi-DB, and have a helpful tutorial and/or script?

    It’s easy to describe, but not easy to do. Basically:

    1. Back up all db’s to sql dumps (can script this is you have ssh access – there is a script or two on this forum for multi-db backups it may be worth searching for)

    2. Import all backups into a single db.

    3. Run move-blogs.php on that new single db to export to 256 databases.