Buy Percona ServicesBuy Now!

Webinar Thurs 6/14: MongoDB Backup and Recovery Field Guide

 | June 13, 2018 |  Posted In: Backups, MongoDB, Replication, Security, Technical Webinars

mongodb backup and recovery field guide

Please join Percona’s Sr. Technical Operations Architect, Tim Vaillancourt as he presents MongoDB Backup and Recovery Field Guide on Thursday, June 14, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now This talk will cover backup and recovery solutions for MongoDB replica sets and clusters, focusing on online and low-impact solutions […]

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

Percona Live 2018 Sessions: Ghostferry – the Swiss Army Knife of Live Data Migrations with Minimum Downtime

 | April 24, 2018 |  Posted In: Cloud and MySQL, Cloud and NoSQL, MySQL, Percona Live, Replication

Shuhao Ghostferry Percona Live 2018 Sessions

In this blog post on Percona Live 2018 sessions, we’ll talk with Shuhoa Wu, Software Developer for Shopify, Inc. about how Ghostferry is the Swiss Army knife of live data migrations. Existing tools like mysqldump and replication cannot migrate data between GTID-enabled MySQL and non-GTID-enabled MySQL – a common configuration across multiple cloud providers that cannot be […]

Read More

Multi-Source Replication Performance with GTID

 | March 30, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, Replication

Multi-Source Replication with GTID

In this blog post, we’ll look at the performance of multi-source replication with GTID. Note. This blog was edited as I received some comments from Percona colleagues. I’ve updated the contents in the marked EDIT section. Thanks! Multi-Source Replication is a topology I’ve seen discussed recently, so I decided to look into how it performs […]

Read More

Percona XtraDB Cluster, MySQL Asynchronous Replication and log-slave-updates

 | March 19, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Replication

Asynchronous Replication

Recently, I’ve been looking into issues with the interactions between MySQL asynchronous replication and Galera replication. In this blog post, I’d like to share what I’ve learned. MySQL asynchronous replication and Galera replication interactions are complicated due to the number of factors involved (Galera replication vs. asynchronous replication, replication filters, and row-based vs. statement-based replication). So […]

Read More

The Multi-Source GTID Replication Maze

 | March 13, 2018 |  Posted In: GTID, Insight for DBAs, MySQL, Replication

Multi-Source GTID Replication

In this blog post, we’ll look at how to navigate some of the complexities of multi-source GTID replication. GTID replication is often a real challenge for DBAs, especially if this has to do with multi-source GTID replication. A while back, I came across a really interesting customer environment with shards where multi-master, multi-source, multi-threaded MySQL 5.6 […]

Read More

This Week in Data with Colin Charles 30: Schedule for Percona Live, and Tracking Those Missing Features

 | March 2, 2018 |  Posted In: Events and Announcements, MariaDB, MySQL, Percona Monitoring and Management, Percona Toolkit, Percona XtraDB Cluster, PMM, Replication, XtraDB Cluster

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Have you registered for Percona Live already? The tutorial grid, the schedules for day 1 and day 2 are pretty amazing, and there is even an extra track being added, for a total of 10 concurrent/parallel […]

Read More