If You Only Have a Hammer, Everything Looks Like a Thumb
In database technology the law of the instrument is a bit overused these days but for a reason! Yelp, like a lot of companies which have been around for a while, has a set of tools we use because we are happy with them. For the Database Engineering team, the tool of choice is MySQL, and it’s a mighty hammer. However, in a fast growing environment it can be difficult to recognize when to scale your data tier and when you might need a screwdriver instead of a hammer, and this has enormous consequences for your application environment. This talk will give you an overview of: * Great reasons to stay solely with MySQL * When and why you should consider adding more tools to the (database) mix. What decision criteria to apply when thinking about this (e.g. Velocity, Volume, Complexity) * Yelp’s choices of alternative databases (Cassandra, Memcached, MongoDB) and how we iterated * The consequences of using other databases, both technological and social * Whether you should follow Yelp into the brave new world of a more well-stocked toolbox and less time hitting your thumb
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.