Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MySQL Multi-Source Replication

MySQL Multi-Source Replication

 21 April 01:50 PM - 02:40 PM @ Ballroom A
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
New and Trending Topics
Scalability/Performance
Topics:
MySQL
Tools and Techniques
Replication

Description

Most global companies gather data from several sources, centralize it and then query it for analytics/reporting using an array of interfaces. Before MariaDB 10.0 and MySQL 5.7, replication from multi-sources was possible by applying remote binary logs locally and/or doing workarounds with some other kind of development. Now with the latest versions of MariaDB and MySQL, a database server can be a slave to multiple masters after setting up connection names or replication channels. In this presentation, I will cover both MariaDB 10.0 and MySQL 5.7 implementations, considering classic and GTID replication protocols, different topologies, what you can do and what you can't and highlight how to protect your environment against data loss.

Speakers

Maximiliano Bubenick's picture

Maximiliano Bubenick

DBA Team Manager, Percona

Biography:

Im a DBA Team Manager at Percona Managed Services with more than 15 years with DB experience and also Im the mydumper developer, I took the project since 0.6 series two years ago with 3 releases and more to come.

Wagner Bianchi's picture

Wagner Bianchi

Remote DBA @ Managed Services, Percona

Biography:

Bianchi, as he likes to be called, is a MySQL DBA for more than 10 years, have been working with many of the biggest companies in the world with focus centered in Data-Infrastructure, Performance, Scale-Out and HA. Before working at Percona as Principal Engineer @ Managed Services, Bianchi worked at Splunk, Oracle, Pythian, and IBM.

Share this talk


Slides