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

  • 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.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.