Need to take your OLTP database and scale it 10 or 100 times and still have it perform well?
In this session you will learn how to take advantage of MySQL table partitioning to allow your database applications to scale in both size and performance. Examine practical ways to design your partitions to be reusable, efficient, and scalable. Understand the different ways to apply partitioning in MySQL 5.1, and walk through an example of hash partitioning that can be applied to most OLTP database applications.
Partitioning does not have to be limited to the traditional data warehouse – it’s directly applicable to your OLTP database.
Phil Hildebrand has been working with a wide variety of platforms including MySQL, Oracle, Informix, and SQLServer since 1989.
Early in his career Phil was a UNIX systems programmer writing lexical analyzers for phone book pagination systems, which lead him into database design and development.
Currently Phil focuses on scaling VLDB systems on both UNIX and Windows operating systems in production environments.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com.
Download the MySQL Sponsor/Exhibitor Prospectus
Download the Media & Promotional Partner Brochure (PDF) for more information on trade opportunities with O'Reilly conferences, or contact Avila Reese at mediapartners@oreilly.com.
For media-related inquiries, contact confpr@oreilly.com.
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.