Moving from one server to two?
 

I'm wondering if you can tell me about your experience with moving from one dedicated server to two. How big was your site when you made the move (how many concurrent users, how many total posts, etc)? What prompted you to move, were you encountering database or server issues (Slowness, timing out, etc)?

How do you have your site setup now that you have two servers instead of one?

I've basically been told by Liquidweb, as well as a someone else who specializes more in vbulletin and server optimization that I really should consider getting a second server. We've been having issues with slow load times and "server time out" errors, despite having our current server optimized as much as possible.

How do you suggest splitting up the site between two servers, to relieve the pressure on one server? We don't have a lot of images so I don't think we would need one server just for image/attachments, we just have very active posters who love to do searches and keep things very busy.

Just looking for a little advice since this is all very new to me.

If you move to two servers, I'd suggest having a dedicated MySQL node, and a web node. It's the logical way to split tasks anyway.

I can't speak for others, but what I have for one of my setups is a 2 server setup (a Web Server and a Database Server). Having the DB on its own server makes a HUGE difference.

I'd talk to Snakes, he seems to have his "stuff" together when it comes to server optimization and setup.

I think he's actually the one who has been helping me! :D I can't remember his exact username on here but it's snakes something and he's been an AMAZING wealth of information who has gone out of his way to do everything possible for my server. He pretty much agrees with liquidweb as far as me needing to make an upgrade sometime soon though.

This is definitely one of the most difficult things, financially, but it's one of those necessary evils, I guess. Without a server that functions properly, I obviously lose a significant amount of traffic, which I've already noticed. :(

I run two sites, the military one is definitely the biggest and busiest of the two, but my other one is steadily growing and seeing more activity by the day. They are both 100% database driven though, I have vba for both and vbulletin running for both. So, I'm unsure of how I could split the load up to make it most even. I don't have much on either site that isn't database driven, so I'm wondering if I would actually need to split the databases up somehow.

:erm:

BrandiDup, what are the specs on the server that you're abandoning? We are quickly growing into our quadcore server with 2gig of RAM and I'm trying to predict what the upgrade cycle might look like. At what point is it less cost-effective to get a powerful single server and two moderate servers make more sense?

There are a lot of variables in moving to a two server setup and what you have now may just need to be tweaked to live a bit longer as a single server setup, a RAM upgrade is cheaper that getting another server regardless, but again, the server your on may have a RAM limitation at the mobo level as well.

Splitting the servers is easy in that aspect, its just a matter of copying data, tweaking mysql (typically a 4 day task), setting up the nic's, changing config.php and away you go.

@brandi, ill give you a hint, it has 1100 on the end....

Our current server specs are

AMD Athlon X2 Dual Core 5000+
OS: Linux - CentOS 4
Memory: 4GB DDR2 SDRAM
Hd1: 160GB 7200RPM SATA / 8MB Cache
Hd2: 160GB 7200RPM SATA / 8MB Cache

We're looking at probably just adding a second one like this. I need to do a bit more research before making a final decision. I'm somewhat server stupid. :(

--------------- Added [DATE]1210521814[/DATE] at [TIME]1210521814[/TIME] ---------------

There you are! I was thinking you were 1001. :D Yeah, I need to pester you again when ever you get a chance. I need to be advised by the wise one, as to what I should do. :erm: This is definitely not my forte! Heh...

Alternatively, you can stick with one server and just get faster hardware.

BrandiCup
Sorry to hijack your thread, but I looked at your military forum and it is very similar to a military forum I will be creating. I will not compete w/ you as it is for a different geographic group of military. Is there way I can contact you and ask you some questions about your style (i like the look)? Also I would like to know how you have handled security issues related to military families! I think you can pm me w/ you contact info. I will check my settings.! Thanks

AMD Athlon X2 Dual Core 5000+

This is the start of your problems. An Athlon is a processor designed for desktop computers, not for servers. Unfortunatly there are a lot of hosting companies that offer this processor for (cheap) servers. :(

The 2nd bottleneck might be your disks. SCSI disks in a good RAID configuration will outperform the single (assuming you have just 2 single SATA disks) disk.

I really doubt if the memory (RAM) is the bottleneck.