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.

Monday Jun 21, 2010

MySQL Sunday tracks at Oracle Open World 2010

Oracle Open World is the conference of everything related to Oracle. This year edition, running from September 19th to 23rd, is expected to have more than 45,000 attendees, making it one of the biggest IT events worldwide.

Traditionally, on the Sunday preceding the main event, there is a full day technical event, fueled by the user groups, independently from the company. These Sunday events are wildly popular. they are organized by users for users, and these sessions are usually fully attended.

Now that MySQL is part of the Oracle portfolio, it is going to be part of the Oracle Open World show. In the spirit of the user groups events, there will be a MySQL Sunday event on Sunday afternoon, with four highly technical tracks, with well known speakers.

The official schedule has all the details of every session (search for "stream/track" = "MySQL Sunday"), but doesn't offer a broad view of the event. For your convenience, here's the unofficial schedule with some useful information.


Golden Gate B
Golden Gate C1
Golden Gate C2
Golden Gate C3
12.30 - 1.00
opening keynote
1.05 - 1.45
Chris Schneider, Ning, MySQL High Availability
Sarah SproehnleCloudera, Leveraging Hadoop to augment MySQL deployments
Calvin Sun, OracleInnoDB Enhancements and Roadmap
Lars Thalmann, Oracle, MySQL 5.5 replication enhancements
1.50 - 2.30
Philip Antoniades, Oracle, MySQL performance tuning best practices
Thomas AndersonOracle,Performance and Scalability Enhancements in MySQL 5.5
Ronald Bradford, 42SQL, MySQL Idiosyncrasies That Bite
Sheeri Cabral, PalominoDB - Mike Frank, Oracle, For best results – Use daily:  MySQL Workbench - Design, Develop, and Admin
2.30 - 2.45
2.45 - 3.25
Sarah Novotny, BlueGecko, You know databases, how hard can MySQL be?
Giuseppe Maxia, Oracle, Boosting MySQL performance with partitioning
Harrison Fisk, Facebook, Advanced MySQL replication techniques
Jeff Freund, Clickability - Mark Matthews, Oracle, Efficient performance analysis and tuning with MySQL Enterprise Monitor
3.30 - 4.10
Mark Callaghan, Facebook, Success with MySQL
Duleepa "Dups" Wijayawardhana,Empire Avenue, Insert MySQL INTO Startup
Sheeri Cabral, PalominoDB, Proactively optimizating queries with EXPLAIN and mk-query-digest
Andrew Morgan, Oracle - Mat Keep, Oracle, MySQL Cluster: The Leading Open Source, HA Database for Real-Time Services
4.15 - 5.00
Closing keynote

Secure your seat.

MySQL Sunday is open to all Oracle OpenWorld, JavaOne, and Oracle Develop attendees, including those with the value-priced Discover pass ($50 if you register by July 16). You will be asked if you are attending MySQL Sunday during the conference registration process. Register today.

  • When: Sunday, September 19
  • Where: Oracle OpenWorld, JavaOne, and Oracle Develop
    San Francisco Marriott Marquis


(Alphabetically by title)

Advanced MySQL Replication techniques

Harrison Fisk

MySQL replication plays a critical role in most successful deployments of MySQL. Replication is relatively simple to setup, but takes much more mastery to optimize. Harrison will discuss some of the more advanced replication topologies, as well as practical tips and tricks designed to allow you to take your replication solution to the next level.

Boosting MySQL performance with partitioning

Giuseppe Maxia

Databases always grow. With partitions, MySQL 5.1 becomes an efficient and easy to use data warehouse. This session explains with practical examples how to create and use MySQL partitions and how they will increase your application performance. This presentation also covers the recent additions from MySQL 5.5

Efficient performance analysis and tuning with MySQL Enterprise Monitor

Jeff Freund - Mark Matthews

How do you know if your MySQL application is having performance issues? More importantly, how do you stop these performance issues before the application is put into production? In this session, learn how to use MySQL Enterprise Monitor to detect and notify you of existing performance robbing issues in production and how to use it in development and QA to prevent the problems from happening in the first place. Plus, you'll learn from Clickability, the leading on-demand Web Content Management solution provider, how the MySQL Enterprise Monitor and MySQL Query Analyzer are utilized to identify performance-tuning opportunities and to eliminate bottlenecks in a fraction of the time.

For best results – Use daily: MySQL Workbench - Design, Develop, and Admin

Sheeri Cabral - Mike Frank

Why are so many DBAs and developers using MySQL Workbench every day? Just ask Sheeri Cabral - Oracle Ace Director and MySQL guru. See how Sheeri designs, develops and administers MySQL databases at PalominoDB using Workbench.

PalominoDB provides remote services for MySQL and Oracle. Sheeri uses MySQL Workbench to manage distributed, replicated MySQL servers around the globe. Learn to leverage Workbench to connect, tunnel, script, control, configure, maintain, and manage your servers.

Sheeri will share her Workbench snippets and show a few in action. Later you can download these snippets to improve your own productivity.

Also on hand, Mike Frank, PM for Workbench will show how to extend Workbench with plug-ins.

InnoDB Enhancements and Roadmap

Calvin Sun

Oracle's InnoDB is the most popular, reliable, and proven transactional storage engine for MySQL. InnoDB provides transactions, row-level locking, multi-version concurrency control for superior performance, and referential integrity and all four ANSI SQL transaction isolation levels to ensure the integrity of your database.

In this session, you will learn InnoDB architecture and some innovative technologies in InnoDB for performance and data protection. You will also hear new performance-enhancing features to improve concurrency and scalability in InnoDB.

MySQL High Availability

Chris Schneider

This talk will cover high availability techniques, sharding fundamentals, third party technologies and how to decrease the likelihood of system outages.

  • Hardware specifications to consider
  • Functionally Sharding your data
  • Why one would use various topologies such as a relay slave,master-master replication or circular replication for High Availability
  • Fail over mechanisms you should consider with replication (i.e. keepalived, heartbeat)
  • How to safely and reliably replicate over a WAN for disaster recovery
  • Mixing up storage engines (e.g., Leveraging the Blackhole engine)
  • Third party options for sharding your data

Leveraging Hadoop to augment MySQL deployments

Sarah Sproehnle

When you're dealing with Petabytes of data, even MySQL starts to struggle. Hadoop can work alongside your current system, allowing you to perform complex analyses of your entire dataset. And with tools such as Sqoop and Hive, you can do all of that in an SQL-like language without needing to learn the complexities of the underlying MapReduce system.

This talk will demonstrate how you can augment your existing MySQL deployments with Hadoop for batch processing of large amounts of data.

In particular, these topics will be discussed:

  • Using Sqoop, an open-source tool for importing data from MySQL to Hadoop
  • Using Sqoop to export data from Hadoop back to MySQL
  • Using Hive, an SQL-like language, for doing reporting or ETL operations in Hadoop

MySQL 5.5 replication enhancements

Lars Thalmann

To scale the business, many companies have large data centers with replicated MySQL servers. Some have hundreds or even thousands of MySQL servers that replicate data. In this talk Lars explains how to use MySQL Replication for scalability and high availability and we especially review the new MySQL 5.5 features that has been implemented to support and simplify maintenance of such installations. Features include replication heartbeating, semi-synchronous replication plugin, fsync tuning, and relay log corruption recovery.

MySQL Cluster: The Leading Open Source, HA Database for Real-Time Services

Andrew Morgan - Mat Keep

MySQL Cluster has proven itself in mission critical telecoms and web services demanding real-time performance and HA in organizations including ALU, Cisco, Juniper, Telenor, UTStarcom & Zillow.com.

This session will introduce the most recent MySQL Cluster 7.1 release including:

  • ndbinfo: presents real-time usage statistics, enabling developers and DBAs to monitor performance and optimize applications.
  • The MySQL Cluster Connector for Java: an easy-to-use, high performance native Java interface & OpenJPA plug-in that maps Java classes to tables stored in the MySQL Cluster database.

Finally, Andrew and Mat will present some real-world case studies & explain some of the new capabilities that are currently in development.

MySQL Idiosyncrasies That Bite

Ronald Bradford

While MySQL is a popular and widely used RDBMS, some default features and settings are very foreign in comparison with other commercial RDBMS products. In this discussion, Ronald Bradford will discuss some of the MySQL defaults including a non-transactional state, silent data truncations, date management, and transaction isolation options. These are all critical for data integrity and consistency. He will cover in-depth topics including SQL_MODE that saves the day. He will also cover character sets and collations and the best practices to ensure your UTF8 is stored and retrieved correctly.

Insert MySQL INTO Startup

Duleepa "Dups" Wijayawardhana

When you picture a software startup today you no longer think of people in a garage creating a piece of software to be shipped on disks. It's all about data and global connectivity. Dups will lead you through the technical wonders of deciding to create a virtual economy and stock market and the decision to use MySQL. For Empire Avenue, MySQL is the foundation for a scalable, fast, web architecture which has allowed the company to create and deploy an application in record time with minimal cost. In the world of massive data and the web, you want applications that Scale Fast and Fail Fast. Those that scale and grab our imagination present new business opportunities, technical challenges and new economies. Welcome to the world of a Startup with MySQL.

MySQL performance tuning best practices

Philip Antoniades

Learn how to do basic tuning of MySQL using only the tools that come with MySQL. See how to tune for connections, select the best storage engines, and learn how to analyze the key statistics of a MySQL server. This is a technical talk, but no MySQL experience is needed.

Performance and Scalability Enhancements in MySQL 5.5

Thomas Anderson

In this technical, deep-dive talk, Thomas will explain the performance features added to MySQL Server and the InnoDB 1.1 Plugin. Including details on the scalability gains for multicore systems.

Proactively optimizating queries with EXPLAIN and mk-query-digest

Sheeri Cabral

This session will cover how to systematically find each query in a system and how to approve or optimize each query using EXPLAIN. Participants do not need to know how to use EXPLAIN or mk-query-digest to attend this session. This methodology can be used to find queries before they become problems; it can also be used in parts for regular query optimization of known bad queries.

Success with MySQL

Mark Callaghan

What determines whether a MySQL deployment will succeed? Some deployments are great while others are a constant source of trouble. The secret to success is you, not the MySQL RDBMS. Decisions that you make with respect to the database operations, server platform, schema and workload are critical. Mark will provide examples of decisions, both good and bad, that have a significant impact on the health of a MySQL deployment.

You know databases, how hard can MySQL be?

Sarah Novotny

DBAs everywhere are being asked to support MySQL as a less costly alternative in Oracle's portfolio. Rest assured, (almost) everything you know about Oracle can be translated and applied to supporting MySQL with some new vocabulary and some smart starting points.

This talk will touch on 5 things that are helpful to get right from the beginning. Through anecdotes, Sarah will spotlight some common pitfalls, share paths to a fix If you've inherited a running system and offer a vocabulary lesson so those who speak Oracle can start understanding MySQL.

She'll be touching on user management and security, backups and replicas, monitoring, storage engine choices, and probably monitoring again (because it is that important).


(Alphabetically by last name)

Thomas Anderson

Thomas is a performance software engineer at MySQL.

Ronald Bradford

Ronald is a RDBMS industry expert with 2 decades experience using MySQL, Oracle and Ingres.

He presently provides MySQL and Drizzle 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 has presented at many MySQL events including a number of presentations for Oracle resources. More information is available at MySQL for the Oracle DBA resources.

Ronald is co author of the upcoming Wrox Press book ‘Expert PHP and MySQL’

For more information and blog visit www.ronaldbradford.com and on Twitter Ronald writes at @RonaldBradford and @MySQLExpert

Sheeri Cabral

Sheeri K. Cabral has a master’s degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; has worked with Oracle, Sybase, DB2, Solaris, RedHat/Fedora, AIX, and HP-UX. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, USA, MySQL User group, and wrote the MySQL Administrator’s Bible.

Mark Callaghan

Mark leads the MySQL engineering team at Facebook. The team makes MySQL better for a large and critical deployment. The team writes about their work at http://facebook.com/mysqlatfacebook and publishes patches for MySQL at http://launchpad.net/mysqlatfacebook.

He previously lead the MySQL engineering team at Google. The team published a popular patch for MySQL that included semi-sync replication, user and table monitoring via SHOW TABLE_STATISTICS and USER_STATISTICS, SMP and IO performance patches for InnoDB, global transaction IDs for replication, row-change logging, transactional replication and many bug fixes.

Prior to Google Mark worked at Identity Engines, Oracle and Informix on database internals. Mark holds an M.S. degree in Computer Science from the University of Wisconsin-Madison. He occasionally writes about MySQL at http://mysqlha.blogspot.com.

Harrison Fisk

Harrison is part of the MySQL team at Facebook. Prior to working for Facebook, he was employed at MySQL AB (subsequently acquired by Sun and then Oracle) for 8 years as a senior principal MySQL support engineer, trainer, and consultant. He also is the co-author of a book, MySQL Clustering. Harrison holds a B.S. degree in Computer Science from University at Buffalo. His MySQL writings can also be found at http://harrison-fisk.blogspot.com.

Mike Frank

Mike Frank is a Senior Product Manager at Oracle focusing on MySQL - specifically Workbench, security, backup/recovery, platforms, and connectors. Prior to joining MySQL, Mike was Director of Technology at Idera. He was a Product Line Manager at PentaSafe Security Technologies which was acquired by NetIQ. His experience includes development and consulting in the fields of IT security, database design and management, e-business and trading systems.

Jeff Freund

Jeff Freund is the Founder and CEO of Clickability. With over 14 years of experience in the technology industry, Jeff works to expand Clickability’s leadership position in the Web Content Management category. Jeff is instrumental to Clickability’s rapid growth through the expansion of customer and partner initiatives, product innovation, and driving the market shift from traditional, on-premise technology to on-demand, cloud-based software and infrastructure. As Clickability's technical visionary and founding CTO, Jeff designed and deployed the first and only pure-play SaaS platform for the entire Web Content Management lifecycle. Under Jeff’s leadership, Clickability is responsible for the management and global deployment of over 500 websites worldwide for such companies as NetApp, BMC Software, PR Newswire (United Business Media), NBC, Cantor Fitzgerald, Smithsonian, Philly.com, and Eloqua, among others.

Mat Keep

Mat is part of the MySQL Cluster product team, responsible for product strategy and community development. In addition to driving adoption of MySQL Cluster into telecoms, web and enterprise industries, Mat is also involved in gathering user feedback and roadmap planning/ implementation with the engineering groups. Based out of the United Kingdom, Mat became part of MySQL in September 2008. Prior to that, Mat held a series of product management and development positions with Sun Microsystems and other vendors.

Mark Matthews

Mark Matthews is a member of the MySQL and Java communities since 1996, and joined MySQL as a developer in 2002. He is currently an architect for the MySQL Enterprise Monitor team at Oracle. Prior to joining the Enterprise Monitor Team, he was the original developer of MySQL's JDBC driver and still participates in the JDBC Experts Group. Before joining MySQL, Mark worked as a consultant helping deliver applications for the finance, healthcare, retail and cosmetics industries.

Giuseppe Maxia

Giuseppe Maxia, a.k.a. “The Data Charmer” is the MySQL community team lead at Oracle.

He’s an active member of the MySQL community and long timer open source enthusiast. During the past 23 years he has 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. Works in cyberspace, with a virtual team.

Philip Antoniades

Philip Antoniades has over 10 years of Web and Database development experience, and has been a MySQL Employee since 2003. He currently heads the MySQL Pre-sales Consulting teams for the Americas and Asia at Oracle. Philip lives in New York City.

Andrew Morgan

Andrew is the MySQL Product Manager responsible for High Availability Solutions - in particular MySQL Cluster and replication. He is based in United Kingdom and has worked for MySQL/Sun/Oracle since February 2009. Before joining MySQL he was responsible for delivering High Availability telecoms applications which is where he became exposed to MySQL Cluster - replacing proprietary and 3rd party databases. His primary roles in MySQL are working with engineers to make sure that MySQL Cluster & replication evolve to meet the needs of their users as well as spreading the word on the what people can get from these technologies. Andrew blogs regularly at www.clusterdb.com.

Sarah Novotny

Sarah’s a founding partner of Blue Gecko. She manages and is a senior administrator in the MySQL/ LAMP practice. Her company does remote administration and management of databases around the world.

She additionally runs the Seattle meetups for LinuxChix, MySQL, and one focused on Opensource and general geeky socializing.

Chris Schneider

Chris is a certified MySQL professional with over 6 years in the MySQL community. He has designed, implemented and maintained small to large-scale MySQL installations. This includes building architectures from the ground up and improving on those that are currently in place while emphasizing scalability, performance and ease of use. A few of the companies he has contributed to are GoDaddy.com, Facebook.com, VMware, Virident, Plaxo.com and Ning.com.

Sarah Sproehnle

Sarah works for Cloudera, where she provides training on Hadoop, Hive, HBase and more. Prior to Cloudera, she worked for MySQL, teaching people database administration, high availability and performance tuning.

Calvin Sun

Calvin Sun is the development manager of the InnoDB group at Oracle. Prior to joining Oracle, he was the development manager of storage engines at MySQL. He has over ten years of database internals experience at Pervasive Software, MySQL and now Oracle. He has an M.S. degree in Computer Science from the University of Science and Technology of China.

Lars Thalmann

Dr. Lars Thalmann is the development manager for MySQL replication and backup. He is responsible for the strategy and development of these features and leads the corresponding engineering teams. Thalmann has worked with MySQL development since 2001, when he was a software developer working on MySQL Cluster. More recently, he has driven the creation and development of the MySQL backup feature, has guided the evolution of MySQL replication since 2004, and has been a key player in the development of MySQL Cluster replication. Thalmann holds a doctorate in Computer Science from Uppsala University, Sweden.

Duleepa "Dups" Wijayawardhana

Duleepa "Dups" Wijayawardhana is the CEO of the brand new web-based startup Empire Avenue based out of Edmonton Alberta, Canada. Prior to starting Empire Avenue, Dups worked for MySQL AB (later Sun Microsystems) and BioWare Corp. (later a subsidiary of Electronic Arts). At MySQL/Sun, Dups was the Community Relations Manager for North America as well as being on MySQL's Web Team. Dups has spoken at various events, and multiple universities on the topics of scaling and web site performance and is now reliving the front line fun of creating a social network and a virtual economy using MySQL, Memcached and whole host of new and old technology.

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.

Tuesday Dec 15, 2009

A new MySQL Milestone Release (5.5.0-M2) has been published

Following our new Milestone-based release model, we've now published MySQL 5.5.0-M2. Please see the "What's New in MySQL 5.5" section of the reference manual for a summary of the most notable changes. The MySQL 5.5.0 Changelog provides a much more detailed list of changes, bug fixes and improvements.

Highlights in this release include:

The InnoDB plugin (currently at version 1.0.5) replaces the built-in InnoDB storage engine. This version includes a number of important performance improvements, especially when running on multi-core CPUs with many concurrent transactions.

Support for "semisynchronous" replication. This is a very useful feature to check out, if you use MySQL replication in a high-availability scenario and you want to ensure that at least one replication slave has received the latest transaction that was committed on the master. The master waits for confirmation from the slave after a commit before it returns control to the application. See the chapter "Semisynchronous replication" in the reference manual for more details. Mark Callaghan and Giuseppe Maxia also provide some more background information about this feature in their blog posts.

You can now use SIGNAL and RESIGNAL statements in stored routines and triggers, as defined by the SQL standard. These statements can be used to raise an error inside of your routines and can define appropriate actions, e.g. displaying an error message or issuing warnings. Check out the reference manual or take a look at Roland Bouman's blog post that provides a quick overview by giving a practical example.

The table partitioning functionality that was introduced with MySQL 5.1 received a large number of bug fixes and improvements. For example, you can now use two new types of user-defined partitioning: RANGE COLUMNS and LIST COLUMNS, providing more flexibility when it comes to defining how a table should be partitioned (e.g. by defining ranges or lists based on DATE, DATETIME or strings). Ranges based on multiple columns are now possible, too. For more information, please see the chapters "RANGE Partitioning", and "LIST Partitioning" in the reference manual.

Other improvements include new LOAD XML statement, which allows you to read data from an XML file into a table, a new TO_SECONDS() date function to calculate the number of seconds since the year zero and a ton of bug fixes.

Binary packages and sources are now available from the MySQL 5.5 download pages. The Bazaar source tree of this milestone release is available on Launchpad, too, in case you want to take a closer look at the ongoing development work in this branch. So please download and toy around with this release – we are looking forward to your feedback!

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!

Monday Jun 29, 2009

FrOSCon schedule draft published, CfP for OpenSQL Camp still open until July 19th!

FrOSCon Logo

FrOSCon, the Free and Open Source Conference, will take place on August 22nd and 23rd in Sankt Augustin, Germany. Sun Microsystems is a Gold Sponsor of the conference which takes place for the fourth time now. As for the previous years, the organizers have managed to arrange a great lineup of speakers and content. Presentations are held in both English and German — a first draft of the schedule is now available. However, it is still subject to change in some details, based on the feedback by the invited speakers.

I am looking forward to this event, especially since we're helping to organize the OpenSQL Camp subconference there, which will take place in parallel (there also is a subconference about Java this time). By the way: if you've missed the deadline for submitting your database-related talk to FrOSCon, you can still submit your talk for OpenSQL Camp until July, 19th! We look forward to your submission.

On the FrOSCon main tracks, there will be a number of MySQL-related talks as well as presentations about other Open Source projects sponsored and supported by Sun. Here's an excerpt from the schedule:

In addition to that, there are numerous other very interesting talks related to Linux, Open Source, Cloud Computing and other topics. There usually is a nice social event (BBQ) and BOFs on Saturday evening and the overall atmosphere at FrOSCon is very relaxed and friendly. So don't miss this opportunity!

Tuesday May 12, 2009

MySQL User Groups: Facebook is not mandatory

Several people commented on our last blog post or contacted us via our Twitter account, asking questions and raising concerns about migrating the MySQL user group organization to FaceBook. It seems like there is some confusion that we would like to address: you are not required to move to FaceBook. This was just a recommendation, you are of course free to choose whatever service you prefer to manage your MySQL user group. In fact, you are of course welcome to continue using Meetup.com for this! However, be advised that you will have to take care of any occurring fees by yourself from now on, as the sponsorship agreement between MySQL and Meetup.com was not renewed.

And if Facebook is not your cup of tea, there are other services that provide similar functionality. We've tried to document these on the MySQL Forge Wiki - please feel free to add your own suggestions and provide hints based on your experiences! Some of the other services that we know about include:

 In any case, wherever your user group's new home will be, please ensure to update the List of MySQL User Groups on the Forge Wiki! Thanks.

Monday May 11, 2009

MySQL User Groups : migrating event management to Facebook


For several years, MySQL User Groups have been organizing their meetings with Meetup.com, a service that simplifies event management. However, MySQL User group organizers received a surprise message from Meetup.com a few days ago.

We were all taken by surprise by Meetup's sudden announcement and allegation that MySQL "did not want to sponsor" the users groups, because there is a valid agreement between MySQL and meetup.com. The agreement is still in effect, ending on June 10, 2009.

Apparently, there was some miscommunication inside Meetup.com, because the group organizers received a message stating that they should now pay for meetup services, which they used to get for free, thanks to MySQL sponsorship.

It took us a few days to track the origin of the misunderstanding, and when we thereafter got in touch with meetup.com, we learned that their business model has changed.

Moreover, they would no longer accept sponsorship agreements like the one we have had in place so far.

Current situation

Meetup.com's business model differs considerably from before.

This is the summary description of how the sponsorship works, as received from meetup.com:

"All organizers will need to pay their Meetup subscription fees and through sponsorship can receive financial support from participating in a sponsorship."

Without sponsoring, each MySQL User Group would end up spending 12 US dollars a month, or 144 dollars a year, for the ability to use Meetup.com's services.

What now?

MySQL User Groups are obviously free to use any service for event management and invitations. However, as Meetup.com has terminated our agreement, we in Sun's MySQL Community Team will no longer sponsor nor recommend the usage of Meetup.com for our User Groups. In this sense, while Meetup.com's announcement that MySQL did not want to sponsor the fees was originally not true, it has now become reality.

That said, we want to thank Meetup.com for graciously hosting MySQL groups so far. It's been a great service! We wish Meetup.com good luck with their new business model. And obviously, any user group that wishes to stay with Meetup.com is free to do so, but in that case, they will be responsible for the fees themselves.

The Community Team recommends the MySQL User Groups to manage from now on their user group invitations with Facebook. We've been in contact with Facebook on this, and they're thrilled at the idea of hosting MySQL groups.

And as you know, their service is free of charge.

We know such a migration is going to be a strain for many of you, and for this reason Colin has prepared an article to assist you in your migration (It's in Colin's blog ).

If your group has been inactive for a while, this might be a great time to re-invigorate your users with a change in scenery!

If you need a mailing list for your user group, we will gladly assist anyone who needs a dedicated list, like we've done for several groups before: http://lists.mysql.com/#ug.

The main point is to keep the groups working, and to keep meeting other users, regardless of the system used to spread the news.

If there are practical problems related to your migration, please let us know. If you would like to use different networks to organize your group, such as in particular Xing for German speaking MySQL User Groups, feel free, and let everyone know.

In particular, make sure to update your Group's whereabouts on the MySQL Forge Wiki.

Happy Meetings!

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!

Thursday Dec 11, 2008

New blog for MySQL Community

There is a new blog in the MySQL Community arena.

It is a collaborative podium for guest posts. We will host colleagues or community members who have no blog and need a temporary place for their message. The first experiment was successful, and we decided to have a more stable place for it.

We start today by hosting Trim Perhad, System QA manager of MySQL, who presents some interesting performance results.

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




« April 2014