pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgresql in cluster of servers
9+ messages / 5 participants
[nested] [flat]

* postgresql in cluster of servers
@ 2003-01-08 17:18 enediel <enediel@com.ith.tur.cu>
  2003-01-08 19:08 ` Re: postgresql in cluster of servers Josh Berkus <josh@agliodbs.com>
  2003-01-08 21:14 ` Re: postgresql in cluster of servers Ron Johnson <ron.l.johnson@cox.net>
  0 siblings, 2 replies; 9+ messages in thread

From: enediel @ 2003-01-08 17:18 UTC (permalink / raw)
  To: pgsql-performance

Hello to all list members:

I'm looking for information about using postgresql in a cluster of servers
where all real servers share a unique databases location outside them.

The question could be one of the follows?

?Is the prostgresql prepared to synchronize simultaneous accesses to oneself
database among processes that  run in different PC's?

or

?Was the postgresql database designed to allow simultaneous acceses of
processes that run in different PC's allowing for own design the
sincronizationof all the processes?


Thanks in advance for the attention
Enediel
Linux user 300141

Happy who can penetrate the secret causes of the things
¡Use Linux!




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: postgresql in cluster of servers
  2003-01-08 17:18 postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>
@ 2003-01-08 19:08 ` Josh Berkus <josh@agliodbs.com>
  1 sibling, 0 replies; 9+ messages in thread

From: Josh Berkus @ 2003-01-08 19:08 UTC (permalink / raw)
  To: enediel <enediel@com.ith.tur.cu>; pgsql-performance


Enediel,

> ?Was the postgresql database designed to allow simultaneous acceses of
> processes that run in different PC's allowing for own design the
> sincronizationof all the processes?

No, unless I'm really out of the loop. 

However, I believe that some/all of the commercial companies who offer 
PostgreSQL-based solutions offer extensions/versions of Postgres that do 
this.   I suggest that you contact:

PostgreSQL Inc.
Command Prompt Inc.
Red Hat (Red Hat Database)

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: postgresql in cluster of servers
  2003-01-08 17:18 postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>
@ 2003-01-08 21:14 ` Ron Johnson <ron.l.johnson@cox.net>
  1 sibling, 0 replies; 9+ messages in thread

From: Ron Johnson @ 2003-01-08 21:14 UTC (permalink / raw)
  To: pgsql-performance

On Wed, 2003-01-08 at 11:18, enediel wrote:
> Hello to all list members:
> 
> I'm looking for information about using postgresql in a cluster of servers
> where all real servers share a unique databases location outside them.
> 
> The question could be one of the follows?
> 
> ?Is the prostgresql prepared to synchronize simultaneous accesses to oneself
> database among processes that  run in different PC's?
> 
> or
> 
> ?Was the postgresql database designed to allow simultaneous acceses of
> processes that run in different PC's allowing for own design the
> sincronizationof all the processes?

To clarify: do you mean 

(1) multiple copies of *the*same*database* sitting on many machines, 
and all of them synchronizing themselves?

   OR

(2) multiple application server machines all hitting a single database
sitting on a single database server machine?

-- 
+------------------------------------------------------------+
| Ron Johnson, Jr.     mailto:ron.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson  |
|                                                            |
| "Basically, I got on the plane with a bomb. Basically, I   |
|  tried to ignite it. Basically, yeah, I intended to damage |
|  the plane."                                               |
|    RICHARD REID, who tried to blow up American Airlines    |
|                  Flight 63                                 |
+------------------------------------------------------------+




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Fw: postgresql in cluster of servers
@ 2003-01-09 01:49 enediel <enediel@com.ith.tur.cu>
  2003-01-08 23:38 ` Re: Fw: postgresql in cluster of servers Ron Johnson <ron.l.johnson@cox.net>
  2003-01-09 16:22 ` Re: Fw: postgresql in cluster of servers pginfo <pginfo@t1.unisoftbg.com>
  0 siblings, 2 replies; 9+ messages in thread

From: enediel @ 2003-01-09 01:49 UTC (permalink / raw)
  To: pgsql-performance

Thanks for all answers:
Ron Johnson, I mean the second option thet you wrote:

(2) multiple application server machines all hitting a single database
sitting on a single database server machine?

Greetings
Enediel
Linux user 300141

Happy who can penetrate the secret causes of the things
¡Use Linux!
----- Original Message -----
From: "Ron Johnson" <ron.l.johnson@cox.net>
To: "postgresql" <pgsql-performance@postgresql.org>
Sent: Wednesday, January 08, 2003 1:14 PM
Subject: Re: [PERFORM] postgresql in cluster of servers


> On Wed, 2003-01-08 at 11:18, enediel wrote:
> > Hello to all list members:
> >
> > I'm looking for information about using postgresql in a cluster of
servers
> > where all real servers share a unique databases location outside them.
> >
> > The question could be one of the follows?
> >
> > ?Is the prostgresql prepared to synchronize simultaneous accesses to
oneself
> > database among processes that  run in different PC's?
> >
> > or
> >
> > ?Was the postgresql database designed to allow simultaneous acceses of
> > processes that run in different PC's allowing for own design the
> > sincronizationof all the processes?
>
> To clarify: do you mean
>
> (1) multiple copies of *the*same*database* sitting on many machines,
> and all of them synchronizing themselves?
>
>    OR
>
> (2) multiple application server machines all hitting a single database
> sitting on a single database server machine?
>
> --
> +------------------------------------------------------------+
> | Ron Johnson, Jr.     mailto:ron.l.johnson@cox.net          |
> | Jefferson, LA  USA   http://members.cox.net/ron.l.johnson  |
> |                                                            |
> | "Basically, I got on the plane with a bomb. Basically, I   |
> |  tried to ignite it. Basically, yeah, I intended to damage |
> |  the plane."                                               |
> |    RICHARD REID, who tried to blow up American Airlines    |
> |                  Flight 63                                 |
> +------------------------------------------------------------+
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Fw: postgresql in cluster of servers
  2003-01-09 01:49 Fw: postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>
@ 2003-01-08 23:38 ` Ron Johnson <ron.l.johnson@cox.net>
  1 sibling, 0 replies; 9+ messages in thread

From: Ron Johnson @ 2003-01-08 23:38 UTC (permalink / raw)
  To: pgsql-performance

On Wed, 2003-01-08 at 19:49, enediel wrote:
> Thanks for all answers:
> Ron Johnson, I mean the second option thet you wrote:
> 
> (2) multiple application server machines all hitting a single database
> sitting on a single database server machine?

Ok, great.  To the PG server, the app servers are db clients, just like
any other client.  Multi-user access, arranged so that users don't step
over each other, is integrated deeply into the server.

Thus, PostgreSQL meets this qualification...

> Happy who can penetrate the secret causes of the things
> ¡Use Linux!
> ----- Original Message -----
> From: "Ron Johnson" <ron.l.johnson@cox.net>
> To: "postgresql" <pgsql-performance@postgresql.org>
> Sent: Wednesday, January 08, 2003 1:14 PM
> Subject: Re: [PERFORM] postgresql in cluster of servers
> 
> 
> > On Wed, 2003-01-08 at 11:18, enediel wrote:
> > > Hello to all list members:
> > >
> > > I'm looking for information about using postgresql in a cluster of
> servers
> > > where all real servers share a unique databases location outside them.
> > >
> > > The question could be one of the follows?
> > >
> > > ?Is the prostgresql prepared to synchronize simultaneous accesses to
> oneself
> > > database among processes that  run in different PC's?
> > >
> > > or
> > >
> > > ?Was the postgresql database designed to allow simultaneous acceses of
> > > processes that run in different PC's allowing for own design the
> > > sincronizationof all the processes?
> >
> > To clarify: do you mean
> >
> > (1) multiple copies of *the*same*database* sitting on many machines,
> > and all of them synchronizing themselves?
> >
> >    OR
> >
> > (2) multiple application server machines all hitting a single database
> > sitting on a single database server machine?

-- 
+------------------------------------------------------------+
| Ron Johnson, Jr.     mailto:ron.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson  |
|                                                            |
| "Basically, I got on the plane with a bomb. Basically, I   |
|  tried to ignite it. Basically, yeah, I intended to damage |
|  the plane."                                               |
|    RICHARD REID, who tried to blow up American Airlines    |
|                  Flight 63                                 |
+------------------------------------------------------------+




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Fw: postgresql in cluster of servers
  2003-01-09 01:49 Fw: postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>
@ 2003-01-09 16:22 ` pginfo <pginfo@t1.unisoftbg.com>
  1 sibling, 0 replies; 9+ messages in thread

From: pginfo @ 2003-01-09 16:22 UTC (permalink / raw)
  To: enediel <enediel@com.ith.tur.cu>; +Cc: pgsql-performance

Hi,

I think if we speak about single db server you will nead to ask
the app. server provider about clustering.

I am working with jboss and it is supporting clustering.


regards,
ivan.

enediel wrote:

> Thanks for all answers:
> Ron Johnson, I mean the second option thet you wrote:
>
> (2) multiple application server machines all hitting a single database
> sitting on a single database server machine?
>
> Greetings
> Enediel
> Linux user 300141
>
> Happy who can penetrate the secret causes of the things
> ¡Use Linux!
> ----- Original Message -----
> From: "Ron Johnson" <ron.l.johnson@cox.net>
> To: "postgresql" <pgsql-performance@postgresql.org>
> Sent: Wednesday, January 08, 2003 1:14 PM
> Subject: Re: [PERFORM] postgresql in cluster of servers
>
> > On Wed, 2003-01-08 at 11:18, enediel wrote:
> > > Hello to all list members:
> > >
> > > I'm looking for information about using postgresql in a cluster of
> servers
> > > where all real servers share a unique databases location outside them.
> > >
> > > The question could be one of the follows?
> > >
> > > ?Is the prostgresql prepared to synchronize simultaneous accesses to
> oneself
> > > database among processes that  run in different PC's?
> > >
> > > or
> > >
> > > ?Was the postgresql database designed to allow simultaneous acceses of
> > > processes that run in different PC's allowing for own design the
> > > sincronizationof all the processes?
> >
> > To clarify: do you mean
> >
> > (1) multiple copies of *the*same*database* sitting on many machines,
> > and all of them synchronizing themselves?
> >
> >    OR
> >
> > (2) multiple application server machines all hitting a single database
> > sitting on a single database server machine?
> >
> > --
> > +------------------------------------------------------------+
> > | Ron Johnson, Jr.     mailto:ron.l.johnson@cox.net          |
> > | Jefferson, LA  USA   http://members.cox.net/ron.l.johnson  |
> > |                                                            |
> > | "Basically, I got on the plane with a bomb. Basically, I   |
> > |  tried to ignite it. Basically, yeah, I intended to damage |
> > |  the plane."                                               |
> > |    RICHARD REID, who tried to blow up American Airlines    |
> > |                  Flight 63                                 |
> > +------------------------------------------------------------+
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Fw: Fw: postgresql in cluster of servers
@ 2003-01-09 20:41 enediel <enediel@com.ith.tur.cu>
  2003-01-09 20:18 ` Re: Fw: Fw: postgresql in cluster of servers scott.marlowe <scott.marlowe@ihs.com>
  0 siblings, 1 reply; 9+ messages in thread

From: enediel @ 2003-01-09 20:41 UTC (permalink / raw)
  To: pgsql-performance

No, pginfo,  suposse this example

Web server or cluster web server, it's unimportant
|
Postgresql cluster server containing{
    ...
    Real server 1    running postgresql processes
    Real server 2    running postgresql processes
    ....
}
|
File server machine that contains all pg_databases

Notice that the real servers don't have in their hard disk any database,
they could have a link to the hard disk in the File server machine.

The syncronization between postgresql processes that are running on
different machines and using the same database is my question.

Thanks for the answer

Greetings
Enediel
Linux user 300141

Happy who can penetrate the secret causes of the things
¡Use Linux!
----- Original Message -----
From: "pginfo" <pginfo@t1.unisoftbg.com>
To: "enediel" <enediel@com.ith.tur.cu>
Sent: Thursday, January 09, 2003 8:21 AM
Subject: Re: Fw: [PERFORM] postgresql in cluster of servers


> Hi,
>
> I think if we speak about single db server you will nead to ask
> the app. server provider about clustering.
>
> I am working with jboss and it is supporting clustering.
>
>
> regards,
> ivan.
>
> enediel wrote:
>
> > Thanks for all answers:
> > Ron Johnson, I mean the second option thet you wrote:
> >
> > (2) multiple application server machines all hitting a single database
> > sitting on a single database server machine?
> >
> > Greetings
> > Enediel
> > Linux user 300141
> >
> > Happy who can penetrate the secret causes of the things
> > ¡Use Linux!
> > ----- Original Message -----
> > From: "Ron Johnson" <ron.l.johnson@cox.net>
> > To: "postgresql" <pgsql-performance@postgresql.org>
> > Sent: Wednesday, January 08, 2003 1:14 PM
> > Subject: Re: [PERFORM] postgresql in cluster of servers
> >
> > > On Wed, 2003-01-08 at 11:18, enediel wrote:
> > > > Hello to all list members:
> > > >
> > > > I'm looking for information about using postgresql in a cluster of
> > servers
> > > > where all real servers share a unique databases location outside
them.
> > > >
> > > > The question could be one of the follows?
> > > >
> > > > ?Is the prostgresql prepared to synchronize simultaneous accesses to
> > oneself
> > > > database among processes that  run in different PC's?
> > > >
> > > > or
> > > >
> > > > ?Was the postgresql database designed to allow simultaneous acceses
of
> > > > processes that run in different PC's allowing for own design the
> > > > sincronizationof all the processes?
> > >
> > > To clarify: do you mean
> > >
> > > (1) multiple copies of *the*same*database* sitting on many machines,
> > > and all of them synchronizing themselves?
> > >
> > >    OR
> > >
> > > (2) multiple application server machines all hitting a single database
> > > sitting on a single database server machine?
> > >
> > > --
> > > +------------------------------------------------------------+
> > > | Ron Johnson, Jr.     mailto:ron.l.johnson@cox.net          |
> > > | Jefferson, LA  USA   http://members.cox.net/ron.l.johnson  |
> > > |                                                            |
> > > | "Basically, I got on the plane with a bomb. Basically, I   |
> > > |  tried to ignite it. Basically, yeah, I intended to damage |
> > > |  the plane."                                               |
> > > |    RICHARD REID, who tried to blow up American Airlines    |
> > > |                  Flight 63                                 |
> > > +------------------------------------------------------------+
> > >
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
> > >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Fw: Fw: postgresql in cluster of servers
  2003-01-09 20:41 Fw: Fw: postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>
@ 2003-01-09 20:18 ` scott.marlowe <scott.marlowe@ihs.com>
  0 siblings, 0 replies; 9+ messages in thread

From: scott.marlowe @ 2003-01-09 20:18 UTC (permalink / raw)
  To: enediel <enediel@com.ith.tur.cu>; +Cc: pgsql-performance

On Thu, 9 Jan 2003, enediel wrote:

> No, pginfo,  suposse this example
> 
> Web server or cluster web server, it's unimportant
> |
> Postgresql cluster server containing{
>     ...
>     Real server 1    running postgresql processes
>     Real server 2    running postgresql processes
>     ....
> }
> |
> File server machine that contains all pg_databases
> 
> Notice that the real servers don't have in their hard disk any database,
> they could have a link to the hard disk in the File server machine.

Postgresql cannot currently work this way.  

It uses shared memory on a single image OS to maintain the database 
coherently.  when you cluster Postgresql across multiple machines, 
currently you have to have two seperate and independant instances which 
are synchronized by an external process of some sort.

since I/O is usually the single limiting factor, your suggested system 
would likely be no faster than a single box with decent memory and CPUs in 
it.




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Fw: Fw: Fw: postgresql in cluster of servers
@ 2003-01-10 00:35 enediel <enediel@com.ith.tur.cu>
  0 siblings, 0 replies; 9+ messages in thread

From: enediel @ 2003-01-10 00:35 UTC (permalink / raw)
  To: pgsql-performance

Thanks for the answer scott.marlowe
I'm agree with you about the limit of the I/O operations with this
configuration.

I'm just looking for a fault tolerance configuration in the databases
server, considering a very large databases, and a lot of users accesing to
them.

I'll accept with pleasure any suggestions about this topic.

Greetings
Enediel
Linux user 300141

Happy who can penetrate the secret causes of the things
¡Use Linux!




^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2003-01-10 00:35 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-08 17:18 postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>
2003-01-08 19:08 ` Josh Berkus <josh@agliodbs.com>
2003-01-08 21:14 ` Ron Johnson <ron.l.johnson@cox.net>
2003-01-09 01:49 Fw: postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>
2003-01-08 23:38 ` Ron Johnson <ron.l.johnson@cox.net>
2003-01-09 16:22 ` pginfo <pginfo@t1.unisoftbg.com>
2003-01-09 20:41 Fw: Fw: postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>
2003-01-09 20:18 ` scott.marlowe <scott.marlowe@ihs.com>
2003-01-10 00:35 Fw: Fw: Fw: postgresql in cluster of servers enediel <enediel@com.ith.tur.cu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox