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


ADVERTISEMENT

Innodb Database Server Setup (for Dummies)

Jun 12, 2008

I'm getting ready to setup a dedicated server for a site that is database intensive that mostly uses mysql innodb databases.

What is the best setup for me that would allow regular database backups of my innodb databases the easiest way possible. I basically want to be able to backup my database at a regular interval (probably weekly) without having to think too much (and without having to shut down my server each time or stop my database).

I'm not too tech savvy with database management so am after tips on:

- Best server setup (second drive just for bakups?)

- I Don't fully understand RAID 1 setups and how they would benefit me

- Explain to me the backup process for any solution you suggest

View 9 Replies View Related

Setup Name Servers

Nov 23, 2007

I know this is kids stuff to you guys but i wanna verify how to that correctly.

I have a dedicated server with cpanel. So i setup nameservers there. like ns1.ABC.com and ns2.ABC.com

So now i wanna host ABC.com in that server. My registrar is Godaddy.

So how to setup at godaddy? can anyone guide me.

Is it like make hosts like ns1 and ns2 and put the IPs from the server in the fileds?

Then i have to put the nameservers fileds also ns1.abc.com and ns2.abc.com too. Or just making ns1 and ns2 hosts enough?

View 14 Replies View Related

How To Setup DNS For 2 Servers With One Domain Name

Apr 8, 2008

I have 2 servers. How do I setup the DSN for these 2 servers with my domain? For example, I have domain "mydomain.com" and server1 and server2. I want
ns1.mydomain.com, ns2.mydomain.com --> server1
ns3.mydomain.com, ns4.mydomain.com --> server2

Both server installed cPanel/WHM.

View 3 Replies View Related

Building New Servers - Drive Setup

Oct 4, 2009

We're building a bunch of new servers (as I mentioned in another thread). What do you guys think is the best drive layout? Traditionally we just have the entire 4-6 drives in a RAID 5, but now I'm wondering if it makes sense to have a separate OS drive, and then the rest in a raid 5?

On a side note, we need a giant ~2TB-3TB partition on these boxes, that's why we go with the multi-drive raid setup. Thoughts? I know it was customary to have a separate OS drive back in the day (I remember having WD raptor's for that), but now when the WD Black-edition (which we'll be using for the raid setup) are as fast as the raptor's, is it even worth it?

View 7 Replies View Related

How Do I Setup A Site On 2 Servers. 1 For Mysql 1 For Web

Jul 7, 2009

How do I setup a site to use two servers? One as a mysql server and the other as a web server.

At the moment I have the site on one server. When I get the second server what steps do I need to take to make this possible?

How do I secure the mysql server to only allow the web server to connect to it?

Do I need a control panel (i.e. cPanel) software on the mysql server?

View 14 Replies View Related

Trying To Setup The Name Servers But Everytime It Fails

Jun 22, 2008

I have a server at volumedrive it has cpanel and whm installed etc I am trying to setup the name servers but everytime it fails is there something that I might be missing?

View 4 Replies View Related

Setup- Multiple Servers Or 1 Powerful One

Sep 21, 2007

some setup recommendations as I feel I have outgrown my current server.

I have two websites:

#1 is a busy vBulletin based forum with 42,000 members.

#2 is a website with Wordpress and Vbulletin installed (though the forum is nowhere near as busy as the first site) and gets roughly 2000 uniques a day.

When site #2 gets a good surge of visitors from offline media or a large site, site #1 will die first with the "mysql error: too many connections" error and site #2 will take a very very long time to load.

For every other day, the load is quite low, nearly always under 1.50.

The current server that both sites reside on has the following specs:

Quote:

processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Pentium(R) 4 CPU 2.66GHz
stepping : 9
cpu MHz : 2667.540
cache size : 512 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid xtpr
bogomips : 5339.18

total used free shared buffers cached
Mem: 1003 484 519 0 3 192
-/+ buffers/cache: 288 715
Swap: 2047 25 2022

What sort of setup would be best for me?

A files server and a sql server?

A server for site #1 and another for site #2?

A single, more powerful server?

Or something else you recommend?

Also, for the setup you do recommend, can you recommend a hosting company that is reliable and can do it for a good price?

View 7 Replies View Related

Setup Time Of Leaseweb Servers After Payment?

Sep 22, 2008

what is the setup time of leaseweb servers after payment?

View 4 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

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 View Related

1 SSL Cert... 1 Domain... 2 Servers. How To Setup A Backup Server

Jan 13, 2009

We have two in-house servers, one is hosting our public web server. The other one was just purchased to host a mirror of the production server (as a backup). The site is protected by an SSL cert... my question is how do i set up the server(s) so if/when the backup server needs to be switched into produciton, the SSL cert will transition flawlessly?

They are both apache 2 servers.

View 2 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

Node Setup - Lots And Lots Of Low Spec Servers Or

Mar 29, 2008

I run a large service on 2 machines (we're talking 8x2.66Ghz processing power, 4-6GB ram, etc), however we are thinking about creating a node/clustered setup to help spread the load, bandwidth, mysql (having one server for hundreds of thousands of databases is not wise it seems :p), diskspace etc. Lots of machines just seems to be a cheaper and more powerful option.

Would you advise going with lots of lower end machines, or just a few mid-range machines.

Here is what I propose:

3 of these
Dual Xeon 3GHZ Dual-Core (4x3GHz)
3GB RAM
500GB Sata Drive
4000 GB Bandwidth
100mbit

or

4 of these
XEON X3220 QUAD CORE 2.4GHZ 1066FSB
2GB DDR2 RAM (Upgradeable)
250GB HDD
2000GB Bandwidth
100mbit

or

7 of these
Dual Xeon 3.06 Ghz
2GB DDR2 RAM
250GB SATA
2000GB BW/MONTH
100mbit

All of the above are roughly similar prices in total.

View 5 Replies View Related

Dedicated Or Reseller Setup With Virtualization Or Decent Chroot Setup

Jul 31, 2008

As my clients' needs expand, they're asking for chroot ssh/sftp setup. I'm currently on a dedicated Linux setup but don't really have the time to set up a whole new box with full virtualization or investigate a full chroot solution (baby on the way), and to be honest it would be less hassle to move to a new provider than worry about down time with sites.

What I'm looking for:

- linux hosting
- hosting for 30+ accounts, some with several domains
- at least 6 IP addresses for SSL certs
- each account in a full chroot environment (ssh/sftp/ftp) so they can't poke around each others' files, or each account set up in a virtual machine setup (ie: openvz)
- maildir
- spamassassin
- php 5, mysql, perl 5.8.8
- suexec apache would be nice

View 3 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

Plesk 12.x / Linux :: Unknown Database Atmail When Selecting Database

Nov 20, 2014

When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:

Code:

Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.

mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database

===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...

There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.

View 5 Replies View Related







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