Feb 01, 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 decision-making regarding your database infrastructure. HA is crucial for maintaining uninterrupted access to essential […]
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 these. First, consider whether or not you will face vendor lock-in. […]
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 environment. This is especially true with systems where a team of DBAs manage the servers. Obviously, the […]
Apr 09, 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 GCP. The process below will set […]
Apr 07, 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 analysis (RCA). Get the server back up and running. Too many […]
Jan 08, 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 care about. Since the installation process is unfamiliar […]
Jul 08, 2020 |
Monitoring, MySQL, Open Source
Ever wanted to extend MySQL and add some feature you think it is missing? With MySQL plugins, you can do exactly that. One thing that has bothered me for several years is that you cannot easily retrieve system metrics from within MySQL. Whether I am connecting via a remote connection or looking to add features […]
Jul 06, 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 to. This will determine the tendency […]
Apr 08, 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, configuring backups, and so on. Instead, DBAs are moving […]
Apr 02, 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 biggest reasons. Why Containers? Almost everyone has deployed […]
Jan 06, 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 big “T” in TAM). While everyone’s path […]
Jan 02, 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 that decision? As is usually the case, the answer lies in joint […]
Oct 07, 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 individuals who often do not well understand the architecture and its limitations. As a Technical Account […]
Oct 07, 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, you often trade one set of challenges for another. Centralized […]