Ever wondered what would happen if you could rethink a decade worth of design changes? Drizzle is a redesign of the MySQL server targeted at web development and cloud infrastructure. Update yourself on the latest features, and use cases for Drizzle7 and what is in store for the near future.
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.
PostgreSQL continues to provide a major release every year full of improvements, better performance and features that measure up to the most popular commercial databases. Our 2011 release, 9.1, is no exception!
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.
Multiversion Concurrency Control (MVCC) allows Postgres to offer high
concurrency even during significant database read/write activity. MVCC
specifically offers behavior where "readers never block writers, and
writers never block readers". This talk explains how MVCC is implemented in Postgres and highlights optimizations which minimize the downsides of MVCC. This talk is for advanced users.
We at DeNA (largest social game provider in Japan) handle over 2
billion page views per day with MySQL. We heavily use SSD and tune
Linux. We run non-trivial solutions such as non-stop, automated MySQL
master failover. We also use MySQL not only as traditional RDBMS but
also an extremely high performance NoSQL. I'd like to introduce our
MySQL solutions to make our social games scale better.
We describe the new replication features in MySQL 5.5 (GA) and MySQL 5.6 (Development release).
Keeping a busy site going when you don't have a lot of servers or developer resources can be a struggle. Hear what we did at Daily Kos to make the most of what we had to bring MySQL in line, make it quick, and keep the users and the boss happy.
Whether you're a beginner Web guy or a veteran DBA, whether you get hands dirty with any code or just manage systems, you still must know algorithms. How come? Because that knowledge enables you to optimize your work, conduct correct benchmarks, and make educated decisions. We'll show you how knowing only a little about SQL internals can help so much with tuning things.