The Fifth Elephant 2013

An Event on Big Data and Cloud Computing

Reporting Using MySQL Multi-Source Replication

Submitted by Vishnu H Rao (@vishnuhr) on Friday, 12 April 2013

videocam_off

Technical level

Beginner

Section

Storage and Databases

Status

Submitted

Vote on this proposal

Login to vote

Total votes:  +13

Objective

How can we do real time reporting using MySQL when data is spread across different MySQL instances?

We can achieve this using Multi-Source replication.

Description

Multi-Source replication is used for consolidating data from different MySQL instances.

There are two major use cases for Multi-Source replication:

(1) Backup at a single place for data spread across different MySQL instances. (2) Real Time Reporting - the capability to do complex joins across tables which were otherwise present in different Instances - say a join across Orders & Invoices Tables.

This session would present different ways of achieving Multi-Source replication in MySQL 5.5, the pros & cons of each approach, solutions to failure scenarios i.e. what if a MySQL instance we were replicating from fails, how would failover take place.

This session would also talk about the Relay Log & its power to make failover very easy.

Speaker bio

I work for Flipkart - India's largest e-commerce company.

I am part of the Flipkart Data Platform team - whose charter is to take care of Flipkart's data infrastructure needs.

I also serve as Chief Surgeon at the Flipkart M*A*S*H - MySQL Army Surgical Hospital - handling MySQL emergencies.

I also love doodling - inspired from Google - i maintain my own doodle blog @ doodle-vishnu.blogspot.in

My favorite t.v series are M*A*S*H & Remington Steele.

A Sharks & Ducks fan - i love the NHL.

Links

Comments

Login with Twitter or Google to leave a comment