by Arunjith Aravindan | Aug 8, 2023 | Insight for DBAs, MySQL
The clone plugin was introduced in MySQL 8.0.17 and offers a convenient method for cloning data from either a local or remote MySQL server instance. This cloning process creates a physical snapshot of the data stored in InnoDB, including schemas, tables, tablespaces,...
by Peter Sylvester | Aug 8, 2023 | Insight for DBAs, Monitoring, MySQL
As businesses grow and develop, the requirements that they have for their data platform grow along with it. As such, one of the more common questions I get from my clients is whether or not their system will be able to endure an anticipated load increase. Or worse...
by Arunjith Aravindan | Aug 7, 2023 | Insight for DBAs, MySQL
In InnoDB, the undo log and the redo log are two indispensable components that play a vital role in maintaining data integrity and ensuring transactional consistency. Both logs are crucial in the ACID (Atomicity, Consistency, Isolation, Durability) properties of...
by Manjot Singh | Aug 5, 2023 | Insight for DBAs, MySQL
This blog was originally published in July 2017 and was updated in August 2023. It’s a pretty common question around here, so let’s see what we can do about that. So, What is MySQL Partitioning? Partitioning is a way in which a database (MySQL in this...
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...
