Database And Website On Different Servers

Oct 26, 2007

We have 2 linux servers directly connected by Gigabyte Ethernet. On a First server (192.168.0.1) we have a website (PHP5, Apache2), on the Second server (192.168.0.2) (CentOS 5 64bit, kernel: 2.6.22.9xe5u) we have MySQL 5.0 Database. A website from a Fist server connects to the database on the Second. The problem is that this system is very slow. We triet to move our website from First server to the Second and it works 50-300 times faster.

This is very strange, because when we print SQL queries of a website we see that some similar queries which are not dependent on a data or where there are very small amount of data, are executing in very different time.

For example:

SELECT t.*, tl.title, tl.content FROM site_tree_public AS t INNER JOIN site_tree_public_localdata AS tl ON t.id=tl.site_tree_public_id WHERE t.hidden='0' AND tl.lang_keyword='eng' ORDER BY parent_id, orderid
0.61763
after refresh 0.00365
another refresh 0.86579
another refresh 0.00302
another refresh 1.22748

Another example:

Four similar queries to four different databases (shemas), on one page load:
SET NAMES utf8 0.00021
SET NAMES utf8 0.00012
SET NAMES utf8 0.00012
SET NAMES utf8 0.20491

When we moved website to the Second server these queries are executing in a good stable time.

Also some following problems were noticed:

1. While connecting to the FTP, server slowed down and sometimes connections were dropped

2. We tried to install Ubuntu unsuccesfully - the network didnt work at all, then we moved to CentOs 5

3. When we first installed CentOs 5 with standart kernel we had experienced problems with network (IP's aliases just didnt work) then we installed newer kernel and the problem was solved.

first server - SM-XE2, SuperMicro 6014H-82, Dual Xeon 3.4 Ghz, 4GB DDR RAM, 2x72GB U320 SCSI RAID1, Dual Intel PRO1000, 1U
second server - SM-XEW, SuperMicro 6015P-8, Dual Xeon 2.0 Ghz (Woodcrest 5130) , 8GB DDR RAM, 2x73GB U320 SCSI RAID1, Dual Intel PRO1000, 1U

So the question is - what do you think about the problem? Did you use such a system - when a website is on one server and the database on the second? And what was the experience? Could it be kernel problems?

we think that it might be problems with kernel that dont work properly with network, please comment this.

View 2 Replies


ADVERTISEMENT

Hosting For 4GB Website + 2GB SQL Database

Aug 9, 2008

I have a friend who has a dedicated server right now that uses a good 4GB for all his website content. (not streaming media but just a whole bunch of scripts and etc. well thats what he tells me). And so anyways, his SQL database is about 1-2GB. And he is not too sure about his monthly traffic but its a social networking site with a good amount of users (so its actively used by many users). Would it be necessary for him to have a dedicated server or do you think he could cut costs with a shared hosting account at like host gator or some other shared hosting service like that? I guess my biggest concern is his current database. A lot of shared hosting companies (from what i saw) offer unlimited Mysql Tables do they have size limits? And does a bigger sql database drastically effect the performance of the overall server?

View 14 Replies View Related

All Website VB On Server Database Error

Nov 7, 2009

i transfer all customer in new server

and restore all backups

but all website VB appear Database error

although mysql work very good

View 3 Replies View Related

Which Host For Website With MySQL Database

Apr 19, 2008

have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!

View 14 Replies View Related

Two Servers, One Website

Jul 19, 2007

I own a VPS through GoDaddy and I just bought a second for my website. My goal is to have all of the .zip files hosted on this second server, and all of the scripts, forums, and images hosted on the other. At the moment the server holding the scripts and everything works fine I just can't figure out how to set the second server as a file host for my domain.

Ideally, I would like to have the second server be FILES.DOMAIN.COM while the first server is DOMAIN.COM. I have no idea how to do this x_x

View 12 Replies View Related

How To Set Up Website To Use Multiple Servers

Jan 17, 2007

how to make it so if the server that hosts my website receives too much traffic it will go to a mirrored copy of my website on another server? I want to make sure that it doesn't go down in the event of a big boost in visitors.

View 5 Replies View Related

Website And Email On Different Servers

Apr 12, 2007

I have server A serving the website for my domain example.com and server B handling email for the same domain example.com.

Apart from one problem everything is working the way it should. The problem is that all email originating from server A (the one hosting the website) to someone@example.com is delivered locally (server A) and never gets out where it could be routed correctly to server B.

What needs to be done to deliver mail originating from server A to server B?

View 4 Replies View Related

Hosting One Website Accross Two Different Servers

Dec 22, 2008

how to host one domain accross two different servers that gives resliance and load balancing?

I know I could setup my domain on two servers and have two of the following records:

www.domain.com x.y.z.a (IP add 1)
www.domain.com y.y.z.a (IP add 2)

But the problem is users also access emails by www.domain.com/webmail.

Now the MX record is pointing to one sever as we want to gather all the emails at one point. So how do I get the users to go to one particular server for the email? I was thinking to alter the email url to something like

www.mail.domain.com/webmail which only goes to one server.

View 8 Replies View Related

New To Dedicated Servers - Pick The Right One For My Website

May 31, 2008

Im setting up a website that will facilitate people to be able to upload and download files.

As you can imagine a lot of people will be downloading so i need unlimited bandwith.

Also require maybe 1tb of diskspace with the option to expand wen needed.

Im not sure how cpu intensive this is but if people can recommend me specs, companies i should be looking for with links that would be very much appreciated.

View 8 Replies View Related

How Many Database Servers Can Work Together

May 14, 2009

Say I had 15 dedi servers all for a database. howmany Could I use before performance started to bog down. lets say 2gb ram centos each with raid 0 hardrives

View 5 Replies View Related

Web/Database Servers Setup

Jul 9, 2008

We are currently looking into getting a new setup to serve our online store, and I would be thankful for feedback as to which servers to choose.

Today almost the entire store is on a single three year old dual proc/dual core server (4 gb ram, RAID5) that is beginning to get overloaded. (There is also a simpler secondary server that serves some static content and does some cron jobs.)

The system is a in-house developed LAMP (where the P is mod_perl/Mason). The database is rather large, two tables with 2-6 million rows are hit multiple times on most public pages - these grow with ~10% per year. Several other often-used tables are in the few-hundred thousand to a million rows, also continuously growing.

We anticipate rapid sales/visit growth over the next couple of years (a good day today is 6000-8000 visits), so I'm thinking of separating the database and web server. The most likely hosting candidate right now is Softlayer's WDC data center (we are located in Europe).

With that background, does this sound like an adequate setup:

Database server
Dual Xeon 5430 - 2.66GHz
8GB ram
RAIDed 3x73GB (or possibly 147GB) (15k rpm). I'm thinking RAID1? The big tables are not written to too much during the day, so read performance is more important than writing.
Web server

This (these) would be serving the Apache/mod_perl part of the system. Some static content (images and some PDFs) unless we put them on a separate server (all static content are placed in a single folder so it would be easy to do a mod_rewrite to an image server).
Dual Xeon 5050 or 7320
4GB ram
2x73GB (SCSI 10k rpm) RAID1

I don't think we need to load balance between two web servers from the beginning but that is something we will keep in mind (and hopefully have to do at some point). Are the two configurations sane (or is one overkill compared to the other)? Generally, how many web servers can a single database server serve? Email is handled separately (Google Apps). I estimate our budget to not more than $1000-1500 a month (if we go with Softlayer we will most likely use some other services such as firewalls, SAN and so on).

We currently use Suse, I have previously used RedHat on personal servers at ThePlanet. Is RedHat 4 32-bit a sensible choice? I have some experience with CPanel so we would most likely use that.

View 2 Replies View Related

When To UseOne Server Or Multiple Servers For A Website

May 11, 2009

I need some expertise on how many servers we need for our site. Basically it is a flash interactive game where a heavy user might download 60-75 megs in a one hour session. Our hope is that we get lots of users, say around 1000 users an hour. Our current server is a AMD 3800plus dual core with 1 gig of ram. It is hosted through Aplus. I am just the programmer for the project and don't know anything in regards to servers, but my client wants to know if one server will be enough to handle the load of 1000 users an hour. Or should we run on multiple servers, etc.

View 14 Replies View Related

Plesk 11.x / Linux :: CentOS Backup Commands For Website Files And MySQL Database

May 27, 2014

I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.

View 1 Replies View Related

Plesk 11.x / Linux :: Website Files Copied To Another Domain But Database Remains On Old Site

May 18, 2014

When I use website copy function the website files are copied to another domain but the database remains on old site. I use this function to move the website from devel state to the production state. All sites work fine but when i schedule the backups all databases are saved on old domain. How to move the database on production domain?

View 1 Replies View Related

Moving A Large 4gig Website Between 2 Dedicated Servers

Sep 11, 2005

I'm moving a large, 4 gig site between 2 servers (both have cpanel... if that's an option). Is there a way to do it quickly and correctly? How would I transfer such a large site?

View 3 Replies View Related

Splitting VBulletin Onto 2 Servers - Remote Database

Jul 4, 2008

I have one server setup to power my forum and its database. It has been running from this server for a while now and as the site gets bigger i have decided i want to move the database to a seperate server.

I have another server at Ecatel and wanted to know if its possible to do this, as they are in seperate datacenters.. or is it only possible between two servers on a private network in the same DC?

View 6 Replies View Related

Plesk Automation :: No Database Servers Available For This Subscription

May 15, 2014

Text when you click Add New Database gives this error

subscription is Administrator

View 1 Replies View Related

Hardware: Db Servers, Web Servers, File Servers. Cpu, Ram, Disk

Jan 20, 2007

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?

View 7 Replies View Related

How To Point Www.website.com To Website.com (or Vice Versa)

May 3, 2008

If I type google.com in my address bar, it forwards me to www.google.com. This is not happening for my website right now. I think its a good idea to do this, since then search engines will have only 1 main URL for the website to index.

My question is:

How do I implement this? I think this may involve mucking with CNAME settings...

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved