Wednesday May 15, 2013

Upcoming EMEA Events with MySQL!

MySQL Community team is pleased to announce following events as the ones supported by us with a great MySQL staff attending. Find more details below (or at our Community wikis).

  • NoSQL Roadshow, Berlin Germany, May 16, 2013
  • Solutions Libres & Open Source, Paris, France, May 28-29, 2013
    • Talk: NoSQL & MySQL by Olivier Zemrag
    • Meet MySQL, Oracle Linux and VM team at our booth E40 in the main exhibition hall!
  • International PHP Conference, Berlin, Germany, June 4-5, 2013
  • DevConf 2013, Moscow, Russia, June 14-15, 2013
    • MySQL team has submitted about 5 talks, however the CfP is still open, so the accepted talks are not yet announced.
    • Lets meet our technical team at the MySQL booth!
  • OpenSUSE, Thessaloniki, Greece, July 18-22, 2013
    • You can find MySQL team at the MySQL booth as well as find several talks at openSUSE!
  • Froscon 2013, St. Augustin, Germany, August 24-25, 2013
    • Froscon is starting to be a tradition. Same as last year you can find our MySQL staff at the booth and also talking about MySQL news during the conference!
  • DrupalCon, Prague, Czech Republic, September 23-27, 2013
    • We are pleased to invite you to visit our MySQL booth as well as find several MySQL related talks we are planning to submit!

If you are interested, you can find the other conferences we are attending (above EMEA area) at our MySQL Community wikis. We are looking forward seeing and talking to you!

Tuesday Aug 10, 2010

Seeking talks for the MySQL stream at the UKOUG Conference in Birmingham (2010-11-29/2010-12-01)

Similar to events in the US and Germany, another large Oracle User Group organization is preparing for their annual conference and would like to set up a dedicated track of sessions about MySQL – this time it's the British UKOUG  which organizes the Conference Series Technology & E-Business Suite 2010.

This annual user group event will offer a place to share knowledge and hear the latest information from key personnel about product development. This event is a technical event and not a marketing event and we'd like to encourage you to submit a MySQL-related talk!

Some more information about this conference:

  • Dates: Monday 29th November – Wednesday 1st December
  • Location: The ICC, Birmingham
  • Size: Approximately 2000 attendees

They have made an exception for the MySQL session stream and extended the call for papers deadline until Monday, 16th of August, 8:00 am (UK).

If you are interested to speak about MySQL or you know somebody who would, please pass this information on and submit your proposal via this link as soon as possible. Once you've registered, the speaker loungeshould provide a button "Add abstract" that allows you to submit your talk.

Thanks in advance! We look forward to your submission and another great conference.

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.

Wednesday Dec 09, 2009

Call for Papers for "MySQL and Friends" Developer Room at FOSDEM 2010 now open!

FOSDEM 2010, the annual Free and Open Source Software Developers' European Meeting will take place again on February 6th and 7th in Brussels, Belgium. Next year they will celebrate their 10th anniversary (congratulations!) and we feel very honored and happy to announce that the organizers accepted our request for a developer room! They had to reject many proposals due to the great demand (there were 39 applications, but there are only 12 rooms available per day). Therefore we are glad to be among the excellent projects that will be present there.

Our devroom is titled "MySQL and Friends" and will be available for sessions on Sunday, 7th from 09:00 - 17:00. It will be located in room AW1.121 and provides 81 seats, a video projector with VGA cable, and wireless Internet. As for the previous edition, we would like to set up a schedule of talks related to the MySQL server and the various projects that surround it. For the next time we will introduce a small change: each talk will last 20 (instead 45 minutes), plus 5 minutes of Q&A. This will give us 12 slots to fill up, plus a short opening keynote and a lunch break. This idea was inspired by Scott Berkun's great book "Confessions of a Public Speaker", which is a very entertaining and insightful read. If you are a frequent speaker at conferences and events, we highly recommend it.

At this time, we would like to encourage and invite you to submit a talk! We are looking for covering a wide range of topics that attract both MySQL DBAs as well as application developers that work with MySQL as their database of choice. Are you developing a new storage engine or other plugin? Do you want to share your experiences and best practices in administering or deploying MySQL servers? Did you develop a new method to scale a MySQL setup? Let us and the audience know about it! You can submit your talk proposal via this submission form.

The deadline for turning in your proposal is Sunday, 3rd of January, 2010, after which there will be a voting and rating period to identify the most interesting and attractive topics.

We are looking forward to your ideas and suggestions! If you have any questions, please check our FOSDEM 2010 page on the MySQL Forge Wiki and feel free to get in touch with us directly or via our public mailing list. Thanks in advance!

Wednesday Sep 09, 2009

MySQL / Open Source Event Calendar

The MySQL Community Team maintains a calendar to keep track of Open Source events and conferences that might be relevant from a MySQL point of view (either by submitting a talk, sponsoring or attending it). This calendar is now public - you can either look at the HTML version on the MySQL Forge or subscribe to the iCal feed (e.g. using Mozilla Sunbird or Lightning).

Are we missing an event? If you know any other events that should be included in this calendar, please submit your suggestions via this event submission form. Thank you!

Thursday Feb 12, 2009

MySQL@FOSDEM 2009: a summary

FOSDEM, the Free and Open Source Software Developers' European Meeting

Now that FOSDEM 2009 in Brussels, Belgium is over, it's about time for a conclusion/summary. I've been to FOSDEM for about five times as both an attendee and speaker, but this year I was much more involved. On Saturday, I gave a lightning talk about "Why you should use Bazaar for maintaining your OSS project". On Sunday, I gave a talk about "MySQL High Availability Solutions" in the main conference track. Both went fairly well and there was good feedback from audience. I've uploaded the slides for both talks to the FOSDEM 2009 page on the MySQL Forge Wiki, video recordings of the sessions should be available on the FOSDEM Video Recordings page soon.

We had a project stand that we shared with the OpenSolaris project, and it was particularly nice to finally meet Roman Strobl in person - he is a former NetBeans evangelist, now OpenSolaris evangelist who blogs on The Observatory. We had quite a lot of visitors stopping by at the desk. I would like to thank Walter Heck and Santo Leto in particular for their outstanding support with manning the desk!

On Sunday, we had a MySQL Developer Room with a full schedule of talks. We had to make some last minute changes to the schedule, one speaker had to cancel his talk on short notice due to a family emergency and we decided to change to topic of Kaj's talk into an interactive Q&A session to address the recent developments that happened that week. The room was usually packed for every session (~70 people), and it seems like both the attendees and speakers had a great time. The slides are now available from the MySQL Forge Wiki.

On this page, you will also find links to related articles and blog postings about the MySQL activities as well as links to pictures - feel free to add other pointers that you are aware of! I would like to thank all speakers for their excellent contributions, especially our volunteers from the MySQL Community: Roland Bouman, Kris Buytaert, Vladimir Kolesnikov and Jurriaan Persyn. Keep up the great work!

In summary, I think the MySQL DevRoom and project desk were a great success and we should have one next year, too (and maybe on other conferences as well). However, there are several things that could be improved for next year. My lessons learned:

  • Try to avoid last-minute changes to the schedule after the conference brochures have been printed
  • Align the session times with the main conference sessions, to allow easier transition and avoid overlap
  • Appoint a moderator that keeps track of the DevRoom schedule and takes care of the speakers and Q&A parts
  • Hire/appoint someone to record the sessions on video
  • Don't schedule yourself for booth duty, if you are also a main track speaker and DevRoom organizer
  • Take some time to properly introduce and brief all volunteers about activities and people involved
  • Make sure that volunteers that offered to help out with booth duty actually show up and are available, keep a printed copy of the booth schedule on the table
  • Provide free drinks and snacks for the people on booth duty
  • Set up a proper demo system for showcasing applications in advance, don't rely on Internet connectivity on site
  • Have more MySQL-branded merchandise/schwag to hand out
  • Have more info material/leaflets about the relevant offerings available, in the appropriate language
What else do you think can be made better next time? Please let me know. Thanks!


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




« August 2016