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...
by Eduardo Krieg | Jun 23, 2023 | Insight for DBAs, MySQL, Percona Software
In Percona Managed Services, one key aspect of managing the databases is configuring backups. Percona XtraBackup is one of the best tools for performing physical database backups. It is a good practice to compress the backups to save costs on storage and to encrypt...
by Smit Arora | Jun 20, 2023 | Insight for DBAs, MySQL
Often while managing and creating new users, we use all the default options and tend not to use extra features provided by MySQL. These extra options could prevent a user from using all the resources and degrading the performance of MySQL. In this blog, we will...
by Larry Xia | Jun 15, 2023 | Insight for DBAs, MySQL, Percona Software
Sometimes we might need to install/upgrade Percona Server for MySQL/MySQL 8 to a particular version in a test or production environment. The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be...
by Pete Scott | Jun 12, 2023 | Insight for DBAs, MySQL, Percona Software, PostgreSQL
When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied....
