MariaDB & MySQL community event, Apr 2014

This community event was hosted by the MariaDB Foundation with support from
AccelerationDB. This was a free community
event to complement the Percona Live conference. The community event was a
full day focusing on many things that were not covered at Percona Live.

The themes for this community event were **MariaDB 10.0 GA**,
**High availability**, and **Performance**. The talks are seen in the schedule below.

There was also a dinner that night at the
Taste restaurant.

Schedule, Videos, and Slides

Here is the schedule of the talks with links to videos and slides of the talks.

09:00am – Welcome to the MariaDB & MySQL community event, Michael ‘Monty’ Widenius

09:10am – What’s new in MariaDB 10.0, Michael ‘Monty’ Widenius
Includes features comparison with MySQL 5.5 and 5.6.
Slides: MariaDB-10.0-foundation-2014.pdf

09:40am – Spider in MariaDB, Kentoku Shiba
Slides: Spider_in_MariaDB_20140403.pdf

09:55am – MariaDB 10.0 optimizer, Sergey Petrunia and Sergei Golubchik, MariaDB developers
Slides: mariadb-10_0-optimizer-apr2014.pdf

10:45am – MariaDB and ScaleDB showcase, Moshe Shadmon, ScaleDB
Showcase of how to insert continuously 1 Million rows/second while doing concurrent reads with MariaDB and ScaleDB
Slides: Scaledb-2014-v4.pptx

11:30am – MySql at Tumblr, Bob Patterson Jr, tumblr
Tumblr manages more than 250+ database servers with 55+ TB of data. We accomplish this through our architecture, tools and process. During this talk I will discuss how the databases at Tumblr are laid out and go into detail about what tables and data lives on each type of machine. Also I will go through how we back our dashboard(news feed) in our application and database layer. Finally I will cover how we manage and deploy our database configuration so our application knows where to retrieve and write data. I will discuss briefly our memcached stats and how we use memcached with over 3 million gets per second and 100 thousands sets per second to support our databases.

12:15pm – Lunch break

1:00pm – MySQL MHA and Continuent Tungsten shootout 2.0, Alex Alexander, SpringbokSQL

1:45pm – Vitess, CAP, and Hitting the sweet spot @YouTube, Sugu Sougoumarane, Google
Slides: Vitess_and_CAP.pdf

2:30pm – Break

2:45pm – Big data with NEO (distributed database powered by MariaDB) and Scikit-learn, Jean-Paul Smets, Nexedi
Slides: NXD-Wendelin.Presentation.MariaDB-005-en.pdf

3:30pm – InfiniDB overview, Jim Tommaney, InfiniDB
Learn about InfiniDB to deliver real time reporting and analytics at scale. InfiniDB is an open source columnar analytics engine available via GPL v2 with no restrictions on syntax, scale, or performance. The InfiniDB custom distribution of work and pure columnar storage deliver is well-suited for specific workloads (analytics, reporting) but does not replace MySQL for transactional and other workloads.
Slides: InfiniDB_Overview_Q2_2014.pptx

4:15pm – mysqlv8udfs – Running JavaScript inside MySQL, Roland Bouman
MySQLv8Udfs provides a number of MySQL UDFs that integrate Google’s v8 JavaScript engine into MySQL. With mysqlv8udfs you can run JavaScript directly in the database. This allows developers to do all kinds of useful things that are hard or inconvenient to achieve with either SQL, stored routines or UDFs. Examples include JSON document generation and manipulation, powerful regular expression support, and data transformation and transport across MySQL instances. For particular types of tasks, especially CPU-intensive ones, mysqlv8udfs also provides substantial performance benefits as compared to stored routines, and even plain SQL expressions. MySQLv8UDFs is free and open source. Code is available here:
Slides: MySQLv8UDFs-UC2014-samples-hidden.pdf

5:00pm – Speeding up MariaDB on Fusion-IO, Jan Lindström, MariaDB developer
This talk will share compression improvements in MariaDB optimized for flash using native interfaces. Get the capacity benefits of compression, without incurring the performance overhead and complexity of packing and re-packing the compressed blocks into one-size-fits-all blocks. Instead, rely on underlying thin provisioning to allocate only what is used and provide efficient garbage collection of unused blocks. We will present some alternatives to address challenges presented and present performance results from TPC-C and LinkBench.
Slides: Speeding_up-MariaDB-on-Fusion-IO2.pdf

This community event was partly inspired by the Baron Schwartz blog post announcing the Percona Performance conference in 2009.
We believe that there should be more free conferences about MariaDB and MySQL
that will allow anyone to attend and participate.

You can use the ‘foundation ‘at’ mariadb (dot) org’ email address if you
want to help sponsor a community event. All sponsorships go to pay for the
event venue, hotel, and travel for speakers (who could not otherwise afford to
attend). In the event there’s anything left over the Foundation will use it for
further community activities.