Given the choice which is more beneficial. Some of the things I've read say Database servers use up more RAM and others say they use up more CPU power. I'm just not sure.
Also, what HDD should be used for the database server? I have a choice for SATA or SAS.
Some benchmarks are showing SATA as faster I believe, but that SAS is more reliable? Can anyone comment intelligently regarding that as well?
I moved my site to a new host and am running IPB 1.3 forums,
I have a 62meg sql backup to restore.
I have tried using BIGDUMP.php as max upload is over 52megs.
No Joy!
I also tried zipping the file, got it down to 9megs,
It wont complete the upload in PhpMyAdmin?
I have not had to restore a back up before, and am really struggling.
I have been interested in setting up my own server for hosting a website and a small online game I created. My only problem is how good of a server I would need to get.
View 10 Replies View Relatedhow to go about spec'ing the power consumption of a server. below are the specs of the two servers I'm interested it.
Dual Xenon 2.8Ghz Processors with 2MB cache
1 250Gig SATA Hard Drives
1 500Gig SATA Hard Drive
4 Gigs of Ram
------
Dual Xenon Quad Core 2.66Ghz
1 80Gig Hard Drive
2 320Gig Hard Drives
1 1T Hard Drive
8 Gigs of RAM
I'm currently running Dell 1750s, 1850s, and 1950s in a colo facility. I am not happy with the 1850s and 1950s power consumption. My 1950s have a single quad core 5310, 2GB memory, dual 15k 73GB drives, dual power suppies and are running at about 1.9 amps with spikes up to 2.4 amps. My applications are disk bound and the servers typically run at a load of .1 to .2.
I'm looking for alternatives to the 1950 that use significantly less power. I need at least 2 Hot Plug SAS drives and would like to have it in 1U. I run 2GB of memory. Dual power supplies would be nice, but are not absolutely necessary. I'd rather not go with a non-hot plug solution, but may have to consider it. I will probably buy 10-15 servers soon and would like them to be identical. I'd prefer buying a name-brand.
do dual power supplies use more power than a single supply?
E.g. Say I have a server than uses two amps, powered by a single power supply. Now if I switch to a dual supply (and say each supply has the same efficiency rating as the single), does my server use more power? How much more?
My simple view of this is that it probably does, but maybe not much. The second power supply consumes some power itself, but since its not under load, it doesn't consume much. Therefore, my server with redundant supplies might use 2.1A or 2.2A.
I'm building a storage server out of spare parts that are lying around here at the office. Purchasing a brandnew server kinda overshoots it's target, since all basic hardware is available lika a big Chieftec 4U casing with 2x 4drive SATA hotswap bays.
The machine will just be dumb storage for saving our backups.
The plan is to add a decent serverboard, proc and some ram as a baseline. On top of that a 3ware 8-port RAID-controller with 8 1TB harddrives (seagate has some nice ones).
Now the only issue i'm having is powerconsumption. The case has an 460W PSU, but I'm not sure if that's enough.
at getting PDUs for the new facility where we plan to move our servers to. Our cabinet will have 2*20a circuits, so we're thinking of getting 2 APC PDUs (1 per circuit). Some offer remote reboot capability.
Our servers (Dell PowerEdge) have dual power supplies, and I assume the best thing is to plug one power supply into each circuit, so things stay up even if a circuit fails.
So, how would this work if we want to reboot? The servers can run on only one power supply, so does that mean we have to click reboot on the web interface of each PDU at exactly the same time?
I've never worked with PDUs before.. just cheap power strips and a call to the datacenter
What are the best ways to reduce server power consumption?
I have a Dell Poweredge 860 (2.4ghz QC, 5GB RAM, 2 HDs) and it uses 0.46AMPs when running normally. The problem is at boot up it spikes for a few seconds here and there to about 0.6 and this is a real problem as I only have a 0.5AMP allowance.
Should I underclock it? Remove the CD Drive?
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.
I currently have a VPS cPanel/WHM and was wondering if I could use another VPS for a database server.
Would this work ok?
Do you know of any downsides to this?
Would you keep the MySQL on the same server (localhost)?