Buy Percona ServicesBuy Now!

Using AWS EC2 instance store vs EBS for MySQL: how to increase performance and decrease cost

 | August 20, 2018 |  Posted In: AWS, Cloud and MySQL, Insight for DBAs, MySQL, Solutions Engineering

AWS EC2 MySQL cost savings

If you are using large EBS GP2 volumes for MySQL (i.e. 10TB+) on AWS EC2, you can increase performance and save a significant amount of money by moving to local SSD (NVMe) instance storage. Interested? Then read on for a more detailed examination of how to achieve cost-benefits and increase performance from this implementation. EBS […]

Read More

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