MySQL/PostgreSQL Servers - Intel Vs AMD
Jun 29, 2007
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:
Two Dual Core AMD Opteron™ 2212
- 2.0GHz, 2X1MB Cache, 1Ghz HyperTransport
Two Quad Core Intel® Xeon® E5310
- 1.60GHz, 2x4MB Cache, 1066MHz FSB
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.
View 14 Replies
ADVERTISEMENT
Apr 7, 2008
I wanted to get a sense of the usage of Postgres versus MySQL. Does anyone here prefer Postgres over MySQL?
View 14 Replies
View Related
Apr 22, 2009
Web hosting is a competitive business with thousands of providers in the market. Success as a web hosting provider often comes down to maximizing the number of customers we can support for each additional server added to the infrastructure. To improve our success in this equation, it becomes critically important to find and use the correct machine/severs - all for excellent prices.
So friends I was just guessing an approx. no. of clients I will be able to accommodate per Intel-Nehalem-Server, (depending on the server resource utilization).
View 4 Replies
View Related
Apr 16, 2008
I've noticed many questions on this site about xeon and quad-core server technology and products. I work at intel and we have a new open online community space where we are inviting IT professionals to come and ask questions to product and technology experts, engage in open dialogue, or read about topics and trends impacting IT and business.
View 7 Replies
View Related
Jul 27, 2009
I'm trying to optimize a server (Intel E8300) with 8Gb of RAM and WHM/cPanel administration panel.
Now the server has only 46 accounts in WHM, and about 10.000 unique visitors / day
As mysql is always on top for CPU ussage I have edited 2 values in my.cnf, but this was done in 10 minutes and not to much research, any more help will be appreciated. On this server as I see it's been using MyISAM for storage engine and maybe just a few tabels with InnoDB ....
View 13 Replies
View Related
Oct 7, 2008
Intel Xeon 3200 series Quad Core VS Intel Core2Quad Q6600
What stood between Intel Xeon 3200 series Quad Core VS Intel Core2Quad Q6600?
View 14 Replies
View Related
Jan 12, 2009
Intel Xeon 3210 2.1 GHz Quad Core/2Gb RAM/250 gb IDE/SATA /BW: 2000gb
DC ThePlanet
or
Intel Quad Core Q9400 4x2.66 ГГц/4Gb RAM/2x500 gb SAT/ BW: 2000gb DC Gnax/NetDepot
Server choice for hosting.
View 5 Replies
View Related
Oct 6, 2009
Anyone have the latest Xeon 3460's, any comparison to the Core i7 920?
[url]
View 8 Replies
View Related
Mar 28, 2008
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.
View 11 Replies
View Related
Jun 12, 2008
We are hosting our software system which do calculation and file manipulation.
Now we have Intel Core 2 Duo E6750 and would like to get Intel Core 2 Quad Q6600 to increase our system performance.
Also we have other choice, get Intel Xeon E5405 Harpertown 2.0GHz
to replace two above.
I think it is better to have one server box because one box easy to manage than two. Also Harpertown is much faster than these two together.
What is your opinion?
View 11 Replies
View Related
Apr 23, 2009
I have currently a server with a "Intel Core 2 duo e6640 2.4Ghz".
Now the company I'm at moving to a new data center and offering me a box for the same price with a Intel P3.4.
As I understand I would move from a two core to a single core CPU.
In the first move letter they send me, they where saying I would get a CPU plus, plus 1 GB mem more.
View 9 Replies
View Related
Oct 9, 2006
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.)
View 5 Replies
View Related
Mar 29, 2007
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.
View 3 Replies
View Related
May 19, 2009
from the title, which one is better for a server?
View 14 Replies
View Related
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
Mar 21, 2007
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.
View 4 Replies
View Related
Oct 29, 2009
does anyone know about a windows web host with postgresql database (possibly running 8.4) and .net 3.5 ?
View 4 Replies
View Related
May 26, 2008
I just bought a VPS to do some testing on.
I have cPanel installed, and I did the "/scripts/installpostgres" and the config/password in WHM.
Now when I login to a cPanel account, and create a user or database, it just simply doesn't show up on the page.
View 2 Replies
View Related
Feb 19, 2007
i'm having isues with postgresql, 1 on 2 times i get this error:
Fatal error: Uncaught exception 'Exception' with message 'Unable to connect to database on localhost' in /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php:96 Stack trace: #0 /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php(321): AbstractDb->connect(NULL) #1 /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/Server.php(227): AbstractDb->execSqlUniqueRes('SELECT server_i...', NULL, false, true) #2 /home/lavals/public_html/auth1/wifidog-auth/wifidog/include/common.php(107): Server::getCurrentServer(true) #3 /home/lavals/public_html/auth1/wifidog-auth/wifidog/index.php(52): require_once('/home/lavals/pu...') #4 {main} thrown in /home/lavals/public_html/auth1/wifidog-auth/wifidog/classes/AbstractDb.php on line 96
the people of wifidog auth server told me to check Ulimit -a and to set it up a bit
but what should i change, here is my curent ulimit -a:
Code:
[/root]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 1000
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
what should i boost?
i'm using a VPS with 256Ram, 1meg burst, cpanel,virtuozzo
View 13 Replies
View Related
Feb 12, 2007
i have a domain running a Wifi auth server, my problem is that i find it very slow when i try to connect to the site.
i know i'm using postgreSQL 7.4, is there a way to speed up the connection?
maybe tweak Postgresql or something,i'm new to this database system.
the link is [url]
i'm running this on a VPS with 256Ram, 1024 burst, cpanel, virtuozzo, OPTERON 246
View 5 Replies
View Related
Jul 18, 2007
When I try add data I got this error
INSERT INTO night_prices (id_prices, id_data, id_services, price_oldi, price_weekend, type_prices) VALUES (DEFAULT, 8, 18, '33', '12', 2)
[nativecode=ERROR: permission denied for sequence night_prices_id_prices_seq]
How to fix that?
I have root access.
View 1 Replies
View Related
Dec 3, 2008
I would like to install a tomcat application on my domain. Where do I upload the .war file and how can I manage the tomcat and access this application? I have root access to my Cpanel/WHM box. Also, I did apply a servlet already via WHM.
Also, I need to restore my postgres backup file as well but its too big to be done via pgmyadmin. How can I go about doing this via command line?
I'm aware of how to restore a mysql db via command line (1st create db in cpanel, 2nd run command in ssh). Never done so with a postgresql database.
View 2 Replies
View Related
Apr 30, 2009
I am looking for a webhost with a package that supports both ASP.NET *and* Postgres. So far, I have been able to find ones that support one but not the other.
View 8 Replies
View Related
Oct 18, 2007
for running PostgreSQL on a VPS,
Take a look what moderator of MySource Matrix forums says (enterprise-CMS based on PHP4+pgSQL):
Quote:
Yes, installing onto a virtual server is great, because its like you have an entire server to yourself. However, running PostgreSQL in a VM is not recommended for performance reasons. Obviously this isn't a concern on low-traffic sites. The ultimate solution would be a virtual server for Apache/PHP/MySource Matrix and a dedicated server for PostgreSQL. Though, I don't know of any virtual server providers that also provide dedicated database server access.
(...)
The problem with PostgreSQL (or any database) under virtualisation is that there is no IO prioritization given. So, the database just waits along with everything else for the hypervisor to deliver IO, with no consideration for priorities. This leads to a performance hit of about 70-80%. In testing, we've seen PostgreSQL under VMware ESX/GSX perform horribly, even with fibre-attached SAN storage. Though, sticking PostgreSQL on a Xen DomU seems better. The sysadmins have done some testing on this too.
If you run PostgreSQL across multiple virtual servers on the same hardware, you're just compounding the IO bottlenecks, so I can't recommend it at all.
Source: forums.matrix.squiz.net/index.php?showtopic=3929&st=15&start=15
Can anyone comment and share thoughts on using PostgreSQL on private virtual server?
View 3 Replies
View Related
Feb 5, 2007
way to upgrade postgresql 7.4 to 8.1, i heard that V8 is less consuming
View 6 Replies
View Related
Feb 7, 2007
i cant find Postgresql log file
can any1 tell where to find it (v. 7.3)
i have cpanel,virtuozzo installed
View 6 Replies
View Related
Nov 18, 2008
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.
View 11 Replies
View Related
May 29, 2007
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?
View 9 Replies
View Related
Jan 9, 2008
Transferred a domain from one cpanel server to another using whm > copy account feature, but now this error arises
---------------
pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: database "udre" does not exist
---------------
Found this in the copy accounts log
Grabbing PostgreSQL databases............
could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
...............
Done
Grabbing PostgreSQL privileges...could not change directory to "/root"
could not change directory to "/root"
could not change directory to "/root"
View 4 Replies
View Related
Mar 15, 2007
I need to create a postgresql database in latin1 encoding with database name "db" and owner "tobe" and the password I select.
I am using PG v8.x and on cpanel box.
Please kindly list simple, straightforward step by step instructions for ssh method. I've done this a long time ago, can't remember how though.
The db is already created too, just need to convert from utf8 to latin1
I tried this:
-bash-3.00$ createdb --encoding='LATIN1' db
CREATE DATABASE
However, how do I change owner to "tobe"
I see two, one owned by root and other was created by user tobe
-bash-3.00$ psql -l
List of databases
Name | Owner | Encoding
-----------+----------+----------
db | postgres | LATIN1
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
tobe_db | tobe | UTF8
(5 rows)
View 6 Replies
View Related
Dec 21, 2007
The postgresql not start on my server. Use REDHAT Enterprise 4, I tried to install the command:
/scripts /installpostgres
But I returned the following error:
[root@s2 backups]# /scripts/installpostgres
This script will install Postgres 7.3.x or later
If you have an older version installed you wil need to
Dump your databases to a file and then restore them
after the install as 7.3.x is not backwards compatible.
If you do not have any databases, you can just run:
mv /var/lib/pgsql /var/lib/pgsql.old
/sbin/service postgresql stop
/sbin/service postgresql start
to force creating a 7.3.x style setup. Do not do this if
you have databases that you wish to keep!
Are you sure you wish to proceed? y
Fetching Obsoletes list for channel: rhel-i386-es-4...
Fetching rpm headers...
Name Version Rel
----------------------------------------------------------
The following packages you requested were not found:
rh-postgresql
rh-postgresql-devel
rh-postgresql-libs
rh-postgresql-server
The following packages you requested are already updated:
postgresql-libs
postgresql-server
postgresql
postgresql-devel
Stopping postgresql service: [FAILED]
postmaster: no process killed
postmaster: no process killed
Starting postgresql service: [FAILED]
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
View 3 Replies
View Related
