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

What is MySQL Partitioning?

 | July 27, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 101

MySQL Partitioning

In this blog, we’ll quickly look at MySQL partitioning. Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables, but still get treated as a single table by the SQL layer. When partitioning, it’s a good idea to find a natural partition key. You want […]

Read More

What is innodb_autoinc_lock_mode and why should I care?

 | July 26, 2017 |  Posted In: MySQL

innodb_autoinc_lock_mode

In this blog post, we’ll look at what innodb_autoinc_lock_mode is and how it works. I was recently discussing innodb_autoinc_lock_mode with some colleagues to address issues at a company I was working with. This variable defines the lock mode to use for generating auto-increment values. The permissible values are 0, 1 or 2 (for “traditional”, “consecutive” or […]

Read More

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