Load Balanced Servers Or Seperate Apache/MySQL
May 29, 2007
I currently have one server a
Dual Xeon 5130 2GHZ (woodcrest)
2GB Ram.
Running cPanel/WHM
Now I run a website that is VERY PHP & MySQL Intensive and MySQL is ALWAYS the top of the process list, hogging a ton of usage. It's getting to the point where the site is needed a second server and I know there's a few options; but I'm not sure which one would be the best.
They way I see it my two options are getting a 2nd server and setting up the two to do load balancing, or getting a 2nd server and setting one up for just Apache and the Other for MySQL and using the 2nd as a remote SQL server.
If I do the Apache on a seperate server would I need such a powerful server? And if I also would want to upgrade this server along with getting a 2nd server would I be better of upgrading to 4GB of RAM or upgrading the processors?
View 9 Replies
ADVERTISEMENT
Oct 1, 2008
Any hosting company providing load balancing in from of 2 VM'S on separate nodes?
Look for a low cost solution to run an ATOM server on 2 separate nodes. No need for web sites, control panels, etc.
Just Jetty or apache + atom + postgres.
View 1 Replies
View Related
May 14, 2007
I have come across a number of hosts who offer Load Balanced hosting. I know that load balancing has something to do with distributing the requests to a cluster of servers. Bu how does it actually work?
What happens if I host my website on load balance hosting provider? Will copies of my website be placed on different servers and the website will be served from the server with the least load?
View 14 Replies
View Related
Jun 15, 2007
Has anyone any experience of using Load Balanced Clustered VPS servers?
If so who would you rate the best provider?
View 1 Replies
View Related
Jun 16, 2007
I have set up a HA network.
Web Servers #1 and #2 have their own IPS, but share a dedicated load balanced IP via the H5 Load Balancer.
We have our domain name registered with Yahoo!
How do we point the domain name at Yahoo! to the load balanced IP?
View 3 Replies
View Related
Mar 31, 2008
We have setup and are currently testing a load balanced cluster using heartbeat and ldirectord. One of the problems we have come across is that we are unable to reliably use the same web server for connections from the same user. As a result the php sessions are getting in a bit of a muddle.
Obviously its not something that we can easily sync between servers like the customers other web content. We are looking at either storing the sessions in a database or NFS.
The site is pretty busy and we are a bit worried that when the site goes live both these options will slow everything down.
Apart from using different load balancing software is there any other solutions we could use for this? Has anyone stored php sessions in a database on a busy site or on a NFS?
View 3 Replies
View Related
Jan 30, 2007
One of our customer is looking to use wild card SSL on one of his site hosted with us, he needs clarification on following.
Quote:
We want to have load balanced site serving contents from three different Apache on different physical machines. Site needs SSL security and we will have wildcard SSL for it. However, since the CSR is generated from one apache, will the SSL certificate give errors or alerts if the request is transferred to other apache?.
This is something I am not aware of, infact no such need come thru.
View 3 Replies
View Related
Mar 28, 2008
I was wondering if it is possible to cluster 2 web servers and 2 mysql servers with only one server working as load balancer.
I am planning to use LVS (ldirectord and heartbeat).
Let's say I have 3 IPs allocated to the load balancing server.
111.222.111.222 (Main IP)
111.222.111.223 (Web Load Balancing IP)
111.222.111.224 (MySQL Load Balancing IP)
If a connection is made to .223 it would pass the request to one of the web nodes.
If a connection is made to .224 it would pass the request to one of the MySQL nodes.
Is it possible to do this?
If not, can I run, for example, nginx on 223 IP address to provide forward proxy? (Then it would not be able to HA but the main point is to load balance so)
Also, what would be the best way to keep the data same on both web servers? This is a web cluster for a very high traffic forum with a lot of uploads every hour so it has to do real time synchronization. I heard that DRDB is only one way and not two way so I'm not going to be able to use this.
View 11 Replies
View Related
Jul 7, 2009
I would like to find out from users how they designed and layout their networks when it comes to subnets.
Currently we have 3 subnet's of different sizes which house our network equipment such as Switches, PDU's, Log Servers etc. but also on these same subnet's are servers which we provide web hosting and VPS services. We also have some clients on these subnets with dedicated servers.
I am curious about this network design. Is it acceptable to house our operational equipment such as switches, PDU's etc on these same subnets which has client access servers or should be obtain a small seperate subnet to house this equipment for security and isolation reasons.
View 9 Replies
View Related
Jan 4, 2007
a good deal of the price in buying servers frequently comes from a nice motherboard, chassis, etc. having to purchase those items twice is just taking away from other components you could be adding to one server-- more ram, more/faster cpu's, etc. not to mention the wasted overhead in just running the operating system twice.
considering all of those factors, wouldn't it be logical to build a nicer single server rather than two "okay" servers?
the only real advantages I see are
1) potentially httpd could be reachable when mysql isn't... but for something like vb, that's almost a moot point
2) at some point you're going to hit a point where buying a nicer CPU isn't really worth the money; spending twice the money for a 10% performance increase, etc. but it seems like multiple cpu's could still get around that.
View 6 Replies
View Related
Jun 21, 2008
if it was possible to load vhosts from a MySQL database and the only solutions i found didnt work for me. Im running Apache on Windows. Has anyone seen anything that would work with Windows? The only alternative i can think of is to read the database info using PHP and output it to a vhosts config file. I dont want to do that though because it means restarting the server to load the new config and i hear that a lot of vhosts slows the server down
View 4 Replies
View Related
Mar 29, 2007
we plan to buy one server for apashe and one for mysql.
So first server will handle apache + cpanel + exim
Dual Processor Dual Core Xeon 5140 - 2.33GHz (Woodcrest) - 2 x 4MB cache
8 GB FB-DIMM
3 x 73GB 15k RPM SA-SCSI
Linux RHE 4 ES
second will handle only mysql
Dual Processor Quad Core Xeon 5345 - 2.33GHz (Clovertown) - 2 x 8MB cache
8 GB FB-DIMM
3 x 73GB 15k RPM SA-SCSI
Linux RHE 4 ES
Server will be used for forums about 4000, 5000 Simultaneous users.
View 3 Replies
View Related
Mar 21, 2007
here's my current setup has my stuff running on 2 separate "self contained" servers (eg; each runs their own apache/php/mysql):
Main site/server:
content: mostly static content (no mysql, very little php). currently has about 4tb/m traffic. in the summer it could push up to 6tb/m
hardware: P4 2.8ghz. 1gb ram. this server has no problem handling the load. only problem is bandwidth (i have to get it off the current host)
Forums site/server:
content: running vBulletin. currently 400-500 peak (probably jump to 800 peak this summer) users active per 15 mins.
hardware: 64bit dual Opteron 242. 4gb ram. it's absolutely griding that to a halt at peak times. it acts like 4gb memery isn't enough (it will run fine then eat through most of the 4gb. grind to a halt, then recover) personally i think it was setup/configured wrong but i've had multiple people look at it and nobody can find anything wrong in the apache/mysql settings.
What I want to know:
what type of server setup should I start migrating to? should I keep both parts of the site separate? eg; main site on one server, forums on another server(s)?
what i've sorta been looking into is 3-server setup.
(server1) main apache/php server. probably on unmetered (honestly don't think i'll find anything else that offers high enough traffic). run the main site and the vB php from here
(server2) dedicated mysql 'read only' server (server3) dedicated mysql 'write only' server.
and have mysql read/write synced and have all 3 servers networked directly together. i have a friend running a single mysql driven site using this setup and it works really well for him.
is this overkill for me? should the current dual Opteron be able to handle the forums and i just need to hire someone smarter, or is there some other setup that would work better for me? i'm tight so i want to go cheap as possible, but I also realize i need room for summer traffic expansion that always hits us.
View 4 Replies
View Related
Apr 15, 2008
A couple days ago I bought 3 Dell Precision Desktop 360s for the purpose of Load balancing for a web server supporting Apache/php/mysql.
The Dells have:
Code:
Win XP Pro,
1 gb 3200 ram - can support up to 4,
p4 2.4 ghz,
2 scsi raid 36 gb hdd
How can I create Load balancing between 3 identical* web servers: by SCSI, network, or something else?
* Bought them all used. Quality tested the hardware, all of it identical.
View 8 Replies
View Related
Apr 5, 2007
is there any way to do this? I know the clustering system built into whm is only for DNS, not for actually serving websites. What I would like is that visitors to a site could be directed to one of two servers, transparently (no www.server1.site.com, www.server2.site.com, it looks idential but are just directed to different ips).
View 2 Replies
View Related
Sep 28, 2009
1. Is it possible to get a server in US and a server in Europe and load balance the two servers so that it would detect where the user is from and based on the users location, it would send the traffic to the right server? is this something a load balancer can do or does this have to be done on the php end to detect and send to the right server?
2. is there a way to sync the two servers meaning, we upload the files to one server and the other server automatically gets updated or synced with the original server?
Thank you
View 14 Replies
View Related
Feb 20, 2008
There's something I've been desperately trying to resolve, but failed, and the question is
can load balancing solution be applied to a shared hosting plan, will I need two plans in this case? Or is it only possible for dedicated servers?
Does any host provide load balancing (round robin will be the most frequently used type, I guess)?
Questions to those using Serverpoint.com and Hostgator.com do these hosts offer load balancing?
View 9 Replies
View Related
Aug 6, 2008
I'm looking for a reliable hosting provider with a well-connected network and a responsive customer support team. I like my current provider, but they can't handle DB clustering, SANs, etc.
Details are below. I would provide all of my own OS and DB software. Suggestions based on first-hand experience would be appreciated ......
View 14 Replies
View Related
Sep 30, 2007
I would just like to no how you would load balance 2 sites. Would this be done via dns settings. EG
instead of seting the domain to something like
ns1.server1.com ns2.server1.com
would it be?
n1.server1.com ns2.server2.com
View 4 Replies
View Related
Aug 26, 2007
list the obvious and not so obvious. And how easy would it be to set one up?
View 1 Replies
View Related
Nov 26, 2007
I am currently using for example these nameservers:
ns1.mydomain.com
ns2.mydomain.com
but I am also thinking of offering hosting, and would like to setup seperate nameservers for example:
ns1.myhosting.com
ns2.myhosting.com
Is it possible to do this, with both sets of domains utilising the same dedicated server?
Would they all need seperate IPs, or can I use the same IP that ns1.mydomain.com is using for ns1.myhosting.com?
View 5 Replies
View Related
Nov 17, 2008
I have a question:
Is it possible to use mplayer, ffmpeg, mencoder from one server while having the program / script calling the conversion from another server?
View 3 Replies
View Related
Nov 14, 2007
I have been reading the Separate Virtual Host Configuration Files configuration reference, but just not clicking.
I want to take each of my httpd.conf domain configurations and store them in seperate files on the drive.
Can someone give me real world examples from their config of what is needed in httpd.conf and then what is needed in each seperate host file.
View 8 Replies
View Related
Jul 30, 2009
Hello, we have a few web servers that run Windows 2003 Server and IIS for web page hosting. We develop custom applications and don't do "web hosting" per se.
What is the best way to do this in a load balanced environment? We have a Cisco load balancer out in front of these servers, but I'm curious about the following:
1) Is there a way to replicate IIS entries instead of having to configure the site on each server?
2) How does everyone handle file replication (hopefully in real time) across all servers?
View 2 Replies
View Related
Dec 4, 2008
Load Balancing a specific cPanel account over multiple servers
I have a couple of my clients cPanel accounts that I would like to load balance over two or three servers. Is this possible?
If load balancing is not available, what about auto failover?
View 6 Replies
View Related
Aug 23, 2007
I am just a beginner and it is about a month that the mysql loads on my server is so high , I have checked the mysql processlist via cpanel and there is no account that takes high mysql and make it high , and even I have checked for any possible rotten databases. but still the server load is so high and I can not control it , even when I restart it just after a minute it goes up again.
just the spamd command takes a high CPU usage sometimes. what it should be from? the spamd for a special account!
I need to optimize mysql , and need help. please do not tell me to hire an expert , just help me thanks
and another question is that how can I check which account is sending spam and stop it?
View 14 Replies
View Related
Mar 11, 2008
I have a dual xeon server that host around 15 small website, but these days I see that the load generated from mysql is very high as you can see below is consumes 32.6 CPU
mysql 32.60 1.20 0.0
how I can know what is the cause of this load?
View 11 Replies
View Related
Feb 15, 2007
MySQL.
Quote:
top - 18:43:24 up 18 days, 18:05, 1 user, load average: 145.13, 92.77, 40.84
Tasks: 145 total, 10 running, 134 sleeping, 0 stopped, 1 zombie
Cpu(s): 28.7% us, 70.6% sy, 0.0% ni, 0.0% id, 0.7% wa, 0.1% hi, 0.0% si
Mem: 1034060k total, 605968k used, 428092k free, 21400k buffers
Swap: 1020088k total, 165076k used, 855012k free, 119448k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6102 mysql 16 0 343m 146m 2868 S 364 14.5 1441:52 mysqld
My server almost went dead... until I rebooted MySQL.
View 7 Replies
View Related
Oct 17, 2007
MySql die with high load problem?
My server running: Server Load124.40 (2 cpus)[url] Memory Used70 %[url]
Server info:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(R) CPU 3060 @ 2.40GHz
Processor #1 speed: 2394.840 MHz
Processor #1 cache size: 4096 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(R) CPU 3060 @ 2.40GHz
Processor #2 speed: 2394.840 MHz
Processor #2 cache size: 4096 KB
Memory Information Memory: 4148800k/4718592k available (1883k kernel code, 43336k reserved, 761k data, 188k init, 3275648k highmem)
View 9 Replies
View Related
Feb 11, 2007
i'm using Vista RTM, and so then
my PHP module can load mysql 5.0.27.
Apache version: 2.0.55 ( ok )
PHP version: 5.2.0 ( unzip package - ok)
MySQL version: 5.0.27 ( connection is ok only with cmd line )
so, what's the problem.
i tried with this solution:
[url]
but it's take no effect.
what's the step i have been lost?
View 2 Replies
View Related
Sep 4, 2007
when mysql has heavy load average what else can be done rather than restarting mysql service.
View 6 Replies
View Related
