FOSDEM 2010 Developer Room
There will be a MySQL Developer Room at FOSDEM 2010 on Sunday, 7th of February, providing a number of MySQL-related talks and sessions.
The room number is AW1.121 and has a capacity of 81 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!
- Connecting MySQL and Python, hand-out and wrap-up blog post.
[edit] Session schedule
This page will provide the session schedule for the "MySQL and Friends" Developer Room at FOSDEM 2010. Each talk will last 20 minutes, plus 5 minutes for Q&A. There will be a 5 minute break between each session, to allow people to leave/enter the room and the speakers to get hooked up. This schedule is available from the official FOSDEM schedule as well. However, this page is the authoritative source (as the FOSDEM version may not always be up to date with the latest changes).
PDFs or links to the presentation slides will later be added to this page. Click on the speaker name for the speaker's biography. Clicking on the session title will get you to the session abstract.
[edit] Abstracts
[edit] Drizzle, A MySQL fork for the Web
The Drizzle project is building a database optimized for Cloud and Net applications. It is being designed for massive concurrency on modern multi-cpu/core architecture. The code is originally derived from MySQL. The code has been simplified by removing many of the original features (Stored procedures, triggers, views, some types etc). Other features are being moved from the core to plugins.
[edit] Multi-Master Replication Manager for MySQL
- Introduction to MySQL high availability with MMM
- MMM architecture overview
- Pros and cons
- Examples of usage
[edit] 10x performance improvements - A case study
Taking a client from a 700ms (at times 1-2 seconds) page load time to a consistent 60ms is a great success story for improvement in database performance. In this presentation we will outline the steps taken and what can be applied to any website as one model to use in evaluation of your website.
While part of a longer talk, we will be reviewing the highlights including:
- Identify what is truly slow and high volume queries
- Choosing the right indexes including unique indexes, concatenated and partical indexes
- Choosing the right storage engines (MyISAM, InnoDB and Memory)
- Removing load including synchronous/real-time queries, master load, locking and sharding
- The best performance improvement for a SQL statement is to eliminate it
- Quantifying improvements made
The 10 Points are:
- Monitor, Monitor, Monitor
- Identify problem SQL
- Analyze problem SQL
- Indexes
- Offloading master load
- Improving SQL
- Storage engines
- Caching
- Sharding
- Handling database maintenance
Bonus: Front end improvements
[edit] MySQL HA overview
Database High Availability is often the core component to build a higly available infrastructure.
This presentation will guide you trough the different options available with their advantages and disadvantages when choosing a method to setup a Highly available MySQL setup.
We'll cover MySQL Cluster, MySQL DRBD, MultiMaster based HA setups and different others including a look at how to integrate them with the Operating System.
[edit] Correcting replication data drift with Maatkit
Replication with MySQL is very easy to set up but also very easy to break. As soon as inconsistencies are introduced, the master and the slaves start being desynchronized - and most often, you have no way to be quickly and efficiently aware of the problem as MySQL offers no built-in mechanism to check data consistency between servers.
Fortunately Maatkit has a neat solution with 2 nice scripts: mk-table-checksum, which is a tool to detect inconsistencies between a master and its slaves and mk-table-sync, which can correct automatically these problems detected with mk-table-checksum.
This session will show you first how to use both tools depending on your replication setup (master-slaves or master-master) and then how to get the most from the multiple options that are available.
[edit] State of phpMyAdmin
phpMyAdmin is still evolving. New features in version 3.3 include changes tracking, replication support and database synchronization. Other lesser known features like data transformation and graphical relational manager will be covered as well.
[edit] Daily Maintenance of Big Databases/Tables
This talk is about maintaining (or trying to maintain) big databases with large tables with a minimum of downtime and the tools helping for those tasks.
- Configure ibdata
- Backup ?
- Clean the data (optimize and archiving)
- Status of long queries in realtime
A short overview of innotop, maatkit, ptxarchiver, ...
[edit] Galera Replication for MySQL
This session will present the current state of Galera replication project. The presentation will contain elements like:
- High level overview of Galera replication method
- Contents of recent MySQL/Galera 0.7 release (fully open source)
- Feedback and experiences from the field
- New benchmark results
- Short term road map, 0.8 development status
[edit] Effective SSD for your Database - a PBXT Primer
In this session it will shown how to efficiently combine SSD and HDD storage for the benefit of performance of a MySQL database. Examples involving the PBXT storage engine will be demonstrated.
[edit] Sharding for the masses
The Spider storage engine, a plugin for MySQL 5.1 and later, is an extension of partitioning. Using this engine, the user can deal transparently with multiple backends in the server layer. This means that the data is accessible from any application without code changes. This lecture will briefly introduce MySQL partitioning, and then shows how to create and use the Spider engine, with some practical examples. This talk covers the latest version of the Spider and the Vertical Partition engines, including the related technology of UDFs that come with the engines. Practical instructions of how to install and use these technologies will be provided during the session.
[edit] Beyond MySQL GA: patches, storage engines, forks, and pre-releases
There is more to the MySQL server than MySQL 5.1 GA.
There are a lot of patches available that are not included in the official MySQL source tree. There are several new or enhanced storage engines. There are a handful of branches of the MySQL source code maintained by community members. And there are official MySQL milestone releases and snapshots. But to benefit from all of this, one has to know that they exist, and know how to use them.
In my talk, I will first give an overview of what community enhancements of various kinds are available. I will then go through the options for using these enhancements, including using pre-build binaries from various sources, building from alternative source trees, building storage engine plugins, and patching upstream MySQL sources.
[edit] Connecting MySQL and Python
There has been lots of chatter about other languages, but not much about Python. This talk will give an overview of what is available to connect to MySQL, and also introduce MySQL Connector/Python.
[edit] Refactoring Stored Routines
Although MySQL stored routines have their drawbacks, especially performance-wise, they still have their use. However, there are many things that can go wrong, and in many cases, observing a few principles, and adopting a few coding habits can have huge benefits for performance and maintainability of your stored routines. In this presentation, I will present a few cases and perform a few stepwise improvements to refactor the stored routine. Benchmarks are presented to show how each change improves performance.
[edit] Gearman for MySQL
Gearman is a client/server infrastructure for generic tasks, usable on distributed servers, with little worry about the details. No matter what language you speak, Gearman can meet your needs in C, PHP, Perl, Ruby, shell scripting, and several more. Gearman can also work in conjunction with MySQL, either using UDFs, or simply through its basic architecture. This talk will show examples of how to use Gearman for remote installation and how to call functions written in Perl from any other language or from inside MySQL server, with no knowledge of Perl at all.
[edit] Speaker Information
[edit] David Axmark
David is one of the Founders of both the MySQL Project and the company behind it. David has been working with MySQL since well before it had a name.
Before MySQL took over all of his time, David worked as a consultant for over 15 years. The things he did included A State of the art market research system (written in CommonLISP+CLOS+MySQL's ISAM) and a advanced business graphics package (back in the days when 32k RAM was all you had). He has written many lines of code in 6502 and Z80 assembler, Basic (Acorn BBC-B and ABC800), C, CommonLisp, (Bourne)-Shell and Perl (and lately even some Ruby).
During the MySQL years, David worked with the business idea, strategy, commercial and business aspects, hiring. Early on also some real work doing code for portability, web site, installation, documentation. The last years included a lot of talking about it all (conferences all over the world, tutorials, customer presentations, interviews etc).
Personal hobbies include mountain hiking, digital photography, disc-golf (the REAL golf!) and ultimate frisbee. David lives close to Windsor outside London with his Malaysian wife, 2 small kids, a large garden and of course a number of computers.
[edit] Piotr Biel
Piotr Biel holds is a Senior Consultant at Percona Inc.
In his past as a systems architect, he helped to build two of Poland’s largest Internet portals serving billions of pageviews a month.
He has experience as a Linux and Unix administrator (IBM AIX Certified Expert, SUN Solaris, *BSD), enterprise-level networking, advanced virtualization techniques with DLPAR/LPAR, Oracle RAC clusters and of course DBA (MySQL & Oracle).
Web: http://mysqlperformanceblog.com
[edit] Roland Bouman
Roland is a web developer, information analyst, and business intelligence developer. He as worked for MySQL AB/Sun Microsystems as MySQL certification developer and training course developer. He's a member of both the MySQL and Pentaho communities, and a regular speaker at conferences and community events. Roland co-authored the MySQL 5.1 Cluster certification Guide. His latest book is "Pentaho Solutions" (Wiley, ISBN: 978-0-470-48432-6). He maintains a technical blog at http://rpbouman.blogspot.com/ and you can follow his tweets at @rolandbouman.
[edit] Ronald Bradford
Ronald brings two decades of enterprise RDBMS industry experience in MySQL, Oracle and Ingres technologies including consulting positions for Oracle Corporation (1996-1999) and MySQL Inc (2006-2008).
He presently provides MySQL consulting in the US and Europe for companies requiring assistance in performance analysis & tuning, web scalability, higher availability and for database architecture and design.
Ronald is co author of the upcoming Wrox Press book "Expert PHP and MySQL"
For more information and blog goto: http://ronaldbradford.com
On Twitter Ronald writes at @RonaldBradford and @MySQLExpert
[edit] Kris Buytaert
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.
Kris is the Co-Author of Virtualization with Xen ,used to be the maintainer of the openMosix HOWTO and author of different technical publications. He is a frequent speaker at different international conferences.
He spends most of his time working on Linux Clustering (both High Availability, Scalability and HPC), Virtualisation and Large Infrastructure Management projects hence trying to build infrastructures that can survive the 10th floor test, better known today as the cloud.
His blog titled "Everything is a Freaking DNS Problem" can be found at http://www.krisbuytaert.be/blog/
[edit] Stéphane Combaudon
Stéphane is a DBA for a major telecom company in Paris. His primary mission is to get the most from MySQL but he is more and more involved in studying NoSQL solutions and finding use cases for which they can replace traditional RDBMS.
He is a regular speaker at conferences on databases and free software and is a member of the MySQL User Group France.
Blog: http://www.dbnewz.com/
[edit] Marc Delisle
Marc Delisle is phpMyAdmin's project administrator - phpMyAdmin is an open source web interface for MySQL.
Bio: Marc Delisle is a member of the MySQL Developers Guild – which regroups community developers – because of his involvement with phpMyAdmin. He started to contribute to this popular MySQL web interface in December 1998, when he made the first multi-language version. He has been actively involved with this software project since May 2001 as a developer and project administrator.
Marc has worked since 1980 at Cegep de Sherbrooke, Québec, Canada, as an application programmer and network manager. He has also been teaching networking, security and PHP/MySQL application development. Marc lives in Sherbrooke with his wife and they enjoy spending time with their four children.
Website: http://infomarc.info
[edit] Frédéric Descamps
I'm a long time Linux and Open Source Consultant doing Linux and Open Source projects in Belgium , Europe and the rest of the universe. I'm currently working for Inuits.
I spend most of my time working on Linux systems and MySQL environment. Most of my free time is used to conrtribute to the community, reporting bugs, answering questions and creating specs files.
During the last years I'm more involved in managing a team of system engineers and DBAs.
I've also provided several business related IT courses and teaching for evening school:
- UNIX Fundamentals
- Mastering UNIX Shell Scripts
- Using MySQL
- Managing MySQL
- PHP 5 in Depth
PHP/MySQL courses, GNU/Linux courses at the University of Labour in Charleroi (UT)
My blog is at http://www.lefred.be
[edit] Seppo Jakoola
CEO of Codership, long experience in developing DBMS replication and clustering solutions.
Seppo works as CEO at Codership, focusing in development of high performance DBMS replication, clustering and high availability solutions. His main responsibility is in integrating Galera replication service with DBMS engines.
Seppo has a long experience in distributed computing, clustering solutions and DBMS development. His earlier employments include ~10 year assigment in Stonesoft R&D developing firewall clustering and main memory DBMS products and ~4 year assignment in Continuent R&D, implementing clustering aware version of MySQL server.
Seppo has MSc degree in Software Engineering from Helsinki University of Technology.
[edit] Vladimir Kolesnikov
Vladimir Kolesnikov joined PrimeBase Technologies an 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.
[edit] Giuseppe Maxia
I am the MySQL Community Team Lead at Sun Microsystems. I am active member of the MySQL community and long timer open source enthusiast. During the past 22 years, I have worked in various IT related fields, with focus on databases, object oriented programming, system administration. Fluent in Italian, English, Perl, SQL, Lua, C, Bash, and good speaker of C++, French, Spanish, Java.
I work in cyberspace, with a virtual team. I have a blog where I write frequently about database matters. I am also a frequent speaker at open source events.
[edit] Kristian Nielsen
Kristian Nielsen is a software developer at MariaDB. While at MariaDB, Kristian has worked on setting up automated building and testing, on merging MariaDB with changes from upstream MySQL and other external contributions, and on bug fixing and stability issues.
Previous work on Free Software goes back to around 1990, and includes work on MySQL/NDB (online add column, NdbRecord API, multithreading); Asterisk (chan_ss7, realtime extensions); DBI/DBD::Oracle (array execute); Wine (multi-threaded X11); McStas; and XFH.
He has a blog at http://kristiannielsen.livejournal.com/
[edit] Geert Vanderkelen
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. He is also the maintainer of Sun's MySQL Connector/Python.