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...
by David Stokes | Apr 19, 2023 | Insight for DBAs, MySQL
MySQL released version 8.0.33 on April 18th, featuring some attention-catching features. This blog post is a quick review of the release notes looking for the exciting items, and comments in italics are solely my own. User-defined collations are now deprecated and...
by Matthew Boehm | Apr 17, 2023 | Insight for DBAs, MySQL, Percona Services
If you have not been keeping up with MySQL news, MySQL 5.7 reaches end of life in October 2023. This means no more bug fixes or security updates for MySQL 5.7. Users will be effectively forced to upgrade to MySQL 8. Upgrading to MySQL 8 from 5.7 is nowhere near as...
by Fernando Laudares Camargos | Apr 14, 2023 | Monitoring, MySQL, Percona Software
A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory. The...
by Kedar Vaijanapurkar | Apr 12, 2023 | Insight for DBAs, MySQL, Percona Software
During the early stages of my career, I was captivated by the theories and concepts surrounding foreign keys and how they empowered us to maintain data integrity. However, in practical application, I have found them to be quite challenging to manage. I am sure...
by Kedar Vaijanapurkar | Apr 11, 2023 | Insight for DBAs, MySQL, Percona Software
Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, can negatively impact performance. While pt-duplicate-key-checker is the go-to tool for identifying duplicate or redundant indexes in...
by David Ducos | Apr 10, 2023 | Insight for DBAs, MySQL
For a long time, MyDumper has been the fastest tool to take Logical Backups. We have been adding several features to expand the use cases. Masquerade was one of these features, but it was only for integer and UUID values. In this blog post, I’m going to present...
by Agustín | Apr 6, 2023 | Insight for DBAs, Monitoring, MySQL, Percona Software, PostgreSQL
In this blog post, we’ll check how to integrate Percona Monitoring and Management (PMM) with Loki to be able to get not only metrics and queries from our database servers but also text-based information like logs. Loki is a log aggregation tool developed by...
by Mike Benshoof | Apr 4, 2023 | Insight for DBAs, MySQL, ProxySQL
When talking about the benefits and use cases of ProxySQL with clients, one feature I generally reference is the query rewrite engine. This is a great feature that is often used for sharding (I’ve written about this in the past at Horizontal Scaling in MySQL –...
by Mani Paluru | Apr 4, 2023 | Insight for DBAs, MySQL
In this blog post, we’ll look at MySQL 8 user attributes and how we can use them. What is the user attribute? A user attribute is a JSON object made up of one or more key-value pairs, and it is set while creating the user with CREATE USER and by including ATTRIBUTE...
by David Stokes | Apr 4, 2023 | Insight for DBAs, Insight for Developers, MySQL
MySQL 5.7 reaches End of Life status this October. If you still need to start your migration, time is getting short. The first step for many is looking into the new reserved words in MySQL 8.0. As MySQL gets new functionality or the project matures, there are new...
by Pete Scott | Mar 30, 2023 | Insight for DBAs
The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. This comprehensive...
by Smit Arora | Mar 29, 2023 | Insight for DBAs, MySQL
A partitioned table in MySQL has its data separated into different tablespaces while still being viewed as a single table. Partitioning can be a useful approach in some cases when handling huge sets of data. Deleting huge data sets could be quickened up in a...
