Providing educational resources and monetary grants to IT professionals.

Liveblogging: Senior Skills: Sysadmin Patterns

The Beacon Pattern:
- This is a “Get out of the business” pattern
- Identify an oft-occurring and annoying task
- Automate and document it to the point of being able to hand it off to someone far less technical
Example:
- System admins were being put in charge of scheduling rooms in the building
- They wrote a PHP web application to help them automate the task
- They refined the app, documented how to use it, and handed it off to a secretary
- They have to maintain the app, but it’s far less work.
The Community Pattern:

- Prior to launch of a new service, create user documentation for it.
- Point a few early adopters at the documentation and see if they can use the service with minimal support
- Use feedback to improve documentation, and the service
- Upon launch, create a mailing list, forum, IRC channel, or Jabber chat room and ask early adopters to help test it out.
- Upon launch, your early adopters are the community, and they’ll tell new users to use the tools you’ve provided instead of calling you.

Liveblogging: Seeking Senior and Beyond

I am attending the Professional IT Community Conference – it is put on by the League of Professional System Administrators (LOPSA), and is a 2-day community conference. There are technical and “soft” topics — the audience is system administrators. While technical topics such as Essential IPv6 for Linux Administrators are not essential for my job, many of the “soft” topics are directly applicable and relevant to DBAs too. (I am speaking on How to Stop Hating MySQL tomorrow.)

MySQL Track at Kaleidoscope

On Monday, Ronald Bradford posted that the independent Oracle Developer Tools User Group had opened up their Kaleidoscope Conference, well-known throughout the Oracle community for in-depth technical sessions for developers, to the MySQL community. Giuseppe Maxia posted his thoughts on Tuesday.
We have confirmed that there will be an entire MySQL track at Kaleidoscope! Because Kaleidoscope is less than 8 weeks away, we could not go through a standard call for papers. Ronald and I have been working to come up with appropriate topics and speakers for an audience that uses MySQL but is probably more familiar with Oracle. We contacted folks we thought would be interested, and who we thought could make it logistically, as the conference is in Washington, D.C.

MySQL Track at Kaleidoscope

On Monday, Ronald Bradford posted that the independent Oracle Developer Tools User Group had opened up their Kaleidoscope Conference, well-known throughout the Oracle community for in-depth technical sessions for developers, to the MySQL community. Giuseppe Maxia posted his thoughts on Tuesday.
We have confirmed that there will be an entire MySQL track at Kaleidoscope! Because Kaleidoscope is less than 8 weeks away, we could not go through a standard call for papers. Ronald and I have been working to come up with appropriate topics and speakers for an audience that uses MySQL but is probably more familiar with Oracle. We contacted folks we thought would be interested, and who we thought could make it logistically, as the conference is in Washington, D.C.

MySQL Track at Kaleidoscope

EAVB_TTDQLIIFNG
On Monday, Ronald Bradford posted that the independent Oracle Developer Tools User Group had opened up their Kaleidoscope Conference, well-known throughout the Oracle community for in-depth technical sessions for developers, to the MySQL community. Giuseppe Maxia posted his thoughts on Tuesday.
We have confirmed that there will be an entire MySQL track at Kaleidoscope! Because Kaleidoscope is less than 8 weeks away, we could not go through a standard call for papers. Ronald and I have been working to come up with appropriate topics and speakers for an audience that uses MySQL but is probably more familiar with Oracle. We contacted folks we thought would be interested, and who we thought could make it logistically, as the conference is in Washington, D.C.

2010 O’Reilly MySQL Conference Slides and Videos

Here’s a matrix of all the videos up on YouTube for the 2010 O’Reilly MySQL Conference and Expo. The matrix includes the title, presenter, slide link (if it exists), video link, and link to the official conference detail page, where you can rate the session and provide feedback that the presenter will see. They are grouped mostly by topic, except for the main stage events (keynote, ignite) and interviews.
If there’s a detail missing (ie, slides, or there are other videos you know about), please add a comment so I can make this a complete matrix.TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)KeynotesState of the DolphinEdward Screven (Oracle)29:10session 12440O’Reilly RadarTim O’Reilly36:38session 12441MySQL at FacebookMark Callaghan (Facebook)21:05session 14841State of MariaDBMonty Widenius (Monty Program Ab)41:54session 12443State of DrizzleBrian Aker (Data Differential)44:58session 12442Keynote: Under New Management: Next Steps for the CommunitySheeri K. Cabral (Pythian)18:16session 14808State of the MySQL CommunityKaj Arnö (Sun Microsystems GmbH)38:06session 12498The Engines of CommunityJono Bacon (Canonical, Ltd)47:51session 14796The Best of Ignite MySQLSarah Novotny, Gerry Narvaja, Gillian Gunson, Mark Atwood23:25RethinkDB: Why Start a New Database Company in 2010Slava Akhmechet (RethinkDB), Michael Glukhovsky (RethinkDB)44:49session 14891Ignite Talks
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Backups Don’t Make Me MoneySarah Novotny (Blue Gecko)6:52Also in Best of IgniteCalpont’s InfiniDBRobin Schumacher (Calpont)6:40A Future [for MySQL]Mark Callaghan (Facebook)6:37/TD>A Guide to NoSQLBrian Aker (Data Differential)6:27Guide to NoSQL, reduxMark Atwood (Gear6)4:22Also in Best of IgniteThe Gunson Rules of Database AdministrationGillian Gunson6:08Also in Best of IgniteMariaDB: 20 slides, 5 minutes, the full MontyMonty Widenius (Monty Program Ab)6:18MySQLtuner 2.0Sheeri K. Cabral (Pythian)PDF5:31“Painting” Data with Entrance (free) and MySQLTod Landis (dbEntrance Software)5:11Three Basic Laws of DB DiagnosisGerry Narvaja (OpenMarket, Inc)2:33Also in Best of IgniteWhat is the difference between XtraDB and others?Baron Schwartz (Percona)6:59What is a Performance Model for SSD’s?Bradley C. Kuszmaul (Tokutek)7:00InterviewsTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Why having InnoDB and MySQL in the same company will improve performance, the way Drizzle leaves the past behind, and other issues in MySQL Development. Kaj Arnö (MySQL)10:40What’s hard to optimize in MySQL, how they’ve improved performance, and what’s in the performance schema.Peter Gulutzan3:01Write-scaling, MySQL performance in an EC2 cloud, why they wrote the book MySQL High Availability.Charles Bell, Mats Kindahl, and Lars Thalmann7:04How third-party ads make web sites slow, why mobile devices are the next frontier in Web performance.Steve Souders, Web performance expert7:12Attractions of Gearman, the adaptation of database technology to large multi-core and multi-node environments, and what relational databases are and are not great for.Brian Aker9:01Thoughts on Drizzle and MySQLSheeri K. Cabral (Pythian)9:22 Democratic culture of Monty Program ABHenrik Ingo (Monty Program AB)2:20Thoughts on democratic companies and his role is in coding and managementMonty Widenius (Monty Program Ab)8:52How MariaDB emerged as a superset of MySQL, and development issues.Kurt von Finck (MontyProgram Ab)7:23TutorialsTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)MySQL Configuration Options and Files: Basic MySQL Variables (Part 1)Sheeri K. Cabral (Pythian)PDF1:25:04, pre-break1:35:47, post-breaksession 12408MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)Sheeri K. Cabral (Pythian)PDF1:25:04, pre-break1:24:28, post-breaksession 12435SessionsPerformanceTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Advanced Sharding Techniques with SpiderKentoku Shiba () and Daniel Saito (MySQL)39:55session 12619Boosting Database Performance with GearmanEric Day (Rackspace Cloud), Giuseppe Maxia (MySQL)46:18session 13310High Concurrency MySQLDomas Mituzas (Facebook)PDF49:53session 13285High-throughput MySQLMark Callaghan (Facebook), Ryan Mack (Facebook), Ryan McElroy (Facebook)57:31session 13223Introduction to InnoDB Monitoring System and Resource & Performance TuningJimmy Yang (Oracle Corporation)ZIP40:49session 13508Linux Performance Tuning and Stabilization TipsYoshinori Matsunobu (Sun Microsystems)slideshare.net48:45session 13252Debugging and Reactive/Proactive MonitoringTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Better Database Debugging for Shorter DowntimesRob Hamel (Pythian)PDF33:13
session 13021Continual Replication SyncDanil Zburivsky (Pythian)ODP45:57session 13428Find Query Problems Proactively With Query ReviewsSheeri K. Cabral (Pythian)PDF45:59session 13267Monitoring Drizzle or MySQL With DTrace and SystemTapPadraig O’Sullivan (Akiba Technologies Inc.)PDF42:33session 12472Security / Risk Management
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Achieving PCI Compliance with MySQLRyan Lowe (Percona)PPTX58:24session 12484Security Around MySQLDanil Zburivsky (Pythian)ODP37:27session 13458Securich – A Security and User Administration plugin for MySQLDarren Cassar (Trading Screen Inc)PDF54:05session 13351Other DBA-related
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Galera – Synchronous Multi-master Replication For InnoDBSeppo Jaakola (Codership), Alexey Yurchenko (Codership) PDF47:39session 13286Large Deployment Best PracticesNicklas Westerlund (Electronic Arts)40:37session 12567MySQL Cluster: An IntroductionGeert Vanderkelen (Sun Microsystems)PDF47:30session 12469Migration From Oracle to MySQL : An NPR Case StudyJoanne Garlow (National Public Radio)PPT34:35session 13404New Replication FeaturesMats Kindahl (Sun Microsystems), Lars Thalmann (MySQL)PDF53:32session 12451Successful and Cost Effective Data Warehouse… The MySQL WayIvan Zoratti (MySQL)PDF1:00:25session 13343The Thinking Person’s Guide to Data Warehouse DesignRobin Schumacher (Calpont)slideshare.net59:50session 13366Using DrizzleEric Day (Rackspace Cloud), Monty Taylor (Rackspace Cloud)58:21session 13308Other Developer-relatedTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)
Connecting MySQL and PythonGeert Vanderkelen (Sun Microsystems)PDF54:56session 13251MySQL Plugin API: New FeaturesSergei Golubchik (MariaDB)ZIP40:14session 13143
PHP Object-Relational Mapping Libraries In ActionFernando Ipar (Percona)PDF49:45session 12489Scalability and Reliability Features of MySQL Connector/JMark Matthews (Oracle), Todd Farmer (Oracle Corporation)PDF39:07session 12448Time Zones and MySQLSheeri K. Cabral (Pythian)PDF45:54session 12412Using Visual Studio 2010MySQL Reggie Burnett (Oracle), Mike Frank (Oracle)ZIP37:53session 13365

2010 O’Reilly MySQL Conference Slides and Videos

Here’s a matrix of all the videos up on YouTube for the 2010 O’Reilly MySQL Conference and Expo. The matrix includes the title, presenter, slide link (if it exists), video link, and link to the official conference detail page, where you can rate the session and provide feedback that the presenter will see. They are grouped mostly by topic, except for the main stage events (keynote, ignite) and interviews.
If there’s a detail missing (ie, slides, or there are other videos you know about), please add a comment so I can make this a complete matrix.TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)KeynotesState of the DolphinEdward Screven (Oracle)29:10session 12440O’Reilly RadarTim O’Reilly36:38session 12441MySQL at FacebookMark Callaghan (Facebook)21:05session 14841State of MariaDBMonty Widenius (Monty Program Ab)41:54session 12443State of DrizzleBrian Aker (Data Differential)44:58session 12442Keynote: Under New Management: Next Steps for the CommunitySheeri K. Cabral (Pythian)18:16session 14808State of the MySQL CommunityKaj Arnö (Sun Microsystems GmbH)38:06session 12498The Engines of CommunityJono Bacon (Canonical, Ltd)47:51session 14796The Best of Ignite MySQLSarah Novotny, Gerry Narvaja, Gillian Gunson, Mark Atwood23:25RethinkDB: Why Start a New Database Company in 2010Slava Akhmechet (RethinkDB), Michael Glukhovsky (RethinkDB)44:49session 14891Ignite Talks
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Backups Don’t Make Me MoneySarah Novotny (Blue Gecko)6:52Also in Best of IgniteCalpont’s InfiniDBRobin Schumacher (Calpont)6:40A Future [for MySQL]Mark Callaghan (Facebook)6:37/TD>A Guide to NoSQLBrian Aker (Data Differential)6:27Guide to NoSQL, reduxMark Atwood (Gear6)4:22Also in Best of IgniteThe Gunson Rules of Database AdministrationGillian Gunson6:08Also in Best of IgniteMariaDB: 20 slides, 5 minutes, the full MontyMonty Widenius (Monty Program Ab)6:18MySQLtuner 2.0Sheeri K. Cabral (Pythian)PDF5:31“Painting” Data with Entrance (free) and MySQLTod Landis (dbEntrance Software)5:11Three Basic Laws of DB DiagnosisGerry Narvaja (OpenMarket, Inc)2:33Also in Best of IgniteWhat is the difference between XtraDB and others?Baron Schwartz (Percona)6:59What is a Performance Model for SSD’s?Bradley C. Kuszmaul (Tokutek)7:00InterviewsTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Why having InnoDB and MySQL in the same company will improve performance, the way Drizzle leaves the past behind, and other issues in MySQL Development. Kaj Arnö (MySQL)10:40What’s hard to optimize in MySQL, how they’ve improved performance, and what’s in the performance schema.Peter Gulutzan3:01Write-scaling, MySQL performance in an EC2 cloud, why they wrote the book MySQL High Availability.Charles Bell, Mats Kindahl, and Lars Thalmann7:04How third-party ads make web sites slow, why mobile devices are the next frontier in Web performance.Steve Souders, Web performance expert7:12Attractions of Gearman, the adaptation of database technology to large multi-core and multi-node environments, and what relational databases are and are not great for.Brian Aker9:01Thoughts on Drizzle and MySQLSheeri K. Cabral (Pythian)9:22 Democratic culture of Monty Program ABHenrik Ingo (Monty Program AB)2:20Thoughts on democratic companies and his role is in coding and managementMonty Widenius (Monty Program Ab)8:52How MariaDB emerged as a superset of MySQL, and development issues.Kurt von Finck (MontyProgram Ab)7:23TutorialsTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)MySQL Configuration Options and Files: Basic MySQL Variables (Part 1)Sheeri K. Cabral (Pythian)PDF1:25:04, pre-break1:35:47, post-breaksession 12408MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)Sheeri K. Cabral (Pythian)PDF1:25:04, pre-break1:24:28, post-breaksession 12435SessionsPerformanceTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Advanced Sharding Techniques with SpiderKentoku Shiba () and Daniel Saito (MySQL)39:55session 12619Boosting Database Performance with GearmanEric Day (Rackspace Cloud), Giuseppe Maxia (MySQL)46:18session 13310High Concurrency MySQLDomas Mituzas (Facebook)PDF49:53session 13285High-throughput MySQLMark Callaghan (Facebook), Ryan Mack (Facebook), Ryan McElroy (Facebook)57:31session 13223Introduction to InnoDB Monitoring System and Resource & Performance TuningJimmy Yang (Oracle Corporation)ZIP40:49session 13508Linux Performance Tuning and Stabilization TipsYoshinori Matsunobu (Sun Microsystems)slideshare.net48:45session 13252Debugging and Reactive/Proactive MonitoringTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Better Database Debugging for Shorter DowntimesRob Hamel (Pythian)PDF33:13
session 13021Continual Replication SyncDanil Zburivsky (Pythian)ODP45:57session 13428Find Query Problems Proactively With Query ReviewsSheeri K. Cabral (Pythian)PDF45:59session 13267Monitoring Drizzle or MySQL With DTrace and SystemTapPadraig O’Sullivan (Akiba Technologies Inc.)PDF42:33session 12472Security / Risk Management
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Achieving PCI Compliance with MySQLRyan Lowe (Percona)PPTX58:24session 12484Security Around MySQLDanil Zburivsky (Pythian)ODP37:27session 13458Securich – A Security and User Administration plugin for MySQLDarren Cassar (Trading Screen Inc)PDF54:05session 13351Other DBA-related
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Galera – Synchronous Multi-master Replication For InnoDBSeppo Jaakola (Codership), Alexey Yurchenko (Codership) PDF47:39session 13286Large Deployment Best PracticesNicklas Westerlund (Electronic Arts)40:37session 12567MySQL Cluster: An IntroductionGeert Vanderkelen (Sun Microsystems)PDF47:30session 12469Migration From Oracle to MySQL : An NPR Case StudyJoanne Garlow (National Public Radio)PPT34:35session 13404New Replication FeaturesMats Kindahl (Sun Microsystems), Lars Thalmann (MySQL)PDF53:32session 12451Successful and Cost Effective Data Warehouse… The MySQL WayIvan Zoratti (MySQL)PDF1:00:25session 13343The Thinking Person’s Guide to Data Warehouse DesignRobin Schumacher (Calpont)slideshare.net59:50session 13366Using DrizzleEric Day (Rackspace Cloud), Monty Taylor (Rackspace Cloud)58:21session 13308Other Developer-relatedTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)
Connecting MySQL and PythonGeert Vanderkelen (Sun Microsystems)PDF54:56session 13251MySQL Plugin API: New FeaturesSergei Golubchik (MariaDB)ZIP40:14session 13143
PHP Object-Relational Mapping Libraries In ActionFernando Ipar (Percona)PDF49:45session 12489Scalability and Reliability Features of MySQL Connector/JMark Matthews (Oracle), Todd Farmer (Oracle Corporation)PDF39:07session 12448Time Zones and MySQLSheeri K. Cabral (Pythian)PDF45:54session 12412Using Visual Studio 2010MySQL Reggie Burnett (Oracle), Mike Frank (Oracle)ZIP37:53session 13365

2010 O’Reilly MySQL Conference Slides and Videos

Here’s a matrix of all the videos up on YouTube for the 2010 O’Reilly MySQL Conference and Expo. The matrix includes the title, presenter, slide link (if it exists), video link, and link to the official conference detail page, where you can rate the session and provide feedback that the presenter will see. They are grouped mostly by topic, except for the main stage events (keynote, ignite) and interviews.
If there’s a detail missing (ie, slides, or there are other videos you know about), please add a comment so I can make this a complete matrix.TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)KeynotesState of the DolphinEdward Screven (Oracle)29:10session 12440O’Reilly RadarTim O’Reilly36:38session 12441MySQL at FacebookMark Callaghan (Facebook)21:05session 14841State of MariaDBMonty Widenius (Monty Program Ab)41:54session 12443State of DrizzleBrian Aker (Data Differential)44:58session 12442Keynote: Under New Management: Next Steps for the CommunitySheeri K. Cabral (Pythian)18:16session 14808State of the MySQL CommunityKaj Arnö (Sun Microsystems GmbH)38:06session 12498The Engines of CommunityJono Bacon (Canonical, Ltd)47:51session 14796The Best of Ignite MySQLSarah Novotny, Gerry Narvaja, Gillian Gunson, Mark Atwood23:25RethinkDB: Why Start a New Database Company in 2010Slava Akhmechet (RethinkDB), Michael Glukhovsky (RethinkDB)44:49session 14891Ignite Talks
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Backups Don’t Make Me MoneySarah Novotny (Blue Gecko)6:52Also in Best of IgniteCalpont’s InfiniDBRobin Schumacher (Calpont)6:40A Future [for MySQL]Mark Callaghan (Facebook)6:37/TD>A Guide to NoSQLBrian Aker (Data Differential)6:27Guide to NoSQL, reduxMark Atwood (Gear6)4:22Also in Best of IgniteThe Gunson Rules of Database AdministrationGillian Gunson6:08Also in Best of IgniteMariaDB: 20 slides, 5 minutes, the full MontyMonty Widenius (Monty Program Ab)6:18MySQLtuner 2.0Sheeri K. Cabral (Pythian)PDF5:31“Painting” Data with Entrance (free) and MySQLTod Landis (dbEntrance Software)5:11Three Basic Laws of DB DiagnosisGerry Narvaja (OpenMarket, Inc)2:33Also in Best of IgniteWhat is the difference between XtraDB and others?Baron Schwartz (Percona)6:59What is a Performance Model for SSD’s?Bradley C. Kuszmaul (Tokutek)7:00InterviewsTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Why having InnoDB and MySQL in the same company will improve performance, the way Drizzle leaves the past behind, and other issues in MySQL Development. Kaj Arnö (MySQL)10:40What’s hard to optimize in MySQL, how they’ve improved performance, and what’s in the performance schema.Peter Gulutzan3:01Write-scaling, MySQL performance in an EC2 cloud, why they wrote the book MySQL High Availability.Charles Bell, Mats Kindahl, and Lars Thalmann7:04How third-party ads make web sites slow, why mobile devices are the next frontier in Web performance.Steve Souders, Web performance expert7:12Attractions of Gearman, the adaptation of database technology to large multi-core and multi-node environments, and what relational databases are and are not great for.Brian Aker9:01Thoughts on Drizzle and MySQLSheeri K. Cabral (Pythian)9:22 Democratic culture of Monty Program ABHenrik Ingo (Monty Program AB)2:20Thoughts on democratic companies and his role is in coding and managementMonty Widenius (Monty Program Ab)8:52How MariaDB emerged as a superset of MySQL, and development issues.Kurt von Finck (MontyProgram Ab)7:23TutorialsTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)MySQL Configuration Options and Files: Basic MySQL Variables (Part 1)Sheeri K. Cabral (Pythian)PDF1:25:04, pre-break1:35:47, post-breaksession 12408MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)Sheeri K. Cabral (Pythian)PDF1:25:04, pre-break1:24:28, post-breaksession 12435SessionsPerformanceTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Advanced Sharding Techniques with SpiderKentoku Shiba () and Daniel Saito (MySQL)39:55session 12619Boosting Database Performance with GearmanEric Day (Rackspace Cloud), Giuseppe Maxia (MySQL)46:18session 13310High Concurrency MySQLDomas Mituzas (Facebook)PDF49:53session 13285High-throughput MySQLMark Callaghan (Facebook), Ryan Mack (Facebook), Ryan McElroy (Facebook)57:31session 13223Introduction to InnoDB Monitoring System and Resource & Performance TuningJimmy Yang (Oracle Corporation)ZIP40:49session 13508Linux Performance Tuning and Stabilization TipsYoshinori Matsunobu (Sun Microsystems)slideshare.net48:45session 13252Debugging and Reactive/Proactive MonitoringTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Better Database Debugging for Shorter DowntimesRob Hamel (Pythian)PDF33:13
session 13021Continual Replication SyncDanil Zburivsky (Pythian)ODP45:57session 13428Find Query Problems Proactively With Query ReviewsSheeri K. Cabral (Pythian)PDF45:59session 13267Monitoring Drizzle or MySQL With DTrace and SystemTapPadraig O’Sullivan (Akiba Technologies Inc.)PDF42:33session 12472Security / Risk Management
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Achieving PCI Compliance with MySQLRyan Lowe (Percona)PPTX58:24session 12484Security Around MySQLDanil Zburivsky (Pythian)ODP37:27session 13458Securich – A Security and User Administration plugin for MySQLDarren Cassar (Trading Screen Inc)PDF54:05session 13351Other DBA-related
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Galera – Synchronous Multi-master Replication For InnoDBSeppo Jaakola (Codership), Alexey Yurchenko (Codership) PDF47:39session 13286Large Deployment Best PracticesNicklas Westerlund (Electronic Arts)40:37session 12567MySQL Cluster: An IntroductionGeert Vanderkelen (Sun Microsystems)PDF47:30session 12469Migration From Oracle to MySQL : An NPR Case StudyJoanne Garlow (National Public Radio)PPT34:35session 13404New Replication FeaturesMats Kindahl (Sun Microsystems), Lars Thalmann (MySQL)PDF53:32session 12451Successful and Cost Effective Data Warehouse… The MySQL WayIvan Zoratti (MySQL)PDF1:00:25session 13343The Thinking Person’s Guide to Data Warehouse DesignRobin Schumacher (Calpont)slideshare.net59:50session 13366Using DrizzleEric Day (Rackspace Cloud), Monty Taylor (Rackspace Cloud)58:21session 13308Other Developer-relatedTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)
Connecting MySQL and PythonGeert Vanderkelen (Sun Microsystems)PDF54:56session 13251MySQL Plugin API: New FeaturesSergei Golubchik (MariaDB)ZIP40:14session 13143
PHP Object-Relational Mapping Libraries In ActionFernando Ipar (Percona)PDF49:45session 12489Scalability and Reliability Features of MySQL Connector/JMark Matthews (Oracle), Todd Farmer (Oracle Corporation)PDF39:07session 12448Time Zones and MySQLSheeri K. Cabral (Pythian)PDF45:54session 12412Using Visual Studio 2010MySQL Reggie Burnett (Oracle), Mike Frank (Oracle)ZIP37:53session 13365

2010 O’Reilly MySQL Conference Slides and Videos

Here’s a matrix of all the videos up on YouTube for the 2010 O’Reilly MySQL Conference and Expo. The matrix includes the title, presenter, slide link (if it exists), video link, and link to the official conference detail page, where you can rate the session and provide feedback that the presenter will see. They are grouped mostly by topic, except for the main stage events (keynote, ignite) and interviews.
If there’s a detail missing (ie, slides, or there are other videos you know about), please add a comment so I can make this a complete matrix.TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)KeynotesState of the DolphinEdward Screven (Oracle)29:10session 12440O’Reilly RadarTim O’Reilly36:38session 12441MySQL at FacebookMark Callaghan (Facebook)21:05session 14841State of MariaDBMonty Widenius (Monty Program Ab)41:54session 12443State of DrizzleBrian Aker (Data Differential)44:58session 12442Keynote: Under New Management: Next Steps for the CommunitySheeri K. Cabral (Pythian)18:16session 14808State of the MySQL CommunityKaj Arnö (Sun Microsystems GmbH)38:06session 12498The Engines of CommunityJono Bacon (Canonical, Ltd)47:51session 14796The Best of Ignite MySQLSarah Novotny, Gerry Narvaja, Gillian Gunson, Mark Atwood23:25RethinkDB: Why Start a New Database Company in 2010Slava Akhmechet (RethinkDB), Michael Glukhovsky (RethinkDB)44:49session 14891Ignite Talks
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Backups Don’t Make Me MoneySarah Novotny (Blue Gecko)6:52Also in Best of IgniteCalpont’s InfiniDBRobin Schumacher (Calpont)6:40A Future [for MySQL]Mark Callaghan (Facebook)6:37/TD>A Guide to NoSQLBrian Aker (Data Differential)6:27Guide to NoSQL, reduxMark Atwood (Gear6)4:22Also in Best of IgniteThe Gunson Rules of Database AdministrationGillian Gunson6:08Also in Best of IgniteMariaDB: 20 slides, 5 minutes, the full MontyMonty Widenius (Monty Program Ab)6:18MySQLtuner 2.0Sheeri K. Cabral (Pythian)PDF5:31“Painting” Data with Entrance (free) and MySQLTod Landis (dbEntrance Software)5:11Three Basic Laws of DB DiagnosisGerry Narvaja (OpenMarket, Inc)2:33Also in Best of IgniteWhat is the difference between XtraDB and others?Baron Schwartz (Percona)6:59What is a Performance Model for SSD’s?Bradley C. Kuszmaul (Tokutek)7:00InterviewsTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Why having InnoDB and MySQL in the same company will improve performance, the way Drizzle leaves the past behind, and other issues in MySQL Development. Kaj Arnö (MySQL)10:40What’s hard to optimize in MySQL, how they’ve improved performance, and what’s in the performance schema.Peter Gulutzan3:01Write-scaling, MySQL performance in an EC2 cloud, why they wrote the book MySQL High Availability.Charles Bell, Mats Kindahl, and Lars Thalmann7:04How third-party ads make web sites slow, why mobile devices are the next frontier in Web performance.Steve Souders, Web performance expert7:12Attractions of Gearman, the adaptation of database technology to large multi-core and multi-node environments, and what relational databases are and are not great for.Brian Aker9:01Thoughts on Drizzle and MySQLSheeri K. Cabral (Pythian)9:22 Democratic culture of Monty Program ABHenrik Ingo (Monty Program AB)2:20Thoughts on democratic companies and his role is in coding and managementMonty Widenius (Monty Program Ab)8:52How MariaDB emerged as a superset of MySQL, and development issues.Kurt von Finck (MontyProgram Ab)7:23TutorialsTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)MySQL Configuration Options and Files: Basic MySQL Variables (Part 1)Sheeri K. Cabral (Pythian)PDF1:25:04, pre-break1:35:47, post-breaksession 12408MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)Sheeri K. Cabral (Pythian)PDF1:25:04, pre-break1:24:28, post-breaksession 12435SessionsPerformanceTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Advanced Sharding Techniques with SpiderKentoku Shiba () and Daniel Saito (MySQL)39:55session 12619Boosting Database Performance with GearmanEric Day (Rackspace Cloud), Giuseppe Maxia (MySQL)46:18session 13310High Concurrency MySQLDomas Mituzas (Facebook)PDF49:53session 13285High-throughput MySQLMark Callaghan (Facebook), Ryan Mack (Facebook), Ryan McElroy (Facebook)57:31session 13223Introduction to InnoDB Monitoring System and Resource & Performance TuningJimmy Yang (Oracle Corporation)ZIP40:49session 13508Linux Performance Tuning and Stabilization TipsYoshinori Matsunobu (Sun Microsystems)slideshare.net48:45session 13252Debugging and Reactive/Proactive MonitoringTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Better Database Debugging for Shorter DowntimesRob Hamel (Pythian)PDF33:13
session 13021Continual Replication SyncDanil Zburivsky (Pythian)ODP45:57session 13428Find Query Problems Proactively With Query ReviewsSheeri K. Cabral (Pythian)PDF45:59session 13267Monitoring Drizzle or MySQL With DTrace and SystemTapPadraig O’Sullivan (Akiba Technologies Inc.)PDF42:33session 12472Security / Risk Management
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Achieving PCI Compliance with MySQLRyan Lowe (Percona)PPTX58:24session 12484Security Around MySQLDanil Zburivsky (Pythian)ODP37:27session 13458Securich – A Security and User Administration plugin for MySQLDarren Cassar (Trading Screen Inc)PDF54:05session 13351Other DBA-related
TitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)Galera – Synchronous Multi-master Replication For InnoDBSeppo Jaakola (Codership), Alexey Yurchenko (Codership) PDF47:39session 13286Large Deployment Best PracticesNicklas Westerlund (Electronic Arts)40:37session 12567MySQL Cluster: An IntroductionGeert Vanderkelen (Sun Microsystems)PDF47:30session 12469Migration From Oracle to MySQL : An NPR Case StudyJoanne Garlow (National Public Radio)PPT34:35session 13404New Replication FeaturesMats Kindahl (Sun Microsystems), Lars Thalmann (MySQL)PDF53:32session 12451Successful and Cost Effective Data Warehouse… The MySQL WayIvan Zoratti (MySQL)PDF1:00:25session 13343The Thinking Person’s Guide to Data Warehouse DesignRobin Schumacher (Calpont)slideshare.net59:50session 13366Using DrizzleEric Day (Rackspace Cloud), Monty Taylor (Rackspace Cloud)58:21session 13308Other Developer-relatedTitlePresenterSlidesVideo link(hr:min:sec)Details (Conf. site link)
Connecting MySQL and PythonGeert Vanderkelen (Sun Microsystems)PDF54:56session 13251MySQL Plugin API: New FeaturesSergei Golubchik (MariaDB)ZIP40:14session 13143
PHP Object-Relational Mapping Libraries In ActionFernando Ipar (Percona)PDF49:45session 12489Scalability and Reliability Features of MySQL Connector/JMark Matthews (Oracle), Todd Farmer (Oracle Corporation)PDF39:07session 12448Time Zones and MySQLSheeri K. Cabral (Pythian)PDF45:54session 12412Using Visual Studio 2010MySQL Reggie Burnett (Oracle), Mike Frank (Oracle)ZIP37:53session 13365

Videos of Pythian Sessions from the 2010 O’Reilly MySQL Conference and Expo

Here’s a sneak peek at a video matrix — this is all the videos that include Pythian Group employees at the MySQL conference. I hope to have all the rest of the videos processed and uploaded within 24 hours, with a matrix similar to the one below (but of course with many more sessions).
TitlePresenterSlidesVideo link (hr:min:sec)Details (Conf. site link)Main StageKeynote: Under New Management: Next Steps for the CommunitySheeri K. Cabral (Pythian)N/A18:16
session 14808Ignite talk: MySQLtuner 2.0Sheeri K. Cabral (Pythian)PDF5:31N/AInterviewThoughts on Drizzle and MySQLSheeri K. Cabral (Pythian)N/A9:22N/ATutorialsMySQL Configuration Options and Files: Basic MySQL Variables (Part 1)Sheeri K. Cabral (Pythian)
PDF
1:25:04, pre-break1:35:47, post-breaksession 12408MySQL Configuration Options and Files: Intermediate MySQL Variables (Part 2)Sheeri K. Cabral (Pythian)
PDF
1:25:04, pre-break1:24:28, post-break
session 12435
SessionsBetter Database Debugging for Shorter DowntimesRob Hamel (Pythian)PDF33:13
session 13021Find Query Problems Proactively With Query ReviewsSheeri K. Cabral (Pythian)PDF45:59session 13267Time Zones and MySQLSheeri K. Cabral (Pythian)PDF45:54
session 12412Security Around MySQLDanil Zburivsky (The Pythian Group)ODP37:27session 13458Continual Replication SyncDanil Zburivsky (The Pythian Group)ODP45:57session 13428