EmergencyEMERGENCY? Get 24/7 Help Now!

Monitoring Databases: A Product Comparison

 | March 16, 2017 |  Posted In: Database Monitoring, MariaDB, MySQL, Percona Monitoring and Management, Percona Monitoring Plugins

Monitoring Databases PMM small

In this blog post, I will discuss the solutions for monitoring databases (which includes alerting) I have worked with and recommended in the past to my clients. This survey will mostly focus on MySQL solutions.  One of the most common issues I come across when working with clients is monitoring and alerting. Many times, companies […]

Read More

Elasticsearch Ransomware: Open Source Database Security Part 2

and  | January 18, 2017 |  Posted In: Big Data, JSON

Elasticsearch Ransomware

In this blog post, we’ll look at a new Elasticsearch ransomware outbreak and what you can do to prevent it happening to you. Mere weeks after reports of MongoDB servers getting hacked and infected with ransomware, Elasticsearch clusters are experiencing the same difficulties. David Murphy’s blog discussed the situation and the solution for MongoDB servers. In this […]

Read More

How to Replace MySQL with Percona Server on a CPanel, WHM VPS or Dedicated Server

 | January 11, 2017 |  Posted In: Hardware and Storage, MySQL, Percona Server, Percona Software, Percona Toolkit, Percona XtraBackup

Replace MySQL with Percona Server

In this blog post, we’ll look at how to replace MySQL with Percona Server for MySQL on a CPanel, WHM VPS or dedicated server. In general, CPanel and WHM have been leaning towards support of MariaDB over other flavors. This is partly due to the upstream repos replacing the MySQL package with MariaDB (for example, […]

Read More

Installing Percona Monitoring and Management on Google Container Engine (Kubernetes)

 | December 21, 2016 |  Posted In: Docker, Percona Monitoring and Management, PMM

This blog discusses installing Percona Monitoring and Management on Google Container Engine. I am working with a client that is on Google Cloud Services (GCS) and wants to use Percona Monitoring and Management (PMM). They liked the idea of using Google Container Engine (GKE) to manage the docker container that pmm-server uses. The regular install […]

Read More

Rescuing a crashed pt-online-schema-change with pt-archiver

 | June 30, 2016 |  Posted In: MySQL, Percona Server, Percona Software, Percona Toolkit, Replication

crashed pt-online-schema-change

This article discusses how to salvage a crashed pt-online-schema-change by leveraging pt-archiver and executing queries to ensure that the data gets accurately migrated. I will show you how to continue the data copy process, and how to safely close out the pt-online-schema-change via manual operations such as RENAME TABLE and DROP TRIGGER commands. The normal process to […]

Read More

Galera warning “last inactive check”

 | June 2, 2016 |  Posted In: Percona XtraDB Cluster, XtraDB Cluster

Managing Replication

In this post, we’ll discuss the Galera warning “last inactive check” and what it means. Problem I’ve been working with Percona XtraDB Cluster quite a bit recently, and have been investigating various warnings. I came across this one today: [Warning] WSREP: last inactive check more than PT1.5S ago (PT1.51811S), skipping check This warning is related […]

Read More

Galera Error Failed to Report Last Committed (Interrupted System Call)

 | May 27, 2016 |  Posted In: MySQL, Percona XtraDB Cluster, XtraDB Cluster

In this blog, we’ll discuss the ramifications of the Galera Error Failed to Report Last Committed (Interrupted System Call). I have recently seen this error with Percona XtraDB Cluster (or Galera): [Warning] WSREP: Failed to report last committed 549684236, -4 (Interrupted system call) It was posted in launchpad as a bug in 2013: https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1434646 My […]

Read More

How We Made MySQL Great Again, or Upgrading MySQL with Orchestrator

and  | April 26, 2016 |  Posted In: GTID, High-availability, MySQL, Orchestrator, Percona Server, Replication

Upgrading MySQL with Orchestrator

In this blog post, we’ll discuss upgrading MySQL with Orchestrator. I recently had a client, Life360, that wanted to upgrade from Percona Server 5.5 to Percona Server 5.6, and implement GTID in their high transaction environment. They had co-masters and multiple read slaves. Orchestrator made this job much easier for us. My colleague, Tibi, recently posted […]

Read More

MySQL Auditing with MariaDB Auditing Plugin

 | February 15, 2016 |  Posted In: MariaDB, MySQL, MySQL Audit Log Plugin

MySQL MariaDB audit

This blog will address how the MariaDB Auditing Plugin can help monitor database activity to help with security, accountability and troubleshooting. Why Audit Your Databases? Auditing is an essential task for monitoring your database environment. By auditing your database, you can achieve accountability for actions taken or content accessed within your environment. You will also […]

Read More