Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I'm starting a service that offers websites that runs on a giant Wordpress multi-site. I have a cloud based vps with nginx-php5-php-fpm-mysql. Storage with Amazon S3, distribution with MaxCDN. WP Total cache takes care of this for WP. I do expect to be busy from the start as far as the number of sites created. My question is about mysql replication.

  1. Should I go ahead and create two more VPS's now, and have one as master and one as slave from the get go? Or, is this something that can be done when it's time to scale? I worry about the size of the db and incomplete backups.

  2. With, currently no service launched and 0 signups, should I even be worrying about this? What # of sites created would justify scaling wordpress?

I want to start this off the right way and not have to deal with expanding down the road.

Thoughts? Nick

share|improve this question
    
I went to a WordPress talk this summer and there was a guy from MaxCDN there, who basically said. You shouldn't worry about having your site scale at the beginning. But you should know how to do it. So if you know how to scale your service, you should be fine. But if you have no idea, create a test install and try it there. –  weston deboer Dec 28 '11 at 22:54
    
Yeah I definitely know how to do it, but planning logistically at first. Your answer was the one I was looking for. Thanks a lot Weston! –  Nick Dec 28 '11 at 23:02
add comment

1 Answer 1

Have a look into how WordPress.com do it - they released all the software they use under open licensing, and it'll let you scale up in future as you need it - far as I know, DB replication is pretty easy to build in. If in doubt, email Matt (ma.tt) - the WP team are super-friendly and will point you in the right direction.

Alternatively, have a look at wpmudev.org - it isn't free, but it looks like you have a decent budget for what you're doing anyway - they have DB replication stuff for WP Multisite.

On the whole though, WordPress is pretty robust, especially with caching, so until you reach the top end of utilisation of your current box, I wouldn't bother.

EDIT: in hindsight, this doesn't fully answer your question. Keep a close eye on your load levels, that'll tell you when it's time to move up. The rest of this ^ is probably information you already know.

share|improve this answer
    
I didn't know I could email Matt! That's pretty sweet. Yeah I'm actually already signed up with wpmudev.org and am utilizing a few of their plugins. I think I'm about as prepared as I can be, so you guys' responses help. Thank you! –  Nick Dec 28 '11 at 23:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.