Sessions

  • Track: Utilizing Hardware
    -
    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
    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
    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
    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
    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
    -
    ,
    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.
  • 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
    -
    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]
  • 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
    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
    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
    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
    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
    Galera was conceived from the ground up to be the simplest replication solution possible. And it really is very simple.
  • Track: Tutorials
    Intermediate
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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.
  • 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
    , ,
    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
    , ,
    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
    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
    ,
    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
    ,
    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
    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
    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
    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
    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
    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
    ,
    -- 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