Just submitted a couple proposals for O’Reilly’s MySQL Conference in April 2009, Santa Clara, CA. Fingers crossed!
Proposal details
Proposer
Sean Hull (hullsean@gmail.com)
Speakers
Sean Hull (hullsean@gmail.com)
Description
MySQL has a number of great features for managing archival data, and very large tables. We look at the MERGE storage engine first. Then we look at views which can hide many tables behind the scenes. And lastly we look at partitioned tables.
Session type: 45 minute conference session
Topics: Data Warehousing and Business Intelligence
Abstract
MySQL has some very powerful features for large databases now available in 5.1.
We’ll look at the MERGE storage engine first. Then we’ll take a look at views, and the strengths and weaknesses there. And lastly we’ll consider partitioning as an option.
Each of these solutions has pros and cons. When you consider performance, ease of administration, and manageability, they all have tradeoffs.