pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedpostgresql 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>
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 19:08 Josh Berkus <josh@agliodbs.com>
parent: enediel <enediel@com.ith.tur.cu>
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 21:14 Ron Johnson <ron.l.johnson@cox.net>
parent: enediel <enediel@com.ith.tur.cu>
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
* Re: Fw: postgresql in cluster of servers
@ 2003-01-08 23:38 Ron Johnson <ron.l.johnson@cox.net>
parent: enediel <enediel@com.ith.tur.cu>
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
* Fw: postgresql in cluster of servers
@ 2003-01-09 01:49 enediel <enediel@com.ith.tur.cu>
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 16:22 pginfo <pginfo@t1.unisoftbg.com>
parent: enediel <enediel@com.ith.tur.cu>
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
* Re: Fw: Fw: postgresql in cluster of servers
@ 2003-01-09 20:18 scott.marlowe <scott.marlowe@ihs.com>
parent: enediel <enediel@com.ith.tur.cu>
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: postgresql in cluster of servers
@ 2003-01-09 20:41 enediel <enediel@com.ith.tur.cu>
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
* 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