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?
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?
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.
Responses (2)
Developer — 30th June 2011 (10 months ago) #
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.
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.
Member — 1st July 2011 (10 months ago) #
Thank you Barry!
Become a member