by Michael Patrick | Feb 1, 2024 | Insight for DBAs
This blog was originally published in June 2016 but was updated in February 2024. In this blog post, we’ll look at various MySQL high availability (HA) solutions, detailing their advantages and disadvantages to equip you with the insight required for informed...
by Przemysław Malkowski | Jan 31, 2024 | Insight for DBAs, Insight for Developers, MySQL
It is a known good practice to keep only necessary indexes to reduce the write performance and disk space overhead. This simple rule is mentioned briefly in the official MySQL Documentation: https://dev.mysql.com/doc/refman/8.0/en/optimization-indexes.html However, in...
by Vinicius Grippa | Jan 18, 2024 | Insight for DBAs, MySQL
In this blog post, we will discuss how to validate at the operating system level the effects of changing the innodb_flush_method to variations other than the default (particularly for O_DIRECT which is most commonly used) and the use of innodb_use_fdatasync....
by David Stokes | Jan 17, 2024 | Insight for DBAs, MySQL
Oracle recently released MySQL 8.0.36 and MySQL 8.3, and this is a perusal of the release notes to determine what is new, what is in the seventy-three bugs fixed, and what has changed in the three months since the last releases. Comments in italics are my own and do...
by Edwin Wang | Jan 12, 2024 | Insight for DBAs, Insight for Developers, MySQL
by Marco Tusa | Jan 11, 2024 | Benchmarks, MySQL, Percona Software, ProxySQL
In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones. Most importantly, we also had...
by Ivan Groenewold | Jan 9, 2024 | Insight for DBAs, MySQL, Open Source
When working with group replication, MySQL router would be the obvious choice for the connection layer. It is tightly coupled with the rest of the technologies since it is part of the InnoDB cluster stack. The problem is that except for simple workloads, MySQL...
by Eduardo Krieg | Jan 8, 2024 | Insight for DBAs, MySQL
One of the most underlooked parameters to configure MySQL is server_id, which is an integer number to identify a server inside a replication topology uniquely. Note that two servers within a replication set can’t have the same server_id value. It is generally set up...
by Yunus Shaikh | Jan 5, 2024 | Cloud, MySQL, Security
The AWS KMS component is now available in Percona Server for MySQL starting from version 8.0.30. This addition enables data-at-rest encryption by utilizing the AWS KMS component, providing the functionality to create and manage cryptographic keys across AWS services....
by Arunjith Aravindan | Jan 4, 2024 | Insight for DBAs, MySQL, Security
Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. This blog discusses general tablespaces and explores their functionalities, benefits, and practical usage, along with...
by Balchandar Reddy Voodem | Jan 3, 2024 | Insight for DBAs, MySQL, ProxySQL
ProxySQL is a high-performance SQL proxy that runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime. The daemon accepts incoming traffic from MySQL clients and forwards it to backend...
by Francisco Bordenave | Jan 2, 2024 | Insight for DBAs, MySQL
TL&DR: Depending on the workload, the thread pool plugin can cause serious performance drops. This post was motivated by two recent cases I’ve worked with. Two setups running in cluster mode: one in MariaDB+Galera and one with Percona XtraDB Cluster (Percona...
by Michael Villegas | Jan 2, 2024 | Insight for DBAs, MySQL, Percona Software, Security
Managing database servers involves different aspects, among which security is critical. We know that we should always grant the minimal required permissions to the different user accounts in the database, as having a user with high-level permission can lead to...
by Oleksandr Kachan | Dec 28, 2023 | Insight for DBAs, MySQL, Percona Software
We’re happy to introduce Audit Log Filter — our newly upgraded audit plugin. Its functionality has been significantly improved in comparison to Audit Log and currently mirrors the functionality of the MySQL Enterprise Audit plugin. Starting with Percona Server for...
by Brijesh Chauhan | Dec 20, 2023 | Insight for DBAs, MySQL
The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to accelerate query performance. In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to...
by Mani Paluru | Dec 13, 2023 | Insight for DBAs, MySQL
Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing...
by Larry Xia | Dec 12, 2023 | Insight for DBAs, MySQL, Percona Software
In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’s...
by Kedar Vaijanapurkar | Dec 11, 2023 | Cloud, Insight for DBAs, MySQL
A quick configuration change may do the trick in improving the performance of your AWS RDS for MySQL instance. Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. While this...
by Totel | Dec 8, 2023 | Insight for DBAs, MySQL, Percona Software
In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. Let us...
by Mohit Joshi | Dec 7, 2023 | Insight for DBAs, MySQL, Percona Software
Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of...