Split-Brain 101: What You Should Know

Split-brain datasets

Disclaimer: The following blog post does not try to provide a solution for split-brain situations, and the example provided is for demonstrative purposes only. Inconsistencies resulting from a split-brain scenario might possibly be more complex than the one shown, so do not use the following example as a complete guide.
What is Split-Brain?
A split-brain scenario […]

Read more

Sysbench and the Random Distribution Effect

Sysbench and the Random Distribution Effect

What You May Not Know About Random Number Generation in Sysbench
Sysbench is a well known and largely used tool to perform benchmarking. Originally written by Peter Zaitsev in early 2000, it has become a de facto standard when performing testing and benchmarking. Nowadays it is maintained by Alexey Kopytov and can be found in […]

Read more

MySQL Performance Optimization with Percona Monitoring and Management – Webinar Followup

optimize MySQL with Percona Monitoring and Management

Last week I did a webinar on MySQL Troubleshooting and Performance Optimization with Percona Monitoring And Management v2 (PMM2).
There was a tremendous amount of interest and many more questions than I could answer, so I’m answering them in this blog post instead.
Q: What are the red and white dots on the last column in […]

Read more

A Tale About Migrating a PostgreSQL Database Between Different DBaaS Providers

Migrating PostgreSQL Between DbaaS Providers

We recently helped migrate a production PostgreSQL database running on a given DBaaS platform… to another DBaaS platform. When it comes to vendor “lock-in”, some providers are easier (and even friendlier) to deal with than others, but it is never a straightforward process. While in a traditional environment we would usually approach this problem […]

Read more