Skip site navigation (1) Skip section navigation (2)

Question on Load balancing

From: "Net Tree Inc(dot)" <nettreeinc(at)gmail(dot)com>
To: PostgreSQL Novice Post <pgsql-novice(at)postgresql(dot)org>, PostgreSQL Post <pgsql-docs(at)postgresql(dot)org>, Slony Post <slony1-general(at)lists(dot)slony(dot)info>
Subject: Question on Load balancing
Date: 2009-07-23 06:36:13
Message-ID: bd9689740907222336s7d29b9f5vcc41db20b143f10f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-novice
Hello,
I am having a concept question about how the Read/Write process transaction
works within the DB network structure.
Assume I have an environment of one master DB with three slaves running
Slony-I replication server.
As you all know Slony is a Single master to multiple slaves replication
system supporting cascading and slave promotion. Master DB can do both read
and write, but the slaves can only do read and for reporting purpose.

Here is the question of concept that I don't understand, if you have answer
or provide me a link to referral is appreciated.

Q: For application Developer write codes to accessing the DB server to
getting/modify datas. Since there is only one server that can handle both
Read/Write which is the Master and slave is only to retrive data.
How should the developer know which DB server should they connecting
to for either to read or to write? If developer is using the same fixed
connection strings to a fix IP to Master server for Read/Write and another
connection string to a fix IP to (for example) my SLAVE1 server to retrive
datas.
How and what would happen if my SLAVE1 failed or due to maintaince that I
need to replace it?

Also what would happen for Master DB if issues such as failover or switch
over that I need to replacing the master server due to failure or
for maintaince, or to promote one of the slave to master?

I just need answer that tells me how PostgreSQL and Slony would react if
such issues happens. Answer can simply just to provide me a web link for me
to read further. Thanks!

Responses

pgsql-novice by date

Next:From: Net Tree Inc.Date: 2009-07-23 06:44:13
Subject: Load Balance
Previous:From: Michael WoodDate: 2009-07-22 07:17:17
Subject: Re: STARTING SERIAL / BIGSERIAL FIELDS FROM 1.

pgsql-docs by date

Next:From: Christopher BrowneDate: 2009-07-23 15:44:13
Subject: Re: [Slony1-general] Question on Load balancing
Previous:From: Peter EisentrautDate: 2009-07-22 18:08:54
Subject: Re: Tiny typo in the 8.4 docs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group