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
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...
by Corrado Pandiani | Nov 2, 2022 | Insight for Developers, MySQL
Are you familiar with the UNION statement for your SQL queries? Most likely, you are. It has been supported for a long time. In case you are not familiar with UNION, don’t worry, I’m going to show you how it works with simple examples. Considering...
by Mario García | Nov 1, 2022 | Insight for DBAs, MySQL, Open Source
For testing purposes, especially if you’re working on a project that uses any database technology to store information, you may need data to try out your project. In that case, you have two options: Find a good dataset (Kaggle) or, Use a library like Faker...
by Vadim Tkachenko | Oct 31, 2022 | Cloud, Insight for DBAs, MySQL
To follow up on my previous Kubernetes articles: Installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation) and Have Percona Server for MySQL running (Using Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL...
by Michael Villegas | Oct 27, 2022 | Insight for DBAs, MySQL, Percona Software
by David Stokes | Oct 25, 2022 | Cloud, Insight for DBAs, MySQL
This week is KubeCon in Detroit, and in preparation for attending I have been polishing up my Kubernetes skills. This big rush to put software in containers and have Kubernetes run everything is getting a lot of push in the industry. Many software applications run...
by Vadim Tkachenko | Oct 14, 2022 | Cloud, Insight for DBAs, MySQL, Percona Software
As we have Kubernetes installed in part one (see Using Percona Kubernetes Operators With K3s Part 1: Installation) and have Percona Server for MySQL running (Using Percona Kubernetes Operators With K3s Part 2: Percona Server for MySQL Operator) lets review how we can...
by Vadim Tkachenko | Oct 13, 2022 | MySQL, Open Source, Percona Software
MySQL is an outstanding database for online transaction processing. With suitable hardware, it is easy to execute more than 1M queries per second and handle tens of thousands of simultaneous connections. Many of the most demanding web applications on the planet are...
by David Stokes | Oct 12, 2022 | Insight for DBAs, Insight for Developers, MySQL
Oracle releases updates to MySQL on a quarterly basis and the Release Notes for 8.0.31 arrived just before the software. This time around there are some very interesting new features that will be handy including SQL standards support, as well as over 130 bug fixes....
