The Road Story of a MyRocks/MariaDB Migration
2 hours ago, percona

This post has been written in collaboration with Nicolas Modalvsky of e-planning. Nicolas and I recently worked together on a tuning engagement involving MyRocks on MariaDB. While it is easy to find online articles and posts about InnoDB performance, finding information about MyRocks tuning is more difficult. Both storage engines are well documented but what […]...

Percona Distribution for MySQL, New Features in Percona Kubernetes Operator for Percona XtraDB Cluster: Release Roundup August 3, 2020
23 hours ago, percona

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

Using SKIP LOCK For Queue Processing in MySQL
1 day ago, percona

A small thing that provides a huge help. The other day I was writing some code to process a very large amount of items coming from a social media API. My items were ending in a queue in MySQL and then needed to be processed and eventually moved. The task was not so strange,  but […]...

How MySQL 8.0.21 and MariaDB 10.5.4 Perform in IO-Bound Scenarios on SATA SSD and NVMe Storage
4 days ago, percona

Continuing with the same topic and evaluating new versions of MariaDB and MySQL on Enterprise SSD Storage and How MySQL and MariaDB Perform on NVMe Storage, this time let’s take a look at how MySQL 8.0.21 and MariaDB 10.5.4 perform in IO-bound scenarios on both SATA SSD and NVMe storage. To emulate the IO-bound scenario, […]...

How MySQL and MariaDB Perform on NVMe Storage
5 days ago, percona

MySQL and MariaDB on NVMe Storage  – The Great Equalizer Continuing with the checkpointing topic I restarted a month ago with MongoDB, followed with PostgreSQL, and then with MySQL and MariaDB on Enterprise SSD Storage, this time let’s take a look at how MySQL and MariaDB perform on NVMe storage. Benchmark To evaluate MariaDB and […]...

Percona Monthly Bug Report: July 2020
5 days ago, percona

At Percona, we operate on the premise that full-transparency makes a product better. We strive to build not only the best open-source database products but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you […]...

Checkpointing in MySQL and MariaDB
6 days ago, percona

Continuing with the checkpointing topic I restarted a month ago with MongoDB and followed with PostgreSQL, I wanted to check how MySQL and MariaDB perform. It was actually some time when I last looked into MySQL in this regard, so I am curious how new MySQL versions (8.0.21 in this case) would perform. And while […]...

Migrating to PostgreSQL Version 13: Incompatibilities You Should Be Aware Of
6 days ago, percona

The PostgreSQL 13 Beta is out in the testing phase with a rich feature set. It is a very good learning effort to participate in the testing of one of the finest databases in the world. It does not matter how much development, coding, and administration experience you have for the testing of the PostgreSQL […]...

Replication Between Two Percona XtraDB Clusters, GTIDs and Schema Changes
6 days ago, percona

I got this question on the “How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster (PXC)” webinar and wanted to answer it in a separate post. Will RSU have an effect on GTID consistency if replication PXC cluster to another cluster? Answer for this: yes and no. Galera assigns its own GTID for […]...

Evaluating Checkpointing in PostgreSQL
1 week ago, percona

Continuing with the checkpointing topic I started a month ago with my blog post MongoDB Checkpointing Woes, this time I want to review how PostgreSQL performs in this area. After this, I will be taking a look at MySQL and MariaDB. If anything, it will be fair not only to complain about MongoDB but to […]...

The Transaction Behavior Impact of innodb_rollback_on_timeout in MySQL
1 week ago, percona

I would say that innodb_rollback_on_timeout is a very important parameter. In this blog, I am going to explain “innodb_rollback_on_timeout” and how it affects the transaction behavior at the MySQL level. I describe two scenarios with practical tests, as it would be helpful to understand this parameter better. What is innodb_rollback_on_timeout? The parameter Innodb_rollback_on_timeout will control […]...

ClickHouse and ColumnStore in the Star Schema Benchmark
1 week ago, percona

There were two new releases in the OpenSource Analytical Databases space, which made me want to evaluate how they perform in the Star Schema Benchmark. I covered Star Schema Benchmarks a few times before: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark) What are […]...

Generating Numeric Sequences in MySQL
1 week ago, percona

What is the easiest way to generate a sequence of integers in MySQL? In other words, which “SELECT <something>” statement should I write to get 0, 1, 2, … N – 1? This is the question I have been struggling with for years and it looks like I have finally got the answer (although I […]...

MongoDB: Utilization of an Index on Subdocuments
1 week ago, percona

MongoDB has a lot of possibilities for creating indexes. We have seen in previous articles some of the available index types and discussed explain() usage: Using Partial and Sparse Indexes in MongoDB MongoDB Index Types and MongoDB explain() (part 1) MongoDB: Investigate Queries with explain() and Index Usage (part 2) You can have a look […]...

Using Percona Kubernetes Operators with Percona Monitoring and Management
1 week ago, percona

Percona Monitoring and Management (PMM) provides an excellent solution to monitor both Percona XtraDB Cluster and Percona Server for MongoDB. Currently, there is no Percona-supported deployment model to deploy PMM by Percona Kubernetes Operators. Still, you can try the following experimental approach to use PMM in Kubernetes or OpenShift environment together with the operators for […]...

Percona Audit Log Plugin and the Percona Monitoring and Management Security Threat Tool
1 week ago, percona

The Security Threat Tool has been available since Percona Monitoring and Management 2.6.0 (PMM) and starting from that first release it is proving to be a severely-needed feature. If you’re not familiar with the Security Threat Tool (STT), it helps you to ensure compliance as you have the ability to run checks daily, get alerts […]...

Beyond Relational Databases: A Focus on Redis, MongoDB, and ClickHouse
1 week ago, percona

Many of us use and love relational databases… until we try and use them for purposes that aren’t their strong point. Queues, caches, catalogs, unstructured data, counters, and many other use cases, can be solved with relational databases, but are better served by alternative options. Recently, Marcos Albe, Support Engineer at Percona, examined the goals, […]...

Announcing Percona Live ONLINE: October 20-21, 2020
1 week ago, percona

We’re moving Percona Live Europe ONLINE, and we’re going global! After much deliberation and consideration of the ever-changing situation around COVID-19 we have decided it would be the best decision to take this year’s event ONLINE! Percona Live ONLINE will take place on October 20-21, 2020 starting at 10:00 am EDT. Last time we streamed […]...

Updates to Percona Kubernetes Operator for Percona XtraDB Cluster
1 week ago, percona

On July 21, 2020, Percona delivered an updated version of our Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) focused on easing deployment and operations management of a clustered MySQL environment. Included in the Percona Distribution for MySQL, our Operator is based on the best practices for MySQL cluster configuration and setup in Kubernetes. This […]...

New MySQL 8.0.21 and Percona XtraBackup 8.0.13 Issues
2 weeks ago, percona

On Monday, July 13, 2020, Oracle released MySQL 8.0.21.  This release contained a few new changes that cause issues with Percona XtraBackup. First, this release introduced the ability to temporarily disable InnoDB redo logging (see the work log and documentation).  If you love your data, this feature should ONLY be used to speed up an […]...

Next