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...
by Marco Tusa | Nov 10, 2022 | MySQL, Percona Software, ProxySQL, Security
Every day we use dozens if not hundreds of applications connecting to some kind of data repository. This simple step is normally executed over the network and, given so, it is subject to possible sniffing with all the possible related consequences. Given that, it is...
by David Stokes | Nov 9, 2022 | Insight for Developers, MySQL, Percona Software
MySQL 8.0.31 added INTERSECT and EXCEPT to augment the long-lived UNION operator. That is the good news. The bad news is that you have to be careful using the EXCEPT operator as there is a trick. Let’s start with some simple tables and load some simple data. SQL...
by Fernando Mattera | Nov 3, 2022 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
Hey folks,This blog is straightforward but, at the same time, handy. At Percona, we know that the audience of our blogs is not limited to DBAs but includes a broader range of IT professionals, such as sysadmins, help desk employees, NOC operators, and developers as...
by Pep Pla | Nov 3, 2022 | Hardware and Storage, Insight for DBAs, MySQL, Open Source
Raspberry PI is a small single-board computer (SBCs) developed by the Raspberry Pi Foundation in association with Broadcom. This tiny computer is extremely popular and widely used in many areas. Thanks to its size, low cost, and low energy requirements, it can be used...
