Author - Michael Patrick

Deploying a MongoDB Proof of Concept on Google Cloud Platform

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 […]

Read more

MySQL 101: Basic MySQL Server Triage

MySQL 101 Server Triage

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 people rush […]

Read more

Updated MySQL OSMetrics Plugins

Updated MySQL OSMetrics Plugins

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 […]

Read more

A Simple MySQL Plugin to Retrieve System Metrics

MySQL Plugin to Retrieve System Metrics

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 […]

Read more

MySQL 101: Linux Tuning for MySQL

Linux Tuning for 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 of […]

Read more