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?
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?
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?
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.
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.
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.
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.
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
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.
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.
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.
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).
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?
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?
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 ......
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?
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?
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
