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.
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 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 know this is not an awesome idea, but I'd like to try it. A friend and I want to share (home) servers. We both have fairly decent upload and we both have nice (dual core, 1GB RAM+) servers, so that's good. Another thing I'd like is failover for when one of our servers go down (I've got that part covered with my own DynDNS client). We're both running Windows servers.
Since I cant really use a load balancer in this situation, we'll be using round robin DNS. Now here's the questions:
How do we keep our MySQL servers synced? Should I use rsync or something else for files? How do we handle PHP sessions across servers?
If you don't think the load balancing thing will work out, I'd still like to do synchronization and failover. My friend is in another state by the way, we're not neighbors or anything so we can't just run some cables from one house to the other.
Just wondering if mysql load balancing is possible in a shared environment.
Example:
I have 3 shared accounts. On one server, I have the write and the 2nd and 3rd server I have the read (select). Or vice versa .. Would it be possible to create a php script to perform this function?
I have a lot of questions here so if you can't answer them all I understand. even pointing me somewhere where I could get the answers would be appreciated; hardware sites focusing on server hardware, forums focusing on such, etc.
we plan to have three different types of servers:
- db server (self explanatory. mysql. for forums, mysql driven sites.)
- file server (lots of files around ~2-10MB, consistant 70mbps right now, but we want more room for upgrades. needs a LOT of storage room.)
- web server (lots of php files, but also static things like plain html, images, etc. also includes all misc services for the setup-- dns, etc.)
could I be given a rundown for which hardware each of the three should have? I don't need specifics, even just knowing that more ram is important here while cpu doesn't matter as much, or that the fastest disks available are a must, etc would all be valuable info for me. despite that, I certainly wouldn't mind specific hypothetical hardware configs.
for the database server I'm assuming the more ram the better. not entirely sure about the cpu? also not positive on disks...
for the fileserver, how much ram would be practical or useful? disk io will be an issue I'm because plenty of people will be pulling files at once so the disk needs to read from multiple places. scsi (and even raptors) are not an option as we need 750GB+ of space on a reasonable budget. more ram will take some load of of the disks, but how much is neccessary / reasonable?
for the web server I'm assuming cpu first, then ram, but it'll likely need less ram than the db server?
I'm more lost on the disks than anything. scsi on the fileserver is not an option under any circumstances due to $/GB. for the db & web server I'm willing to pay for scsi if the performance increase really does warrant the extra money, but I'd like to be convinced before shelling it out. if you have benchmarks geared at server hardware when it comes to disks I'd really appreciate it.
also, what's the best way to network these together when colocated? each one with a dual gigabit ethernet port and then the communications go to and from the router?
I'm working on transitioning to a new server. Long story short, I have about a database around 100MB in size that I need to get from a MySQL (4.0.25) server to MySQL 4.1.14 server. (Both machines are running Linux and are sitting in data centers with fast pipes.)
What's the easiest way to do this? I have full root access on both machines, ssh access, and phpMyAdmin on both. Is there a way to have one machine read the data directly from the other, say some command line tool? (What I plan to do is to use phpMyAdmin to 'export' it to a backup, download that to my desktop machine, upload it to the new machine, and import it. This seems quite inefficient.)
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.
Haven't seen much debate lately on what processors to use within dedicated database servers. We're currently considering Dell 2950s and 2970s with the following:
8GB RAM, single SAS, 3.5-inch, 15K RPM Hard Drive for OS, single SAS, 3.5-inch, 15K RPM Hard Drive for SWAP, and four SAS, 3.5-inch, 15K RPM Hard Drives in a RAID10 array for database storage.
We'll be getting one server just for MySQL applications and one server for just PostgreSQL applications.
I am just colocating servers and managing them myself, and renting services off of them. In the future I would like to start offering dedicated servers as well. I am wondering if many companies do this, or if its more of a general practice to just setup as a reseller? The worst part that comes to mind is thinking of how to do billing for the bandwidth per month. With my setup I would only be offering flat bandwidth packages (like 2TB a month) but even so, I cant think of anyway to automate it so WHMCS knows if they went over, if so, how much, etc.
the loads on my server is VERY HIGH and it needs to be upgraded fast.
I really have no clue as what to do... and i do not know any expert other than you people here - to help me out and put me on the right track.
i was thinking of
1) Getting a server with better CPU and more RAM 2) Load Balancing
However I know nothing of load balancing (other than how to spell it correctly )
1) Which of the above two options should i choose? 2) what are the extra costs in load balancing? 3) what should i know about load balancing before deciding? 4) How does load balancing work? I know there are two server - like one for database and one as webserver... but how does this work together? 5) what config should i be looking at in the two servers?
I'll stop here else i can go on and on and on...
I am giving the details of my server and service below, in case you guys need it.
We host a large number of small websites and are looking for high-availability and the ability to do maintenance on our application servers, so I'm looking for a load balancing solution. At this point, I'm considering Zeus ZXTM LB software, the Coyote Point e350si, and potentially an F5 1500 LTM.
The F5 solution is a total budget buster, and the Coyote Point UI is rough around the edges, but I've used them and they are reliable. Zeus looks like a winner with a great UI, but I haven't heard much about their reliability.
Bandwidth requirements are low at this point, so this is mostly about reliability and ease of configuration of a moderately complex set of services.
Any opinions on these vendors, or alternates I should consider?
I run a GSP (Game Server Provider) and i just baught 2 new octi xeon servers(Intel 5320)
i am having a problem with the load balancing, it dosen't balance de cpu usage on all cores but only on one, and it gets at about 80-85% and 3%CPU usage on the other one.
Here is what I am trying to do, to set up a WordPress powered site to be run across two servers for load balancing. The two servers are dedicated and I have the load balancing software installed and set up. I need to set up the site so that both of them are accessed, but to also have the same content. The main concern is for the same content.
WordPress uses a MySQL database to place all of the content there, so the main thing I would need is to set up the databases so they are synched on both servers, so that the same content is showing up on both of the servers, and so I don't have to manually upload data to the database every few hours, that would suck. I have already found a script to connect to a remote mysql server, it is called HyperDB, but I was wondering if there are any better ways.
Our server is going down due to several reasons. We decided use load balancing or clustering solution. What are the main difference between load balancing and clustering?
I have a growing website that needs to move from its current single-server setup to using a cluster of servers to deliver its dynamic pages.
My current host does not support load balancing among its servers, so I'm left to configure that on my own. Round-rovin DNS doesn't work for me as I'll need certain http requests to always go to the central server (the one with the master database).
My distro is Redhat 9, and I only access the server remotely through SSH. I'm using Apache 2 (and PHP and Mysql).
Any ideas on the simplest way to do this?
I've read a bit about LVS (http://www.linuxvirtualserver.org/) but it seems to require a kernel recompile, which is way beyond the things I would dare to try...