Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

Implementing Multi-Source Replication With MySQL 5.7 @ Verisure (and How We Got There)

Implementing Multi-Source Replication With MySQL 5.7 @ Verisure (and How We Got There)

 21 April 03:00 PM - 03:50 PM @ Ballroom A
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Case Stories
Operations and Management
Topics:
MySQL
Tools and Techniques
Business Intelligence

Description

Verisure, Europe's most popular home alarm with more than 1.8 million customers using the system every day, relies on MySQL for a lot of its customers' data. Data is stored into a sharded database architecture using MySQL. Some of that data is is being replicated into a centralized data warehouse for business intelligence purposes. For a long time, Tungsten Replicator has been used to fan-in the data into a single MySQL instance. This worked well until Verisure expanded. The data growth has increased dramatically ever since, and the architecture began to be difficult to operate. MySQL 5.7 comes with multi-source replication support out of the box, and as this can simplify the architecture a lot, Verisure became early adopters of MySQL 5.7. This talk is about being an early MySQL 5.7 adopter. We'll talk about why we did it, how we put it into production, what problems we ran into and what successes we had with MySQL 5.7.

Speakers

Kenny Gryp's picture

Kenny Gryp

MySQL Practice Manager, Percona

Biography:

Kenny is currently MySQL Practice Manager at Percona.

Kristofer Grahn's picture

Kristofer Grahn

DBA, Verisure Innovation AB

Biography:

Swiss army knife Sysadmin and Dba. Started of as a Novell administrator working with Netware/Groupwise for Malmö university. Add Suse, Vmware and some Iscsi to the mix and you are ready to go Dba. Started @Verisure as a Linux Sysadmin and ended up caring for the the sharded Mysql databases backing the platform. Working close with RnD to develop and maintain the platform. Latest project (in addition to the 5.7) looking into Cassandra to add as a Archive part of the platform. When not working (It happens), "Working" as a Scoutmaster for Scouts aged 15-18. Mostly sailing and other outdoor activities.

Share this talk