You have a working application that is using MySQL: great! At the beginning, you are probably using a single database instance, and maybe – but not necessarily – you have replication for backups, but you are not reading from slaves yet. Scalability and reliability were not the main focus in the past, but they are starting to be a concern. Soon, you will have many databases and you will have to deal with replication lag. This talk will present how to tackle the transition.

We mostly cover standard/asynchronous replication, but we will also touch on Galera and Group Replication. We present how to adapt the application to become replication-friendly, which facilitate reading from and failing over to slaves. We also present solutions for managing read views at scale and enabling read-your-own-writes on slaves. We also touch on vertical and horizontal sharding for when deploying bigger servers is not possible anymore.

Are UNIQUE and FOREIGN KEYs still possible at scale, what are the downsides of AUTO_INCREMENTs, how to avoid overloading replication, what are the limits of archiving, … Come to this talk to get answers and to leave with tools for tackling the challenges of the future.

Comments

Please login to leave a comment

Rated 5

Srdjan Vranac at 11:53 on 2 Dec 2018

Really good talk, but unfortunately it had to have some parts of it dropped because of time constraint. The content was really good, I filled some gaps in my knowledge about db replication

Good talk with a lot of examples from experience. The only bad thing for me was a lot of content. Maybe it is too big topic for 45 mins.

Rated 5

Bogdan Kecman at 15:31 on 2 Dec 2018

Best one on the conference :D as expected :D

Rated 5

Nikola Krgovic at 18:03 on 2 Dec 2018

Looked forward to this one, and it hasn't disappointed. One of the best talks on the conference, with the only issue being the limited time: the lecturer clearly had much more to say.

Rated 5

Nikola Poša at 20:01 on 2 Dec 2018

This talk is an eye-opener for everyone who have a basic knowledge of the subject of replication. Speaker had a really good performance on the stage and was able to deliver advanced concepts in a clear and understandable way.

He crammed so much info into a single talk, it's amazing. Especially given the complexity of the topic. On this one I took the most notes (of things to look up), which means it was very informative. Lots of links in the slides for advanced topics, which add value to the talk. One of the best talks on the conf, at least for someone interested in the topic.

Rated 5

Milan Rasljic at 21:16 on 2 Dec 2018

Realy well documented and much info provided. Reference links with more info are great. Great presentation.