EmergencyEMERGENCY? Get 24/7 Help Now!

How Life360 Used ProxySQL to Lower Its Database Load

 | September 1, 2017 |  Posted In: Percona Server for MySQL, ProxySQL, Solutions Engineering

ProxySQL

In this blog post, we’ll look at how to use ProxySQL to help the database load by handling PINGs. I’ve blogged before about one of our regular clients, Life360. One of the issues they recently had was the PING command taking about 30%-40% of total queries per second across their database infrastructure. This is a non-trivial […]

Read More

Percona Server for MongoDB: Dashing New LDAP Authentication Plugin

 | March 16, 2017 |  Posted In: MongoDB, Security, Solutions Engineering

LDAP Authentication

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. In this blog, we’ll look at the new LDAP authentication plugin.  Hear ye, hear ye, hear ye… With the arrival of version 3.4, Percona has included an LDAP plugin in Percona Server for MongoDB. Authentication is an essential […]

Read More

Webinar Thursday, March 16, 2017: Moving to Amazon Web Services (AWS)

 | March 13, 2017 |  Posted In: Cloud and MySQL, Cloud and NoSQL, Solutions Engineering, Technical Webinars

Amazon Web Services

Join Percona’s Solutions Engineer Dimitri Vanoverbeke on Thursday, March 16, 2017 at 7:00 a.m. PDT / 10:00 a.m. EDT (UTC-7) for a webinar on Moving to Amazon Web Services (AWS). Register Now This webinar covers the many challenges faced when migrating applications from on-premises into Amazon Web Services (AWS). It will specifically look at moving MySQL to […]

Read More

Migrating MongoDB Away from MMAPv1

 | March 8, 2017 |  Posted In: MongoDB, Percona Server for MongoDB, Percona Software, Solutions Engineering

MMAPv1

This is another post in the series of blogs on the Percona Server for MongoDB 3.4 bundle release. In this blog post, we’ll discuss moving away from the MMAPv1 storage engine. Introduction WIth the MongoDB v3.0 release in February of 2015, the long-awaited ability to choose storage engines became a reality. As of version 3.0, […]

Read More

Installing Percona Monitoring and Management (PMM) for the First Time

 | February 24, 2017 |  Posted In: Database Monitoring, Docker, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, Percona Software, Percona XtraDB Cluster, PMM, ProxySQL, Solutions Engineering, XtraDB Cluster

Percona Monitoring and Management 2

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. This post is meant to walk a prospective user through the benefits of Percona Monitoring and Management (PMM), how it’s architected and the simple install process. By the end of this post, you should have a good idea […]

Read More

Percona Monitoring and Management (PMM) Upgrade Guide

 | February 21, 2017 |  Posted In: Database Monitoring, Docker, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM, Solutions Engineering

Percona Monitoring and Management

This blog post is another in the series on the Percona Server for MongoDB 3.4 bundle release. The purpose of this blog post is to demonstrate current best-practices for an in-place Percona Monitoring and Management (PMM) upgrade. Following this method allows you to retain data previously collected by PMM in your MySQL or MongoDB environment, […]

Read More

Overview of Different MySQL Replication Solutions

 | February 7, 2017 |  Posted In: MySQL, Percona XtraBackup, Percona XtraDB Cluster, Replication, Solutions Engineering

MySQL Replication

In this blog post, I will review some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). I will also try to clarify some of the misconceptions people have about replication. Since I’ve been working on the Solution Engineering team, I’ve noticed that – although information […]

Read More

MariaDB ColumnStore

 | January 30, 2017 |  Posted In: MySQL, Solutions Engineering

MariaDB ColumnStore

Last month, MariaDB officially released MariaDB ColumnStore, their column store engine for MySQL. This post discusses what it is (and isn’t), why it matters and how you can approach a test of it. What is ColumnStore? ColumnStore is a storage engine that turns traditional MySQL storage concepts on their head. Instead of storing the data […]

Read More

MongoDB PIT Backups: Part 2

 | January 9, 2017 |  Posted In: Cloud and NoSQL, High-availability, MongoDB, open source databases, Solutions Engineering

MongoDB PIT Backups

This blog post is the second in a series covering MongoDB PIT backups. You can find the first part here. Sharding Makes Everything Fun(ner) The first blog post in this series looked at MongoDB backups in a simple single-replica set environment. In this post, we’ll look at the scale-out use case. When sharding, we have exactly […]

Read More