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 Michael Patrick | Apr 21, 2022 | Cloud, Database Trends
Before you transition your database environment to the cloud, there are a few considerations you should consider first. Some of the touted benefits of the cloud also carry with them some risks or negative impacts. Let’s take a look at just a few of... by Michael Patrick | Apr 20, 2022 | Insight for DBAs, MySQL, Percona Software
When one is responsible for promoting application development from Dev through the various environments such as QA, UAT, etc., through Production, it is often useful to ensure that configurations in test environments are comparable to the final production... by Michael Patrick | Apr 9, 2021 | Cloud, MongoDB, Percona Software
Recently, I needed to set up a Proof of Concept (POC) and wanted to do it on Google Cloud Platform (GCP). After documenting the process, it seemed it might be helpful for others looking for the most basic guide possible to get a Mongo server up and running on... by Michael Patrick | Apr 7, 2021 | MySQL, Open Source, Percona Services, Percona Software
So your MySQL server has crashed. What do you do now? When a server is down, in my opinion, there are two steps that are essential and both are extremely important and neither should be neglected: Save diagnostic information for determining the root cause... by Michael Patrick | Jan 8, 2021 | Insight for DBAs, Insight for Developers, MySQL, Open Source
It has been some time since I have posted updates to my plugins. After the initial version, I decided to split the plugins into categories of metrics. This will allow users to choose whether they want to install all of the plugins or only select ones they... by Michael Patrick | Jul 8, 2020 | Monitoring, MySQL, Open Source
by Michael Patrick | Jul 6, 2020 | Insight for DBAs, MySQL
When trying to do some Linux tuning for MySQL, there are a few options that will greatly influence the speed of MySQL. Below are some of the most important of these settings to help you get started. Swappiness The first thing to look at is what swappiness is set... by Michael Patrick | Apr 8, 2020 | Database Trends, Insight for DBAs, Percona Services
As I interface with large clients as a Technical Account Manager (TAM) at Percona, one thing I have noticed is the evolution of the DBA role. With the rise of the cloud, DBAs seem to be spending less time doing traditional DBA roles of performance tuning,... by Michael Patrick | Apr 2, 2020 | Cloud, Database Trends, Percona Services
As a Technical Account Manager, or TAM for short, I am fortunate to work with some large clients. Most all of them are in some state of increasing their usage of containerization. There are a number of reasons for this, but let’s explore a few of the... by Michael Patrick | Jan 6, 2020 | Database Trends, Insight for DBAs, Percona Services
So, what do you do when you love technology but are ready for a change in the day-to-day activities of a DBA? One consideration is to become a Technical Account Manager, or TAM for short. At Percona, a TAM is an account manager who is also technical (the... by Michael Patrick | Jan 2, 2020 | Database Trends, Insight for DBAs, Insight for Developers, Open Source
In your organization, who decides what database platform will be utilized for that new application being built? For many groups, that decision is made by the Development Team while for others, it is the Database Team. But, which is best equipped to make... by Michael Patrick | Oct 7, 2019 | Percona Software
One thing that comes up often from working with a variety of clients at Percona is “How can I achieve a Disaster Recovery (DR) solution with Percona XtraDB Cluster (PXC)?” Unfortunately, decisions are sometimes made with far-reaching consequences by... by Michael Patrick | Oct 7, 2019 | Insight for DBAs
As a Technical Account Manager (TAM), I have seen many of our clients adopt a decentralized DBA Team. In many cases, this is an effort to better align the DBA Team with the Development Teams. This is an admirable and logical goal. As often happens,...