EmergencyEMERGENCY? Get 24/7 Help Now!

Services Monitoring with Probabilistic Fault Detection

 | March 9, 2017 |  Posted In: Database Monitoring, JSON, MongoDB, MySQL

Services Monitoring

In this blog post, we’ll discuss services monitoring using probabilistic fault detection. Let’s admit it, the task of monitoring services is one of the most difficult. It is time-consuming, error-prone and difficult to automate. The usual monitoring approach has been pretty straightforward in the last few years: setup a service like Nagios, or pay money to […]

Read More

How X Plugin Works Under the Hood

 | September 16, 2016 |  Posted In: Insight for DBAs, MySQL

X Plugin

In this blog post, we’ll look at what MySQL does under the hood to transform NoSQL requests to SQL (and then store them in InnoDB transactional engine) when using the X Plugin. X Plugin allows MySQL to function as a document store. We don’t need to define any schema or use SQL language while still […]

Read More

MHA Quick Start Guide

 | September 2, 2016 |  Posted In: High-availability, MySQL

MHA

MHA (Master High Availability Manager and tools for MySQL) is one of the most important pieces of our managed services. When properly set up, it can check replication health, move writer and reader virtual IPs, perform failovers, and have its output constantly monitored by Nagios. Is it easy to deploy and follows the KISS (Keep It […]

Read More

Amazon RDS and pt-online-schema-change

 | July 1, 2016 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL

Amazon RDS and pt-online-schema-change

In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together. The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by community users and customers. Using it on Amazon RDS requires knowing about some specific […]

Read More

Where is the MySQL 5.7 root password?

 | May 18, 2016 |  Posted In: MySQL

Using Vault with MySQL

In this blog, we’ll discuss how to find the MySQL 5.7 root password. While new MySQL software security features are always welcome, they can impact use and performance. Now by default, MySQL 5.7 creates a password for the root user (among other changes) so the installation itself can be considered secure. It’s a necessary change, […]

Read More

Dealing with Jumbo Chunks in MongoDB

 | April 11, 2016 |  Posted In: MongoDB

Jumbo Chunks in MongoDB

In this blog post, we will discuss how to deal with jumbo chunks in MongoDB. You are a MongoDB DBA, and your first task of the day is to remove a shard from your cluster. It sounds scary at first, but you know it is pretty easy. You can do it with a simple command: […]

Read More

Setup a MongoDB replica/sharding set in seconds

 | January 28, 2016 |  Posted In: MongoDB, MySQL

In the MySQL world, we’re used to playing in the MySQL Sandbox. It allows us to deploy a testing replication environment in seconds, without a great deal of effort or navigating multiple virtual machines. It is a tool that we couldn’t live without in Support. In this post I am going to walk through the different ways we […]

Read More