Postgresql database has come a long way since its initial release. One of the feature that can come in very handy in handling database that are located across geographical region is multi-master replication. The idea is to provide localised access to the database for each sites and yet still maintain a single view of the database. There are two solution that can get this done rather painlessly.
Option 1: BDR
This is a new replication solution by second quadrant. Still in beta but the ease of installation is very promising. The quirks:
a. Some of the database administrative functions are rendered inoperative.
b. A global sequence need to be explicitly set during table creation. Otherwise, would have a lot of write failure as the sequences are being replicated asynchronously.
c. Need a patched version of Postgresql 9.4.
Option 2: Bucardo
This solution has been around for quite sometime and is quite stable. The latest version which is 5.4 added support for multi-masters. The quirks:
a. DDL is not replicated. Any update to DDL need to be manually handled across all nodes.
b. Sequences is not replicated. A good strategy is to increment the sequence by the number of nodes installed.
Personally I prefer BDR solution as DDL and sequences replication can make deployment so much easier.
It's Really A Great Post. Looking For Some More Stuff.
ReplyDeleteBest MSBI Training Centers in Bangalore
Best PEGA Training Centers in Bangalore
Best Oracle PLSQL Training Centers in Bangalore
Best Advanced JAVA Training Centers in Bangalore
Its a Nice Post.
ReplyDeleteBest Oracle Training in Bangalore
It’s nice and valuable information, really appreciate for the nice blog...!!
ReplyDeleteHi guyz click here Best Pega Training in Bangalore to get the best knowledge and details and also 100% job assistance hurry up...!!
DO NOT MISS THE CHANCE...
Thanks for sharing the information...
ReplyDeletepega training in bangalore
Nice blog...Thanks for sharing the Information...
ReplyDeleteBest IT and Non-IT Course Training Institute in Bangalore
Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving.
ReplyDeleteItalian Language Training In Bangalore
Italian Training Institute in Bangalore
Italian Institute in Bangalore
Italian Language Institute
Indian Institute of Italian & Italian Language
Italian Learning
Italian Language Institute in Bangalore
Italian Courses
Italian language course in Bangalore
learn Italian language in Bangalore
Italian language basics learning in Bangalore
learn Italian grammar in Bangalore
Italian learning centres contact addresses in Bangalore
Italian grammer tuition phone numbers in Bangalore
reviews of Italian language learning centres in Bangalore
ratings of Italian spoken classes in Bangalore
Thank you for excellent article.You made an article that is interesting.
ReplyDeleteSAP Online Training
SAP Classes Online
SAP Training Online
Online SAP Course
SAP Course Online
Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot.
ReplyDeleteSAP ABAP Online Training
SAP ABAP Classes Online
SAP ABAP Training Online
Online SAP ABAP Course
SAP ABAP Course Online
Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article.
ReplyDeleteBlockchain training in bangalore
Blockchain class in bangalore
learn Blockchain in bangalore
places to learn Blockchain in bangalore
Blockchain schools in bangalore
Blockchain reviews in bangalore
Blockchain training reviews in bangalore
Blockchain training in bangalore
Blockchain institutes in bangalore
Blockchain trainers in bangalore
learning Blockchain in bangalore
where to learn Blockchain in bangalore
best places to learn Blockchain in bangalore
top places to learn Blockchain in bangalore
Blockchain training in bangalore india
I have recently visited your blog profile. I am totally impressed by your blogging skills and knowledge.
ReplyDeleteDevOps Online Training
DevOps Classes Online
DevOps Training Online
Online DevOps Course
DevOps Course Online
Informative content,thanks for sharing...waiting for next update...
ReplyDeletePrimavera Training in Chennai
Primavera Course in Chennai
Primavera Software Training in Chennai
Oracle DBA Training in Chennai
oracle dba course in chennai
Pega Course in Chennai
Pega Training Institutes in Chennai
GOOD ARTICLE
ReplyDeletefinal year project
mini projects for cse
final year projects for cse
final year projects for cse students
final year projects for cse domains
final year projects for cse in data mining
final year projects for cse with source code
final year project for ece
final year project in mechanical engineering
final year project for eee
Help full post, lots of information
ReplyDeletegazetted officer
z or r twice
what is isp
space complexity
ng-focus
unexpected token o in json at position 1
do a barrel roll 20 times
cannot set headers after they are sent to the client
how to hack any instagram account 100% working
blink html google trick
Super article
ReplyDeleteartificial neural network
what is artificial neural network
what is an artificial neural network
application of artificial neural network
artificial neural network application
artificial neural network pdf
artificial neural network ppt
artificial neural network tutorial
artificial neural network definition
artificial neural network types
seo fiyatları
ReplyDeletesaç ekimi
dedektör
instagram takipçi satın al
ankara evden eve nakliyat
fantezi iç giyim
sosyal medya yönetimi
mobil ödeme bozdurma
kripto para nasıl alınır
Smm panel
ReplyDeleteSmm panel
is ilanlari
instagram takipçi satın al
Hirdavatciburada.com
beyazesyateknikservisi.com.tr
Servis
tiktok jeton hilesi
bostansepeti.com
ReplyDeletesite kurma
ürünler
vezirsosyalmedya.com
postegro
sosyal medya yönetimi
surucukursuburada.com
Very interesting post and thanks for your knowledgeable sharing with us. Keep doing well!
ReplyDeleteVirginia Online Divorce
Divorce Lawyer Consultation Cost
Divorce in Virginia with Child
Nice post! it was too good and thank you for sharing it.
ReplyDeletepvc foam board manufacturers in kerala
pvc foam board manufacturers kerala