Renormalize | Solving MySQL Performance Problems without Denormalization

Renormalize

As operational database schemas become complex, users resort to denormalization to handle performance issues. This includes a range of techniques from materialized views to using MySQL as a key-value store for blobs containing full objects. While denormalization solves immediate bottlenecks, it comes at a hefty price. In this presentation Ori will explore common denormalization approaches and trade-offs using real world examples. He will then present a solution under development at Akiban Technologies (http://www.akiban.com) to alleviate these same problems much more efficiently, and allow users to get the best of both worlds. Currently we're working with design partner companies on development. The product will be open source by the end of April. So far here are the four most common MySQL patterns that cause bottlenecks (http://www.akiban.com/akiban-use-cases) in performance.

Ori Herrnstadt is the founder and CTO of Akiban. He has been involved in developing large scale operational database systems since his days in the Israeli Military. After experiencing similar problems of large-scale operational systems in healthcare, ERP, CRM and modern web applications, he began developing the Orthogonal Architecture. In 2009, he founded Akiban Technologies to accelerate the development of this technology.

Food & Swag

We'll be sponsoring pizza and drinks for attendants. Also Ori will stick around after the talk to give out swag and speak more in depth about the presentation with anybody that wants to.