by Brian Sumpter | Apr 1, 2024 | Insight for DBAs, MySQL
This blog was published in April of 2021 and updated in April of 2024.In past versions of MySQL, there was often an ‘upgrade dance’ that had to be performed in starting up a newly upgraded MySQL instance with the previous version configuration file. In... by Brian Sumpter | Oct 3, 2023 | Insight for DBAs, Insight for Developers, MySQL
Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we... by Brian Sumpter | Sep 1, 2023 | Insight for DBAs, Monitoring, MySQL
This post was originally published in June 2020 and was updated in September 2023.While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL... 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 Brian Sumpter | Nov 18, 2022 | Insight for DBAs
With the holiday season approaching quickly, it’s an opportune time to discuss preparation for the busiest shopping season of the year, especially the typical surge of high traffic on Black Friday. Many businesses find themselves caught off guard by high holiday... by Brian Sumpter | Mar 23, 2022 | Insight for DBAs, MySQL, Security
As part of my ongoing series around MySQL 8 user administration, I’d like to cover one of the new features introduced in MySQL 8.0.27 – multi-factor authentication. In order to establish identity, multi-factor authentication (MFA) is the use of multiple... by Brian Sumpter | Mar 22, 2022 | Insight for DBAs, MySQL, Security
In keeping with my MySQL 8 user administration and security theme, I’d like to discuss the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by... by Brian Sumpter | Oct 8, 2021 | Insight for DBAs, Insight for Developers, MySQL, Security
As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how using the new dual passwords feature can reduce the overall DBA workload and streamline the management process. I’ve also covered how the new password failure tracking... by Brian Sumpter | Oct 5, 2021 | Insight for DBAs, MySQL, Security
As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how the new dual passwords feature can reduce the overall DBA workload and streamline the management process (see MySQL 8: Dual Passwords). This wasn’t the only change to... by Brian Sumpter | Jul 5, 2021 | Insight for DBAs, MySQL
One of the new features introduced in MySQL 8.0.24 was the ability to log all SQL statements that are issued in the MySQL Shell to the system log. This is a useful feature that can greatly assist in tracking who did what on the system. Usage The simplest way to... by Brian Sumpter | Jul 1, 2021 | Insight for DBAs, MySQL, Open Source
MySQL 8 brought many highly anticipated features, with support for user roles, a new shell, a more robust data dictionary, and better SQL support, just to name a few. There are lesser-known new features, however, that aim to reduce overall DBA workload and streamline... by Brian Sumpter | Mar 31, 2021 | Insight for DBAs, MySQL
As many of you may remember, Percona added the super_read_only feature way back in Percona Server for MySQL 5.6.21, based on work done by WebScaleSQL. This feature eventually found its way into the Community branch of MySQL starting with 5.7.8, and it works the same... by Brian Sumpter | Jan 7, 2021 | Database Trends, MySQL, Percona Services, Security
In previous TAM Enterprise Experiences posts, we have outlined typical aspects of utilizing MySQL in an Enterprise environment. One thing we have not yet covered is the topic of database encryption, both from the standpoint of business requirements as well as some of... by Brian Sumpter | Jan 5, 2021 | Database Trends, Insight for DBAs, Open Source, Percona Services
One of the great things about being a Technical Account Manager (TAM, for short) at Percona is having the opportunity to see a wide variety of issues across many clients, and having the space to identify the common threads that seem to bind many of these issues. While... by Brian Sumpter | Jun 29, 2020 | Insight for DBAs, Percona Services, Percona Software
In 2006, a small company formed, specializing in MySQL database consulting at a time when very few companies had fully embraced open source. This small company quickly grew, riding the wave of open source adoption within the greater enterprise market and became the... by Brian Sumpter | Apr 1, 2020 | Insight for DBAs, Monitoring, MySQL, Percona Software
While there is no magic bullet for MySQL 5.7 database tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. While much information has been published on this topic over the years, I... by Brian Sumpter | Mar 27, 2020 | Percona Services, Percona Software
This is usually one of the first questions asked by clients when discussing the possibility of adding a TAM (Technical Account Manager) to their Percona Support contract. Although the TAM role in a general sense has been around for many years, there are often... by Brian Sumpter | Dec 19, 2019 | Cloud, Insight for DBAs, MySQL
As the world’s most popular open-source database, MySQL has been around the block more than a few times. Traditionally installed in on-premise data centers, recent years have shown a major trend for MySQL in the cloud, and near the top of this list is Amazon...