Nice! thanks for that one. On Fri, Sep 4, 2009 at 10:59 PM, Continuation <selforgani...@gmail.com>wrote:
> > MySQL has better replication support. > > MySQL has built-in replication based on log shipping. > > Postgresql doesn't have built in replication. You have to use external > tools. From > http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL#PostgreSQL_Replication_Weakness > : > > "Slony-I, the most widely used PostgreSQL replication tool, is > inherently inferior to MySQL's built in replication for a number of > reasons. First, it uses SQL and triggers to replicate the data across > servers. This is considerably slower than MySQL's binary log shipping > and makes the communication costs much higher. Second, Slony-I's > communication costs grow quadratically in relation to the number of > servers in the replication pool (Order(n^2)). This makes it inherently > unusable for larger clusters. If we conservatively figure that Slony- > I's SQL/trigger method takes twice as much communication as MySQL's > binary log shipping, we can easily see how poorly this would work for > larger clusters in the real world. > > With two servers: MySQL: 2 = 2 PostgreSQL: 2*2^2 = 8 > > With 4 servers: MySQL: 4 = 4 PostgreSQL: 2*4^2 = 32 > > With 12 servers: MySQL: 12 = 12 PostgreSQL: 2*12^2 = 288. > > > > On Sep 4, 4:29 pm, Joshua Russo <josh.r.ru...@gmail.com> wrote: > > I personally don't have any experience with PostgreSQL and I'm generally > > working in a mixed MS and Linux environment. I'm interested to hear > peoples > > views on the pluses and minuses of the two different systems. I'm a bit > of a > > query geek too. How does that play in? I know in MySQL there are > limitations > > on where you can use subqueries. Is that true with PostgreSQL? (Ya I > could > > just look that one up but it's just an example.) > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
