by Manjot Singh | Aug 5, 2023 | Insight for DBAs, MySQL
This blog was originally published in July 2017 and was updated in August 2023.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)... by Manjot Singh | Sep 7, 2017 | 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... by Manjot Singh | Sep 1, 2017 | Percona Software, 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... by Manjot Singh | Jul 26, 2017 | MySQL
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... by Manjot Singh | Jul 20, 2017 | Insight for DBAs, 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... by Manjot Singh | Jul 18, 2017 | Insight for DBAs, MySQL, Percona Services
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 NowWhen discussing disaster recovery, it’s important to take your business’... by Manjot Singh | Jun 28, 2017 | MySQL, Security
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... by Manjot Singh | Jun 6, 2017 | MySQL, Security
In this first of a series of blog posts, we’ll look at MySQL encryption at rest.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... by Manjot Singh | Apr 4, 2017 | 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... by Manjot Singh | Mar 16, 2017 | MariaDB, Monitoring, MySQL, Percona Software
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... by Manjot Singh | Mar 6, 2017 | Insight for DBAs, Insight for Developers, MariaDB, MySQL, Security
In this blog post, we’ll look at how “operator error” can cause serious problems (like the one we saw last week with AWS), and how to avoid them in MySQL using --i-am-a-dummy.Recently, AWS had some serious downtime in their East region, which they... by Manjot Singh | Jan 18, 2017 | Insight for DBAs
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... by Manjot Singh | Jan 11, 2017 | Hardware and Storage, MySQL, Percona Software
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... by Manjot Singh | Dec 21, 2016 | Cloud, Percona Software
by Manjot Singh | Jun 30, 2016 | Insight for DBAs, MySQL, Percona Software
This article discusses how to salvage a crashed pt-online-schema-change by leveraging pt-archiver and executing queries to ensure that the data gets accurately migrated. I will show you how to continue the data copy process, and how to safely close out the... by Manjot Singh | Jun 2, 2016 | Percona Software
In this post, we’ll discuss the Galera warning “last inactive check” and what it means. Problem I’ve been working with Percona XtraDB Cluster quite a bit recently, and have been investigating various warnings. I came across this one... by Manjot Singh | May 27, 2016 | MySQL, Percona Software
In this blog, we’ll discuss the ramifications of the Galera Error Failed to Report Last Committed (Interrupted System Call).I have recently seen this error with Percona XtraDB Cluster (or Galera):[Warning] WSREP: Failed to report last committed 549684236, -4... by Manjot Singh | Apr 26, 2016 | Insight for DBAs, MySQL, Percona Software
In this blog post, we’ll discuss upgrading MySQL with Orchestrator.I recently had a client, Life360, that wanted to upgrade from Percona Server 5.5 to Percona Server 5.6, and implement GTID in their high transaction environment. They had co-masters and... by Manjot Singh | Feb 15, 2016 | MariaDB, MySQL
MariaDB no longer meeting your needs? Migrate to Percona software for MySQL – an open source,production-ready, and enterprise-grade MySQL alternative. Learn More This blog will address how the MariaDB Auditing Plugin can help monitor database activity to help...