by Alkin Tezuysal | Feb 20, 2020 | Insight for DBAs, MariaDB, MySQL, Storage Engine
In this blog post, we will share some experiences with the hidden gem in MySQL called MyRocks, a storage engine for MySQL’s famous pluggable storage engine system. MyRocks is based on RocksDB which is a fork of LevelDB. In short, it’s another key-value store based on...
by Robert Golebiowski | Feb 19, 2020 | MySQL, Percona Software, Security
In the last blog post of this series, we discussed in detail how Master Key encryption works. In this post, based on what we already know about Master Key encryption, we look into how Master Key rotation works. The idea behind Master Key rotation is that we want to...
by David Quilty | Feb 19, 2020 | Insight for Developers, MySQL, Percona Software, Webinars
This talk covers some of the challenges we sought to address by creating a Kubernetes Operator for Percona XtraDB Cluster, as well as a look into the current state of the Operator, a brief demonstration of its capabilities, and a preview of the roadmap for the...
by Ivan Groenewold | Feb 17, 2020 | MySQL, Open Source
by Corrado Pandiani | Feb 13, 2020 | Insight for DBAs, MySQL, Percona Software
This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), a new feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0. In this article, we’ll present the Recursive Common Table...
by Corrado Pandiani | Feb 10, 2020 | Insight for DBAs, MySQL, Percona Software
This blog is the first part of a two-articles series. In this article, I’m going to introduce the Common Table Expression (CTE), a new feature available on MySQL 8.0, as well as Percona Server for MySQL 8. What is a Common Table Expression? We can define a CTE...
by Vadim Tkachenko | Feb 7, 2020 | Cloud, MySQL, Percona Software
As our Percona Kubernetes Operator for Percona XtraDB Cluster gains in popularity, I am getting questions about its performance and how to measure it properly. Sysbench is the most popular tool for database performance evaluation, so let’s review how we can use it...
by David Quilty | Feb 7, 2020 | Insight for Developers, MongoDB, MySQL, PostgreSQL, Webinars
Most applications use databases, yet many fail to follow even the most basic best practices, resulting in poor performance, downtime, and security incidents. In this presentation, we will look into the foundational best practices you as a Developer should know about...
by Peter Zaitsev | Feb 5, 2020 | Insight for Developers, MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source, production-ready, and enterprise-grade MySQL alternative. Learn More I did a MariaDB Observability talk at MariaDB Day in Brussels, which I roughly based on the...
by Vadim Tkachenko | Feb 3, 2020 | Insight for DBAs, Insight for Developers, MySQL
It’s been a while since I wrote about ClickHouse, there are a lot of new features that are worth mentioning, and for this, I recommend to follow the Altinity Blog but today I want to look at the improved integration of ClickHouse and MySQL. There are two features:...
by David Quilty | Jan 30, 2020 | MariaDB, MySQL, Webinars
At the moment, MySQL 8 and MariaDB 10.4 are the latest versions of the corresponding database management systems. Each of these DBMS has a unique set of features. For example, specific MariaDB features might be unavailable in MySQL, and vice versa. In this...
by Vadim Tkachenko | Jan 23, 2020 | MySQL, Percona Software
From the initial release, one of the biggest complaints I had about Group Replication is that it allowed “stale” reads and there was no way to prevent them or to even know that you read “stale” data. That was a huge limitation. Thankfully, Oracle released features to...
by Yves Trudeau | Jan 22, 2020 | Insight for DBAs, MySQL, Percona Software, Storage Engine
As the second part of the earlier post Give Love to Your SSDs – Reduce innodb_io_capacity_max! we wanted to put together some concepts on how InnoDB flushing works in recent Percona Server for MySQL versions (8.0.x prior to 8.0.19, or 5.7.x). It is important to...
by Daniel Guzmán Burgos | Jan 21, 2020 | Cloud, MySQL, Percona Software, ProxySQL
Being that Amazon is one of the most-used cloud vendors, it is only natural that one may ask “How can Kubernetes be used in AWS?”. And the answer is – not that different than with other cloud vendors. What one needs is two things (and this applies...
by Peter Zaitsev | Jan 20, 2020 | Monitoring, MySQL, Percona Software
If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table. You might assume these hashes are stable between different versions, so, for example,...
by Vadim Tkachenko | Jan 17, 2020 | MySQL, Percona Software
Percona Server for MySQL 8.0.18 ships all functionality to run Group Replication and InnoDB Cluster setups, so I decided to evaluate how it works and how it compares with Percona XtraDB Cluster in some situations. For this I planned to use three bare metal nodes, SSD...
by Agustín | Jan 15, 2020 | MySQL, Percona Software
In a previous post Profiling Software Using perf and Flame Graphs, we took a look at how to generate Flame Graphs from perf outputs. In this short follow-up, we will use Flame Graphs to process outputs from pt-pmp. Flame Graphs were not originally thought of for this...
by Alkin Tezuysal | Jan 15, 2020 | Cloud, Insight for DBAs, MySQL
In this blog post, we will continue to explore Vitess and test an example database provided in its repository. This is Part III of the previously discussed installation of Vitess on minikube environment, so please make sure to follow those steps to bring the cluster...
by Alkin Tezuysal | Jan 14, 2020 | Cloud, Insight for DBAs, MySQL
In this blog post, I’d like to share some experiences in setting up a Vitess environment for local tests and development on OSX/macOS. As previously, I have presented How To Test and Deploy Kubernetes Operator for MySQL(PXC) in OSX/macOS, this time I will be showing...
by Alok Pathak | Jan 14, 2020 | Cloud, Insight for DBAs, MySQL
The promise of DBaaS like RDS is to reduce operational overhead (among other things) and one of the stellar cases is upgrades (major and minor). The suggested procedure involves just a couple of steps. For example, using AWS Console, you can enable “Auto minor...
