pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Bucardo, BDR , pglogical 3+ messages / 3 participants [nested] [flat]
* Bucardo, BDR , pglogical @ 2021-11-09 13:21 Firthouse banu <penguinsfairy@gmail.com> 0 siblings, 2 replies; 3+ messages in thread From: Firthouse banu @ 2021-11-09 13:21 UTC (permalink / raw) To: pgsql-admin Best tool to replicate a database to multiple servers and also when user do any changes in replicated database that too should be brought into master database . Master —— to multiple servers And in those servers if any changes done then should be bright those to master also . All database should be in sync….. If anybody have supporting documents please do send me . And I need answers as well. Thanks ^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: Bucardo, BDR , pglogical @ 2021-11-09 14:08 Alvaro Aguayo <aaguayo@opensysperu.com> parent: Firthouse banu <penguinsfairy@gmail.com> 1 sibling, 0 replies; 3+ messages in thread From: Alvaro Aguayo @ 2021-11-09 14:08 UTC (permalink / raw) To: Firthouse banu <penguinsfairy@gmail.com>; pgsql-admin Hi. Until a few months ago, I was using BDR for a large database (> 600Gb). Worked pretty well. At the beginning hand some problems with large transactions, but solved them by adapting the program to use smaller transactions; never knew if it was a Postgres problem, a BDR problem, or if it was solved or is still causing trouble somewhere. Decided to stop using it because the release was old, it forced me to stay on PG9.4 and the newer releases were not free software, but commercial. pglogical is based on the same technology as BDR, but it’s only master-slave. You might find some information about pglogical “multi-master” mode, but it’s just a way to make many masters converge into a single slave. Never tried Bucardo, but, as far as I know, it’s trigger based, so I would not recommend it for nothing more than testing or small systems, as trigger-based replicators suffer from amplification and thus poor performance on high transaction concurrency. If you are willing to pay, BDR is probably the better option. If not, you can always change your application to fit a different architecture. You can also consider some PostgreSQL-as-a-service such as the ones offered by Azure, AWS, or GPC, all of them offering high availability. Regards, Alvaro Aguayo Operations Manager Jr. Prolongación Ayacucho 177 Urb. Santa Eulalia - San Miguel Telf. (+51-1) 680-5726 E-mail: aaguayo@ocs.pe From: Firthouse banu <penguinsfairy@gmail.com> Sent: 09 November 2021 08:22 To: pgsql-admin@postgresql.org Subject: Bucardo, BDR , pglogical Best tool to replicate a database to multiple servers and also when user do any changes in replicated database that too should be brought into master database . Master —— to multiple servers And in those servers if any changes done then should be bright those to master also . All database should be in sync….. If anybody have supporting documents please do send me . And I need answers as well. Thanks ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Bucardo, BDR , pglogical @ 2021-11-09 14:14 Vijaykumar Jain <vijaykumarjain.github@gmail.com> parent: Firthouse banu <penguinsfairy@gmail.com> 1 sibling, 0 replies; 3+ messages in thread From: Vijaykumar Jain @ 2021-11-09 14:14 UTC (permalink / raw) To: Firthouse banu <penguinsfairy@gmail.com>; +Cc: pgsql-admin On Tue, Nov 9, 2021, 6:52 PM Firthouse banu <penguinsfairy@gmail.com> wrote: > Best tool to replicate a database to multiple servers and also when user > do any changes in replicated database that too should be brought into > master database . > > Master —— to multiple servers > And in those servers if any changes done then should be bright those to > master also . All database should be in sync….. > What is your use case that only a multimaster setup can solve the problem and not a simple primary replica setup. BTW, https://github.com/ApsaraDB/PolarDB-for-PostgreSQL > > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-11-09 14:14 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-11-09 13:21 Bucardo, BDR , pglogical Firthouse banu <penguinsfairy@gmail.com> 2021-11-09 14:08 ` Alvaro Aguayo <aaguayo@opensysperu.com> 2021-11-09 14:14 ` Vijaykumar Jain <vijaykumarjain.github@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox