FOSDEM 2009 Developer Room
There will be a MySQL Developer Room at FOSDEM 2009 on Sunday, 8th of February, providing a number of MySQL-related talks and sessions.
The room number is AW1.126 and has a capacity of 72 seats (in the building "AW"). It is equipped with a video projector with VGA cable and Internet connectivity (wifi A and B only, no wired).
[edit] Recordings / Transcripts
For people that could not make it to FOSDEM or any of the sessions, it would be nice to be able to provide video recordings or transcriptions (e.g. live blogging) from these talks. We're looking for volunteers to record the sessions!
[edit] Session schedule
This is the session schedule for the MySQL Developer Room at FOSDEM 2009. Each talk lasted 45 minutes, plus 10 minutes for Q&A. PDFs of the slides have been added to this page for all presentations that were made available.
| Time | Speaker | Title | Abstract | Speaker Bio |
|---|---|---|---|---|
| 09:00-09:05 | Lenz Grimmer | Welcome! | Quick welcome talk and introduction to the MySQL Devroom at FOSDEM 2009 | Lenz Grimmer works for the Database Group at Sun Microsystems as a MySQL Community Relations Manager. |
| 09:05-10:00 | Vladimir Kolesnikov | Practicing DBA's Guide to the PBXT Storage Engine | PBXT is an ACID-compliant storage engine for MySQL available for MySQL 5.1 and 6.0. PBXT is also available for Drizzle and is shipped as part of the OurDelta builds for MySQL.
PBXT is reaching GA state and now its a good time to learn how you as a DBA can benefit from this. During this session, attendees will learn about the best PBXT practices, including PBXT deployment architectures on various types of media, PBXT multicore performance, system variables and their tuning, startup parameters and run-time statistics. The session will also cover other practically important topics such as installation, compatibility with other storage engines, migration, monitoring, recovery of corrupted data, online backup. | Vladimir Kolesnikov joined Primbebase Technologies as a software engineer in September 2008, after more than 3 years in MySQL. At Primebase Technologies Vladimir is involved in the development of the PBXT storage engine for MySQL. Besides this work Vladimir also develops QOT – a query and index optimization tool for MySQL server. |
| 10:00-10:55 | Kris Buytaert | Monitoring MySQL | Over the past 18 months different open source monitoring solutions have popped up, some of them with a lot of potential. Zabbix, Zenoss and Hyperic are probably the most famous ones but other more specialized ones exist.
Last year we evaluated these Monitoring solutions and presented our findings at OLS. As we are MySQL users we obviously wanted to take a closer look at these tools regarding their integration with MySQL. This talk therefore will guide the MySQL users around in a selection of Open Source Monitoring tools that they could use to monitor MySQL as a part of a bigger infrastructure. | Kris Buytaert is a long time Linux and Open Source Consultant doing Linux and Open Source projects in Belgium , Europe and the rest of the universe. He is currently working for Inuits. |
| 10:55-11:50 | Geert Vanderkelen | MySQL Cluster | MySQL Cluster became a new product in 2008, but little is still known about it.
This talk will show how MySQL Cluster works, and show some practical situations where it can be useful. Version 6.4, the next release, will also be presented with some great new features coming in. | Geert Vanderkelen is a member of the MySQL Support Team at Sun Microsystems. He is based in Germany and has worked for MySQL AB since April, 2005. Before joining MySQL he worked as developer, DBA and SysAdmin for various companies in Belgium and Germany. Today, Geert specializes in MySQL Cluster and works together with colleagues around the world to ensure continued support for both customers and community. |
| 11:50-12:45 | Roland Bouman | MySQL 5.1 Plugins | MySQL 5.1 features the plugin API. In essence, the MySQL plugin API provides a generic extension point to the MySQL server. It allows users to load a shared library into the server to extend its functionality. A key feature is that this process is completely dynamic - the server need not be re-compiled and need not be stopped in order to benefit from the functionality of a new plugin. Hence, new functionality can be added without suffering any downtime.
This session provides an overview of the plugin architecture. The different plugin types will be described. Then, the process of creating your own plugins will be described. This will be illustrated with code examples. | Roland studied Molecular Biology, but is professionally occupied as a Web Application Developer, Information and Business Process Analyst, and Business Intelligence Guy. He has worked for Inter Access, MySQL AB, Sun Microsystems, and currently works for Strukton Rail. |
| 12:45-13:15 | Lunch break | |||
| 13:15-14:10 | Kaj Arnö | Q&A: Recent developments at Sun/MySQL, Roadmap | Interactive Q&A session about the changes announced this week:
| Kaj joined MySQL in 2001, after 14 years as an entrepreneur. He split his company into two, selling the half focusing on MySQL Training to MySQL AB and launching MySQL’s training department as VP Training. Since then, Kaj has been VP Professional Services, VP Services, and VP Engineering at MySQL, before assuming his last pure-MySQL role of VP Community Relations in 2005. With MySQL AB being acquired by Sun, Kaj continues to lead the MySQL community efforts, but devotes most of his time to his role as MySQL’s Ambassador to Sun. This involves meeting with Sun teams, customers and communities across organisational and geographical boundaries. A native of Finland, Kaj lives in Munich since 2006. |
| 14:10-15:05 | Roland Bouman | Starring Sakila | MySQL is increasingly being adopted for Business Intelligence (BI) and data warehousing (DWH) purposes. Although the technology as such is far from new, there is still quite noticeable confusion and misunderstanding among MySQL Developers and DBAs surrounding key BI/DWH concepts such as denormalization, dimensional modeling, ETL, and OLAP. Even if the concepts are clear, it is still not clear what the purpose is of a datawarehouse, and what problems it can solve.
The Sakila database is a simple, publicly available sample database of a DVD rental business, distributed by Sun (formerly MySQL AB). It is quite popular for illustrating traditional database schema design issues and SQL queries. The sakila database makes for a great mini-tutorial on how to design, create, load and use a data warehouse. In 45 minutes, attendees can witness exactly how this is done, and how the result differs from the original sakila schema. | Roland studied Molecular Biology, but is professionally occupied as a Web Application Developer, Information and Business Process Analyst, and Business Intelligence Guy. He has worked for Inter Access, MySQL AB, Sun Microsystems, and currently works for Strukton Rail. |
| 15:05-16:00 | Giuseppe Maxia | Boost performance with MySQL 5.1 partitions | MySQL 5.1 introduces partitioning – a very useful feature for databases with large tables. This session explains the benefits of partitioning and shows in practice how to take advantage of its features. Topics include:
| Giuseppe Maxia is the MySQL community team lead. A system analyst with 20 years of IT experience, he has worked as a database consultant and designer for several years. He is a frequent speaker at open source events and the author of many articles. He lives in Sardinia (Italy). |
| 16:00-16:55 | Jurriaan Persyn | Database Sharding at Netlog | Database sharding is an approach to horizontally scale databases by federating data over different servers. The talk will give an overview of the different approaches we have had and still have at Netlog, and how we came to the current solution. Experiences, tips and remarks from having worked on the Netlog implementation of sharding with mySQL and PHP, in a high availability and high performance focused environment, will be shared in this session. Related technologies include memcached and the Sphinx search engine, that are being used to tackle some of sharding's difficulties. | Jurriaan Persyn is a lead web developer at Netlog since 3 years, working on both back-end and front-end development. Netlog is a 36+ million member social network, targeted at the European youth and available in 25 languages. Netlog is being developed in Ghent, Belgium. |