by Peter Zaitsev | Aug 4, 2023 | Database Trends, MariaDB, MySQL, Percona Software
In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. It is worth noting both MySQL and MariaDB have Community and Enterprise versions. For MySQL, both releases...
by Corrado Pandiani | Aug 3, 2023 | Insight for Developers, MySQL, Open Source
In this article, I want to discuss a couple of pretty new features in MySQL 8.0 — and an older one. Maybe these are minor features you are not aware of, and maybe not so relevant, to be honest. But it is worth providing a quick overview, showing how they work, and how...
by David Stokes | Aug 2, 2023 | Insight for DBAs, MySQL
The MySQL 5.7 End of Life is now two months away. Those of you who have waited may be wondering which is the best way to upgrade – an In-Place or Logical upgrade. An In-Place upgrade is where the binaries for 5.7 are replaced with the binaries for 8.0, and the...
by Brijesh Chauhan | Aug 2, 2023 | Insight for DBAs, Monitoring, MySQL
Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Monitoring the progress of the restore process is essential to estimate completion time and ensure everything is proceeding smoothly. In this blog...
by Kedar Vaijanapurkar | Aug 1, 2023 | Insight for DBAs, MySQL
In the world of database management, ALTER TABLE operations are a crucial part of modifying database structures. MySQL, a popular database management system, offers online operations since version 5.6, providing a convenient way to perform these alterations without...
by Fernando Mattera | Aug 1, 2023 | Cloud, Insight for DBAs, Insight for Developers, MySQL
Hello friends! If you plan to migrate your database from on-prem servers to RDS (either Aurora or MySQL RDS), you usually don’t have much choice but to do so using logical backups such as mysqldump, mysqlpump, mydumper, or similar. (Actually, you could do a...
by Yunus Uyanik | Jul 31, 2023 | Insight for DBAs, Insight for Developers, MySQL
Dynamic SQL is a desirable feature that allows developers to construct and execute SQL statements dynamically at runtime. While MySQL lacks built-in support for dynamic SQL, this article presents a workaround using prepared statements. We will explore leveraging...
by David Stokes | Jul 31, 2023 | Database Trends, Insight for DBAs, MySQL
Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the...
by Bartek Gatz | Jul 27, 2023 | Insight for DBAs, MySQL, Percona Software
On July 18th, Oracle released its first pair of MySQL LTS and Innovation releases. (For more, check out A Quick Peek at MySQL 8.0.34 and MySQL 8.1.0.) These releases were announced several months ago and gradually detailed closer to the release date. Today, we know...
by David Stokes | Jul 27, 2023 | Insight for DBAs, MySQL
This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 and 8.1.0 on July 17th, 2023. MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. Many people loved access to the new features even...
by Satya Bodapati | Jul 25, 2023 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 (PXB), which significantly reduces the time to prepare the backups before the restore operation. This improvement in Percona XtraBackup significantly reduces the time required for a...
by Marcelo Altmann | Jul 25, 2023 | Insight for DBAs, MySQL, Percona Software
When it comes to backups, there are several options for saving backup files. You can choose to save them locally on the same server, stream them to different servers, or store them in object storage. Percona XtraBackup facilitates streaming through the use of an...
by Taras Onishchuk | Jul 19, 2023 | Monitoring, MySQL, Percona Software
When adding a remote MySQL instance to Percona Monitoring and Management (PMM), there are a few options you can specify during the setup, but they are not editable once added. For example, a table statistics limit is introduced to avoid querying...
by Matthew Boehm | Jul 19, 2023 | Insight for DBAs, Insight for Developers, MySQL
by Corrado Pandiani | Jul 15, 2023 | Insight for DBAs, Insight for Developers, MySQL, Percona Software
This blog was originally published in January 2022 and was updated in July 2023. Working with hundreds of different customers, I often face similar problems around running queries. One very common problem when trying to optimize a database environment is index usage....
by Arunjith Aravindan | Jul 13, 2023 | Insight for DBAs, MySQL
In the world of modern web applications, it is increasingly important to support a diverse range of languages and character sets. With the rise of globalization, the need to store and process multilingual data has become essential. MySQL, one of the most popular...
by Pep Pla | Jul 5, 2023 | Insight for DBAs, Insight for Developers, MySQL
Fragmentation is a common concern in some database systems. Highly fragmented tables can affect performance and resource allocation. But reducing fragmentation often involves rebuilding the table completely. This blog post will discuss fragmentation and its impact on...
by Ananias Tsalouchidis | Jul 1, 2023 | Cloud, Insight for DBAs, MySQL, ProxySQL
This post was originally published in July 2018 and was updated in July 2023. Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should...
by Yoann La Cancellera | Jun 28, 2023 | Insight for DBAs, MySQL, Percona Software
Recently, I was working on a very unfortunate case that revolved around diverging clusters, data loss, missing important log errors, and forcing commands on Percona XtraDB Cluster (PXC). Even though PXC tries its best to explain what happens in the error log, I can...
by Bhuvanes Waran | Jun 27, 2023 | Insight for DBAs, MySQL, Percona Software
MySQL Shell is an advanced client and code editor for MySQL. In addition to the provided SQL functionality, similar to MySQL, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. The X DevAPI enables you to...