M|18

Agenda

Join the conversation
Agenda Highlights

Workshops

Choose from five hands-on, half-day workshops to help you master key skills around MariaDB, including high availability, analytics, security and performance. Learn directly from MariaDB engineers, RDBAs and consultants – ask questions, do the labs and become a MariaDB expert.

Keynotes

Get the latest on how companies are adopting open source and modernizing their infrastructure with MariaDB. Be the first to learn about new product features and how we’re making it even easier to fulfill today’s needs and tomorrow’s possibilities.

Sessions

40+ sessions ranging from deeply technical to use cases to product features. Learn and ask questions about security enhancements, performance tuning, cloud and container deployments, microservices, high availability optimizations and more.

 
 
 
 
 
 
 
 
 
 
Workshops

Implementing High Availability for Mission-Critical Databases

MariaDB delivers scalability and high availability to data infrastructure environments where flexibility, performance and security really matter. This workshop will introduce attendees to the architecture, setup and development of MariaDB Server for mission-critical applications. Focus will be on MariaDB Server’s asynchronous, semi-synchronous and multi-source replication capability along with an introduction to MariaDB MaxScale and MariaDB Cluster.

Securing MariaDB: Beyond the Basics

In this workshop attendees will learn how to run MariaDB in a secure and safe way in order to meet common regulatory standards. This workshop will cover all aspects of MariaDB security, including encryption, data masking, role-based access control (RBAC), external authentication (PAM/LDAP), encryption at rest and key management. We will also dive deep into transport encryption, data masking and filtering with MariaDB MaxScale.

Ultimate Performance: Tuning MariaDB for Reliably Faster Performance

This workshop will explore performance tuning for MariaDB Server, including query and index tuning, storage engine optimization and general server configuration options. We will also share best practices for data types, and look at how to identify bottlenecks and better manage resources across the board.

High Performance Analytics with MariaDB ColumnStore

MariaDB AX is a modern data warehousing solution for large-scale analytics that includes MariaDB ColumnStore, a simple to use, scalable and high performance columnar storage engine that supports a wide variety of analytical use cases. This workshop will provide an architectural overview of ColumnStore, will walk through an installation and configuration of a ColumnStore cluster, and will show how to do real-time and batch data streaming into ColumnStore with MariaDB MaxScale.

Expert Tour: What’s New in MariaDB Server

The latest GA release of MariaDB Server 10.2 added a ton of cool new features and there’s more to come in 10.3. In this hands-on presentation, MariaDB experts will showcase how to powerfully analyze data with window functions and common table expressions (CTEs) and combine structured and unstructured data with our latest JSON functions. Attendees will see firsthand the power of temporal data processing with versioned tables, our newest Oracle compatibility features, and much more. MariaDB has never been easier to use and we’re just getting started!

Sessions
Day 1 Day 2
Monday, February 26
Tuesday, February 27
Monday, February 26
9:00 am - 12:00 pm
Workshops
12:00 pm - 1:00 pm
Lunch for Workshop Attendees
1:15 pm - 2:45 pm
Keynotes
Welcome Keynote
ServiceNow: Operating Massive Scale with Cloud Infrastructure and MariaDB

ServiceNow, faced with unprecedented scalability challenges as it became the fastest growing enterprise software company over $1 billion, required database infrastructure capable of supporting petabytes of data and billions of queries. How did they do it? Why did they switch to MariaDB?

Tim Yim

Speaker

Tim Yim
ServiceNow
Director of Operations
MariaDB at DBS Bank

Speaker

Ng Peng Khim
DBS Bank
Manager Director, Head of IBG Technology
3:00 pm - 3:50 pm
What’s New in the MariaDB TX Platform

This session will review new features and improvements available in the MariaDB TX platform, focusing on MariaDB Server 10.3 and MariaDB MaxScale 2.2.

Intel and MariaDB: Strategic Collaboration to Enhance MariaDB Functionality, Performance and TCO

As businesses become more and more data intensive, the cost per transaction becomes an important metric. The combination of MariaDB and Intel® technologies is extremely powerful in this age of distributed computing. In this session, we will discuss the use of shared, log-structured storage to support the persistence requirements of databases. We will outline the details of this approach and provide some early results based on an operational MariaDB/MyRocks implementation. Furthermore, you will learn how our cooperation supports the transformation of transaction performance and cost by optimizing the combination of MariaDB running on the Intel® Xeon® processor Scalable family and Intel® Optane™ SSDs taking advantage of 3D XPoint™ memory media. We will also describe how Intel® FPGAs are accelerating on-prem cloud-scale DBaaS.

David_Cohen

Speaker

David Cohen
Intel
Storage Solutions CTO and Senior Principal Engineer, Data Center Solutions Group
Mike Strickland

Speaker

Mike Strickland
Intel
Director, Solutions Architect, Intel Programmable Solutions Group
Choosing the Right High Availability Strategy for You

This session will outline the high availability options available in MariaDB TX, highlight the pros and cons of different approaches, explain the trade-offs involved, and show how to optimize for consistency and/or performance.

Somewhere between Schema and Schemaless

A traditional problem of relational databases is storing similar data with different attributes. For example, querying a product catalog when different products have different properties (e.g., color for shirts, length for pants). You can store everything in the same table or create multiple tables, but both options have their issues. There are other design patterns as well. MariaDB Server, with dynamic columns and JSON functions, introduces new options. In this session, we will evaluate the pros and cons of these approaches based on different use cases.

Understanding the Architecture of MariaDB ColumnStore

MariaDB ColumnStore’s architecture is a meld of MariaDB’s traditional row based database server with a distributed high performance analytical columnar storage engine. This session is for MariaDB users so they can get to grips with the the MariaDB ColumnStore engine and how it works. It will cover:

  • Use cases
  • Query processing
  • Bulk data insertion
  • Distributed partitions
  • Optimizing queries

We will also go over the new features in MariaDB ColumnStore 1.1 and a sneak peek at some upcoming features.

4:00 pm - 4:50 pm
How to use MyRocks with MariaDB Server

The goal of this session to help attendees understand when to use MyRocks and how. MyRocks is storage engine developed by Facebook. It was engineered to meet the highest compression and write efficiency requirements. While it was alpha in MariaDB 10.2, it is expected to be GA in MariaDB Server 10.3. In this session, Sergei will cover everything from intended use cases and expected benefits to important differences when compared with InnoDB.

It will conclude with walkthrough of practical considerations when migrating and/or using MyRocks:

  • Tuning for performance
  • Migrating data from InnoDB
  • Backing up and restoring data
  • Replication considerations
  • Using write-optimized operation modes
  • MyRocks differences in MariaDB
Global Data Replication with Galera for Ansell Guardian

The Ansell Guardian® service helps companies select the right personal protective equipment solution for improved safety, productivity and cost performance, resulting in a 65% injury reduction and savings of over $149 million for our customers.

In early 2017, we seamlessly replaced the global geo-distributed data synchronization processes supporting the Guardian application suite with MariaDB TX, resulting in better performance and vastly reduced support issues from the previous MySQL-based solution. We will discuss our preparation for this successful implementation and how MariaDB TX with clustering supports the Ansell Guardian application – and the in-house scripting tools we developed to simplify administration of it.

Greg Henderson

Speaker

Greg Henderson
Ansell Healthcare
Senior Manager, Architect - Global Business Systems
Louis Zircher

Speaker

Louis Zircher
Ansell Healthcare
Director, Ansell Guardian® Technology Solutions
Planning for Disaster Recovery, Online and Offline

This session will explain how to use the disaster recovery features and tools available in the MariaDB TX platform, everything from point-in-time rollback to full backup and restore to failover with standby databases.

Migrating from Oracle and Handling PL/SQL Stored Procedures

It’s easier than ever to migrate from Oracle to MariaDB TX, with new features introducing compatibility and reducing the effort necessary to conduct a successful migration. In this session, we will discuss our experiences with customers migrating from Oracle, and the lessons learned we’ve learned. In addition, we will introduce the Oracle PL/SQL compatibility and sequence support in MariaDB Server 10.3, noting what Oracle PL/SQL syntax is supported, and show how Oracle PL/SQL stored procedures can be run on MariaDB Server.

Analyzing Data with the MariaDB AX Platform

This session will provide an introduction and overview of the MariaDB AX platform, highlight updates to the ColumnStore storage engine and provide an update the latest tools and connectors, including the new streaming data adapters.

5:00 pm - 5:50 pm
How MariaDB Server Scales with Spider

This session will provide an overview of the Spider storage engine (GA in MariaDB Server 10.3), explain how it works, highlight recent updates and show how to configure and deploy MariaDB Server with scalable storage using distributed partitions.

Creating a Reference Architecture for High Availability at Nokia

This session will focus on the creation a reusable reference architecture at Nokia to simplify the deployment of MariaDB TX in multiple data centers to maintain high availability. We’ll start with the high availability and failover requirements for geo-distributed applications. We will then examine the high availability and failover options provided out of the box before describing our reference architecture and showing how native automatic failover can be combined with real-time events and external scripts to maintain HA within and between data centers.

Rick Lane

Speaker

Rick Lane
Nokia
Consulting Member of Technical Staff
PolarDB: A Shared-storage Solution for InnoDB

PolarDB uses shared storage to provide read scalability, using InnoDB redo logs for physical replication and storing physical page level operations for crash recovery. PolarDB extends this functionality, allowing multiple read replicas to be deployed for read scaling. In this talk we’ll take a deep dive into InnoDB internals and explain the changes we made to the core InnoDB code. We’ll touch upon design issues around logging, crash recovery, buffer pool management, MVCC, DDL synchronization and more.

Querying Data at a Previous Point in Time

This session will introduce the point-in-time querying functionality added in MariaDB Server 10.3, using practical examples to show how SQL can be used with AS OF and system versioned tables to query data as it was at a specific point in time.

Max Mether

Speaker

Max Mether
MariaDB
Head of Server Product Management
Ingesting Data with the New Bulk Data Adapters

With bulk data adapters for C++, Java and Python, developers can bypass the SQL interface, parser and optimizer for high-throughput, low-latency ingestion of bulk data – ideal for storing machine learning results, collecting clickstream data, importing scientific data and more. This session will provide an overview of how the bulk data adapters work and show how to use them with examples. We’ll also give a demo of how we’ve integrated this with Spark.

6:00 pm - 7:00 pm
Opening Party Sponsored by Intel
Tuesday, February 27
8:40 am - 9:30 am
Under the Hood: Galera Cluster

This session will provide attendees with common use cases for clustering, a comprehensive explanation of how clustering works with Galera and introduce new features and improvements available in Galera Cluster 4.

How We Made the Move to MariaDB at FNI

In this session, we will explain our evaluation criteria for selecting a new database (e.g., security considerations in the financial sector) and why we chose MariaDB. We will then focus on how we migrated from Oracle and database-specific development to MariaDB and database-agnostic development. Finally, we will conclude with a summary of where we are in the migration process: implementation, performance and production.

William Wood

Speaker

William Wood
Financial Network, Inc.
Director of Database Architecture
Where and How to Optimize for Performance

An important part of hardware cost and efficiency is performance tuning and optimization. This session, for developers and DBAs, will describe how to optimize everything from the OS to the network to the database (and queries) to get the best performance possible.

Building Location-Based Services with Geospatial Data

With the rise of GPS-enabled devices and beacons, comes the need, opportunity and use cases to extend applications with location-based services. This session will introduce the latest GIS features in MariaDB Server and explain the supported GIS data types and how to index/query them.

Real-time Analytics With The New Streaming Data Adapters

MariaDB AX now includes two streaming data adapters. The first consumes messages from MariaDB MaxScale change-data-capture streams – data written to MariaDB TX is automatically and continuously replicated to MariaDB AX. The second consumes message from Apache Kafka topics. This session will introduce these streaming data adapters and explain how they can be deployed and configured to ensure data in MariaDB AX is always up to date and without the need for manual and/or batch processes.

9:30 am - 10:00 am
Break & Partner Pavilion
10:00 am - 10:50 am
Understanding the Query Optimizer

In this session, Igor Babaev and Vicentiu Ciorbaru will provide a technical overview of query optimizations for views, derived tables and common table expressions – embedded queries, late materialization, condition pushdown, lateral and mergeable derived tables and more – while Vicentiu Ciorbaru will covers query optimizations for window functions.

Panel Discussion: Open Source in the Enterprise

This session will feature a panel discussion and open Q&A on successfully adopting OSS in the enterprise. Red Hat, Copart and Financial Network, Inc. will share their experience with OSS: why they chose to adopt it, how important it is, how they got started, the business and technical challenges they faced and how other enterprises can succeed with OSS too.

PolarDB: Extending Shared-storage to MyRocks

PolarDB is a next-generation, cloud-native storage engine for Alibaba Cloud. PolarDB for MyRocks extends PolarDB to support MyRocks on shared storage, using RocksDB logs for replication. In this session, we’ll explain how we solved many problems for deploying MyRocks on shared storage: log replication, converting system tables, cache and DDL replication, MVCC and the new RocksDB log format.

Running MariaDB TX on Containers

It’s one thing to run a database on a single containers, it’s another to run a replicated/clustered database on multiple containers. This session will provide an overview of the requirements for running databases on containers and show how to configure and deploy a MariaDB TX cluster on Docker.

MariaDB AX Panel Discussion on Analytical Use Cases

Hear directly from MariaDB AX users from diverse industries. Our group of panelist are building innovative use cases such as genome analysis for cows and pigs, healthcare program cost-effectiveness analysis to improve public health and customer behavior analysis to provide high-quality customer support. In this session, you will learn why these companies chose and how they implemented MariaDB AX.

Jack Sprague

Speaker

Jack Sprague
Center for Information Management
Enterprise Architect
11:00 am - 11:50 am
Technical Introduction: Automatic Failover

This session will introduce the automatic failover feature being developed in MariaDB MaxScale, providing an overview of failover concepts, a step-by-step explanation of the failover process and how to configure it.

How InfoArmor Harvests Data from the Underground Economy

Christian Lees, CISO, will provide an illuminating, “behind the curtain” look at threat actor attribution and the underground economy, information gained from years of research into the dark web. He will examine methods and provide examples of how InfoArmor harvested data, specifically compromised credentials, from the underground economy. Steve Olson, lead engineer, will then expand on the technical details of how data is ingested from the dark web.

What we learned from growing by a billion rows:

  • Query and table optimization
  • Application optimization
  • Monitoring bad queries via application logging and Montog
  • Python pyramid -> sql alchemy ORM -> Zope transaction manager
  • MariaDB consulting role -> advice, config, admin work
  • Replication, read/write splits -> MariaDB MaxScale
  • Hardware configuration needed
Securing Databases at Tencent Cloud

In this session, we will explain how we implement database security at Tencent Cloud, focusing on encryption and auditing with technical explanations of the security architecture, the plugin implementations and how we use audit logs to diagnose database issues.

Taking Advantage of Common Table Expressions

The first half of this session will provide an overview of common table expression (CTEs), the SQL syntax, use cases for non-recursive CTEs and query optimizations for CTEs, including condition pushdown. The second half of this session will focus on recursive CTEs, use cases such as transitive closures and an explanation for how loops are handled and stopping recursion.

Analytics in the Real World, Case Studies and Use Cases

With scalable, high-performance analytics readily available, organizations of all kinds are moving beyond reporting, building decision support systems and using predictive analytics to identify outcomes and provide recommendations. In this session, we will explore innovate use cases in the finance, healthcare, telecommunications and manufacturing seconds and highlight the most interesting case studies.

12:00 pm - 1:00 pm
Lunch & Partner Pavilion
1:10 pm - 2:00 pm
Architectural Overview: MariaDB MaxScale

Johan Wikman, the lead developer for MariaDB MaxScale, will describe the architecture behind MariaDB MaxScale and explain how it has evolved with each release, improving performance and scalability.

How Copart Switched to MariaDB and Reduced Costs During Growth

Due to exponential growth in its international business unit, Copart face significantly higher database costs if we continued to use IBM DB2. We will explain why we chose to standardize on MariaDB TX, how we convinced operational and development teams to adopt it, the challenges we faced and how we are now evaluating MariaDB AX as a replacement for our current analytics database too.

How Facebook Migrated to MyRocks

Facebook created MyRocks, and it is now available in MariaDB. MyRocks is a space and write optimized storage engine built on top of RocksDB. The initial objective was to replace InnoDB with MyRocks in the users database (UDB), reducing the amount of storage space needed by half. It was a success, and now Facebook is trying to make it better and help increase adoption in other services. In this session, Yoshinori will explain how Facebook replaced InnoDB with MyRocks in UDB, and highlight the features being developed and planned for future releases of MyRocks.

Using Window Functions and User-Defined Functions

In this session, we will explain how when, where and how to use windows functions (e.g., to optimize queries with self-joins and related rows) as well as how to create your own user-defined functions and user-defined aggregate functions. We will cover everything from implementation details and performance advantages to use cases and practical examples.

Getting Started with Analytics: MariaDB AX + Kubernetes

MariaDB AX leverages distributed, columnar storage for performance and scale, but what if you want to get started without having to run MariaDB AX in a scale out environment? In this session, we will walk you through the process of building a multi-node MariaDB AX cluster on a single machine using Kubernetes and containers. With a straightforward and practical introduction to both MariaDB AX and Kubernetes, we will give attendees the know-how to build and test a real-world deployment right from their laptop.

2:10 pm - 3:00 pm
Deep Dive: InnoDB Transactions and Write Paths

This session will explain in technical detail every step in the write path for InnoDB transaction, from the very beginning to the very end. It will introduce advanced DBAs to mini-transactions and how they used to modify buffer pools, redo/undo logs, clustered and secondary indexes, and checkpoints – all the way to fsync and commit.

Scalability via Expendable Resources: Containers at BlaBlaCar

When it comes to building scalable infrastructure, making resources expandable is always the right choice. In this session, we will discuss our shift to containers and high availability. We will provide an overview of our infrastructure and environment, introduce our service discovery solution and reveal what we call “Backend High Availability Pillars” with MariaDB Galera as example.

Why Abstract Away the Underlying Database Infrastructure

The best way to maintain high availability for a database is to abstract away the underlying infrastructure. MariaDB MaxScale, an advanced database proxy with a networking core and modular architecture, enables applications to connect and query multiple database clusters as if they were a single database. This requires MariaDB MaxScale to detect changes to the database topology and state of the databases. In this session, we will explain how MariaDB MaxScale creates this abstraction, and how it is able to route database queries to the right database servers.

Battle of the Online Schema Change Methods

We will review different options for performing online schema changes without downtime, whether it is via built-in database capabilities or external tools like gh-ost and pt-online-schema-change, highlighting their strengths and weakness and using practical examples to provide recommendations on what to use and when.

Analytics as a Service with MariaDB AX and Microsoft Azure

Creating a reporting and analytics solution to manage over 200 retailers and 60 million loyalty cards is a complex problem, especially when you have to integrate multiple components from different vendors – and with a consistent architecture. In this session, we’ll look at the real life use case for a large, UK-based customer loyalty program running reporting and analytics as a service on Microsoft Azure. The solution is built on MariaDB AX, Analysis Services and other products and services to delivery an intuitive front end.

3:00 pm - 3:30 pm
Break & Partner Pavilion
3:30 pm - 4:20 pm
Deep Dive: InnoDB Transactions and Replication

In this session, we’ll explain in technical detail every step that occurs when data is replicated – what’s replicated, when and where. We will introduce concepts like group commit and GTIDs, the binlog format and data structure (and relay log), parallel replication threads and how the replication process fits within a transactions – what is written to disk and when, and when is the data durable.

How DBAs at TradingScreen Make Life Easier With Automation

This session will explain how DBAs can use automation to simplify database administration – everything from backups and maintenance to monitoring and alerts across multiple databases and servers. We will highlight the pros and cons, discuss how we use it and introduce the tools we use. In some cases, it has made our easier. In others, not so much. We’ll be sharing best practices and recommendations based on the lessons we’ve learned.

Beyond Routing, Everything You Can Do With A Database Proxy

The database proxy is a key component of modern database infrastructure, responsible for routing queries to the right database server, regardless of the topology. However, MariaDB MaxScale, as an advanced database proxy, is capable of a lot more – everything from caching to data masking to change-data-capture. In this session, we will walk through all of the features in MariaDB MaxScale and explain how it improves database performance, scalability, availability and security. In addition, we’ll show how MariaDB MaxScale can be extended by creating customer modules. In this case, a simple module for generating a whitelist for the firewall by inspecting SQL queries.

Writing Stored Procedures in the Real World

In this session, we will discuss writing stored procedures in MariaDB Server and show working code examples with a live demo using Vagrant.

4:30 pm - 5:30 pm
Closing General Session
Tracks

Focus Areas

 

Cloud deployments

The cloud makes it easier and faster for developers to build modern applications because it removes the hassle of managing complex infrastructure. But for the teams in charge of DevOps, the cloud brings a host of new challenges. If you’re deploying databases on a public or private cloud, this track will show you what’s possible with MariaDB. Learn best practices for deploying on any cloud – public or private – using Docker, Mesos, Kubernetes and more.

Business and customer use cases

Learn from technology practitioners and business leaders how MariaDB is core to their businesses. If you are responsible for keeping your organization competitive, reducing costs and accelerating time to market, join this track to learn how others have improved their overall operations with MariaDB. Sessions will cover everything from building a business case and establishing open source ROI to use cases and lessons learned from industry leaders around the world.

Big data and analytics

Data scientists know that big data is powering competitive advantage. Join data scientists, developers of analytic applications and other thought leaders to share ideas, discuss what’s coming next and to learn how MariaDB enables high-performance analytics at a massively lower cost than proprietary alternatives. 

How we build MariaDB

Want to know what’s included in the next MariaDB release? Looking for a deep dive into MariaDB architecture? Join this track to hear what’s new – and what’s coming next – directly from MariaDB engineers and product managers. This track will include sessions on the MariaDB roadmap, as well as advanced technical use cases for experts in application development and operations.

Building modern applications with MariaDB

MariaDB’s extensible architecture has many advantages, including support for a variety of storage engines, which expands the types of use cases you can support on a single database. Are you building high-performance analytics? How about web scale and highly responsive customer-facing applications? Or are you simply trying to get started with MariaDB? This track includes sessions that cover everything from getting started with MariaDB to building complex applications with cross-engine joins.

Sponsors

M|18 offers sponsors a chance to directly engage with the growing global audience of MariaDB users to inspire new ideas and solutions. We offer flexible and valuable sponsorship opportunities to suit your needs. Join the journey and sponsor M|18!

 

Contact us for sponsorship opportunities

2018 Sponsors