38 pointsStarting to get into this DEV thingI'm helpful
bghouse
Member
—
19th January 2012 (4 months ago)
I've been reading all the instructions and the forum posts for multi-db, and looking at my site strategy for short-term and long-term.
My long, long term strategy is to have many, many sites - enough that I go to the 4096 number of databases. But of course, that's the "yep, I have the BEST IDEA EVER" enthusiasm talking, which keeps me going with my plans but you have to be realistic (not pessimistic, but tempered enthusiasm) ;-)
What I didn't really find was information about how hard it is to grow once you've setup. I'm thinking of going straight to the 256 db option, as it says there is no difference really in performance between 16 and 256. (dedicated server leased from hostgator - fyi).
But, what if this really is my "big honking idea" and I need to go past the 100,000 blogs/sites? Is it possible to upgrade a live network from 256 to 4096 without problems? What are my "gotchas"?
When would I have to do this - realistically not year 1 of business operation for sure (unless I have the Midas touch, at which point I'll be throwing a party on my private yacht first - lol). But I prefer to plan out my architecture and any potential gotcha's upfront - so I have a strategy to implement in the future when I need it.
I've been reading all the instructions and the forum posts for multi-db, and looking at my site strategy for short-term and long-term.
My long, long term strategy is to have many, many sites - enough that I go to the 4096 number of databases. But of course, that's the "yep, I have the BEST IDEA EVER" enthusiasm talking, which keeps me going with my plans but you have to be realistic (not pessimistic, but tempered enthusiasm) ;-)
What I didn't really find was information about how hard it is to grow once you've setup. I'm thinking of going straight to the 256 db option, as it says there is no difference really in performance between 16 and 256. (dedicated server leased from hostgator - fyi).
But, what if this really is my "big honking idea" and I need to go past the 100,000 blogs/sites? Is it possible to upgrade a live network from 256 to 4096 without problems? What are my "gotchas"?
When would I have to do this - realistically not year 1 of business operation for sure (unless I have the Midas touch, at which point I'll be throwing a party on my private yacht first - lol). But I prefer to plan out my architecture and any potential gotcha's upfront - so I have a strategy to implement in the future when I need it.
8202 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
WPMU DEV Fanatic
—
19th January 2012 (4 months ago)
#
Hi bghouse,
I'm not quite so keen on Multi-DB as some of the other guys around here so I'll ask a few of them to respond here as well but in general, yes you can definitely install and move your existing site over to Multi-DB use after it's already established.
In fact, that's necessarily the case, since you need to install WordPress and enable Multisite in order to use it, thus you'd have a pre-existing site no matter how you look at it. It's just that the database wouldn't be quite so full of data at the start.
However, it's definitely easier installing it right from the start and I think that'd be the main point of installing right off.
Thanks David. My question wasn't so much about moving a site, but specifically about starting with a smaller number of DBs using multi-db and then upgrading it later if I need to expand.
10635 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Sales & Support Lead
—
20th January 2012 (4 months ago)
#
Hiya,
You cannot (easily) upgrade the # of databases (say from 16 to 256). It's not something we support here. So pick a number at the start based on where you see your site growing to and go with that. There should be no noticeable performance issue for choosing 256 over 16 - it just may be unnecessary if you're not expecting tens of thousands of sites.
7257 pointsLike some sort of WPMU DEV GodMindblowingly helpful memberLifetime member
Support Chimp
—
5th February 2012 (3 months ago)
#
Great to hear your well!!
Yeah I know its doable, I have seen a few threads around the forum. I haven't really done much with Multi-DB so still have a lot of understanding to do myself yet...... So its all theoretical in my mind.
@vincent2
If there isn't yet a request, then please feel free to open one. :-)
Responses (9)
WPMU DEV Fanatic — 19th January 2012 (4 months ago) #
Hi bghouse,
I'm not quite so keen on Multi-DB as some of the other guys around here so I'll ask a few of them to respond here as well but in general, yes you can definitely install and move your existing site over to Multi-DB use after it's already established.
In fact, that's necessarily the case, since you need to install WordPress and enable Multisite in order to use it, thus you'd have a pre-existing site no matter how you look at it. It's just that the database wouldn't be quite so full of data at the start.
However, it's definitely easier installing it right from the start and I think that'd be the main point of installing right off.
-David
Member — 19th January 2012 (4 months ago) #
Thanks David. My question wasn't so much about moving a site, but specifically about starting with a smaller number of DBs using multi-db and then upgrading it later if I need to expand.
Sales & Support Lead — 20th January 2012 (4 months ago) #
Hiya,
You cannot (easily) upgrade the # of databases (say from 16 to 256). It's not something we support here. So pick a number at the start based on where you see your site growing to and go with that. There should be no noticeable performance issue for choosing 256 over 16 - it just may be unnecessary if you're not expecting tens of thousands of sites.
thanks!
Member par excellence — 5th February 2012 (3 months ago) #
@masonjames IT is some thing you guys should look at a update system to move from 16 to 256 to 4096
To all the guys and girls please +1 to get WPMU to get a upgrade system for 16 to 256
Support Chimp — 5th February 2012 (3 months ago) #
Hey Mark, hope you are well. :-)
Don't forget you can post your feedback and requests here:
http://wpmudev.uservoice.com/
The more votes, the more likely it is to gain support. :-)
Take care
Member — 5th February 2012 (3 months ago) #
I also wondered about this same thing.
Couldn't find the request to vote on uservoice.
Member par excellence — 5th February 2012 (3 months ago) #
@Timothy yes i am still well :) just pulling out my hair about my current Multi Db Setup
Member par excellence — 5th February 2012 (3 months ago) #
@Timothy It is doable but it will be a lot of work http://premium.wpmudev.org/forums/topic/multi-db-fresh-install-common-imp-questions#post-74224
Support Chimp — 5th February 2012 (3 months ago) #
Great to hear your well!!
Yeah I know its doable, I have seen a few threads around the forum. I haven't really done much with Multi-DB so still have a lot of understanding to do myself yet...... So its all theoretical in my mind.
@vincent2
If there isn't yet a request, then please feel free to open one. :-)
Become a member