Re: Load Balancing/Multiple Postgres Machines
От | Joshua D. Drake |
---|---|
Тема | Re: Load Balancing/Multiple Postgres Machines |
Дата | |
Msg-id | 41ACE9FF.5090605@commandprompt.com обсуждение исходный текст |
Ответ на | Load Balancing/Multiple Postgres Machines (Adile Abbadi <adile@minitdrugs.com>) |
Список | pgsql-admin |
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:jd@commandprompt.com] > Sent: November 29, 2004 12:30 PM > To: Adile Abbadi > Cc: pgsql-admin@postgresql.org > 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 - jd@commandprompt.com - 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 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
Вложения
В списке pgsql-admin по дате отправления: