Sessions

  • Track: Utilizing Hardware
    -
    Jeff Sosa
    Many organizations are lowering costs and dramatically improving the performance of their MySQL deployments by leveraging advanced PCIe Flash Storage products. These products offer the lowest latency and highest density possible, leading to increased consolidation and lower operating costs. This talk will discuss the benefits of PCIe Flash Storage for MySQL environments and include examples.
  • Track: Database Administration
    Intermediate
    Ryan Huddleston
    A reliable backup and recovery system can be the difference between a minor outage and the end of a business. Do you have the tools and resources to adequately address this critical need? Join Percona’s Director of Remote DBA services, as he shares how they are helping customers prevent disaster scenarios by performing reliable backups using open source components at it's core. Includes... [read more]
  • Intermediate
    Zburivsky Danil
    Hadoop is gaining popularity as an integration point for various data sources inside a company. Hadoop's scalability properties and batch-oriented architecture also make it a great candidate for a data warehousing solution. In this session we will review a practical use case for building a Hadoop data warehouse and using MySQL as one of the data sources. There are many challenges... [read more]
  • Track: Database Administration
    Intermediate
    Marco "The Grinch" Tusa
    In this talk we present a real customer case that included a challenging Architecture Design and Proof of Concept of using Synchronous Replication in AWS. The customer had asked to investigate and design an upgrade to their MySQL based solution that supports an application serving retail shops around the globe. The requirements were to build a highly available MySQL database using only the... [read more]
  • Track: Tools
    Intermediate
    Shlomi Noach
    This session introduces the common_schema project: a self contained schema which includes a set of sophisticated views, routines and a specialized scripting language (QueryScript), simplifying MySQL server administration and analysis. common_schema is aimed to be imported onto any MySQL server, on any platform. Along with INFORMATION_SCHEMA and PERFORMANCE_SCHEMA, common_schema becomes a... [read more]
  • Track: New Features
    -
    Robert Hodges, Giuseppe Maxia
    Continuent Tungsten 2.0 includes key feature improvements to help you manage very large datasets on MySQL. It also sets the stage for operation in cloud environments like Amazon.
  • Robert Hodges
    MySQL is practically a standard for managing data in the cloud. But what are the real risks of managing data there? How do you manage risks when you don't even know what they are? In this keynote we'll illustrate how cloud data management problems divide into the classic buckets of known knowns, known unknowns, and unknown unknowns. MySQL users can use this classification to build more... [read more]
  • Track: Database Administration
    -
    Peter Zaitsev
    In many Performance evaluation studies, you will find comparison made in terms of peak throughput or corresponding response time. Yet these metrics are not the ones which well describe how technology would behave in real production systems. In this brief presentation, we will look into why such metrics can be misleading as well as provide framework and principles about performance evaluation... [read more]
  • Tomas Ulin
    Join Tomas Ulin, Oracle’s Vice President of MySQL Engineering, as he talks about the focus, strategy, investments and innovations evolving MySQL to power next generation Web, mobile, Cloud and embedded applications. Tomas will also discuss the latest and the most significant MySQL database release ever in its history, MySQL 5.6.
  • Track: Developing Applications
    Intermediate
    Tim Callaghan
    Improvements in index theory and practice can greatly improve performance for modern applications with big data sets. My presentation will cover Fractal Tree Indexes and how they enable numerous advantages in MySQL (TokuDB) and MongoDB (TokuMX).
  • Track: Developing Applications
    Beginner
    Adrian Nuta
    Or better said when Sphinx can help MySQL on queries that at first look they don’t involve any fulltext searching. Sphinx was build in mind to help the DB on fulltext queries. But it can also help on where there is no text search. That is everyday used queries with combined filtering,grouping and sorting used for various analytics, reporting of simply general usage. In Sphinx, the fulltext... [read more]
  • Track: New Features
    Seppo Jaakola
    This session presents Galera Cluster synchronous multi-master feature and functionality and the new features of Galera Cluster 3.0, including MySQL 5.6 compatibility and how Galera makes the best match with 5.6 features, especially for true multi-master WAN or cloud implementations for business critical applications. • Galera Cluster 3.0, synchronous multi-master feature and functionality... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Jonathan Thurman
    Awesome! Traffic to your site is really picking up and everything is lookin’ good. Well, except for that database back in the corner, but it will hold… right? No one really wants to deal with scaling the database tier, but hopefully your customers will drag you (perhaps kicking and screaming) to some sort of distributed database architecture. This talk is all about scaling MySQL through... [read more]
  • Track: Replication and High Availability Strategies
    Intermediate
    Alexey Yurchenko
    Galera was conceived from the ground up to be the simplest replication solution possible. And it really is very simple.
  • Track: Tutorials
    Intermediate
    Peter Zaitsev
    This presentation will teach you the InnoDB internals you need to know for performance optimization and operational tasks. You'll learn topics such as how InnoDB allocates space on the filesystem and in memory, how InnoDB recovery works, and how MVCC and locking work. We'll also cover the insert buffer and doublewrite buffer, and how InnoDB purges old data. We will not get into code-... [read more]
  • Track: Utilizing Hardware
    Intermediate
    Aurimas Mikalauskas
    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: New Features
    Intermediate
    Colin Charles
    MariaDB is now three years old and we've made 5 major GA releases of the popular database software. With many Linux distributions taking the path to replace MySQL with MariaDB, it can be said that it is 2013 that MariaDB has arrived (so a little longer than OpenOffice.org/LibreOffice split). With MariaDB, you have many new features that you can utilize to take your database usage to the... [read more]
  • Track: Tutorials
    Intermediate
    Henrik Ingo
    Many organizations use NoSQL solutions along with a relational database system, and the combination of MongoDB with MySQL is popular. This tutorial will teach MySQL users the most prominent features of MongoDB: - how to install it and use the command line client to connect to the server - how to write queries - how to use index for better performance - how to perform backups and how to build... [read more]
  • Track: Database Administration
    Beginner
    Johan Andersson
    Correct tuning of MySQL NDB Cluster can have dramatic impact on performance. As a distributed shared-nothing system, it is quite sensitive to tuning of communication buffers, or correct partitioning of the schema. In this session we will look at different tuning aspects of MySQL Cluster. - Application design guidelines - Schema Optimization - Index Selection and Tuning - Query Tuning... [read more]
  • Track: Tools
    Beginner
    Mats Kindahl
    MySQL Fabric is an open-source solution recently released by the MySQL Engineering team at Oracle. It seeks to make horizontal scale-out through sharding more accessible to users with growing data management requirements. This integrated framework supports management of large farms of MySQL servers, and includes support for sharding and high-availability. This session will present MySQL Fabric... [read more]
  • Track: Tools
    Beginner
    Giuseppe Maxia
    Need to test a new MySQL release? If the only spare “server” at your disposal is your laptop and resources are an issue, you can try MySQL Sandbox, an open source project that enables you to install and manage many instances of MySQL at once on your Linux or Mac laptop. Using this tool, you can install a new version of MySQL in a few seconds, without conflicts and without wasting resources. What’... [read more]
  • Track: Utilizing Hardware
    Torben Mathiasen
    As an increasing number of MySQL environments move to all flash based storage, additional resources aim to make the database better utilise this advanced technology. Applications have assumed rotational mechanical storage devices for the past 20+ years, trying to get the most performance by working around their limitations. Moving to fast flash based storage today increases performance... [read more]
  • Track: Tools
    Beginner
    Art van Scheppingen
    This session will explain how Spil Games migrated from available MySQL performance monitoring systems to their new internal standardized system using Statsd and Graphite. It will cover its architecture, functional basics and dashboard creation. In the past few years we have been using and testing most MySQL monitoring systems available. While scaling up our infrastructure cross datacenter the... [read more]
  • Track: New Features
    Intermediate
    Dimitri KRAVTCHUK
    MySQL Performance is the real passion of this session’s speaker, so the presentation is about MySQL Performance and only about MySQL Performance! It starts from an overview of the most common performance tuning, tuning errors, and “best” practices (in both senses) and then goes more and more in depth to the latest improvements made in MySQL Performance up to the present. Benchmark results and... [read more]
  • Track: Database Administration
    Beginner
    Frederic Descamps
    Deployment automation is now almost everywhere thanks to the devops movement, tools like puppet and chef are now very popular. However even if it's very easy to deploy packages and configurations, how easy is it to maintain database schemas and how can this task be automated ? During this session, I will try to describe the problematic and bring one of the solution using existing tools... [read more]
  • Track: Best Practices for Businesses
    Intermediate
    Luis Motta Campos
    Talk Submission for the Percona Live Conference 2013. The ebay Classifieds Group (eCG) is the part of the ebay Corporation dedicated to the Classified Ads market. We help people find whatever they're looking for in their local communities, from apartments to jobs, from couches to cars. In the process, we churn through amazing amounts of data, most of which is, at least at some point,... [read more]
  • Track: Best Practices for Businesses
    Intermediate
    Oli Sennhauser
    Database Performance is what everybody is asking for. Often we expect that some changes in the database configuration is the solution for our problem. But typically it is not. Very often (in most of the cases) the problem is missing indexes. In this talk we will have a look at Indexes, how they are used and how they should not be used. We take over the role of a MySQL Optimizer to understand... [read more]
  • Track: Replication and High Availability Strategies
    Beginner
    Luis Soares
    MySQL replication is the foundation for many of the world’s busiest on-line services. MySQL 5.6, released earlier this year, includes a comprehensive set of new replication features to improve scalability and performance. These have been proven to increase the performance of both masters and slaves by over 5 times and enhance the user experience by reducing load on DevOps and DBA teams.
  • Peter Zaitsev
    This year is the tenth anniversary of our gathering as a community to discuss and guide the direction of the MySQL ecosystem. With the release of MySQL 5.6, the increasing need for performance, the demand for big data support, and the question of the cloud, 2013 brings opportunity for an enormous leap in innovation. In his keynote, Peter Zaitsev gives his perspective on the state of the MySQL... [read more]
  • Track: Tutorials
    Beginner
    Kenny Gryp, Dimitri Vanoverbeke, Liz van Dijk
    Do you want to get more familiar on how to become a MySQL DBA? Are you a developer familiar with writing applications that use MySQL but you feel a bit limited on how to manage a MySQL Database? This full day tutorial will be mainly hands-on. On each of the various topics some slides will be presented, but the goal is to have YOU, as the student, work on a MySQL environment as much as... [read more]
  • Track: Tutorials
    Beginner
    Kenny Gryp, Dimitri Vanoverbeke, Liz van Dijk
    NOTE: this is part 2 of a full day tutorial Do you want to get more familiar on how to become a MySQL DBA? Are you a developer familiar with writing applications that use MySQL but you feel a bit limited on how to manage a MySQL Database? This full day tutorial will be mainly hands-on. On each of the various topics some slides will be presented, but the goal is to have YOU, as the student... [read more]
  • Track: Database Administration
    Beginner
    Ratheesh Kaniyala
    Bodybuilding.com is ranked around #300 - #370 in website traffic and we are the facebook when it comes to bodybuilding. I am the Mysql DBA at bodybuilding.com since 2009 and have found it to be a very interesting and challenging role. I am in the Site Operations Department and an equally responsible member to keep the site up and running. As a Mysql DBA I have the pleasure of working with a team... [read more]
  • Track: Tutorials
    Intermediate
    Frederic Descamps, Peter Boros
    NOTE: The solutions for this tutorial can be found here: http://lefred.be/pluk/pxc_solutions.pdf -- This is a full day tutorial -- Percona XtraDB Cluster is a high availability and high scalability solution for MySQL clustering. Percona XtraDB Cluster integrates Percona Server with the Galera synchronous replication library in a single product package which enables you to create a cost-... [read more]
  • Track: Tutorials
    Intermediate
    Frederic Descamps, Peter Boros
    NOTE: The answers for this tutorial can be found here: http://lefred.be/pluk/pxc_solutions.pdf, and the slides here: http://www.percona.com/live/london-2013/sessions/percona-xtradb-cluster-nutshell-hands-tutorial-part-1 -- This is a full day tutorial -- Percona XtraDB Cluster is a high availability and high scalability solution for MySQL clustering. Percona XtraDB Cluster integrates Percona... [read more]
  • Track: New Features
    Intermediate
    Valerii Kravchuk
    The list of new features and improvements to PERFORMANCE_SCHEMA in MySQL 5.6 is impressive: - Instrumentation for table input and output - Event filtering by table, based on schema and/or table names - Event filtering by thread. More information is collected for threads - Summary tables for table and index I/O, and for table locks - Instrumentation for statements and stages within... [read more]
  • Track: Utilizing Hardware
    Beginner
    Peter Boros
    This session will be about benchmarking MySQL and disk IO subsystems with sysbench and interpreting the results. In our consulting practice, I helped a reasonable number of customers with sysbench, so this way I know the common caveats more people run into. The talk will cover benchmarking IO subsystems with the fileio test, as well as benchmarking MySQL.
  • Track: Tutorials
    Intermediate
    Jaime Crespo
    MATERIAL FOR THE TUTORIAL Slides: http://www.slideshare.net/jynus/query-optimization56 VirtualBox 4.3.0 64bit Machine Image -1.7GB- (OVA file, File > Import Appliance): md5sum: 9fdaff735f17bd6ffe42cde5bdcce204 percona_live.ova * Google Drive Mirror: http://tinyurl.com/query56google * Dropbox Mirror: http://tinyurl.com/query56dropbox Separate downloads: * CentOS 6.4: http://... [read more]
  • Intermediate
    Barry Abrahamson
    WordPress.com, started in late 2005, has grown to be one of the largest platforms on the web. Today, WordPress.com and self-hosted WordPress sites power almost 20% of the Internet. Very early on, we made the decision to create multiple database tables per site instead of combining multiple sites into larger, monolithic tables. At the time, everyone thought we were crazy and that it wouldn... [read more]
  • Track: Database Administration
    Intermediate
    David Busby
    Covering why selective grants are important to protect against certain attack vectors. Why user passwords need to be complex. Dissecting MySQL's authentication handshake, and a look at Scapy. Deploying SELinux in targeted enforcing mode; and how to not be afraid of it. Performance implications of deploying selinux. Why it's important to deploy and properly configure... [read more]
  • Track: Tutorials
    Intermediate
    Giuseppe Maxia, MC Brown
    -- This is a full day tutorial -- Modern business require complex data management, which result in complex problems. Although MySQL native replication offers a robust streaming in simple topologies, it is not up to the tasks required today: * seamless failover * multiple masters * fan-in replication * data transformation * replication from and to different database servers. All the... [read more]

Pages

Subscribe to Proposed Sessions