Buy Percona ServicesBuy Now!

How Binary Logs (and Filesystems) Affect MySQL Performance

 | May 4, 2018 |  Posted In: Benchmarks, InnoDB, Insight for DBAs, MySQL, MySQL 8.0

I want to take a closer look at MySQL performance with binary logs enabled on different filesystems, especially as MySQL 8.0 comes with binary logs enabled by default. As part of my benchmarks of the MyRocks storage engine, I’ve noticed an unusual variance in throughput for the InnoDB storage engine, even though we spent a […]

Read More

Causes and Workarounds for Slave Performance Too Slow with Row-Based Events

 | May 3, 2018 |  Posted In: High-availability, Insight for DBAs, MySQL, Replication

Slave Performance Too Slow

Recently I worked on one customer issue that I would describe as “slave performance too slow”. During a quick analysis, I’ve found that the replication slave SQL thread cannot keep up while processing row-based events from the master’s binary log. For example:

The processlist state for the SQL thread can be one of the following: Reading […]

Read More

MongoDB Rollback in replicaset

 | May 1, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Replication

MongoDB Rollback

In this blog post, we’ll look at how MongoDB rollback works during replicaset failovers. In recent versions, MongoDB has provided lots of features related to replicaset and automatic failover. When it comes to failover, the next question that arises is “How does MongoDB ROLLBACK work during replicaset failover?” If a PRIMARY member (say node A) stepped […]

Read More

Webinar Thursday May 3, 2018: Running MongoDB in Production (Part 3)

 | May 1, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MongoDB, Replication, Technical Webinars

Running MongoDB

Please join Percona’s Senior Technical Operations Architect, Tim Vaillancourt as he presents Running MongoDB in Production (Part 3) on Thursday, May 3, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you a seasoned MySQL DBA that needs to add MongoDB to your skills? Are you used to managing a small environment […]

Read More

A Look at MyRocks Performance

 | April 30, 2018 |  Posted In: Benchmarks, Insight for DBAs, MyRocks, MySQL

MyRocks Performance

In this blog post, I’ll look at MyRocks performance through some benchmark testing. As the MyRocks storage engine (based on the RocksDB key-value store http://rocksdb.org ) is now available as part of Percona Server for MySQL 5.7, I wanted to take a look at how it performs on a relatively high-end server and SSD storage. […]

Read More

This Week In Data with Colin Charles 37: Percona Live 2018 Wrap Up

 | April 27, 2018 |  Posted In: Big Data, Insight for DBAs, Insight for Developers, Percona Live

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 is now over! All things considered, I think it went off quite well; if you have any comments/complaints/etc., please don’t hesitate to drop me a line. I believe a survey […]

Read More

Percona Live 2018: Closing Ceremony with Lightning Talks

 | April 25, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, High-availability, InnoDB, Insight for DBAs, Percona Live

Mariella ViaSat Percona Live 2018

Percona Live 2018 is officially done! The closing ceremony ends the conference with a last few lightning talks and a prize giveaway. We ended the Percona Live 2018 conference the same way we started: with talks! This year, we had our lightning talks as part of our closing ceremony. They included: Amazon Aurora MySQL and […]

Read More

Percona Live 2018: Migrating to Vitess at (Slack) Scale

 | April 25, 2018 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Percona Live

Michael Slack Percona Live 2018

Percona Live 2018 is moving along, and the first person I got a chance to talk with is Michael Demmer, Senior Staff Engineer at Slack. His talk was on Migrating to Vitess at (Slack Scale). MySQL is the backbone of Slack’s data storage infrastructure. It handles billions of queries per day across thousands of sharded […]

Read More

Percona Live 2018 Featured Talk: Data Integrity at Scale with Alexis Guajardo

 | April 23, 2018 |  Posted In: Cloud and MySQL, Insight for DBAs, Insight for Developers, Percona Live, Security

Alexis Google Percona Live 2018

Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post highlights Alexis Guajardo, Senior Software Engineer at Google.com. His session talk is titled […]

Read More