Adile Abbadi wrote:
Thank you very Joshua for your help - Glad to hear my hardware should be
able to handle my needs and there is something out there. Do you know of any
documentation or online help that I could refer on the apps listed below?
Also are they separate apps that are to be installed and configured outside
postgres or are they included with the postgres build?
Slony: www.slony.info
Mammoth Replicator: www.commandprompt.com
PgPool: http://www2b.biglobe.ne.jp/~caco/pgpool/index-e.html
Cheers
Adile
-----Original Message-----
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: November 29, 2004 12:30 PM
To: Adile Abbadi
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Load Balancing/Multiple Postgres Machines
Adile Abbadi wrote:
Hi all,
Not sure if this has been asked before - it probably has been - but I
figure
its probably just easier if I ask so my question is this:
How easy is it - or rather is it possible to create multiple instances of
the same db on multiple machines?
We are currently running a very highly used postgres db (Ver 7.2) that
eats
up a lot of cpu time when its heavily used. We recently bought some very
powerful equipment to accommodate this high use, (currently its on a
single
CPU, 1GB of Ram SCSI server - upgraded to a dual CPU, 4GB of ram SCSI
server) but my fear is over time this issue is going to haunt me again and
hardware can only be upgraded so much.
Well you have a very long way to go before you get to that "too much" stage.
Within your current platform it should be possible to upgrade to 8GB of
ram and you can almost always add more hard drives.
So is it possible to do some level of load balancing in postgres - I would
love a situation where I could have multiple machines running multiple
instances of the same db (that are all synced in real-time), where there
is
some smart level of load balancing happening.
You may want to look at pgpool, slony or Mammoth Replicator.
So if it is possible is there some instruction info out there to help me
along my way. Any help or insight would be greatly appreciated.
Sincerely,
Joshua D. Drake
All the best
Adile
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/04
--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/04
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/04
--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
