by Mike Benshoof | Jul 1, 2019 | MySQL
The CTO has issued the decree: “We are moving to the cloud!” Great, so now what do we do? When it comes to migrating from on-premise to the cloud, there are many factors to consider and decisions that need to be made. First (and probably most... by Mike Benshoof | Jun 5, 2019 | Database Trends, MySQL
It used to be easy: a company developed a new application, chose a database solution, launched the new application and then tuned the chosen database solution. A team of DBAs looked at the infrastructure as well as the workload and made changes (or suggestions) as... by Mike Benshoof | Mar 13, 2015 | Insight for Developers, MySQL
Geographic information systems (GIS) are used by application developers to incorporate geographic information into their datasets to create apps with cool features such finding the address to the best steakhouse in town or the locations of local points of historical... by Mike Benshoof | Sep 18, 2014 | Insight for DBAs, MySQL
Over the past few months, I’ve seen an increase in the following use case while working on performance and schema review engagements:I need to store exponentially increasing amounts of data and analyze all of it in real-time.This is also known simply as:... by Mike Benshoof | Apr 15, 2014 | MySQL
I recently helped a client implement a custom replication delay monitor and wanted to share the experience and discuss some of the iterations and decisions that were made. percona-millipede was developed in conjunction with Vimeo with the following high-level goal in... by Mike Benshoof | Nov 21, 2013 | Insight for DBAs, MySQL, Percona Software
Recently, I helped a client that was having issues with deployments causing locking in their production databases. At a high level, the two key components used in the environment were: Capistrano (scripted deployments) [website] Liquibase (database version... by Mike Benshoof | Nov 12, 2013 | MySQL, Webinars
Drupal is one of the most popular open source CMS applications available – and it runs primarily on a MySQL backend. Out of the box, the schema is well tuned and indexed. However, there are some ways to tweak the default installation to get more out... by Mike Benshoof | Jun 24, 2013 | Insight for DBAs, MySQL
Statement-based or row-based, or mixed? We’ve all seen this discussed at length so I’m not trying to rehash tired arguments. At a high level, the difference is simple: Statement based replication (SBR) replicates the SQL statements to the slave... by Mike Benshoof | Jun 10, 2013 | Insight for DBAs, MySQL
Recently, I was working with a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with a different schema name on the same server. It caught me off guard because I’d never really thought... by Mike Benshoof | Mar 29, 2013 | MySQL
A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively... by Mike Benshoof | Oct 24, 2012 | Cloud, MySQL
Well, it happened again… Another lengthy EBS outage in the US-East region impacted several sites across the net. While failures like this are rare, they can be quite costly and translate into headaches for the operations team when impact production... by Mike Benshoof | Sep 25, 2012 | Insight for DBAs, MySQL, Percona Software
I recently worked through an issue with a client trying to detect data drift across some servers that were located in different timezones. Unfortunately, several of the tables had timestamp fields and were set to a default value of CURRENT_TIMESTAMP....