Author - Manjot Singh

Always Verify Examples When Comparing DB Products (PostgreSQL and MySQL)

PostgreSQL and MySQL

In this blog post, I’ll look at a comparison of PostgreSQL and MySQL.
I came across a post from Hans-Juergen Schoenig, a Postgres consultant at Cybertec. In it, he dismissed MySQL and showed Postgres as better. While his post ignores most of the reasons why MySQL is better, I will focus on where his post is less than […]

Read more

How Life360 Used ProxySQL to Lower Its Database Load

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?

MySQL Partitioning

It’s a pretty common question around here, so let’s see what we can do about that.
So, What is 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 in MySQL, […]

Read more

What is innodb_autoinc_lock_mode?

I was recently discussing innodb_autoinc_lock_mode with some colleagues to address issues at a company I was working with.
innodb_autoinc_lock_mode
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 “interleaved” lock mode, respectively). In most cases, this variable is set to the […]

Read more

Where Do I Put ProxySQL?

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

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 infrastructure.
A well-tested […]

Read more

MySQL Encryption at Rest – Part 2 (InnoDB)

MySQL Encryption at Rest

Welcome to Part 2 in a series of blog posts on MySQL encryption at rest. This post covers InnoDB tablespace encryption.
At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL needs to be encrypted “at rest.” As with all […]

Read more