Designing open-source databases for high availability

It is said that if you are not designing for failure, then you are heading for failure. How do you design a database system from the ground up to withstand failure? This can be a challenge as failures happen in many different ways, sometimes in ways that would be hard to imagine. This is a consequence of the complexity of today’s database environments.

At Severalnines we’re big fans of high availability databases and have seen our fair share of failure scenarios across the thousands of database deployments we enable every year.

In this webinar replay, we’ll look at the different types of failures you might encounter and what mechanisms can be used to address them. We will also look at some of popular HA solutions used today, and how they can help you achieve different levels of availability.

Content of the webinar

• Why design for High Availability?
• High availability concepts
  • CAP theorem
  • PACELC theorem
• Trade offs
  • Deployment and operational cost
  • System complexity
  • Performance issues
  • Lock management
• Architecting databases for failures
  • Capacity planning
  • Redundancy
  • Load balancing
  • Failover and switchover
  • Quorum and split brain
  • Fencing
  • Multi datacenter and multi-cloud setups
  • Recovery policy
• High availability solutions
  • Database architecture determines Availability
  • Active-Standby failover solution with shared storage or DRBD
  • Master-slave replication
  • Master-master cluster
• Failover and switchover mechanisms
  • Reverse proxy
  • Caching
  • Virtual IP address
  • Application connector