Once vertically scaling your databases can’t help you any further you need to think about sharding them. Sharding basically means you are going to distribute your (write) workload over multiple database hosts using an algorithm. For some OpenSource Databases, you get sharding out of the box, but for MySQL, you don’t.
This means you either implement a sharding yourself and have absolute control over what data goes where or choose...
Most software engineers would make terrible civil engineers. A software engineer tasked with building a bridge in the middle of nowhere might say “I heard that the George Washington Bridge in NYC gets 103 million vehicles per year, what if my bridge got 104 million vehicles? The George Washington Bridge has the best practice!”
In reality, most of us are building applications that operate squarely between the scale of one person...
In this talk Travis Frutas and Brian Walters will discuss the process and technical details of PCI compliance, and how these are implemented with PerconaServer for MongoDB.
Regulatory compliance is high on the list of concerns for companies across multiple industry vertices, for many good reasons. We’ll discuss what compliance means, where responsibilities lie for providing a compliant environment and then provide a practical...
Advanced Optimization and Troubleshooting MySQL Using PMM2 - Peter Zaitsev - Percona Live ONLINE 2020
Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs.
The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA’s are also expected to find cost-efficient means of solving these issues. In this presentation, we will...
Containers and Automation
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.