Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hEalW-0007qh-Cz for pgsql-admin@arkaria.postgresql.org; Thu, 11 Apr 2019 14:33:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hEalV-0008KJ-2L for pgsql-admin@arkaria.postgresql.org; Thu, 11 Apr 2019 14:33:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hEalU-0008Jd-GV for pgsql-admin@lists.postgresql.org; Thu, 11 Apr 2019 14:33:20 +0000 Received: from mail-oln040092253021.outbound.protection.outlook.com ([40.92.253.21] helo=APC01-SG2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hEalP-00076A-WB for pgsql-admin@lists.postgresql.org; Thu, 11 Apr 2019 14:33:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=+zoIRrdxM99mP4BPRO+KvccBE+WBA0O5sryIelXP5eY=; b=sXqbLAQ36P+UxciRAuTTqTRiRb5plWtmAMd2qy44BtFtN3gra8Fh8QGXNaNp4xvSbPTRzdqOpHNPA+1+oZgV78YypopKOTM59C8X9OsKGUl6hA73k2O67oIL1Xx64oFh7//CbwT/bpTlzIglVFfVfsdkx9pCglxTP8/bq57tN4jcOOflCcJ9sI3JGbnM5qNJST2Qd5oK5DhXv/5psPZg3rjlIuqgIB2dP3J18lhCc01aKJePOCUwWHMRfd5a/PdYiJuTp9XBi2bMHTq28dKed8pX8/e0ttB+pkvMOhH0Ph3yBdbXyACfZM0Y92HUitVE68Gy7B+JmhDkSEACoQCj6Q== Received: from HK2APC01FT037.eop-APC01.prod.protection.outlook.com (10.152.248.56) by HK2APC01HT244.eop-APC01.prod.protection.outlook.com (10.152.249.91) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1771.16; Thu, 11 Apr 2019 14:33:11 +0000 Received: from MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM (10.152.248.57) by HK2APC01FT037.mail.protection.outlook.com (10.152.248.223) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.20.1771.16 via Frontend Transport; Thu, 11 Apr 2019 14:33:11 +0000 Received: from MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM ([fe80::c1f8:460e:124a:283]) by MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM ([fe80::c1f8:460e:124a:283%2]) with mapi id 15.20.1771.016; Thu, 11 Apr 2019 14:33:11 +0000 From: soumitra bhandary To: "pgsql-admin@lists.postgresql.org" Subject: BDR OR MASTER SLAVE REPLICATION WITH REPMGR IS SUITABLE FOR LARGE ONLINE APPLICATION Thread-Topic: BDR OR MASTER SLAVE REPLICATION WITH REPMGR IS SUITABLE FOR LARGE ONLINE APPLICATION Thread-Index: AQHU8HN9YH+0uD6VV0KJ8jQM4DxcuQ== Date: Thu, 11 Apr 2019 14:33:11 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-incomingtopheadermarker: OriginalChecksum:45B8756D7A53B20756F7EB489A696FEF5C48A47EDEE9F5EB56BE0D58C1A95273;UpperCasedChecksum:4EB2FF2C6F09BA7225A947DED5CAD6C2982DC92F618FB8FFE583D0057AE06EA4;SizeAsReceived:6789;Count:42 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [A8Ya+NmAMRIDSLmXtxybYIv9Ot8kaxYsMNYNQvGTIRE=] x-ms-publictraffictype: Email x-incomingheadercount: 42 x-eopattributedmessage: 0 x-microsoft-antispam: BCL:0;PCL:0;RULEID:(2390118)(7020095)(20181119110)(201702061078)(5061506573)(5061507331)(1603103135)(2017031320274)(2017031323274)(2017031324274)(2017031322404)(1601125500)(1603101475)(1701031045);SRVR:HK2APC01HT244; x-ms-traffictypediagnostic: HK2APC01HT244: x-microsoft-antispam-message-info: HRfxKRGebhnX0nFfGDJV8WQbkntjJE4258VwVGSyS34kTGoVguNgIpcNu2qpCGtM7bfO3caplyeEhpCrDIWqOMlsIjrqjaq8lQiGOyO3vpHQ2fDrhls79hUqKFbb/T4SKP5L5A/SA/FhvqBF7sXGSg53iXFmc50aBgLL6OQWfag9u5QdPSnV6putNMMNmu/a Content-Type: text/plain; charset="us-ascii" Content-ID: <1569ADE5CDF43D4289BA8CCD7DC15F11@sct-15-20-1580-16-msonline-outlook-e52fc.templateTenant> Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 949ba16d-837e-4a8c-3c62-08d6be8a9fc6 X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-originalarrivaltime: 11 Apr 2019 14:33:11.4296 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: HK2APC01HT244 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi , Can anyone suggest me for large OLTP application which sort of replication = is suitable BDR or master slave replication with synchronous and asynchrono= us node and REPMGR enabled.=20 Can BDR handle real-time conflicts arises due to high network latency or Da= taintegrity conflicts?? Please suggest Sent from my iPhone=