Thursday Jan 14, 2010

"MySQL & Friends" DevRoom@FOSDEM schedule published, want to join us for dinner on Saturday evening?

The tracks of this year's "MySQL & Friends" Developer Room at FOSDEM 2010 have now been scheduled - please check the Wiki page for details on the talks as well as some background information about the speakers. This info should soon be available via the FOSDEM conference system as well. We had some last-minute changes and we actually managed to schedule two more talks due to a small glitch in the initial calculation. The topics look very interesting, we hope that we can provide some valuable information for developers, users as well as MySQL DBAs!

One of our speakers (Kris Buytaert) suggested to arrange a joint dinner for Saturday evening, which is indeed a good idea! Thankfully he also volunteered for coordinating it - thanks in advance! If you'd like to join, please leave your name and food preference on this doodle poll. We plan to meet at 19:00 on Saturday, under the big tree in front of the AW building.

Friday Jan 08, 2010

Announcing the tracks of the "MySQL & Friends" Developer Room at FOSDEM 2010

We are happy to announce the selected sessions for our "MySQL and Friends" developer room at FOSDEM 2010 in Brussels, Belgium. It will take place on Sunday, 7th of February from 9:00-17:00 in Room AW1.121.

In total, we received 20 submissions from 15 speakers. We'd like to thank them very much for their great proposals!

As we only have 12 speaking slots (20 mins each) available that day, we first needed to perform a selection process. Unfortunately there wasn't enough time to perform a full-blown voting process that involved the community at large. Since we didn't want to do this in a completely closed committee, we decided to involve all speakers that submitted a talk in this.

After this voting process, the final candidates are (ordered by last name).

Update: Mikael Ronström had to cancel his talk about "The new MySQL Thread Pool Design". Instead, Frédéric Descamps will talk about "Daily Maintenance of Big Databases/Tables".

Speaker: David Axmark
Title: 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.

Speaker: Piotr Biel
Title: Multi-Master Replication Manager for MySQL

  • Introduction to MySQL high availability with MMM
  • MMM architecture overview
  • pros and cons
  • examples of usage

Speaker: Ronald Bradford
Title: 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:

  1. Monitor, Monitor, Monitor
  2. Identify problem SQL
  3. Analyze problem SQL
  4. Indexes
  5. Offloading master load
  6. Improving SQL
  7. Storage engines
  8. Caching
  9. Sharding
  10. Handling database maintenance

Bonus: Front end improvements

Speaker: Kris Buytaert
Title: 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.

Speaker: Stéphane Combaudon
Title: 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.

Speaker: Marc Delisle
Title: 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.

Speaker: Frédéric Descamps
Title: Daily Maintenance of Big Databases/Tables

Explain the tools and best practices on how to daily maintain big databases/tables

Speaker: Seppo Jaakola
Title: 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

Speaker: Vladimir Kolesnikov
Title: 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.

Speaker: Giuseppe Maxia
Title: 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.

Speaker: Kristian Nielsen
Title: 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.
Speaker: Mikael Ronström
Title: The new MySQL thread pool design
This session will present a new thread pool design worked out in the last few months. The design will be presented together with its pros and possible cons. Benchmark data validating its relevance to users will also be presented.

The main benefits of a thread pool design is that users can now have thousands of connections to the MySQL Server in a scalable manner. It also provides a performance which is more independent of the number of concurrently active connections than previously.

Speaker: Geert Vanderkelen
Title: MySQL and Python: an overview

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.

These talks will now be put in the room schedule on the MySQL Forge Wiki. We look forward to having these sessions! If you happen to be a FOSDEM, please stop by at our Developer Room!

Tuesday Jan 05, 2010

Call for Papers for the "MySQL and Friends" Developer Room at FOSDEM 2010 extended until Wednesday, 6th

A Happy New Year to all of you! About a month ago we posted our initial Call for Papers for the MySQL Developer Room at FOSDEM 2010 in Brussels, Belgium. We already received several great submissions and we'd like to thank the speakers who contributed their suggestions so far. But we would like to get some more!

Therefore we decided to extend the deadline for a few more days: you can still submit your talk proposals until tomorrow (Wednesday, 6th)!

So if you think you have an interesting MySQL-related topic to talk about, we'd like to hear about it! Thanks.

Monday Aug 10, 2009

Setting up a MySQL Guru Bar at FrOSCon

FrOSCon Logo

Do you plan to attend the Free and Open Source Conference (FrOSCon) in St. Augustin, Germany on August 22 & 23? Are you a fan of MySQL and would you like to share your knowledge about it with other users? Here is your chance!

Sun Microsystems is a Gold sponsor of FrOSCon this year and will also be present with a booth there on both days. In addition to demo stations about Open HA Cluster, OpenSolaris and NetBeans, Sun will also provide space for a MySQL info desk, which we would like to turn into a "Guru Bar", including members of the MySQL community.

The goal is to talk with existing and potential new MySQL users, share knowledge and expertise. We want to inform the visitors about what's new at MySQL and how they can get more information and help. If you have a solid MySQL background, are familiar with the various MySQL information resources (e.g. the DevZone, Forge, Forums, Mailing Lists, Planet MySQL) and enjoy talking to other users, we would like to hear from you! If you're interested in participating at the Guru Bar, please contact us at mysql-community AT sun DOT com for details. Thank you!


Get the latest updates on products, technology, news, events, webcasts, customers and more.




« February 2017