by Sergey Pronin | Apr 20, 2021 | Cloud, MySQL, Percona Software
Percona Kubernetes Operators support various options for storage: Persistent Volume (PV), hostPath, ephemeral storage, etc. In most of the cases, PVs are used, which are provisioned by the Operator through Storage Classes and Persistent Volume Claims. Storage Classes...
by Sri Sakthivel | Apr 19, 2021 | Insight for DBAs, Insight for Developers, MySQL
MySQL Group Replication is a plugin that helps to implement highly available fault-tolerant replication topologies. In this blog, I am going to explain the complete steps involved in the below two topics. How to convert the group replication member to an asynchronous...
by Marco Tusa | Apr 15, 2021 | Insight for DBAs, MySQL, Percona Software
While I was working on my grFailOver POC, I have also done some additional parallel testing. One of them was to see how online DDL is executed inside a Group Replication cluster. The online DDL feature provides support for instant and in-place table alterations and...
by Marco Tusa | Apr 14, 2021 | Insight for DBAs, MySQL, Open Source, Percona Software
Where x is >= 22 😉 The Problem There are few things your data does not like. One is water and another is fire. Well, guess what: If you think that everything will be fine after all, take a look: Given my ISP had part of its management infrastructure on OVH, they...
by Marco Tusa | Apr 14, 2021 | Insight for DBAs, MySQL, Open Source, Percona Software
This blog provides high availability (HA) guidelines using group replication architecture and deployment recommendations in MySQL, based on our best practices. Every architecture and deployment depends on the customer requirements and application demands for high...
by Marcelo Altmann | Apr 12, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Chasing bugs can be a tedious task, and multi-threaded software doesn’t make it any easier. Threads will be scheduled at different times, instructions will not have deterministic results, and in order for one to reproduce a particular issue, it might require the...
by Michael Patrick | Apr 7, 2021 | MySQL, Open Source, Percona Services, Percona Software
So your MySQL server has crashed. What do you do now? When a server is down, in my opinion, there are two steps that are essential and both are extremely important and neither should be neglected: Save diagnostic information for determining the root cause analysis...
by Sergey Pronin | Apr 7, 2021 | Cloud, MongoDB, MySQL, Percona Software
Percona Kubernetes Operators allow users to simplify deployment and management of MongoDB and MySQL databases on Kubernetes. Both operators allow users to store backups on S3-compatible storage and leverage Percona XtraBackup and Percona Backup for MongoDB to deliver...
by Mike Benshoof | Apr 6, 2021 | MySQL, Percona Software, Storage Engine
As database footprints continue to explode, many companies are looking for ways to deal with such rapid growth. One approach is to refactor traditional relational databases to fit into a NoSQL engine, where horizontal scalability is easier. However, in many cases,...
by Sveta Smirnova | Apr 2, 2021 | Insight for DBAs, MySQL, Percona Software
Recovering to a particular time in the past is called Point-In-Time Recovery (PITR). With PITR you can rollback unwanted DELETE without WHERE clause or any other harmful command. PITR with Percona XtraBackup is pretty straightforward and perfectly described in the...
by Mike Benshoof | Apr 2, 2021 | Insight for DBAs, MySQL, Percona Services
Nobody likes change, especially when that change may be challenging. When faced with a technical challenge, I try to remember this comment from Theodore Roosevelt: “Nothing in the world is worth having or worth doing unless it means effort, pain, difficulty.” While...
by Mike Benshoof | Apr 1, 2021 | MySQL, Percona Software, Storage Engine
Percona Technical Account Managers get the privilege of working with some of our largest enterprise clients day in and day out. As such, we get to really focus on how to best leverage our technology to generate measurable benefits for our users. While it is fun to...
by Sergey Pronin | Apr 1, 2021 | Cloud, MySQL, Open Source, Percona Software
It is no secret that compute and storage costs are the main drivers of cloud bills. Migration of data from the legacy data center to the cloud looks appealing at first as it significantly reduces capital expense (CapEx) and keeps operational expenses (OpEx) under...
by David Quilty | Mar 31, 2021 | Insight for DBAs, MySQL, Percona Software, Webinars
Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs. The databases powering applications need to be able to handle changing traffic workloads while remaining responsive and stable in order...
by Brian Sumpter | Mar 31, 2021 | Insight for DBAs, MySQL
As many of you may remember, Percona added the super_read_only feature way back in Percona Server for MySQL 5.6.21, based on work done by WebScaleSQL. This feature eventually found its way into the Community branch of MySQL starting with 5.7.8, and it works the same...
by Sri Sakthivel | Mar 26, 2021 | Insight for DBAs, Insight for Developers, MySQL, Storage Engine
For MySQL, MyISAM and InnoDB storage engines are very popular. Currently, we are mostly using InnoDB engines for high reliability and high performance. Apart from those engines, we also have some other alternative engines and they have some nice features in them. In...
by Kathy Williamson | Mar 25, 2021 | Insight for Developers, MySQL, Percona Software
Have you ever wondered what it takes to complete Percona Server for MySQL (PS), Percona XtraDB Cluster (PXC), and Percona XtraBackup (PXB) releases? Let’s step back just a minute and talk about what Percona stands for. We believe we “stand on the shoulders of...
by Sri Sakthivel | Mar 24, 2021 | Insight for DBAs, MySQL
Transportable tablespaces were introduced in MySQL 5.6. Using this feature, we can directly copy a tablespace to another server and populate the table with data. This is a very useful feature for large tables. The transportable tablespace mechanism is faster than any...
by David Ducos | Mar 23, 2021 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Starting a long time ago, we wanted to reproduce workload in a non-production environment, and there were different attempts to achieve that goal (Query Playback is just one of them). But there is another point of view, where you need to write your own workload to do...
by Patrick Birch | Mar 23, 2021 | MySQL, Percona Announcements, Percona Software
Due to CVE-2020-29488, Percona XtraBackup is modifying how xbstream handles absolute paths to prevent malicious file injections. Like the tar archiving utility, the new behavior removes the leading ‘/’ character and references to the parent directory....
