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....
by Colin Charles | Jun 4, 2023 | Insight for DBAs, MariaDB, MySQL
This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL). Introduction: MariaDB vs. MySQL The goal of this blog post is to...
by Joe Brockmeier | Jun 2, 2023 | Database Trends, MySQL, Open Source
WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions. It...
by Peter Zaitsev | Jun 1, 2023 | Insight for Developers, MySQL
Updated June 1, 2023. Suboptimal MySQL ORDER BY implementation, especially together with MySQL LIMIT is often the cause of MySQL performance problems. Here is what you need to know about MySQL ORDER BY LIMIT optimization to avoid these problems. Try Now: Free your...
by Fernando Mattera | Jun 1, 2023 | Insight for DBAs, MariaDB, MySQL, Percona Software
Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem. In this case, we will be analyzing the migration of MariaDB to...
by David Ducos | May 16, 2023 | Insight for DBAs, MySQL
At the end of 2021, I pushed the first Docker image to hub.docker.com. This was the first official image and since then, we have been improving our testing and packaging procedures based on Docker, CircleCI, and GitHub Actions. However, when I’m coding, I’m not...
by Marco Tusa | May 15, 2023 | Cloud, Insight for DBAs, MySQL, Percona Software
Historically MySQL is great in horizontal READ scale. The scaling, in that case, is offered by the different number of Replica nodes, no matter if using standard asynchronous replication or synchronous replication. However, those solutions do not offer the same level...
by Anil Joshi | May 2, 2023 | Insight for DBAs, MySQL, Percona Software, Security
Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns. The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other...
by Vinicius Grippa | May 2, 2023 | Database Trends, Insight for DBAs, MySQL
Given the increasing popularity of ChatGPT in solving questions of humankind, I decided to take a better look at the current state of AI. At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. As the...
by Francisco Bordenave | May 1, 2023 | Cloud, Insight for DBAs, MySQL
Default settings can help you get started quickly – but they can also cost you performance and a higher cloud bill at the end of the month. Want to save money on your AWS RDS bill? I’ll show you some MySQL settings to tune to get better performance, and cost...
by Abhinav Gupta | Apr 24, 2023 | MySQL, ProxySQL, Security
In this blog post, we will see how to persist the password inside the ProxySQL mysql_users table in hashed format only. Also, even if someone stored the password in cleartext, we see how to change those into the hashed format easily. Here we are just highlighting one...
by Mughees Ahmed | Apr 21, 2023 | Insight for DBAs, MySQL
In this article, we will discuss errant Transaction /GTID and how we can solve them with the Orchestrator tool. Orchestrator is a MySQL high availability and replication management tool that runs as a service and provides command line access, HTTP API, and Web...
by Brian Sumpter | Apr 20, 2023 | Insight for DBAs, MySQL, Percona Software
As we approach end of life for MySQL 5.7 later this year, many businesses are currently working towards upgrading to MySQL 8. Such major version upgrades are rarely simple, but thankfully there are tools that can help smooth the process and ensure a successful...
