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 David Quilty | Jan 20, 2020 | Percona Services, Percona Software
It’s release roundup time here at Percona! In our continued effort to make it a little easier for you to keep track of our latest releases and updates, every few weeks a Release Roundup showcases the latest in software updates, tools, and features to help you...
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 Peter Zaitsev | Jan 15, 2020 | Monitoring, Percona Software
April 2021 Update: From Percona Monitoring and Management 2.27, the procedure is now simplified and it is possible by running: docker exec pmm-server change-admin-password <new_password> 1 docker exec pmm-server change-admin-password <new_password> ...
by Andrew Pogrebnoi | Jan 14, 2020 | MongoDB, Percona Software
Prior to version 1.0, Percona Backup for MongoDB (PBM) had a separate coordinator daemon as a key part of its architecture. The coordinator was handling all communications with backup agents and the control program. It held a PBM configuration and backups list, made a...
by Marco Tusa | Jan 10, 2020 | MySQL, Percona Software
In the many years we have used MySQL, we got accustomed to the fact that upgrades from MySQL 5.7.11 to 5.7.12 was a minor event. This meant that if something was going wrong, we could roll back the binaries and be happy again. From MySQL 8, this is no longer true....
by Walter Garcia | Jan 10, 2020 | MySQL, Percona Software, ProxySQL
If you are thinking of using ProxySQL in our Percona XtraDB Cluster environment, I’ll explain how to use ProxySQL 2 for failover tasks. How to Test ProxySQL uses the “weight” column to define who is the WRITER node. For this example, I’ll use...
by David Quilty | Jan 8, 2020 | Percona Services, Percona Software
It’s release roundup time here at Percona! We publish quite a few updates to our software and services, so we wanted to make it a little easier for you to keep track of our latest releases. Today’s post includes Percona releases and updates from the last...
by Zsolt Parragi | Jan 6, 2020 | MySQL, Percona Software, Security
Starting with Percona Server for MySQL 8.0.17, Percona Server ships with a data masking plugin, using the same API as the MySQL Enterprise Masking and De-identification feature. This plugin was developed by MySQL Enterprise plugin. What is Data Masking? The data...
by David Quilty | Jan 5, 2020 | MongoDB, Open Source, Percona Software, Webinars
Join Rick Vasquez, Chief of Staff to the CXO, for an engaging webinar on MongoDB Atlas vs Managed Community Edition! In this webinar, we discuss at length the implications that MongoDB’s decision to change licensing from AGPL to SSPL had on the broader landscape...
by Terri Schlosser | Jan 3, 2020 | Cloud, Monitoring, MySQL, Percona Software
Percona Monitoring and Management 2.2 (PMM) was released on December 24th with new features and updates designed to help you more easily manage and monitor your open source databases across your multi-cloud and hybrid-cloud environments. Let’s take a look at a few of...
by Arunjith Aravindan | Dec 27, 2019 | MySQL, Percona Software
This blog discusses a few concepts about Docker and how we can use it to run a MySQL async replication environment. Docker is a tool designed to make it easier for developers and sysadmins to create/develop, configure, and run applications with containers. The...
by Daniel Guzmán Burgos | Dec 19, 2019 | Monitoring, MySQL, Percona Software
Percona Monitoring and Management (PMM) is built upon the shoulder of giants like Prometheus and Grafana. And speaking of Grafana, one of the coolest features that come with it is the ability to customize the experience through 3rd party plugins. Plugins are an easy...
by David Quilty | Dec 18, 2019 | MySQL, Percona Software, Webinars
This talk uncovers which tools/plugins/settings you need to use to comply with PCI/DSS when using MySQL. Gain a solid grasp of the possibilities, as well as the limitations, MySQL offers to someone looking to become PCI/DSS certified. Please join Percona Support...
by David Quilty | Dec 17, 2019 | Percona Services, Percona Software
It’s release roundup time here at Percona! We publish quite a few updates to our software and services every week, so we wanted to make it a little easier for you to keep track of our latest releases. It’s been a busy couple of weeks here at Percona!...
