alinford
07-21-2008, 11:56 AM
When setting up cPanel/WHM shared hosting and reseller boxes, is it preferable to just put all services on the same box, or is it better to setup separate boxes for MySQL and Email?
![]() | View Full Version : Separating Services with cPanel alinford 07-21-2008, 11:56 AM When setting up cPanel/WHM shared hosting and reseller boxes, is it preferable to just put all services on the same box, or is it better to setup separate boxes for MySQL and Email? SingleHopChris 07-21-2008, 02:49 PM Austin, It is going to depend a lot on how many clients you are planning to put on that box. If you are just starting out you may want to keep everything on one box, firstly because ideally the box can handle it, and secondly, it is more cost effective. If you are planning on immediately dropping a ton of accounts on the server, then you may want to consider splitting at least mySQL off onto it's own box. alinford 07-21-2008, 03:13 PM Austin, It is going to depend a lot on how many clients you are planning to put on that box. If you are just starting out you may want to keep everything on one box, firstly because ideally the box can handle it, and secondly, it is more cost effective. If you are planning on immediately dropping a ton of accounts on the server, then you may want to consider splitting at least mySQL off onto it's own box.We will be putting ~700 accounts on the server(s) in the first 45 days as we move them from our current hosting provider. SingleHopChris 07-21-2008, 03:23 PM In that case, if the accounts are mySQL heavy, a dedicated mySQL box sounds like a good idea. Fizzadar 07-21-2008, 03:29 PM You could just use multiple cPanel servers, each doing everything, an easier setup, and if the accounts aren't super MySQL heavy, it should be more cost effective than a dedicated SQL box (because if they're not using it much, its just a wasted box). alinford 07-21-2008, 03:38 PM You could just use multiple cPanel servers, each doing everything, an easier setup, and if the accounts aren't super MySQL heavy, it should be more cost effective than a dedicated SQL box (because if they're not using it much, its just a wasted box). Yep, I have thought of that as well, but I am also considering using an R1Soft server for backup. Putting all MySQL on a separate server would let me buy a single MySQL agent instead of one for each box. I could also go with the idea that most tables will not actually be locked during backups, and not worry about the MySQL agent. Oh the choices... camers 07-21-2008, 05:22 PM Are you using MySQL Enterprise? Just I see you talking about buying MySQL so got me a little confused! alinford 07-21-2008, 05:25 PM Are you using MySQL Enterprise? Just I see you talking about buying MySQL so got me a little confused!I am talking about R1Soft's MySQL agent, not MySQL itself :) camers 07-21-2008, 05:37 PM I am talking about R1Soft's MySQL agent, not MySQL itself :) Ah, sorry! Might be a nice saving to grab a dedicated MySQL box then. Probably want to think about the redundancy side of things though, cause a problem would interrupt all users on every server. |