MySQL Performance Blog - RSS Feed

Percona's MySQL & InnoDB performance and scalability blog

Latest articles

PostgreSQL Replication and Conflicts

Replication sits at the core of database high availability (HA). While on-disk data can be replicated through various methods, whether hardware or software, disk, file, or block-based solutions, without an online copy of the database, HA setup cannot be achieved. This blog digs into more detail the challenges/conflicts that impact PostgreSQL replication,...

Automate the SSL Certificate Lifecycle of your Percona Monitoring and Management Server

We highly value security here at Percona, and in this blog post, we will show how to protect your Percona Monitoring and Management (PMM) Server with an SSL certificate and automate its lifecycle by leveraging a proxy server. Introduction As you may know, PMM Server provides a self-signed SSL certificate out-of-the-box to encrypt traffic between the...

Percona Operator Volume Expansion Without Downtime

There are several ways to manage storage in Percona Kubernetes Operators: Persistent Volume (PV), hostPath, ephemeral storage, etc. Using PVs, which are provisioned by the Operator through Storage Classes and Persistent Volume Claims, is the most popular choice for our users. And one of the most popular questions is how to scale our operator storages...

Using Percona Server for MySQL with Amazon KMS as Keyring

Percona Server for MySQL 8.0.28-20 introduces a new keyring component, component_keyring_kms, which allows using the AWS Key Management Service as a keyring. The component is also included in Percona XtraBackup 8.0.28, allowing backing up databases encrypted with this component. The feature is similar to the AWS keyring plugin included in MySQL Enterprise,...

Introducing Buffered Error Logging in Percona Server for MySQL

The MySQL error log is usually used to store and later analyze error and warning messages, but in some cases, it is also used for high throughput debug messages for analyzing complex issues. These messages take up more space, slow down the server, and also make the error log harder to use for other issues. To solve this problem, Percona Server for MySQL...

Enabling and Enforcing SSL/TLS for PostgreSQL Connections

Enabling SSL in PostgreSQL is very straightforward. In just three steps we can make sure the connections to it are more secure, using in-transit encryption via SSL/TLS: Make sure we have the server certificate and key files available Enable the SSL configuration (ssl = on) Make sure the pg_hba.conf file rules are updated accordingly In this...

Understanding Database High Availability

Ensuring that databases are highly available is not just a thing these days, it’s the thing.  Downtime, whether scheduled or unplanned, is barely, if at all, tolerated by end users. The consequences of downtime can be severe and may include things like loss of customers, damage to your reputation, or penalties for not meeting Service Level Agreements...

PostgreSQL Sequences – Episode 5 of PostgreSQL for MySQL DBAs

Many MySQL DBAs have expressed interest in learning about PostgreSQL and this series is a guided tour through the basics. One of the ‘Wow! That is Different!’ things for MySQL DBAs looking at PostgreSQL are sequences.  Sequences can be used as a rough equivalent to MySQL’s AUTO_INCREMENT but that is only part of the story. Sequences are much more than...

Digital Signatures: Another Layer of Data Protection in Percona Server for MySQL

Imagine you need to design an online system for storing documents on a per-user basis where nobody, including database administrators, would be able to change the content of those documents without being noticed by document owners. In Percona Server for MySQL 8.0.28-20, we added a new component called Encryption UDFs – an open-source alternative to...

Database Corruption: An Overview

Though I am writing this post being a PostgreSQL DBA, this page can be read by anyone because the concept of corruption is the same in every database. After reading this blog post, one should understand what database corruption is and how it may occur. Being DBAs, corruption is something we do not want to ever see in our system; however, there are...

Discover, share and read the best on the web

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

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