by Carlos Salguero | Jun 10, 2020 | Monitoring, MySQL, Percona Software
Even though Percona Monitoring and Management 2 (PMM) comes with a lot of dashboards and metrics out of the box, sometimes we need to extend the default metrics by running custom MySQL queries. For example, suppose you want to have information about cached indexes...
by Rachel Pescador | Jun 9, 2020 | Database Trends, MySQL, Percona Services, Percona Software
Our latest Solution Brief uses our relationship with Patreon to detail the ways that Percona services work together to provide customers with a complete database infrastructure solution. Last year Patreon enlisted Percona’s help with their MySQL databases. Utilizing...
by Sveta Smirnova | Jun 4, 2020 | MySQL, Percona Software, Webinars
First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page. Here are answers to the questions from participants which I was not able to provide...
by Carlos Tutte | Jun 3, 2020 | MySQL, Security
In systems nowadays, improving security is a must! One of the weakest links in the security system is the user password from where an attacker can enter. In order to improve password strength and security, MySQL provides a plugin called “Validation plugin” which can...
by Daniil Bazhenov | Jun 3, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
Percona engineers often need to analyze and review complex SQL database queries. Good formatting can make these SQL queries much easier to understand and work with. Without clear formatting, queries can become confusing and hard to debug. Online query formatting...
by Agustín | Jun 1, 2020 | Insight for DBAs, MySQL, Open Source
In a previous post, Using DBdeployer to manage MySQL, Percona Server, and MariaDB sandboxes, we covered how we use DBdeployer within the Support Team to easily create MySQL environments for testing purposes. Here, I will expand on what Peter wrote in Installing MySQL...
by David Quilty | May 29, 2020 | MySQL, Webinars
Join Peter Zaitsev, CEO at Percona, as he discusses eBFT. eBPF is one of the most powerful instrumentation frameworks in modern Linux Kernel. In this presentation, we will cover eBPF basics as well as usage of Interactive eBPF tools, showing practical examples when...
by Daniil Bazhenov | May 28, 2020 | Insight for DBAs, MySQL, Open Source, Percona Software
Open-source companies live by their community. Favorable buzz by community users is ultimately what’s made Percona software successful. Some users make further contributions in the form of expertise, source code, documentation, and more. As an open-source company in...
by Matthew Boehm | May 27, 2020 | MySQL, Percona Services, Percona Software
Here in Percona’s Training department, we like to think that we instruct our learners on the best practices for all things MySQL-related. In addition to performance tuning, query optimization, and replication configurations, another important topic is backups....
by David Quilty | May 26, 2020 | MySQL, Webinars
Join Alkin Tezusal, Percona Technical Expert, as he covers the past, present, and future of MySQL as an Open Source Database. During this webinar he will discuss: * Use cases of MySQL as well as edge cases of MySQL topologies using real-life examples and...
by Stephen Thorn | May 22, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
Database backups are a fundamental requirement in almost every implementation, no matter the size of the company or the nature of the application. Taking a backup should be a simple task that can be automated to ensure it’s done consistently and on schedule....
by Matthew Boehm | May 21, 2020 | Database Trends, MySQL, Open Source, Percona Services
Percona Training Is Here for You! Percona’s Training and Education Department wants you! For the past three years, Percona has quietly been delivering world-class training all over the globe, to companies large and small. We are in full force and ready to spread...
by Marco Tusa | May 18, 2020 | MySQL, Percona Software
Percona has enforced stronger security in Percona XtraDB Cluster (PXC) 8, but this requires some attention during the rollout of the new server version, so let see the why and what. In PXC there are two different kinds of traffic: client-server exchange (ie:...
by David Quilty | May 15, 2020 | MySQL, Percona Software, Webinars
During this webinar, Tyler Duzan, Product Manager for MySQL and Cloud at Percona, will discuss Percona’s decision to delay Percona XtraDB Cluster 8.0 to ship it with Galera 4 instead of Galera 3, and why that matters. In addition, he’ll talk about the work...
by Vadim Tkachenko | May 15, 2020 | MySQL, Percona Software
Percona XtraDB Cluster 8.0 comes with an upgraded Galera 4.0 library, which provides a new feature – streaming replication. Let’s review what it is and when it might be helpful. Previous versions of Percona XtraDB Cluster with Galera 3.x had a limitation...
by Yves Trudeau | May 14, 2020 | Insight for DBAs, MySQL
In this post, the third in a series explaining the internals of InnoDB flushing, we’ll focus on tuning. (Others in the series can be seen at InnoDB Flushing in Action for Percona Server for MySQL and Give Love to Your SSDs – Reduce innodb_io_capacity_max!)...
by Tibor Korocz | May 13, 2020 | MySQL, Percona Software
I was testing the latest Percona XtraDB Cluster 8.0 (PXC) release which has the Galera 4 plugin, and I would like to share my experiences and thoughts on the Streaming Replication feature so far. What Is Streaming Replication, in One Sentence? In Galera 4, the large...
by David Ducos | May 13, 2020 | Insight for DBAs, MySQL, Percona Software
pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. It executes INSERT statements to import the data, that runs in a single connection to fill the new table. In this repository, there is...
by Stephen Thorn | May 7, 2020 | Cloud, Insight for DBAs, MySQL, Percona Software
As a Solutions Engineer at Percona, one of my responsibilities is to support our customers as they investigate new and emerging technologies. This affords me the opportunity to speak to many current and new customers who partner with Percona. The topic of Kubernetes...
by Jake Davis | May 7, 2020 | Insight for DBAs, MySQL
In Percona’s Managed Services, we start up and shut down MySQL servers all the time. Over the years, we’ve seen various issues occur due to the way servers are shut down. No matter if it is a situation where unexpected errors appear in the log or...
