From christopherl_smith@yahoo.com Mon Nov 28 08:44:42 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A6D4A9DCB91 for ; Mon, 28 Nov 2005 04:44:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47524-03-5 for ; Mon, 28 Nov 2005 04:44:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id 3EFB99DCBD5 for ; Mon, 28 Nov 2005 04:44:36 -0400 (AST) Received: from web33106.mail.mud.yahoo.com (web33106.mail.mud.yahoo.com [68.142.206.87]) by svr2.postgresql.org (Postfix) with SMTP id 44716F0C35 for ; Mon, 28 Nov 2005 03:02:39 +0000 (GMT) Received: (qmail 26143 invoked by uid 60001); 28 Nov 2005 03:02:39 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=FsNkMc6paIsXGUwSMuDoLXEZmuQbZDHylRk5/Bf57FuiVP61uq1FlwuYMnHboCXv6YbWrCjAUPZo1ujODWU5/vJmH4ar9Ok4Ns5/bH9cw8/dSkdNGKi+55cd36jsBCjtvfas126u0PZ3HAC2NF7hVrYZKlzZKsiQaLGt5CpaOJE= ; Message-ID: <20051128030239.26141.qmail@web33106.mail.mud.yahoo.com> Received: from [12.43.23.89] by web33106.mail.mud.yahoo.com via HTTP; Sun, 27 Nov 2005 19:02:38 PST Date: Sun, 27 Nov 2005 19:02:38 -0800 (PST) From: Christopher Smith Subject: Postgresql Replication High Availability To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1038678060-1133146958=:25402" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.48 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, HTML_MESSAGE=0.001] X-Spam-Score: 0.48 X-Spam-Level: X-Archive-Number: 200511/319 X-Sequence-Number: 19692 --0-1038678060-1133146958=:25402 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I am currently looking into high availability solutions for Postgresql. I am designing system that should not have a single point of failure. I would like to at run-time Add new hardware and add them to my (cluster ) environment without shutting anything down. Please advise, Thanks #1. Is PGCluster production environment ready? #2. CJDBC.... has anyone used this in production environment with Postgresql? #3. Any other solutions viable for production environments? --------------------------------- Yahoo! Music Unlimited - Access over 1 million songs. Try it free. --0-1038678060-1133146958=:25402 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
I am currently looking into high availability solutions for Postgresql. 
 
I am designing system that should not have a single point of failure.  I would like to at
 
run-time Add new hardware and add them to my (cluster ) environment without shutting anything down.
 
Please advise, Thanks
 
 
#1. Is PGCluster production environment ready?
 
 
#2. CJDBC.... has anyone used this in production environment with Postgresql?
 
 
#3. Any other solutions viable for production environments?


Yahoo! Music Unlimited - Access over 1 million songs. Try it free. --0-1038678060-1133146958=:25402-- From rodrigo.hjort@gmail.com Sat Dec 3 03:32:19 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id EF1D79DCAD7 for ; Fri, 2 Dec 2005 23:32:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72789-05 for ; Fri, 2 Dec 2005 23:32:13 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by postgresql.org (Postfix) with ESMTP id C61A29DD896 for ; Fri, 2 Dec 2005 23:32:15 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 55so836156wri for ; Fri, 02 Dec 2005 19:32:20 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=rZuD1RxQx4VQ7wksN7gG49QFqx/+MmW5M4Ki8i8KRhh9pAhMrtpHYBulpy+gNe5fHOt95PpVvjnCrM6KMDWu3B2VZ2G4CipBcdAAAlvSD6RR7Jx5dAh8xKRGoDpcpO7lD0Zz7pEyi4X0OOzmVKZtBtUoVKF2iE5giZYtJ4iLVmc= Received: by 10.65.11.4 with SMTP id o4mr1933942qbi; Fri, 02 Dec 2005 19:32:20 -0800 (PST) Received: by 10.64.153.16 with HTTP; Fri, 2 Dec 2005 19:32:20 -0800 (PST) Message-ID: <731083980512021932v7b3236cdg@mail.gmail.com> Date: Sat, 3 Dec 2005 01:32:20 -0200 From: Rodrigo Hjort To: pgsql-admin@postgresql.org Subject: Re: Postgresql Replication High Availability MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.322 required=5 tests=[AWL=0.322] X-Spam-Score: 0.322 X-Spam-Level: X-Archive-Number: 200512/22 X-Sequence-Number: 19742 We're on the same situation. --> PGCluster Actualy, we installed and tested PGCluster on UML (User Mode Linux) environment and real distributed stations. There were a lot of critical issues on it! For example, once a user tries to connect to an unexisting database, the load balancer fails and needs to be restarted... Another: if closed by Ctrl+C, the postmaster starts in an infinite loop! We sent these problems to its User List, and we noted that there are other unsolved issues and a lot of patches not officially posted yet... One thing that made us afraid is that the project isn't updated since march of 2005! http://pgcluster.projects.postgresql.org/ Too much risky to our critical mission database, we thought! --> ClusGres This application should be very promisor, if it weren't "vaporware"... http://www.linuxlabs.com/clusgres.html --> C-JDBC / Sequoia It looks like we're gonna stay with this solution, as I explained on a later e-mail. http://c-jdbc.objectweb.org/ http://sequoia.continuent.org/ ------ Christopher wrote: I am currently looking into high availability solutions for Postgresql. I am designing system that should not have a single point of failure.=20 I would like to at run-time Add new hardware and add them to my (cluster ) environment without shutting anything down. Please advise, Thanks #1. Is PGCluster production environment ready? #2. CJDBC.... has anyone used this in production environment with Postgresq= l? #3. Any other solutions viable for production environments? ------ Regards, Rodrigo Hjort Linux User #348191 (http://counter.li.org) From brendan@clickspace.com Sat Dec 3 22:46:23 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D10A19DCC00 for ; Sat, 3 Dec 2005 18:46:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99974-08 for ; Sat, 3 Dec 2005 18:46:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cobalt.clickspace.com (mail.clickspace.com [65.110.166.234]) by postgresql.org (Postfix) with ESMTP id C2A0D9DCA94 for ; Sat, 3 Dec 2005 18:46:20 -0400 (AST) Received: from [10.0.1.3] (S0106000d93022b5d.cg.shawcable.net [68.147.204.179]) by cobalt.clickspace.com (8.10.2/8.10.2) with ESMTP id jB3MkJK11241; Sat, 3 Dec 2005 15:46:19 -0700 In-Reply-To: <731083980512021932v7b3236cdg@mail.gmail.com> References: <731083980512021932v7b3236cdg@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-2-723973395; protocol="application/pkcs7-signature" Message-Id: <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com> Cc: pgsql-admin@postgresql.org From: Brendan Duddridge Subject: Re: Postgresql Replication High Availability Date: Sat, 3 Dec 2005 15:46:35 -0700 To: Rodrigo Hjort X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/25 X-Sequence-Number: 19745 --Apple-Mail-2-723973395 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Hello Rodrigo, Have you (or anyone else on this list) had great success with Sequoia? I've been reading a bit about it. It looks like it might work for us for a high-availability solution. Do you think it's just as good as using p/cluster? We're deploying to Mac OS X Server and it looks like p/cluster only supports Linux on x86. Thanks, ____________________________________________________________________ Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Dec 2, 2005, at 8:32 PM, Rodrigo Hjort wrote: > We're on the same situation. > > --> PGCluster > > Actualy, we installed and tested PGCluster on UML (User Mode Linux) > environment and real distributed stations. There were a lot of > critical issues on it! For example, once a user tries to connect to an > unexisting database, the load balancer fails and needs to be > restarted... Another: if closed by Ctrl+C, the postmaster starts in an > infinite loop! We sent these problems to its User List, and we noted > that there are other unsolved issues and a lot of patches not > officially posted yet... > > One thing that made us afraid is that the project isn't updated since > march of 2005! > http://pgcluster.projects.postgresql.org/ > > Too much risky to our critical mission database, we thought! > > --> ClusGres > > This application should be very promisor, if it weren't "vaporware"... > http://www.linuxlabs.com/clusgres.html > > --> C-JDBC / Sequoia > > It looks like we're gonna stay with this solution, as I explained on a > later e-mail. > > http://c-jdbc.objectweb.org/ > http://sequoia.continuent.org/ > > ------ > > Christopher wrote: > > I am currently looking into high availability solutions for > Postgresql. > > I am designing system that should not have a single point of failure. > I would like to at > run-time Add new hardware and add them to my (cluster ) environment > without shutting anything down. > > Please advise, Thanks > > #1. Is PGCluster production environment ready? > #2. CJDBC.... has anyone used this in production environment with > Postgresql? > #3. Any other solutions viable for production environments? > > ------ > > Regards, > > Rodrigo Hjort > > Linux User #348191 (http://counter.li.org) > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > --Apple-Mail-2-723973395 Content-Transfer-Encoding: base64 Content-Type: application/pkcs7-signature; name=smime.p7s Content-Disposition: attachment; filename=smime.p7s MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGIDCCAtkw ggJCoAMCAQICAw84ujANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3VpbmcgQ0EwHhcNMDUwNzI5MjAxMTQzWhcNMDYwNzI5MjAxMTQzWjBIMR8wHQYDVQQD ExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSUwIwYJKoZIhvcNAQkBFhZicmVuZGFuQGNsaWNrc3Bh Y2UuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAqWfMCdFgKzXroGNqJuU3eyDC K/Gxts3mtmIdgcHGmUjRKdlBSfkmcCBUDPJIt4QQc91sY3h8Itg0EAsF+1yFECU6afn/1SEAHSDK 6Q86PclF58/Dux2FYNGpeIAw/lisZ2UCyIYoUiWtEDKCBq5jDuYzcGkFS5Csz+/rEL+BHTXQVqnS nUdUaXu9xdZn4wgjB/n65UEYRqr0LGN53CGsFcA9uC+ViS7WyBtzJcP02LMNT+cAZ7TKHw4Q/ZeG 5ptPgQHLTD2wza3GMbPQ4fYK6aNPA+lVzslLSCjyQpg55gVyQQlV0k/5zU5Q5m48ZtqwOqN+fPYd eIB7H5y1SFLd/wIDAQABozMwMTAhBgNVHREEGjAYgRZicmVuZGFuQGNsaWNrc3BhY2UuY29tMAwG A1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAT+6hGvStHoRO0OCHlJev31BpUlvPSpbYVKJN i5kCMF164sSX7j0IRvcyU6DfUuW7samTluXJbANyuX1ZIpXulGen5EEc2NV7eU/rMz6ExklMShTh ++azcvmMjOzTuqXi3ZsIjwzBBhqCB0U++kYlMlHEYla2qKLFbXY6PiH0a8swggM/MIICqKADAgEC AgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBl MRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQL Ex9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29u YWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5j b20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UE ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFs IEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftO ucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9x VsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAe ZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJo dHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8E BAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3 DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9 reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAa WzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIC5zCCAuMCAQEwaTBiMQswCQYDVQQGEwJaQTElMCMG A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw84ujAJBgUrDgMCGgUAoIIBUzAYBgkqhkiG9w0BCQMx CwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNTEyMDMyMjQ2MzZaMCMGCSqGSIb3DQEJBDEW BBRxZa7FyJkehUTEipbvnFyZnIeAHDB4BgkrBgEEAYI3EAQxazBpMGIxCzAJBgNVBAYTAlpBMSUw IwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDzi6MHoGCyqGSIb3DQEJEAILMWugaTBiMQswCQYD VQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMj VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw84ujANBgkqhkiG9w0BAQEFAASC AQCNsYmNimtLw779Wr5DnPpOsxxxpfOyRLlI8Pd391x2TXpdPbmvRsldL3kUkRrwqWZ0go93fwo7 P6yshKRMUDfHJySG8TxlC5UL13bXdLlwxWe/PRA+l6Bfr29phoBZE2+wFDJ5DlJ+b/Fnna1WdBht fotLERD3QFFKfva5wzYtyaqOeqz25WT5dqaURHFfre+M47M6wgYZ08i60UOQs7mWeHPKdeN7WMMD g88SCQt+5q+MjYS5D1K6m0mzEE64lUMMNdJkxT0n5ljO7kEti9ZlhUJucspsHCrmxXKNmWFFpuZs 0MV9HET1Hkdz4NgyXAxmwAwVoXjOU1RgjVtPKxtaAAAAAAAA --Apple-Mail-2-723973395-- From rodrigo.hjort@gmail.com Sun Dec 4 18:41:38 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A88129DCBB6 for ; Sun, 4 Dec 2005 14:41:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40982-10 for ; Sun, 4 Dec 2005 14:41:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by postgresql.org (Postfix) with ESMTP id 52BBF9DCB94 for ; Sun, 4 Dec 2005 14:41:35 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i11so467117wra for ; Sun, 04 Dec 2005 10:41:33 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=K2i6YHzvILK8la1LUeXzxMCaA2R7LYNnQGv2gOr38PkwdREW1fRQfHNIVBGeicUIRp/GH+88Yq+vO3V6ZyGxmhxscF5GO+9qSNQxhpa5X96HQ6SMQzsQzQ6DTYMRh7NZdDHSY02IONWDEM2dOkitzILlV5krmjLIfVSlwZORDv4= Received: by 10.64.193.4 with SMTP id q4mr2328592qbf; Sun, 04 Dec 2005 10:41:33 -0800 (PST) Received: by 10.64.153.16 with HTTP; Sun, 4 Dec 2005 10:41:33 -0800 (PST) Message-ID: <731083980512041041o27e363a0s@mail.gmail.com> Date: Sun, 4 Dec 2005 16:41:33 -0200 From: Rodrigo Hjort To: Brendan Duddridge Subject: Re: Postgresql Replication High Availability Cc: pgsql-admin@postgresql.org In-Reply-To: <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <731083980512021932v7b3236cdg@mail.gmail.com> <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.161 required=5 tests=[AWL=0.161] X-Spam-Score: 0.161 X-Spam-Level: X-Archive-Number: 200512/27 X-Sequence-Number: 19747 Brendam, We started testing Sequoia last week, and it reached our expectatives of High Availability and Load Balance. We still need to verify if the performance is not so degradated due to multiple clusters updating. What is the difference between Sequoia and p/cluster? I mean, the latter is a commercial solution offered by Continuent, the same producer of Sequoia. Our applications are based on JBoss, connecting to a PostgreSQL via JDBC. One of the greatest features we found on Sequoia is the URL style: "jdbc:sequoia://first_node:port,second_node:port/database" When a Sequoia Controller is down (eg: first_node), the JDBC tries another one (ie, second_node), and it occurs transparently to the application! The JDBC Driver handles it all alone! I don't know if with a pure PostgreSQL JDBC Driver and the Slony I + Heartbeat joint solution the application would perform the same behavior... 2005/12/3, Brendan Duddridge : > Hello Rodrigo, > > Have you (or anyone else on this list) had great success with > Sequoia? I've been reading a bit about it. It looks like it might > work for us for a high-availability solution. Do you think it's just > as good as using p/cluster? We're deploying to Mac OS X Server and it > looks like p/cluster only supports Linux on x86. > > Thanks, > > ____________________________________________________________________ > Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com > > ClickSpace Interactive Inc. > Suite L100, 239 - 10th Ave. SE > Calgary, AB T2G 0V9 > > http://www.clickspace.com Regards, Rodrigo Hjort http://www.pr.gov.br From brendan@clickspace.com Sun Dec 4 22:23:01 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B62369DCC4F for ; Sun, 4 Dec 2005 18:23:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38715-03 for ; Sun, 4 Dec 2005 18:22:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cobalt.clickspace.com (mail.clickspace.com [65.110.166.234]) by postgresql.org (Postfix) with ESMTP id 457B19DCBCB for ; Sun, 4 Dec 2005 18:22:58 -0400 (AST) Received: from [10.0.1.3] (S0106000d93022b5d.cg.shawcable.net [68.147.204.179]) by cobalt.clickspace.com (8.10.2/8.10.2) with ESMTP id jB4MMtK27028; Sun, 4 Dec 2005 15:22:55 -0700 In-Reply-To: <731083980512041041o27e363a0s@mail.gmail.com> References: <731083980512021932v7b3236cdg@mail.gmail.com> <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com> <731083980512041041o27e363a0s@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v746.2) Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-1-808970857; protocol="application/pkcs7-signature" Message-Id: <8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.com> Cc: pgsql-admin@postgresql.org From: Brendan Duddridge Subject: Re: Postgresql Replication High Availability Date: Sun, 4 Dec 2005 15:23:12 -0700 To: Rodrigo Hjort X-Mailer: Apple Mail (2.746.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/28 X-Sequence-Number: 19748 --Apple-Mail-1-808970857 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Hi Rodrigo, So where did you install sequoia? On your application servers? On your database servers? Or on dedicated servers running only sequoia? Thanks, ____________________________________________________________________ Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9 http://www.clickspace.com On Dec 4, 2005, at 11:41 AM, Rodrigo Hjort wrote: > Brendam, > > We started testing Sequoia last week, and it reached our expectatives > of High Availability and Load Balance. We still need to verify if the > performance is not so degradated due to multiple clusters updating. > > What is the difference between Sequoia and p/cluster? I mean, the > latter is a commercial solution offered by Continuent, the same > producer of Sequoia. > > Our applications are based on JBoss, connecting to a PostgreSQL via > JDBC. One of the greatest features we found on Sequoia is the URL > style: > > "jdbc:sequoia://first_node:port,second_node:port/database" > > When a Sequoia Controller is down (eg: first_node), the JDBC tries > another one (ie, second_node), and it occurs transparently to the > application! The JDBC Driver handles it all alone! I don't know if > with a pure PostgreSQL JDBC Driver and the Slony I + Heartbeat joint > solution the application would perform the same behavior... > > 2005/12/3, Brendan Duddridge : >> Hello Rodrigo, >> >> Have you (or anyone else on this list) had great success with >> Sequoia? I've been reading a bit about it. It looks like it might >> work for us for a high-availability solution. Do you think it's just >> as good as using p/cluster? We're deploying to Mac OS X Server and it >> looks like p/cluster only supports Linux on x86. >> >> Thanks, >> >> ____________________________________________________________________ >> Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com >> >> ClickSpace Interactive Inc. >> Suite L100, 239 - 10th Ave. SE >> Calgary, AB T2G 0V9 >> >> http://www.clickspace.com > > Regards, > > Rodrigo Hjort > http://www.pr.gov.br > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > --Apple-Mail-1-808970857 Content-Transfer-Encoding: base64 Content-Type: application/pkcs7-signature; name=smime.p7s Content-Disposition: attachment; filename=smime.p7s MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGIDCCAtkw ggJCoAMCAQICAw84ujANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhh d3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3VpbmcgQ0EwHhcNMDUwNzI5MjAxMTQzWhcNMDYwNzI5MjAxMTQzWjBIMR8wHQYDVQQD ExZUaGF3dGUgRnJlZW1haWwgTWVtYmVyMSUwIwYJKoZIhvcNAQkBFhZicmVuZGFuQGNsaWNrc3Bh Y2UuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAqWfMCdFgKzXroGNqJuU3eyDC K/Gxts3mtmIdgcHGmUjRKdlBSfkmcCBUDPJIt4QQc91sY3h8Itg0EAsF+1yFECU6afn/1SEAHSDK 6Q86PclF58/Dux2FYNGpeIAw/lisZ2UCyIYoUiWtEDKCBq5jDuYzcGkFS5Csz+/rEL+BHTXQVqnS nUdUaXu9xdZn4wgjB/n65UEYRqr0LGN53CGsFcA9uC+ViS7WyBtzJcP02LMNT+cAZ7TKHw4Q/ZeG 5ptPgQHLTD2wza3GMbPQ4fYK6aNPA+lVzslLSCjyQpg55gVyQQlV0k/5zU5Q5m48ZtqwOqN+fPYd eIB7H5y1SFLd/wIDAQABozMwMTAhBgNVHREEGjAYgRZicmVuZGFuQGNsaWNrc3BhY2UuY29tMAwG A1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEEBQADgYEAT+6hGvStHoRO0OCHlJev31BpUlvPSpbYVKJN i5kCMF164sSX7j0IRvcyU6DfUuW7samTluXJbANyuX1ZIpXulGen5EEc2NV7eU/rMz6ExklMShTh ++azcvmMjOzTuqXi3ZsIjwzBBhqCB0U++kYlMlHEYla2qKLFbXY6PiH0a8swggM/MIICqKADAgEC AgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBl MRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQL Ex9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29u YWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5j b20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMGA1UE ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFs IEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVzVftO ucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Vaqj9x VsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20TxhBEAe ZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJo dHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8E BAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3 DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9 reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAa WzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIC5zCCAuMCAQEwaTBiMQswCQYDVQQGEwJaQTElMCMG A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw84ujAJBgUrDgMCGgUAoIIBUzAYBgkqhkiG9w0BCQMx CwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNTEyMDQyMjIzMTNaMCMGCSqGSIb3DQEJBDEW BBThaaHJmHneyTKG8t3/rssx5mJKgzB4BgkrBgEEAYI3EAQxazBpMGIxCzAJBgNVBAYTAlpBMSUw IwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIDDzi6MHoGCyqGSIb3DQEJEAILMWugaTBiMQswCQYD VQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMj VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECAw84ujANBgkqhkiG9w0BAQEFAASC AQBsqBlIycBMyaIswfR8Qf4+D/3x0Y4l3A+H9snf3+xxhwdtc7xTYWZY05yNfUB53b/YIQxmWgU9 nk3iGSoadz0h7FBxIuA6ARdDoCgPMKjTVbMqw3rONbqYEm1zU0OaXB8fd/xpNhWTSV9bpiB3rDwq 3p3o2oe6+0GYOlG11HPpBslF9LiZJo13gT0JELx/njF/vW1Khoahrwv5hEb2ggCLjXnUPXS4R2Nr GTZC0nNIrpouhXv8Jbda9e0EUdDFxEIT3EZbPblTFmlLUvz0awfx/BVDIRq0C6bRsHuUY/fotJHU ck7M6RDhxUAY5cLsnbDI3VO077qOkF1eFmM+Sm5ZAAAAAAAA --Apple-Mail-1-808970857-- From rodrigo.hjort@gmail.com Mon Dec 5 01:22:29 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B91E49DCA9F for ; Sun, 4 Dec 2005 21:22:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20642-05 for ; Sun, 4 Dec 2005 21:22:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.192]) by postgresql.org (Postfix) with ESMTP id 7DB3F9DCCED for ; Sun, 4 Dec 2005 21:22:26 -0400 (AST) Received: by zproxy.gmail.com with SMTP id o1so595881nzf for ; Sun, 04 Dec 2005 17:22:28 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BEMev7Mm9oen6sgZn5PQScT6BujYDxMdSWgvaMky8/MljDn3I6pcv9I8526IpZsMlPhmbQoKzFgz9bu0kkG0x3gWjzviKHnqvcbQUkleMQHnE2SpQtxJ/Q4E01n2mKIPvAvSy5IdMLXE7clL23xIKSATr+RHhMwwu2vE+r/Pc7I= Received: by 10.65.213.10 with SMTP id p10mr2424952qbq; Sun, 04 Dec 2005 17:22:27 -0800 (PST) Received: by 10.64.153.16 with HTTP; Sun, 4 Dec 2005 17:22:27 -0800 (PST) Message-ID: <731083980512041722n5e8feff8v@mail.gmail.com> Date: Sun, 4 Dec 2005 23:22:27 -0200 From: Rodrigo Hjort To: Brendan Duddridge Subject: Re: Postgresql Replication High Availability Cc: pgsql-admin@postgresql.org In-Reply-To: <8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <731083980512021932v7b3236cdg@mail.gmail.com> <8C2FC712-48C3-41BA-8596-3052B2B75A25@clickspace.com> <731083980512041041o27e363a0s@mail.gmail.com> <8D02A94B-8E41-41BB-B9DB-8C5D29DC143D@clickspace.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.107 required=5 tests=[AWL=0.107] X-Spam-Score: 0.107 X-Spam-Level: X-Archive-Number: 200512/29 X-Sequence-Number: 19749 The plan is the 3rd option, to achieve Fail Over capabilities. There will be 2 or more servers running only Sequoia Controller, pointing to a group of PostgreSQL backends each one. The application server will use Sequoia JDBC Driver (not PostgreSQL JDBC anymore) where those controllers will be specified. No more modifications are needed to do it! Well, the exception is a string on the setting XML used by Hibernate... 2005/12/4, Brendan Duddridge : > Hi Rodrigo, > > So where did you install sequoia? On your application servers? On > your database servers? Or on dedicated servers running only sequoia? > > Thanks, > > ____________________________________________________________________ > Brendan Duddridge | CTO | 403-277-5591 x24 | brendan@clickspace.com > > ClickSpace Interactive Inc. > Suite L100, 239 - 10th Ave. SE > Calgary, AB T2G 0V9 > > http://www.clickspace.com > Regards, Rodrigo Hjort GTI - Projeto PostgreSQL CELEPAR - Cia de Inform=E1tica do Paran=E1 http://www.pr.gov.br