MySQL Performance Blog

Percona's MySQL & InnoDB performance and scalability blog

Latest articles

What You Can Do With Auto-Failover and Percona Distribution for MySQL (8.0.x)

Where x is >= 22 😉 The Problem There are few things your data does not like. One is water and another is fire. Well, guess what: If you think that everything will be fine after all, take a look: Given my ISP had part of its management infrastructure on OVH, they had been impacted by the incident. As you can see from the highlight, the...

Percona Distribution for MySQL: High Availability with Group Replication Solution

This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on our best practices. Every architecture and deployment depends on the customer requirements and application demands for high availability and the estimated level of usage. For example, using high read or high write...

Percona Live ONLINE: Focus on Unprecedented Demand for Scale

The full conference schedule for Percona Live ONLINE 2021, taking place on May 12-13, is now live!  This year we see a strong focus on how organizations successfully managed the technology challenges of the past 12 months. Register and attend for FREE! A number of presentations demonstrate the key role databases played in achieving company success...

Replay the Execution of MySQL With RR (Record and Replay)

Chasing bugs can be a tedious task, and multi-threaded software doesn’t make it any easier. Threads will be scheduled at different times, instructions will not have deterministic results, and in order for one to reproduce a particular issue, it might require the exact same threads, doing the exact same work, at the exact same time. As you can imagine,...

Latest Version of pg_stat_monitor in Percona Distribution for PostgreSQL, Bug Fix in Percona Server for MongoDB: Release Roundup April 12, 2021

It’s release roundup time again here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Today’s post includes...

Deploying a MongoDB Proof of Concept on Google Cloud Platform

Recently, I needed to set up a Proof of Concept (POC) and wanted to do it on Google Cloud Platform (GCP).  After documenting the process, it seemed it might be helpful for others looking for the most basic guide possible to get a Mongo server up and running on GCP.  The process below will set up the latest version of Percona Server for MongoDB on a...

MySQL 101: Basic MySQL Server Triage

So your MySQL server has crashed.  What do you do now?  When a server is down, in my opinion, there are two steps that are essential and both are extremely important and neither should be neglected: Save diagnostic information for determining the root cause analysis (RCA). Get the server back up and running. Too many people rush to Step #2 and...

Percona Kubernetes Operators and Azure Blob Storage

Percona Kubernetes Operators allow users to simplify deployment and management of MongoDB and MySQL databases on Kubernetes. Both operators allow users to store backups on S3-compatible storage and leverage Percona XtraBackup and Percona Backup for MongoDB to deliver backup and restore functionality. Both backup tools do not work with Azure Blob Storage,...

Which Version of MySQL Should I Use for MyRocks?

As database footprints continue to explode, many companies are looking for ways to deal with such rapid growth.  One approach is to refactor traditional relational databases to fit into a NoSQL engine, where horizontal scalability is easier.  However, in many cases, this is in no way a trivial undertaking. Another approach that has been gaining interest...

What’s New at Percona Live ONLINE 2021?

Percona Live ONLINE is a community-focused event for database developers, administrators, and decision-makers to share their knowledge and experiences. We would love you to join us on May 12-13 for this year’s event. Register and attend for FREE! This year Percona Live is going to be our biggest and best event yet!  Free, just like our software,...

Discover, share and read the best on the web

Subscribe to RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters! Get unfiltered news feeds or filter them to your liking.

Get Inoreader
Inoreader - Subscribe to RSS Feeds, Blogs, Podcasts, Twitter searches, Facebook pages, even Email Newsletters!