Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-09-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/01/07 08:12, chris smith wrote: >> Ever read anything on how myspace is laid out? The big ones need >> replication to handle the traffic. > > Actually no. > > http://highscalability.com/livejournal-architecture > > "Using MySQL replication on

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-09-01 Thread Bill Moran
"chris smith" <[EMAIL PROTECTED]> wrote: > > > Ever read anything on how myspace is laid out? The big ones need > > replication to handle the traffic. > > Actually no. > > http://highscalability.com/livejournal-architecture > > "Using MySQL replication only takes you so far." (Yeh it's mysql bu

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-09-01 Thread chris smith
> Ever read anything on how myspace is laid out? The big ones need > replication to handle the traffic. Actually no. http://highscalability.com/livejournal-architecture "Using MySQL replication only takes you so far." (Yeh it's mysql but the point is valid regardless). "You can't keep adding re

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-09-01 Thread Bill Moran
Markus Schiltknecht <[EMAIL PROTECTED]> wrote: > > Hi, > > Bill Moran wrote: > > While true, I feel those applications are the exception, not the rule. > > Most DBs these days are the blogs and the image galleries, etc. And > > those don't need or want the overhead associated with synchronous > >

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-29 Thread Trent Shipley
On Monday 2007-08-27 08:04, Andrew Sullivan wrote: > On Sat, Aug 25, 2007 at 11:13:45AM -0400, Tom Lane wrote: > > In case you hadn't noticed the disconnect between these statements: > > if they have to be that close together, there *will* be a single point > > of failure. Fire in your data center

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-28 Thread Markus Schiltknecht
Hi, Bill Moran wrote: While true, I feel those applications are the exception, not the rule. Most DBs these days are the blogs and the image galleries, etc. And those don't need or want the overhead associated with synchronous replication. Uhm.. do blogs and image galleries need replication a

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-28 Thread Bill Moran
In response to Markus Schiltknecht <[EMAIL PROTECTED]>: > Hi, > > Bill Moran wrote: > > First off, "clustering" is a word that is too vague to be useful, so > > I'll stop using it. There's multi-master replication, where every > > database is read-write, then there's master-slave replication, wh

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-28 Thread Markus Schiltknecht
Hi, Bill Moran wrote: First off, "clustering" is a word that is too vague to be useful, so I'll stop using it. There's multi-master replication, where every database is read-write, then there's master-slave replication, where only one server is read-write and the rest are read-only. You can ad

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-27 Thread Philip Hallstrom
Bill Moran <[EMAIL PROTECTED]> writes: First off, "clustering" is a word that is too vague to be useful, so I'll stop using it. Right. MySQL Cluster, on the other hand, is a very specific technology. http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html It is, however, capable of being d*

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-27 Thread Vivek Khera
On Aug 27, 2007, at 11:04 AM, Andrew Sullivan wrote: It was a way to scale many small systems for certain kinds of workloads. My impression is that in most cases, it's a SQL-ish solution to a problem where someone decided to use the SQL nail because that's the hammer they had. I can think of

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-27 Thread Andrew Sullivan
On Sat, Aug 25, 2007 at 11:13:45AM -0400, Tom Lane wrote: > In case you hadn't noticed the disconnect between these statements: > if they have to be that close together, there *will* be a single point > of failure. Fire in your data center, for instance, will take out every > copy of your data. S

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-27 Thread Vivek Khera
On Aug 25, 2007, at 8:12 AM, Phoenix Kiula wrote: The sentence that caught my attention is "Nokia, Alcatel and Nortel are all building real-time network nodes on top of MySQL Cluster." My experiences with MySQL so far have been less than exhilerating (only tried it for our web stuff, which is

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-26 Thread David Fetter
On Sat, Aug 25, 2007 at 10:18:25AM -0400, Bill Moran wrote: > "Phoenix Kiula" <[EMAIL PROTECTED]> wrote: > > > > We're moving from MySQL to PG, a move I am rather enjoying, but > > we're currently running both databases. As we web-enable our > > financial services in fifteen countries, I would like

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-25 Thread Shane Ambler
Bill Moran wrote: BTW: does anyone know of a link that describes these high-level concepts? If not, I think I'll write this up formally and post it. Chapter 24 - http://www.postgresql.org/docs/8.2/interactive/high-availability.html is a recent addition to the manual that starts to explain mo

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-25 Thread Tom Lane
Bill Moran <[EMAIL PROTECTED]> writes: > First off, "clustering" is a word that is too vague to be useful, so > I'll stop using it. Right. MySQL Cluster, on the other hand, is a very specific technology. http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html It's interesting but far from an a

Re: [GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-25 Thread Bill Moran
"Phoenix Kiula" <[EMAIL PROTECTED]> wrote: > > We're moving from MySQL to PG, a move I am rather enjoying, but we're > currently running both databases. As we web-enable our financial > services in fifteen countries, I would like to recommend the team that > we move entirely to PG. > > In doing re

[GENERAL] Bigtime scaling of Postgresql (cluster and stuff I suppose)

2007-08-25 Thread Phoenix Kiula
We're moving from MySQL to PG, a move I am rather enjoying, but we're currently running both databases. As we web-enable our financial services in fifteen countries, I would like to recommend the team that we move entirely to PG. In doing research on big installations of the two databases, I read