2:20pm–3:00pm Tuesday, 07/26/2011
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.
11:30am–12:10pm Monday, 07/25/2011
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.
10:40am–11:20am Tuesday, 07/26/2011
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!
4:20pm–5:00pm Monday, 07/25/2011
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.
2:20pm–3:00pm Monday, 07/25/2011
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.
3:30pm–4:10pm Monday, 07/25/2011
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.
10:40am–11:20am Monday, 07/25/2011
We describe the new replication features in MySQL 5.5 (GA) and MySQL 5.6 (Development release).
1:30pm–2:10pm Tuesday, 07/26/2011
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.
11:30am–12:10pm Tuesday, 07/26/2011
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.