225 points
Community rank #221
mikee17
ExpertJust Getting Started
MemberLikes (0)
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?
6740 pointsCommunity rank #8Supreme DeityWPMU DEV StaffLifetime member
Developer
(joined June 2008)
Likes (0)
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 (joined June 2008) Likes (0)
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 (joined February 2009) Likes (0)
Thank you Barry!
Become a member