Performance Tuning Best Practices for MySQL

Google TechTalks April 28, 2006

Jay Pipes Jay Pipes is a co-author of the recently published Pro MySQL (Apress, 2005), which covers ... all » all of the newest MySQL 5 features, as well as in-depth discussion and analysis of the MySQL server architecture, storage engines, transaction procesing, benchmarking, and advanced SQL scenarios. You can also see his name on articles appearing in Linux Magazine and can read more articles about MySQL at his website.

ABSTRACT Learn where to best focus your attention when tuning the performance of your applications and database servers, and how to effectively find the "low hanging fruit" on the tree of bottlenecks. It's not rocket science, but with a bit of acquired skill and experience, and of course good habits, you too can do this magic! Jay Pipes is MySQL's Community Relations Manager for North America.

iClaustron: Open Source Grid Cluster Storage Controller

Google Tech Talks October 17, 2006

Mikael Ronstrom has a Ph.D in technical information systems. He is the founder of the technology in ... all » NDB Cluster, the storage engine of MySQL Cluster. Lately he developed the Partitioning feature in MySQL 5.1. He has a long background from the telecom industry with many innovative solutions developed. Currently he works as an open source consultant at iClaustron AB and spends also some time on some new ideas in the area of clustered storage systems.

ABSTRACT Many applications has requirements to store petabytes of base data and many terabytes of structured data. Examples of this are genealogy, astronomy, biotech and so forth. This talk will discuss requirements from the genealogy application and show how this requirements requires building very large clustered systems with an hierarchy of clusters. These clusters are used to both store base data and structured data. He goes on to show how these requirements translate into a systems architecture with essential components of off-the shelf servers, cheap storage, clustered software and integrated cluster interconnects.

A Googly MySQL Cluster Talk

Google TechTalks April 28, 2006
Stewart Smith Stewart Smith works for MySQL AB as a software engineer working on MySQL Cluster. He is ... all » an active member of the free and open source software community, especially in Australia.

ABSTRACT Part 1 - Introduction to MySQL Cluster The NDB storage engine (MySQL Cluster) is a high-availability storage engine for MySQL. It provides synchronous replication between storage nodes and many mysql servers having a consistent view of the database. In 4.1 and 5.0 it's a main memory database, but in 5.1 non-indexed attributes can be stored on disk. NDB also provides a lot of determinism in system resource usage. I'll talk a bit about that.

Part 2 - New features in 5.1 including cluster to cluster replication, disk based data and a bunch of other things. anybody that is attending the mysql users conference may find this eerily familiar.