Hey all,
I’m looking to migrate a friend over to local colocation company from his dedicated server he leased for a few years (he’s been having some problems with them recently). He hosts a single forum that has roughly 30,000 users and 4M+ threads. The current host has him on a single server (without RAID… I didn’t even know people were stupid enough to do this these days.. but that’s besides the point).
I’ve selected the hardware he is going to need for colo- I just have a few questions in terms of how we are going to set it all up for redundency .
Option 1:
- Server 1: Apache
- Server 2: MySQL
Both servers are going to be configured very similarily, RAID 5, and all of the other goodies.
Option 2:
- Server 1: Apache, MySQL
- Server 2: Apache, MySQL
I was looking into doing a CentOS cluster with heartbeat, and having one server act as the primary node, and the other the secondary. It looks fairly straight forward to get Apache setup in this type of configuration, but from my research, to do a MySQL cluster in this type of setup, you require a secondary Management Console. Is this true? Have any of you done something like this in the past with MySQL and just two servers?
I’m obviously leaning towards the latter- it seems like the way to go in my eyes, but I am just concerned we won’t be able to do it with just two machines, because of the SQL Management Console as another requirement.
Any insight/advice is greatly appreciated!
im guessing the biggest question when it comes to forums is the average ‘users on at a time’ number. number of registered users doesnt mean shit when it comes to loads as they are just rows in a db. you want to see what his peak is with users logged in during the day.
^ At any given time there is generally about 1500 users on the forum.
We have decided to go with a linux clustering setup, two servers. One primary, one secondary. Configured with Heartbeat and DRBD.