Operational Difficulties With Distributed Databases

  • Data replication is common in distributed databases. Which site to query? Which site to update first and then the rest (with cascades)?
  • If a site (or a link) fails then, on re-connecting the isolated sites, the relevant data commits done during the interruption must be updated.
  • Transaction scheduling over multiple sites is much harder than the centralised case.
kaizenlogadmin (2863 Posts)

I am Peter, a blogger, SEO and social media person who has an interest in E-commerce, ERP and CMS systems. You can contact me by e-mail: kaizenlog@gmail.com