• Track: Replication & Backup
    Jean-François Gagné
    At Booking.com, we are adding new components to our replication architecture: Binlog Servers. Those allow us to deploy remote site replication without needing Intermediate Masters (which is good as those cause problems in our environment). Moreover, Binlog Servers allow us to reach extreme number of slaves replicating from a single master (greater than 100 slaves and growing). In this session,... [read more]
  • Track: What's new in MySQL
    Olav Sandstå, Manyi Lu
    There have been substantial improvements to the optimizer in MySQL 5.7—most noticeably, users can now combine relational data with NoSQL. MySQL introduced a new JSON datatype and built-in JSON functions, and functional indexes are now supported through both stored and virtually generated columns. On the performance side, MySQL can avoid creating temporary tables for UNION ALL, enable range scans... [read more]
  • Track: DevOps
    Frederic Descamps
    During this presentation, I will show how to implement several stuff that will improve your day-to-day workload. The points will cover topics like Point in Time Recovery, WAN replication with group segments, Avoiding SST when adding new Percona XtraDB Cluster node, ... the tips will be briefly explained to the audience and then show how to implement them. The tips covered must be known by every... [read more]
  • Track: Programming
    Anders Karlsson
    Where did databases start? Who developed them? Today we probably take them for granted, but this hasn't always been the case. I will in 5 minutes talk about some of the important milestone in database development. What they were first used, how the technologu developed, what the architectures and the companies developing them looked like then and now. This should be interesting for anyone... [read more]
  • Track: MySQL and NoSQL
    David Pilato
    How do you mix SQL and NoSQL worlds without starting a messy revolution? This live coding talk will show you how to add Elasticsearch to your legacy application without changing all your current development habits. Your application will have suddenly have advanced search features, all without the need to write complex SQL code! David will start from a RestX, Hibernate and MySQL based... [read more]
  • Track: What's new in MySQL
    Ivan Zoratti
    MaxScale is a proxy server designed to be database-centric and database-agnostic. The key features of the proxy are its flexibility in handling different types of plugins and workloads, and a multi-threaded, event-driven core that provides maximum scalability and performance. In this section we will look at the internals of MaxScale for: - The MaxScale internal architecture - How MaxScale... [read more]
  • Track: Security
    Andrew Moore
    With so many logging options, it's not easy deciding how to meet regulatory compliance. This session will compare the various methods of MySQL logging. We will take many factors into account including reliability, performance, and ease-of-use. We will also discuss what to do with your logs after you have them. The Elasticsearch ELK stack offers new opportunities for searching,... [read more]
  • Track: MySQL and NoSQL
    Beginner
    Natalino Busa
    NoSQL databases such as Cassandra trade speed and availability at the expenses of a much more rigid data model. Table joins are not available and search queries are limited because of the way items are stored. Spark can fill in the gaps of what Cassandra can natively do by providing a larger set of SQL functions. Today it is possible to efficiently connect Cassandra and Spark via a spark-... [read more]
  • Track: High Availability
    Seppo Jaakola
    Big and long term transactions have traditionally not behaved well in Galera Cluster. Large replication data sets have resulted in symptoms like elevated conflict rate, increased memory consumption, even OOM kill may happen, flow control pausing, cluster freezing... To deal with these issues, Galera users have been adviced to split large transactions in "reasonable size". There is also... [read more]
  • Track: MySQL and NoSQL
    Ævar Arnfjörð Bjarmason
    At Booking.com we’ve written our own in-house key-value store for HTTP cookie data on the server-side. It combines consistent hashing across Redis and MySQL servers, using Redis as a cache and MySQL for longer-term storage. The system is designed to stores tens of TB of data on many data centers and to serve hundreds of thousand of queries per-second with an average response time of ~5... [read more]
  • Track: Security
    Intermediate
    David Busby
    Cloud security, sounds like a myth does it not?
  • Track: Security
    Sergei Golubchik
    Databases can be treasure troves of sensitive information. They can contain customers' personal data, confidential competitive information, and intellectual property. Lost or stolen data, especially customer data, can result in brand damage, competitive disadvantage, and serious fines—even lawsuits. Many of today’s privacy mandates require protecting data at rest, and the database is an... [read more]
  • Track: DevOps
    Laine Campbell
    IT is undergoing a revolution, and database administration is no exception. As Ops teams evolve into reliability engineers, developers and traditional systems administrators find themselves diving into the world of the DBA. In this session, we take the model of site reliability engineering and guide you through the components of the craft of DB architecture/operations in that context.Consider... [read more]
  • Track: MySQL in the Cloud
    Colin Charles
    Today you can use hosted MySQL/MariaDB/Percona Server in several "cloud providers" in what is considered using it as a service, a database as a service (DBaaS). You can also use hosted PostgreSQL and MongoDB thru various service providers. Learn the differences, the access methods, and the level of control you have for the various public cloud offerings: - Amazon RDS for MySQL and... [read more]
  • Track: Performance Optimization
    Charity Majors, David Murphy
    The abstract for this talk is to be provided soon.
  • Track: MySQL Case Studies
    Emily Slocombe
    Drupal is one of the more widely adopted CMSs. It is open source and has a huge developer base. However, I rarely hear a DBA mention having to administer Drupal with anything but frustration and pessimism. At Acquia, we have thousands of Amazon instances running Drupal databases. Most sites are quite different from each other, but some basic principles apply to all. Being the DBA for Drupal does... [read more]
  • Track: DevOps
    Travis Redman
    Parse has built a powerful and easy-to-use mobile platform on top of MongoDB, leveraging the flexibility of its NoSQL document-based model to store data for over half a million applications with diverse workloads. Parse supports a wide variety of applications, including social networking, games, marketing, and services. Workloads vary, from apps with very simple document storage, to those with... [read more]
  • Track: Replication & Backup
    Károly Nagy
    Do you want some ideas how to manage MySQL backups with instant recoverability when you store data on the petabyte scale and backing up multiple terabytes daily? How to test your backups? How to encrypt them on the fly? How to centralise and scale your backup system? In this talk we’re going see how we did it at Booking.com come and even more: - what prerequisites did we have before we... [read more]
  • Track: High Availability
    damien krotkine
    At Booking.com, we have a constant flow of events coming from various applications and internal subsystems. This critical data needs to be stored for real-time, medium and long term analysis. Events are schema-less, making it difficult to use standard analysis tools. This presentation will explain how we built a complete storage and real-time analysis solution from scratch, based on Riak. I... [read more]
  • Track: DevOps
    Beginner
    Jervin Real
    Not all backup requirements are the same, there are simple backups and then there are complex backup and recovery strategies. After working with hundreds of users laying out the ground work, we've decided that although not all installations are the same, all of them run through the same procedure so we have decided to automate most of this things with pyxbackup. This talk will highlight the... [read more]
  • Track: Replication & Backup
    MC Brown
    New Tungsten Replicator 4.1 by VMware Continuent is now available as an Apache 2.0 licensed open source project. In this session, we are completing a flyover of all the new features and functionality. We'll look at the new extraction methods to get data out and the new methods for applying inserting information into a target database. We'll also use the opportunity to look at how other... [read more]
  • Track: Replication & Backup
    Maximiliano Bubenick
    Logical backups are still important for any full professional backup solution that wants to cover all posible restore scenarios, like partial restores or over environments where you don't have physical access to the IO subsystem. And nowadays being the databases a primary component of any business, restore times are more important than ever. So in this session I will talk about... [read more]
  • Track: High Availability
    Frederic Descamps
    During this talk, I explain how the Galera replication works. This is a theoretical talk in which I explain in details what's replication and how it work. I discuss about what is certification and how it's done. I also cover the difference between MySQL 5.6 GTID and Galera GTID. We always say Galera replication in synchronous... is it really ? Always ? For every steps ? What... [read more]
  • Track: Programming
    Intermediate
    Paolo Spreafico
    Having pioneered many of the technologies used for "Big Data" processing, Google has a unique set of high-performance, finely-tuned, extremely-scalable data processing tools for internal use.
  • Track: Performance Optimization
    Intermediate
    Jeremy Cole, Davi Arnaut
    Following up on "InnoDB: A journey to the core", we'll walk you through exploring InnoDB’s on-disk storage for yourself.
  • Track: Performance Optimization
    Jeremy Cole, Davi Arnaut
    InnoDB is the storage engine behind most busy MySQL databases in the world. How does it store data? How does it track free space? How does it retrieve rows? This presentation dissects InnoDB's storage formats and digs into the physical structure of tablespace files, extents, pages, records, indexes, and free space management. How many bytes would it take to store rows in a particular schema... [read more]
  • Track: MySQL and NoSQL
    Susanne Lehmann
    We love MySQL at Yelp! We use it heavily and are planning to do so for a long time. But we've encountered situations where MySQL has turned out not to be the right tool for the job, and suffered poor performance as a result. That’s why at Yelp, we've iterated on different solutions and have now added Cassandra to our data stores. In this talk, we'll cover the evolution of Yelp... [read more]
  • Track: What's new in MySQL
    Ian Meyers
    Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability. Learn... [read more]
  • Track: MySQL in the Cloud
    Beginner
    Krzysztof Ksiazek
    Amazon Web Services is a popular environment to run Galera Cluster in. It is significantly different than dedicated hosting and bare metal servers. In this talk, we’ll take a close look at the different aspects of operating Galera Clusters on AWS. First, AWS comes with a battery of tools that can bring efficiency in how you manage your databases. We’ll go over some of these (EBS snapshots,... [read more]
  • Giuseppe Maxia
    1 The perils of compatibility: Scripting MySQL installation across versions, by Giuseppe Maxia (VMware): https://www.percona.com/live/europe-amsterdam-2015/sessions/perils-compatibility-scripting-mysql-installation-across-versions 2 MongoDB's Se7en Deadly Sins, by Philipp Krenn (ecosio): https://www.percona.com/live/europe-amsterdam-2015/sessions/mongodbs-se7en-deadly-sins 3 When... [read more]
  • Track: Replication & Backup
    Shlomi Noach
    Introducing Orchestrator: a MySQL replication topology management service, that greatly simplifies DBA's tasks and enhances visibility on your topologies. Orchestrator allows for: - Automatic topology discovery & continuous mapping - Easy topology refactoring (as easy as drag-n-drop) - Failure analysis - Automated master & intermediate master recovery and healing of... [read more]
  • Track: Replication & Backup
    Shlomo Priymak
    MySQL is at the core of Facebook's persistent storage. The graph itself, including every like, comment, post and status, is stored in MySQL, along with many other things. This data is the company's most important asset, and we take great care to make sure everything is properly backed up. Yes, even the lol cats and puppy picture posts. Everything! As you can imagine, backing up this... [read more]
  • Track: What's new in MySQL
    Colin Charles, Monty Widenius
    New MariaDB major release is out of the door (really). It has new unique features (at rest encryption of the database, integrated Galera Cluster, GIS enhancements), performance enhancements (optimistic parallel replication, max statement timeouts, dump thread enhancements in replication), as well as better MySQL compatibility (temporal literals like 5.6). This talk will go over everything new... [read more]
  • Track: MySQL and NoSQL
    Intermediate
    Kenny Gorman
    With MongoDB 3.0 the Wired Tiger storage engine will be included. In addition, 3rd party pluggable storage engines are possible as well. Kenny will present some performance benchmarks, show typical configuration options, and help attendees make sense of these new changes and how the effect MongoDB workloads. He will detail the various components of the Wired Tiger engine and the impact they make... [read more]
  • Track: MySQL and NoSQL
    Nicola Iarocci
    Exposing MongoDB over the internet through a RESTful API is becoming a common pattern, and for very good reasons. Your REST API provides a nice layer of abstraction, isolation and validation above the actual datastore while providing access to all kind of clients. At the same time MongoDB, with its BSON store, is ideal for serving data over the Internet. But designing first, and then building a... [read more]
  • Track: MySQL and NoSQL
    Stephane Combaudon
    MongoDB replication is asynchronous, so it is fast and it does not block the primary if a secondary is slow. However can you make sure that a write was received by several servers before the client acknowledges it? Yes you can! And it is very helpful to avoid losing data if the primary fails. Conversely can you make sure a read will be run on the primary when you need the most up-to-date... [read more]
  • Track: Performance Optimization
    Kenny Gorman
    So you are a DBA or Developer, but you want to be able to have the skills to tune and troubleshoot MongoDB performance? Maybe you already know some MongoDB, but you want to increase your skills? This is your session. Kenny will present an overview of MongoDB performance tuning, he will use analogies to the traditional SQL world (using MySQL and Oracle references), as well as explain key... [read more]
  • Track: MySQL and NoSQL
    Stephane Combaudon
    Data security is a concern for most people and recent reports in the news showed that significant amounts of user details stored in MongoDB are very easily accessible. Does it mean that MongoDB is not able to secure your data? As we will see, MongoDB can be correctly secured, but some features are not enabled by default. You will learn in this session the main items that need to be checked in... [read more]
  • Track: MySQL and NoSQL
    Philipp Krenn
    Lust, gluttony, greed, sloth, wrath, envy, and pride — MongoDB touches each one of them in one area or another; either by commiting the sin itself or by seducing its users. Let's discuss those seven deadly sins so we can work around them or at least be aware of their presence.
  • Track: High Availability
    Kimberly Wilkins
    Mixed Technology NoQSL Topic Abstract : With the larger amounts of data stored, analyzed, and used today, new database technologies have come around to handle that data optimally. Three of these are MongoDB, Elastic, and Hadoop. This presentation will give a brief overview and comparison along with the basic architectures of each. We will provide best use cases for each technology and... [read more]

Pages

Subscribe to Proposed Sessions