How Many Database Servers Can Work Together
May 14, 2009Say 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
ADVERTISEMENT
How Do Servers And DCs Work
Oct 3, 2009I would like to know how servers work, like how to build, set up, and how they work, what software is in them? Also could I own a server and send them to a data center and host them there?
Also a little infomation on Data Center. Could you share me some knowlage.
MyTop Doesn't Work Anymore Error... Unknow Database...
Nov 13, 2006it works fine for months but now when i type: mytop in SSH i geto erro:
----------------
Cannot connect to MySQL server. Please check the:
* database you specified "test" (default is "test")
* username you specified "root" (default is "root")
* password you specified "" (default is "")
* hostname you specified "localhost" (default is "localhost")
* port you specified "3306" (default is 3306)
* socket you specified "" (default is "")
The options my be specified on the command-line or in a ~/.mytop
config file. See the manual (perldoc mytop) for details.
Here's the exact error from DBI. It might help you debug:
Unknown database 'test'
---------------
I also try to reinstall but nothing...
Nameservers Work On Multiple Servers
May 7, 2009Can the same nameservers be used on multiple servers/vps on different geographical locations and if so, how are they setup? That would save me quite some money. Hoping for some input.
View 8 Replies View RelatedWeb/Database Servers Setup
Jul 9, 2008We 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.
Database And Website On Different Servers
Oct 26, 2007We 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.
Splitting VBulletin Onto 2 Servers - Remote Database
Jul 4, 2008I 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?
Plesk Automation :: No Database Servers Available For This Subscription
May 15, 2014Text when you click Add New Database gives this error
subscription is Administrator
Hardware: Db Servers, Web Servers, File Servers. Cpu, Ram, Disk
Jan 20, 2007I 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?
Plesk 12.x / Linux :: Unknown Database Atmail When Selecting Database
Nov 20, 2014When 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.