Sessions

  • Robert Hodges
    Lean, mean MySQL and hulking Hadoop clusters may seem like an odd couple, but tying them together is now priority #1 for many MySQL users.  This talk explores the data management trends spurring integration, how the MySQL community is stepping up, and where the integration may go in the future.  We outline how work at Continuent fits into this picture and how we are contributing to the MySQL... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Evan Elias, Santosh Banda, Yoshinori Matsunobu
    Global Transaction ID (GTID) is one of the most compelling new features of MySQL 5.6. It is also one of the trickiest to deploy to an existing large-scale environment. This talk will cover every aspect of how and why we adopted GTID at Facebook, including: * Benefits and use-cases * Comparison of different GTID implementations * A failover technique to easily replay missing transactions on... [read more]
  • Track: MySQL & NoSQL
    Beginner
    Chris Schneider
    Everyone knows that big data is here to stay, and one of the best NoSQL solutions out there is Hadoop. MySQL DBAs will need to know when to adjust and leverage Hadoop within their environment and even start using and administering Hadoop clusters. Hadoop is no replacement for the time-tested RDBMS, but for dealing with petabytes of data, Hadoop is the coolest kid on the block. In this session,... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Stephane Combaudon
    Replication has been used for a long time to provide high availability. However the traditional position-based replication has a serious drawback: a same transaction will never have the same position on two different servers. Reconfiguring replication is then difficult and error-prone, which is bad when you want to make failovers as graceful and reliable as possible. Enter MySQL 5.6 and Global... [read more]
  • Track: Replication and High Availability Strategies
    Beginner
    Jay Janssen
    Vips, TCP proxies, NATing proxies, Layer 7 Load balancers, DNS entries, smoke signals. Every good HA architecture will abstract the physical connection information between the application and the database and make failover as transparent as possible, but what's the best way? This talk will attempt to survey the vast landscape of HA tools/methods, whether designed for MySQL or not.... [read more]
  • Kyle Redinger
    Sitting in a chair managing MySQL all day is destructive to our lives. We have lost one of the most fundamental abilities to move as a human. The Squat. This session will be a fun, [b]interactive[/b] presentation, talking about what happens to our bodies when we sit in a chair all day, the science behind the squat, how the squat heals us, and why we perform better at our jobs when we exercise... [read more]
  • Track: New Features
    -
    Monty Widenius
    The talk covers all important replication features in MariaDB since 5.1 up to 10.0: - Multi source - Group commit - Parallel replication This includes explanation of how things works, different replication setups (speed versus security) and benchmarks results that shows the effect of the different replication options. After the talk one should have got a basic understand of the... [read more]
  • Track: Database Administration
    Beginner
    David Berube
    Today, many programmers have a skillset focused on the application layer - ORM systems like Hibernate and Ruby on Rails can hide much of the complexity of SQL programming, so many feel that focusing on their database is unimportant. ORMs, of course, have brought many benefits - but their widespread use has also resulted in many programmers being less familiar with the theoretical underpinings of... [read more]
  • Track: Database Administration
    Intermediate
    David Berube
    Many strategies exist for increasing the performance of a database system. Some attempt to make each access to the data faster: for example, faster hardware may be used, or system settings may be tweaked. Other approaches attempt to decrease the total number of database operations: for example, by caching database queries or entire pages. Nevertheless, generally, performance decreases as the... [read more]
  • Track: New Features
    Intermediate
    Rongrong Zhong
    Merge consecutive leaf pages together to release storage space. Unless the insertion pattern is sequential, an insertion to a full page will result in a page split producing two half full pages. Depending on the application, many times lots of the split pages never get more than 70% full. Furthermore, deletions sometime make pages less than 50% full and many times these nearly empty pages... [read more]
  • Track: Database Administration
    Intermediate
    Jeremy Cole, Davi Arnaut
    Last year, we demoed innodb_ruby in “InnoDB: A journey to the core” with very small snippets; this year we’ll walk you through exploring InnoDB’s on-disk storage for yourself.
  • Track: Database Administration
    Intermediate
    Davi Arnaut, Jeremy Cole
    In this new installment of the series, we explore the most crucial structures for crash recovery and consistency, the redo and undo logs. This presentation dissects the structure and organization of InnoDB's redo and undo logs, providing insight into how data changes occur at the InnoDB layer and how it guarantees that it can recover to a consistent state in the event of a crash. This... [read more]
  • Track: Database Administration
    Intermediate
    Aurimas Mikalauskas, Frederic Descamps
    Come to this talk if you want to understand better how a multi-core multi-disk system operates and how you can inspect its operation on Linux in order to measure utilization for capacity planning, or just for fun. Long gone the days when a commodity server had one single-core CPU, one disk and understanding system utilization was as easy as checking that load average is below 1. Yet some still... [read more]
  • Track: Database Administration
    Beginner
    Ike Walker
    Now that performance_schema is enabled by default in MySQL 5.6 a lot more people will be using it. Although performance_schema has a lot of potential value, it's also very complex and has performance overhead. If you're already squeezing every possible ounce of performance out of MySQL you may just disable it to avoid the overhead of instrumentation. But what about the rest of us?... [read more]
  • Robert Hodges, Nisha Talagala, Peter Zaitsev, Terry Erisman
    MySQL is used by many organizations for mission-critical applications where downtime is very costly. MySQL in the Cloud is also growing in relevance and usage. During this panel discussion we’ll discuss the challenges of operating MySQL at scale in this changing technology landscape. Topics such as high availability clusters, multi-datacenter replication, and data storage will be discussed in... [read more]
  • Track: Tools
    Intermediate
    Baron Schwartz
    What if you'd like to know something about your SQL statements, but it's not possible to measure it? Consider the relationship between a statement's execution and some work it causes that can't be measured inside the server. In this talk, Baron will demonstrate how to infer these relationships with statistical techniques. This allows you to avoid measuring things that are... [read more]
  • Track: Database Administration
    Intermediate
    Ryan Lowe, Syam Puranam
    Too many DBAs focus solely on MySQL configuration, without considering the tremendous benefits that can be achieved on the systems side. This presentation will provide a high level overview of how linux internals work (covering such topics as memory management, filesystems, networking, and process scheduling) and talk specifically about how they interact with MySQL. Attendees will be able to... [read more]
  • Track: Tools
    Beginner
    Nathan Voxland
    You never develop code without version control, why do you develop your database without it? Liquibase is a free and open source project for tracking, managing and applying your database changes throughout your development cycle from development through production. This session will cover how Liquibase works, major features, and how you can introduce schema management into your new and... [read more]
  • Beginner
    Bill Karwin
    When backing up a database in the cloud, many people are forced to choose between using command-line tools, or else writing a custom script to export data. We may not have privileges to use command-line tools in a cloud environment. Writing your own data dump script is deceptively complex. This presentation outlines a simple PHP class I've written that creates backups in the same format as... [read more]
  • Track: Tools
    Intermediate
    Tom Christ
    Jetpants provides an automation framework for managing large sharded MySQL installations. In addition to providing support for shard splits and merges, there is oft-overlooked tooling for concurrent operations across entire database topologies. Some examples include determining the aggregate size of your data set across all shards and/or functional partitions, determining global min and max... [read more]
  • Track: Tools
    Intermediate
    Walter Heck
    This session will discuss how to manage MySQL with the popular configuration management tool Puppet. We'll discuss the following topics: * what is puppet and why do we care? * which modules to use? * which puppet features work well with MySQL and which won't * how to set up mysql using puppet across multi-server infrastructures * how to deal with replication and a puppet... [read more]
  • Track: New Features
    Intermediate
    Sergei Golubchik
    If you're maintaining and old application, you may want or not want to upgrade your database server. But if you start developing something new, you should know what the recent releases are capable of. MariaDB 10.0 is the latest stable branch of MariaDB, with many new features in replication, optimizer, administration, and other areas. This talk will go over everything new that MariaDB 10.0... [read more]
  • Track: Developing Applications
    Intermediate
    Colin Charles
    MariaDB includes a lot of new features that developers can take advantage of. In this practical overview (this is not a hands on session - demos performed by the presenter), the attendee as a developer will learn to take advantage of the new MariaDB features over what is currently available in MySQL. Some highlights include: * Using microsecond precision & type, plus compatibility with... [read more]
  • Track: New Features
    Intermediate
    Sergei Golubchik, Sergei Petrunia
    It is a common knowledge that in the MySQL world you have to use indexes to optimize your queries. Indexes provide fast access to the data, indexes provide statistics. True, indexes can also be quite expensive to maintain, but what choice do we have? New MariaDB 10.0 optimizer supports storage engine independent statistics tables. Which means that you can have data statistics calculated for all... [read more]
  • Track: New Features
    Intermediate
    Sergei Golubchik
    The storage engine family in MariaDB got new members. CONNECT engine allows you connect MariaDB to almost anything and read data in almost any format. Cassandra engine lets you access a Cassandra cluster conveniently and transparently from MariaDB. Sequence engine is small, fast, and completely virtual, but it can be very useful in joins. These and other storage engines will be covered in this... [read more]
  • Track: Replication and High Availability Strategies
    Advanced
    Massimiliano Pinto, Vilho Raatikka
    Flexible database clusters impose challenges in terms of load balancing, load splitting, write conflict avoidance and service availability, to name a few. MaxScale is a highly modular proxy with a pluggable API, that assists in offloading tasks away from both clients and the back-end servers. In its simplest form it acts as a non-blocking zero-copy load balancer for read-only connections,... [read more]
  • Intermediate
    Dimitri KRAVTCHUK
    Come to have an informal discussion with all members of MySQL Team present during the Conference. Don't miss an occasion to get the info directly from the source! As well we're very curious to know what are your main issues today when using MySQL Server in your production environments. Please, share! - probably we already have, or will have soon a solution to your problems ;-)
  • Track: Replication and High Availability Strategies
    Intermediate
    Art van Scheppingen
    Galera Cluster is a synchronous multi-master cluster for MySQL that allows you to synchronously replicate your data to every node in the cluster. Galera Cluster makes the life of a DBA easier with features like automatic node joining, electing donor nodes and automatic node removal once a node has failed. There is also no need to distinguish master and slave relations in your application as all... [read more]
  • Track: Tools
    Beginner
    Andrew Moore, David Busby
    In this talk we'll take a deep dive into the popular iostat and pt-diskstats tools and look at how they can be used to monitor performance on Linux. We'll look at the options associated with the tools to understand how they influence behavior, the kernel metadata they both use as a basis for their calculations, and review the source code to understand the metrics that they report... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Giuseppe Maxia
    Database replication, in its simplest definition, is just data flowing from a master to some slaves. Until recently, the most daring topologies adopted by DBAs was a master-to-master deployment, with perhaps a DRBD in between. The times of circular replication are over!
  • Track: Database Administration
    Advanced
    Yoshinori Matsunobu, Steaphan Greene
    Facebook deployed MySQL 5.6 in 2013 on very critical environments, and has continued to add features to work better for us. In this session, the speaker explains 5.6 best practices worked at Facebook, lessons learned, and major feature enhancements such as faster full table scan, efficient semi-synchronous replication, etc. Facebook's recent move to WebScaleSQL, and future plans for that... [read more]
  • Beginner
    Stephane Combaudon
    Global Transaction IDs (GTIDs) in MySQL 5.6 are a great addition as they are supposed to ease replication administration a lot. But they are also changing some old habits and they require careful planning when enabling them. Learn the benefits and gotchas of GTIDs in this talk.
  • Track: Replication and High Availability Strategies
    Beginner
    Luis Soares
    Like its predecessor, MySQL 5.7 will be a ground breaking release. The latest Development Milestone Release (DMR) shows very appealing replication features. They reduce the administrative overhead, provide a much improved user experience, and enable running MySQL smoothly both at scale and/or in very tightly coupled network environments such as in a cluster.
  • Track: New Features
    Intermediate
    Morgan Tocker, Rune Humborstad
    For MySQL 5.7, one of the engineering goals is to continue to clean up and simplify code, and improve the architecture of the MySQL Server. As part of this spring cleaning process, some features in MySQL 5.7 have a change in behaviour; for example the EXPLAIN PARTITIONS and EXPLAIN EXTENDED syntax will be enabled by default. Other features will be deprecated and may be removed; for example... [read more]
  • Track: New Features
    Sunny Bains
    Learn about the improvements that are coming in MySQL/InnoDB 5.7. It has massive scalability improvements. Improvements are around CPU utilisation and more effective use of faster IO. Faster temporary tables, Memcached plugin improvements that deliver 1M QPS. Integrated data dictionary. More flexible tablespace management and lots more.
  • Track: New Features
    Intermediate
    Dimitri KRAVTCHUK
    This session will be interesting for any person who cares about making MySQL fly! Any published MySQL Benchmark results always involving a lot of discussions around, and a lot of misunderstanding too.. Some benchmark workloads are helping to understand and fix MySQL Performance issues.
  • Track: Tools
    Intermediate
    Mark Leith
    Performance Schema within MySQL 5.6 exposed a wealth of new instrumentation useful to DBAs and Developers, bringing statement instrumentation, table usage statistics and more.
  • Erin O'Neill
    There are just not enough women working on the technology side of tech. The media keeps shouting that a diverse work place is good for all and data scientists say the data proves this. Then why aren't there more women in MySQL? Where are the women at the MySQL conferences? Sure the number of women attending is increasing but not so the number of women speakers. Why do some companies have so... [read more]
  • Track: Best Practices for Businesses
    Beginner
    Gavin Towey
    So you've got MySQL running in your business. You've gotten a handle on replication, performance and backing up your database. You're an experienced MySQL DBA and can troubleshoot, repair and design schemas. What's next? How do you take the next step and turn your database into a polished, professional service? This talk with follow the journey made by the DBA team at... [read more]
  • Intermediate
    Bob Patterson
    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... [read more]

Pages

Subscribe to Proposed Sessions