Buy Percona ServicesBuy Now!

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

This Week in Data with Colin Charles 27: Percona Live Tutorials Released and a Comprehensive Review of the FOSDEM MySQL DevRoom

 | February 9, 2018 |  Posted In: Events and Announcements, InnoDB, MariaDB, MySQL, Percona Live, Percona Monitoring and Management, Percona Server for MySQL, PMM, ProxySQL, Replication

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 update: tutorials have been announced. The committee rated over 300+ talks, and easily 70% of the schedule should go live next week as well. In practice, then, you should see […]

Read More

MySQL Point in Time Recovery the Right Way

 | October 23, 2017 |  Posted In: Backups, GTID, MySQL, Replication

MySQL Point In Time Recovery

In this blog, I’ll look at how to do MySQL point in time recovery (PITR) correctly. Sometimes we need to restore from a backup, and then replay the transactions that happened after the backup was taken. This is a common procedure in most disaster recovery plans, when for example you accidentally drop a table/database or run […]

Read More

Where Do I Put ProxySQL?

 | July 20, 2017 |  Posted In: High-availability, ProxySQL, Replication

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 was created for DBAs by René Cannaò, as a means of solving […]

Read More

Multi-Threaded Slave Statistics

 | July 19, 2017 |  Posted In: Insight for DBAs, MySQL, Replication

Multi-Threaded Slave Statistics

In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file. MySQL version 5.6 and later allows you to execute replicated events using parallel threads. This feature is called Multi-Threaded Slave (MTS), and to enable it you need to modify the slave_parallel_workers variable to a value greater than 1. Recently, a […]

Read More