EmergencyEMERGENCY? Get 24/7 Help Now!

Where Do I Put ProxySQL?

 | July 20, 2017 |  Posted In: High-availability, ProxySQL, Replication

ProxySQL

In this blog post, we’ll look at how to deploy ProxySQL. ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. It was created for DBAs by René Cannaò, as a means of solving […]

Read More

Backups and Disaster Recovery

 | July 18, 2017 |  Posted In: Backups, Business Continuity, MySQL, MySQL 101, Percona Backup Service, Percona XtraBackup

Backups and Disaster Recovery

In this post, we’ll look at strategies for backups and disaster recovery. Note: I am giving a talk on Backups and Disaster Recovery Best Practices on July 27th. Register Now When discussing disaster recovery, it’s important to take your business’ continuity plan into consideration. Backup and recovery processes are a critical part of any application […]

Read More

Percona Live Featured Session: Using SelectStar to Monitor and Tune Your Databases

 | April 4, 2017 |  Posted In: MongoDB, MySQL, Percona Live

Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live […]

Read More

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