Implementing Multi-Source Replication With MySQL 5.7 @ Verisure (and How We Got There)
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.
MySQL Practice Manager, Percona
Kenny is currently MySQL Practice Manager at Percona.
DBA, Verisure Innovation AB
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.