If only I could find my databases --Service Discovery with Smartstack and MySQL
How do you correctly direct traffic to your databases? How do you add new replicas or remove broken or retired replicas from the traffic flow? How do you scale elastically? Every company has their own way of how they solve the service discovery problem. Some use solely DNS, others use VIPs, Consul, …..etc. At Yelp we’ve had great success using SmartStack for service discovery in most of our infrastructure, and we wanted to use it for MySQL too. This talk will cover our journey to successfully using SmartStack for MySQL, and the highlights and pitfalls along the way.. This talk will give you an overview of: * Service Discovery * How Smartstack works ** Nerve ** Synapse ** Zookeeper and HAProxy * How we use Smartstack in combination with MySQL * The advantages and challenges of using Smartstack and MySQL together Technologies: Percona MySQL 5.6 Ubuntu Trusty Smartstack Zookeeper and HA Proxy Puppet Terraform
Database Engineer, Yelp
Susanne has been a database engineer for more than 16 years and has spent the last 3 years at Yelp. She loves being responsible for keeping big data reliable, scalable and fast for the user. Also she greatly enjoys how vibrant the open source community is with all things databases! Prior to joining Yelp, Susanne was the senior database engineer at DeNA where she developed data stores for mobile social apps running on MySQL as well as on NoSQL databases. Throughout her career she has covered a wide range of different database work from huge global players like Sanofi to -at that time- very early startups like Metamarkets. She holds a master’s degree from Goettingen University, Germany in mathematics and computing.