Best Practice in Design and Implementing MySQL Geographic Distributed, High Availability Solutions - PLO October 2020
Nowadays implementing different grades of business continuity for the data layer storage is a common requirement.
When designing architectures that include MySQL as a data layer, we have different options to cover the required target. Nevertheless we still see a lot of confusion when in the need to properly cover concepts such as HighAvailability and Disaster Recovery. Confusion that often leads to improper architecture design...
Disaster Recovery and High Availability: The Concepts, The Mistakes, and How To Properly Plan For Failure
Any good system must be built to expect the unexpected. None are perfect and at some point something WILL happen to render the system non-operational causing failure.
Join Dimitiri Vanoverbeke, Percona Engineer, as he discusses the concepts of High Availability, Disaster Recovery, common missteps that happen along the way and how to ultimately prepare for failure.
Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the capability of the database to store and process more data, for example, adding a new process, memory, or disk to an...
PostgreSQLHigh AvailabilityPerformance Optimization
It is common knowledge that built-in asynchronous master-master (active-active) replication is not safe. I remember times when the official MySQL User Reference Manual stated that such an installation is not recommended for production use. Some experts repeat this claim even now.
While this statement is generally true, I worked with thousands of shops that successfully avoided asynchronous replication limitations in active-active...
Peter Zaitsev, Founder and CEO at Percona, presents a webinar focused on dealing with an unexpected high traffic event as it is happening. He'll address the impact a traffic spike can have on your database - from poor query response time to replication lag issues - and provide actionable tips and tricks. Join us and learn how to bring your database under control, earn performance gains and delight your customers!
MySQLHigh AvailabilityPerformance Optimization
Join us April 15 for an hour-long roundtable with Peter Zaitsev, CEO and Matt Yonkovit, CXO of Percona.
Peter and Matt will be answering your questions, and exploring topics that are top of mind with the recent COVID-19 outbreak:
- Is your business experiencing a slowdown? Matt will share five easy ways your company can cut costs quickly — without reducing staff.
- Or, perhaps...
Josh Berkus (Red Hat) delivers the talk, "HA PostgreSQL on Kubernetes by Demo", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.
You can have fully automated high availability PostgreSQL on your Kubernetes cluster ... today. The Patroni system for automating PostgreSQL deployment, failover, and migration is ready to use and in production in several places. In this live demo session, we will...
Percona Live SessionsPostgreSQLHigh AvailabilityMigration
Avinash Vallarapu (Percona) delivers the talk, "High Availability and Automatic Failover in PostgreSQL on Kubernetes, On-premise and Cloud", on DAY 2 of the Percona Live Open Source Database Conference 2019, 5/30, at Austin, TX.
PostgreSQL is an advanced open source database that is completely community driven. Continuous development and performance improvements, while maintaining a secondary focus on Oracle compatibility, gave...
Percona Live SessionsPostgreSQLHigh Availability