EmergencyEMERGENCY? Get 24/7 Help Now!

WAN Synchronous Clusters: Dealing with Latency Using Concurrency

 | February 1, 2017 |  Posted In: Group Replication, Insight for DBAs, Insight for Developers, MySQL, Percona XtraDB Cluster, Replication

WAN Latency

In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters. WAN Latency Problem Our customers often ask us for help or advice with WAN clustering problems. Historically, the usual solution for MySQL WAN deployments is having the primary site in one data center, and stand-by backup site in […]

Read More

MySQL Sharding Models for SaaS Applications

 | January 30, 2017 |  Posted In: Insight for DBAs, MySQL

MySQL Sharding Models

In this blog post, I’ll discuss MySQL sharding models, and how they apply to SaaS application environments. MySQL is one of the most popular database technologies used to build many modern SaaS applications, ranging from simple productivity tools to business-critical applications for the financial and healthcare industries. Pretty much any large scale SaaS application powered […]

Read More

When MySQL Lies: Wrong seconds_behind_master with slave_parallel_workers > 0

 | January 27, 2017 |  Posted In: Insight for DBAs, MySQL

MySQL error code 1215

In today’s blog, I will show an issue with seconds_behind_master that one of our clients faced when running slave_parallel_workers > 0. We found out that the reported seconds_behind_master from SHOW SLAVE STATUS was lying. To be more specific, I’m talking about bugs #84415 and #1654091. The Issue MySQL will not report the correct slave lag if you have slave_parallel_workers […]

Read More

MongoDB 3.4 Views

 | January 13, 2017 |  Posted In: Insight for DBAs, MongoDB

MariaDB ColumnStore

This blog post covers MongoDB 3.4 views, one of the more recent MongoDB features. Views are often used in relational databases to achieve both data security and a high level of abstraction, making it easier to retrieve data. Unlike regular tables, views neither have a physical schema nor use disk space. They execute a pre-specified […]

Read More

The Impact of Swapping on MySQL Performance

 | January 13, 2017 |  Posted In: InnoDB, Insight for DBAs, MySQL, PMM

In this blog, I’ll look at the impact of swapping on MySQL performance.  It’s common sense that when you’re running MySQL (or really any other DBMS) you don’t want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL’s case) is standard practice to make sure there is enough free […]

Read More

MySQL 8.0.1: The Next Development Milestone

 | January 9, 2017 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Quality Assurance

MySQL 8.0.1

This post discusses the next MySQL development milestone: MySQL 8.0.1. From the outset, MySQL 8.0 has received plenty of attention. Both this blog (see the MySQL 8.0 search) and other sites around the Internet have covered it. Early reviews seem positive (including my own MySQL 8.0 early bugs review). There is plenty of excitement about the new features. As […]

Read More