A look at the state of data storage, management & analysis, from SQL
to NOSQL, “NewSQL” and beyond. I will explain why the core premises of
data management have changed; tell some of the tales of success and failure I have collected on the topic; share some
counterintuitive rules-of-thumb about the sometimes mind-blowing,
sometimes nerve-wrecking reality of life with an alternative
Everyone thinks they know what sharding is and how to do it, but simple horizontal read scaling is the small potatoes. In this talk we'll focus on the sharding pattern for large scale read/write architectures, based on real world implementations. Supporting millions of users on commodity hardware doesn't need magical software, just careful application of the right scalability pattern.
With most modern web applications, there are requirements for both SQL access to complex data as well as simple Key-Value look-ups. This session will cover how to use the HandlerSocket Plug-In for MySQL to get exponentially faster look-ups for simple access patterns.
There are many exciting InnoDB performance and Scalability features in MySQL 5.5 and its upcoming release. But how to best use them? What are the caveats? At this session, we will describe those performance and Scalability features in depth. We will also present some benchmark results that explore the performance of those features.
BrowserMob, a Portland-based cloud load testing and monitoring service, spins up thousands of servers every day in various cloud environments, including Amazon, Rackspace, and GoGrid. Learn from the founder about the various open source Java tools he built upon to design a highly scalable, modern cloud-based architecture.
Managing a MySQL database server can become a full time job. What we need are tools that bundle a set of related tasks into a common utility. While there are several such utility libraries to choose, it is often the case that you need to customize them to your needs. The MySQL Utilities library is the answer to that need. It is open source so you can modify and expand it as you see fit.
Redis is an entry in the new breed of nosql databases. But it takes a different approach that makes it much more interesting then most of the other key/value stores in the same category. Come learn what makes redis so useful that it seems everyone is adding it to their toolbox.
Writing SQL is has very little in common with writing application code. Refactoring SQL has nothing in common with writing application code. Good object-oriented refactoring techniques frequently cause problems with SQL. This talk covers tried and true methods for refactoring SQL.