by Arunjith Aravindan | Dec 12, 2022 | Insight for DBAs, MySQL, Percona Software
Table modifications are a common task for database administrators. In this blog, I’ll explain how to alter tables online in a controlled manner that does not disrupt application users or cause application downtime. One of the tools in Percona Toolkit is...
by Mani Paluru | Dec 8, 2022 | Insight for DBAs, MySQL
In this blog, I’m going to discuss how to easily skip the replication errors in GTID (Global Transaction Identifier)-based replication. In the MySQL world, if replication is broken we all use the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; to skip the...
by Zsolt Parragi | Dec 8, 2022 | MySQL, Percona Software
Percona Server for MySQL 8.0.30-22 introduces a new authentication plugin, named authentication_fido. With this new plugin, it is possible to perform multi-factor authentication using hardware keys, or single-factor passwordless authentication with the same keys. This...
by Zsolt Parragi | Dec 6, 2022 | Insight for DBAs, MySQL, Percona Software
Percona Server for MySQL 8.0.30-22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. All improvements are in technical preview. A description of the existing plugin features and...
by Mughees Ahmed | Dec 6, 2022 | Insight for DBAs, MySQL, Percona Software
What is a Delay Replica and how does it help? MySQL Replication is useful, easy to set up, and used for very different purposes. For example: split reads and writes run data mining or reporting processes on them disaster recovery To learn more, check out How Does...
by Yunus Shaikh | Dec 5, 2022 | MySQL, ProxySQL
ProxySQL is a very useful tool for gaining high availability, load balancing, query routing, query caching, query rewriting, multiplexing, and data masking. It is a proven tool and is used largely in production. There can be an instance of ProxySQL using a lot of...
by David Stokes | Dec 5, 2022 | Insight for DBAs, MySQL, Percona Software
The need to audit who is using a database and their activities is crucial in many environments. This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log...
by Anil Joshi | Dec 2, 2022 | Database Trends, Insight for Developers, MySQL, Open Source
Database-as-code service is a new concept and gaining some popularity in recent years. As we already know, we have deployment solutions for application code. Managing and tracking application changes are quite easy with tools like Git and Jenkins. Now this concept is...
by David Stokes | Dec 1, 2022 | Insight for DBAs, MySQL, Percona Software
Data masking is a handy tool to obscure sensitive information. Percona Server for MySQL is a free, fully compatible, enhanced, and open source drop-in replacement for any MySQL database. It provides superior performance, scalability, and instrumentation including...
by David Ducos | Nov 30, 2022 | Cloud, Insight for DBAs, MySQL
If you are using MyDumper as your Logical Backup solution and you store your backups on S3, you need to take a local backup and then upload it to S3. But what if there is not enough space to hold the backup on the server where we are taking the backup? Even if we have...
by Gaurav Pareek | Nov 29, 2022 | Insight for DBAs, MySQL, Percona Software
We all know that data is important, and some businesses need historical data to be available all the time. The problem is that queries on large tables perform poorly if they are not properly optimized. We get many customer requests in Managed Services to purge/archive...
by Peter Sylvester | Nov 29, 2022 | Insight for DBAs, Monitoring, MySQL, Percona Software
Earlier in the year, I was working on an issue where one of my clients had reported a massive influx in connection on their hosts after enabling Percona Monitoring and Management (PMM). This was something I had not seen before and after researching for a couple of...
by Anil Joshi | Nov 25, 2022 | Cloud, Insight for DBAs, MySQL
In this blog post, I will try to cover a few dump and data-loading utilities offered by MySQL Shell. What is MySQL Shell? It is a robust client and code editor for MySQL. In addition to having APIs for dealing with MySQL, MySQL Shell offers scripting capabilities for...
by Peter Sylvester | Nov 23, 2022 | Insight for DBAs, MySQL, Percona Software
One thing I commonly hear when working with my clients is “I want to change my DDL strategy in order to avoid locking in my database! The last time I used the same old method I ended up in a metadata lock situation!” I agree that metadata locks can be painful, but...
by Marco Tusa | Nov 23, 2022 | Insight for DBAs, MySQL, Security
What is dual password in MYSQL and how it works was already covered by my colleague Brian Sumpter in Using MySQL 8 Dual Passwords. However, let me do a brief recap here about it. Dual password is the MySQL mechanism that allows you to keep two passwords active at the...
by Sergey Pronin | Nov 22, 2022 | Cloud, MySQL, Percona Software
Percona loves and embraces Kubernetes. Percona Operators have found their way into the hearts and minds of developers and operations teams. And with growing adoption, we get a lot of valuable feedback from the community and our support organization. Two of the most...
by Marcelo Altmann | Nov 18, 2022 | Insight for DBAs, MySQL, Percona Software
Taking a MySQL backup using Percona XtraBackup (PXB) consists of basically two steps: 1) take the backup and 2) prepare the backup. Briefly speaking, taking a backup means that PXB will copy all of the files from your instance and transfer them to another location....
by Marcelo Altmann | Nov 17, 2022 | Insight for DBAs, MySQL, Percona Software
Having a backup of your database is like insurance, you have to pay a monthly price to ensure you have a service available when you need to. When talking about backups, the storage required to keep your backups is what comes into factor when talking about price, the...
by Larry Xia | Nov 14, 2022 | Insight for DBAs, MySQL
At Percona Managed Services, sometimes clients’ applications face deadlock situations and need all historic deadlock information for application tuning. We could get the LATEST DETECTED DEADLOCK from SHOW ENGINE INNODB STATUSG: Shell …. ------------------------...
by Sergey Pronin | Nov 10, 2022 | Cloud, MySQL, Percona Software
This blog post continues the series of comparisons of solutions to run databases on Kubernetes. Previous blog posts: Run MongoDB in Kubernetes: Solutions, Pros and Cons Run PostgreSQL in Kubernetes: Solutions, Pros and Cons The initial release of MySQL was in 1995 and...
