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--