M|19

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
1:15 pm - 1:45 pm
Welcome Keynote: The Open Source Mandate
Watch Video

The velocity of change in today’s world, regarding new opportunities, as well as new threats, can only be handled by technology that is a reflection of our times. State sponsored cyberattacks on private companies, or operational leverage of machine learning, are just two examples of threats and opportunities that were unheard of five years ago. This duality is the new normal, and past methods of proprietary responses cannot continue. Accordingly, the world is moving. Only a well organized community of innovation can keep up. Therein lies the strategic mandate of Open Source. Michael Howard will illustrate the key points of this mandate, exemplified through innovation and how MariaDB is helping some of the largest organizations in the world into the era of Open Source.

1:15 pm - 2:45 pm
Welcome Keynote
Watch Video
ServiceNow: Operating Massive Scale with Cloud Infrastructure and MariaDB
Watch Video

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
DBS Bank’s Journey with MariaDB
Watch Video

The largest bank in Southeast Asia, DBS Bank returns to the MariaDB keynote stage to share its success, migrating from proprietary products to open source with MariaDB. Ng Peng Khim, Managing Director, Head of Institutional Banking Group & Future Ready Technology and Joan Tay Kim Choo, Executive Director of Technology, will share DBS Bank’s corporate internet banking use case and how the team deployed more than 50 percent of their critical applications on MariaDB in the last two years.

Ng Peng Khim

Speaker

Ng Peng Khim
DBS Bank
Head of Institutional Banking Group & Future Ready Technology Group Technology & Operations
1:45 pm - 2:15 pm
Keynote Session: DBS Bank's Journey to Open Source
Watch Video

DBS Bank Ltd is a Singaporean multinational banking and financial services corporation headquartered in Marina Bay, Singapore. Ms. Tay is leading the company’s Open Source transformation. In this keynote, she will share DBS' reasons for adopting a strategic Open Source initiative and how they have solved organizational and technological challenges by replacing Oracle Enterprise and DB2 with MariaDB as their database standard.

2:15 pm - 2:45 pm
Keynote Session: How Chips and Databases Change Everything
Watch Video

Not too long ago the world was all about low cost, clustered machines. Scale out was in and scale up was out. Transactional integrity was sacrificed for scale. MapReduce was heralded over SQL as the best way of processing analytical use cases. Cloud and the exponential increase in processor cores and memory are blowing up that theory. Roger will discuss how MariaDB exploits these fundamental architectural changes and how MariaDB enables both OLTP and Analytical use cases for enterprises at any scale.

3:00 pm - 3:50 pm
What’s New in the MariaDB TX Platform
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Migrating from Oracle and Handling PL/SQL Stored Procedures
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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.

Ingesting Data with the New Bulk Data Adapters
Watch Video

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.

Tuesday, February 27
8:40 am - 9:30 am
Under the Hood: Galera Cluster
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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.

10:00 am - 10:50 am
Understanding the Query Optimizer
Watch Video

In this session, Sergei Petrunia and Igor Babaev 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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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.

1:10 pm - 2:00 pm
Architectural Overview: MariaDB MaxScale
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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:30 pm - 4:20 pm
Deep Dive: The Machinery of Replication
Watch Video

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
Watch Video

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
Watch Video

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
Watch Video

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

Harnessing the Power of GPUs for High Performance Analytics
Watch Video

In this session, we will explain how GPU processing can accelerate analytical workloads using advanced data structures and recursion. We will then demo a preview of initial GPU support in MariaDB Server, contributed by Brytlyt, to show how response times can be cut by minutes when querying millions to billions of rows.

Tuesday, April 11
3:00 pm - 3:50 pm
What’s New: MariaDB 10.2 and MaxScale 2.1
Watch Video

In this talk you will learn about the latest features in MariaDB Server and MaxScale.

In MariaDB Server 10.2, we will introduce:

  • SQL additions: window functions, common table expressions, check constraints, and administrative statements
  • Security enhancements, including enforced security options
  • Per user resource limitations and enhanced options for replication environments
  • Multi-trigger support, binary log based rollback, and MyRocks

MariaDB MaxScale 2.1 is the newest release of the next-generation database proxy for the MariaDB and MySQL environment. New features in this release further enhance security, scalability, performance and ease of use of the database environments. 

In this talk you will learn about the following new features of MaxScale 2.1:

  • Security: binlog encryption, SSL, LDAP/GSSAPI, data masking, max row/size limits, and prepared statement/function filtering
  • Scalability: Aurora cluster monitor, multi-master and failover mode for MySQL Monitor, read-write splitting with master pinning
  • Performance: query cache filter, streaming Insert plugin
  • Ease of use: Dynamic configuration of firewall rule, dynamically add or remove servers, listeners, and monitors
First Steps: Getting Started with MariaDB on AWS
Watch Video

In this session, we’ll go over the basics of deploying MariaDB, both a single server as well as a cluster, on Amazon Web Services – including a live demo. In addition, we’ll go over fundamental concepts and best practices to help you successfully deploy and manage MariaDB databases on AWS. We will cover everything from recommended instance types to performance optimizations. Amazon Web Services offers Relational Database Services that make it easy to set up, operate, and scale MariaDB deployments in the cloud. With Amazon RDS, you can deploy scalable MariaDB databases in minutes with cost-efficient and resizable hardware capacity. Amazon RDS frees you up to focus on your application by managing time-consuming database administration tasks including backups, software patching, monitoring, scaling and replication – and makes it easy to upgrade from MySQL, Oracle and other sources to MariaDB.

Lessons Learned: Troubleshooting Replication
Watch Video

Replication is a feature that is easy to set up, allows read-write access on both master and slave, and can easily create complicated deployments, such as circular replication. By default, MariaDB and MySQL replication is asymmetrical, but has a semi-sync replication plugin that supports multi-master slaves. All these features can be implemented quickly; however, there is also huge risk in making the wrong decisions. In this session, I will:

  • Discuss common replication errors and methods which will help to resolve them

  • Use built-in, then command-line tools, because knowledge of how they work is essential for effective troubleshooting

  • Cover the differences between MariaDB and MySQL replication

Technical Overview: How to Query Geospatial Data
Watch Video

Storing geospatial data in databases is becoming more and more popular, and there are several reasons for this trend. The most prominent reason is the increased use of mobile smartphones, which tracks location using built-in GPS features. As a result, using location data is much more convenient, and is creating many new use cases for GIS technologies. In this talk, we will look at some of the existing and new features of managing GIS data in MariaDB. Some topics we will discuss include the GIS datatypes available in MariaDB, how to index them, and how to search for GIS data.

4:00 pm - 4:50 pm
Overview: What Storage Engine to Use and When
Watch Video

Choosing the right storage engine has an impact on your business. This talk will list all common storage engines which are in production for many years, those innovative new and experimental storage engines.

Technical Collaboration: Extreme Performance with Intel
Watch Video

The goal of this presentation is to inform MariaDB users about the potential for reducing total cost of ownership (TCO) by enjoying enhanced performance with Intel support. Our presentation will be structured into three parts:

  • An overview of the Intel group working with MariaDB.

  • A description of the technical collaboration with MariaDB and how well it runs on Intel Xeon processors.

  • Swarm64 will present their cloud solution based on various Intel products (e.g., FPGA, SSD) with MariaDB. Swarm64 will be used as the model “use case” or success story of a solution provider using Intel technologies with MariaDB.
Getting It Right: How to Scale in Distributed Environments
Watch Video
Max Mether

Speaker

Max Mether
MariaDB
Head of Server Product Management
Technical Overview: Using Common Table Expressions
Watch Video

MariaDB 10.2 introduces support for common table expressions (CTEs). This talk will provide everything you need to know about CTEs.

The first part is about non-recursive CTEs. We will present:

  • A description of SQL syntax for non-recursive CTEs
  • Real-world use cases for non-recursive CTEs
  • Query optimizations that are applicable for these kinds of CTEs
  • MariaDB's query optimizations, and how they compare to PostgreSQL and MySQL
  • A closely related new optimization in MariaDB 10.2 called Condition Pushdown into CTEs

The second part of the talk is about recursive CTEs. Following the same pattern, we will present:

  • An introduction to recursive CTEs
  • Use cases: computation of transitive closures and paths
  • How MariaDB knows when to stop the recursion, and how loops are handled in each of the use cases
  • A comparison of MariaDB with MySQL 8.0, SQL Server and PostgreSQL
  • MariaDB's extra features for recursive CTEs
General Introduction: Analytics with ColumnStore
Watch Video

MariaDB ColumnStore is a columnar storage engine in the MariaDB ecosystem for analytics use cases. In this session we will look at the architecture and capabilities of MariaDB ColumnStore. Specifically, we will talk about how to do analytics using MariaDB ColumnStore, what MariaDB ColumnStore 1.0 offers and what are we planning for MariaDB ColumnStore 1.1.

Wednesday, April 12
9:00 am - 9:50 am
Technical Introduction: Say Hello to MyRocks
Watch Video

MyRocks is a new storage engine developed by Facebook, providing a breakthrough in compression and storage efficiency. And now, it is coming to MariaDB!

This talk has two parts: Part one is about MyRocks itself. We will describe MyRocks architecture and how it allows us to achieve better compression and higher storage efficiency. We will also present benchmark results confirming these improvements.

Part two is about MyRocks in MariaDB. We will describe how MyRocks works with MariaDB's features, and also cover household items like packaging, running MyRocks together with other storage engines, and identifying limitations.

 

Migration: Moving Off Oracle Enterprise and Into the Cloud
Watch Video

Are you trapped by high-cost closed-source legacy databases? Do people tell you that upgrading to MariaDB is too hard? Learn how to break free using tools and techniques from Amazon Web Services and others to upgrade Oracle Database and other high-cost databases to scalable, managed open source solutions. Got 10,000 lines of PL/SQL? Applications with obscure connection code? Complex schemas? No problem!

Real World: Scalability and High Availability at Bandwidth
Watch Video
Technical Overview: How to Use Window Functions
Watch Video

With a focus on practical applications, this talk will give a full introduction to window functions, an important tool for analytical queries. Window functions act as regular functions but have access to more than one row during computation. This makes them highly useful for optimizing queries involving self-joins, as well as queries that need to extract data from multiple related rows from the same table. The performance speedups obtained are sometimes hundredfold, especially for analytical use cases. We will cover syntax, supported functions, use cases and performance. We will also see how MariaDB compares feature wise to other database solutions.

Real World: ColumnStore Use Cases and Customer Examples
Watch Video

Want to leverage big data analytics to transform your business? MariaDB ColumnStore, a powerful open source columnar storage engine, delivers high performance at scale, enterprise-level analytics, and reduces costs with better price performance. MariaDB ColumnStore has been deployed in various industries, including healthcare and high-tech, to provide deep analytical insights that drive business growth and change. In this session, we will showcase real-world big data analytics use cases from various industries.

10:00 am - 10:50 am
Real World: Deploying MyRocks in Production at Facebook
Watch Video

In this session, I'll discuss how we migrated from InnoDB to MyRocks in production at Facebook, for both slave and master instances, without stopping services, losing data, or returning incorrect results. We created many features for easier migration, such as fast data loading, and a tool that confirms data and query correctness, and runs without affecting online service. I will share lessons learned from our initial migrations and the impact we have seen.

First Steps: Solutions and Templates, Azure Deployments
Watch Video

This session will provide an overview of MariaDB solutions available in the Azure Marketplace today. This includes a standalone deployment, a full cluster deployment with the MariaDB Enterprise Cluster + MaxScale template and the MariaDB “Test Drive”. In addition to a demo, we’ll cover basic Azure concepts, helpful to anyone who has used AWS or Google Cloud.

Overview: Properly Securing Production Deployments
Watch Video

Today’s IT infrastructure is vulnerable to a range of attacks and threats. How do you safeguard your database against them? By learning and using best practices, and choosing a database with robust security tools built in. We will discuss both securely deploying MariaDB Server alone and with MariaDB MaxScale.

Technical Overview: How to Best Use Dynamic Columns
Watch Video
Max Mether

Speaker

Max Mether
MariaDB
Head of Server Product Management
Deep Dive: How Data Is Stored and Queried with ColumnStore
Watch Video

MariaDB ColumnStore works a little differently than traditional storage engines so that it can perform well with OLAP workloads. In this session we will cover how MariaDB ColumnStore organizes data in disk, how multi-node configurations work and the steps involved to process a query and return data. This will give you the tools you need to optimize your data and queries for use with ColumnStore as well as set up the right hardware for your workloads.

 

11:10 am - 12:00 pm
Deep Dive: Supporting Distributed Data with Spider
Watch Video

When your database is growing to big data capacity, you need to consider other techniques to manage your data, including database sharding. Spider is a MariaDB Server storage engine plugin for database sharding that allows you to access your data efficiently across multiple database backends. During this talk we will introduce:

  • An overview of Spider, including its architecture, features roadmap and use cases

  • How to get started with Spider

  • A multi-dimensional sharding technique with the Vertical Partitioning (VP) storage engine
First Steps: Deploying and Scaling Clusters on Containers
Watch Video

Containers are great ephemeral vessels for your applications. But what about the data that drives your business? It must survive containers coming and going, maintain its availability and reliability, and grow when you need it. Alvin Richards does some live coding to show key strategies to help you survive the transition to production.

Alvin Richards

Speaker

Alvin Richards
MariaDB
Director of Global Field Technical Services
Migration: Replacing Oracle Database at DBS Bank
Watch Video

With the new features of MariaDB 10.2, migrating existing Oracle-based applications has become much easier and thus economically advantageous. We present some of our best practices and introduce the Migration Practice of MariaDB.

Speaker

Madan Sugumar
DBS Bank
VP of Architecture, Engineering & Innovation
Technical Preview: Temporal Querying with AsOf
Watch Video

MariaDB introduces SQL support for time-related information (ISO 32N2439) which makes it possible to query past states of database records. This talk discusses:
 

  • Use cases for SQL system versioning

  • SQL examples (how to enable system versioning for a table, how to query previous states of records and so on)

  • Design considerations and limitations

  • The implementation internals and how InnoDB transactions handling was adjusted

  • Further development of the feature
First Steps: How to Get Data Into ColumnStore
Watch Video

To be able to work with MariaDB ColumnStore, or with any other database, we need to get some data in it first. As ColumnStore is built on MariaDB, it may be presumed that loading data into ColumnStore is no different than with MariaDB. While this is possible, it is not the most efficient way. MariaDB ColumnStore is a column-based distributed database system, and while LOAD DATA INFILE and standard INSERT, UPDATE and DELETE statements work, there are faster and better ways to load data into ColumnStore. This talk will discuss how and from where to retrieve data, and will showcase examples, guidelines and demos for data loading with MariaDB ColumnStore.

1:10 pm - 2:00 pm
Deep Dive: Adding Replication and Scaling with Galera
Watch Video

Data inconsistency is the worst problem that can happen for a synchronous database cluster. At some point it will appear during replication processing, simply because the application of replication events is not possible in some cluster nodes due to missing rows, excessive rows or wrong values in the row columns. As a result, this usually stops the replication process altogether or, at the least, the failing node must drop out from the cluster. Sorting out the reason for the cluster inconsistency can be problematic because the inconsistency may have occurred without leaving any signs in the system. Therefore, it may also be difficult to determine which cluster node has the trusted data contents.

Recovering from data inconsistency usually requires full database state transfers across the cluster nodes. Galera Cluster 3 has a strict inconsistency policy: all transaction replication errors cause emergency abort for all nodes detecting the inconsistency – a rather aggressive strategy that can lead to full cluster crash. Galera Cluster 4 has a more sophisticated inconsistency strategy where the cluster runs an inconsistency voting protocol and optimizes the way the cluster reacts to the detected inconsistency. This presentation will describe:

  • The various reasons that cause data inconsistency in a cluster

  • Possible ways to deal with them

  • How to recover a cluster after data inconsistency

  • Galera Cluster’s built-in support for continuous consistency checking, helping to harden the cluster against potential threats for data inconsistency

  • The difference in data inconsistency strategies between Galera 3 and Galera 4 clusters

Lessons Learned: Running Database Services on DC/OS
Watch Video

Deploying MariaDB on DC/OS requires just a few clicks, but once the service is running, you may have a few questions, such as:

  • "What" is actually running?
  • How is data persistence and consistency handled?
  • How does the DC/OS architecture affect database performance?
  • What do containers have to do with all this?

The goal of this session is to help answer the questions that may arise after deploying your first database on DC/OS. We will share some of the thought processes and lessons learned from a real-world use case, provide the background of how DC/OS operates, and identify key items that need to be considered when deploying database services.

Best Practices: Performance Tuning, Optimization and Tools
Watch Video

Performance tuning and subsequent optimization is an important way to save money and time in the company. In this talk, the basic tools for DBAs and developers are presented in order to achieve this goal.

Migration: How Huatai Securities Replaced Oracle Database
Watch Video

Huatai Securities is one of the leading comprehensive securities groups in China, with brokerage and investment services for a broad customer base that is supported by the most stockbrokers in China. The company also maintains a leading internet platform to support the company’s extensive transactions in the stock exchange field. In 2015, the company replaced Oracle with MariaDB in its production environment, and is now the biggest user of MariaDB in China’s financial sector.

This talk is aimed at:

  • Providing an overview of how Huatai uses open source

  • Discussing reasons to migrate from Oracle to MariaDB, including security, fees, and reliability

  • Sharing the benefits of making the switch, including disaster recovery technology to ensure data security and integrity

Jian Fan

Speaker

Dr. Jian Fan
Huatai Securities
Director of Platform Architecture
Wenqi Guan

Speaker

Wenqi Guan
Huatai Securities
System Architect
Real World: Visual Analysis of Health Data at UW IHME
Watch Video

The University of Washington’s Institute for Health Metrics and Evaluation (IHME) supports multiple research teams who contribute research and data towards the comprehensive Global Burden of Disease Study. As the volume of data rapidly grows throughout the tenure of the study, IHME has looked to various database platforms to meet their growing needs. Initially choosing Percona Enterprise Server 5.6, significant time and resources were invested into performance tuning the database environment to handle the query and data loading traffic from their 16,000 CPU-core high performance computer cluster. While the platform met initial needs, issues developed in being able to handle the increased volume of data and IHME needed to find a more reliable and flexible solution.

This talk will describe our journey to MariaDB, and will focus on:

  • Our initial needs and architecture demands

  • The growing pains and challenges

  • The ColumnStore solution
Andrew Ernst

Speaker

Andrew Ernst
University of Washington IHME
Assistant Director of Infrastructure
2:10 pm - 3:00 pm
Deep Dive: The Nuts and Bolts in MaxScale, a DB Proxy
Watch Video

MaxScale is MariaDB's database proxy for managing security, scalability and high availability.

In this session we will start by providing an overview of MaxScale's extendable architecture and an introduction to its functionality. We will also briefly cover how MaxScale can be extended with new functionality.

Thereafter we will look more closely at some particular use-cases and round the session up with a hands-on demonstration.

Step-By-Step: Clustering with Galera and Docker Swarm
Watch Video

Clustering is an important feature in container technology, as multiple nodes are required to provide redundancy and failover in case of outage. Docker Swarm is an orchestration tool that allows administrators to manage a cluster of Docker nodes as one single virtual system. MariaDB Cluster, however, has its own clustering model based on Galera.

How do you get the two to work together? Container orchestration tools like Docker Engine swarm mode and Kubernetes are not aware of the redundancy model of MariaDB Cluster and presumes containers are independent from each other. It is possible, however, to make Swarm aware of Galera’s model by extending Galera on-container startup logic to bring MariaDB up to the correct state before serving any data.

In this talk, we’ll look at how to deploy MariaDB Cluster on Docker Swarm with a multi-host environment, by “homogeneousing” the MariaDB image to achieve high availability and scalability in a fully automated way. We will touch upon service controls, multi-host networking, persistent storage, scaling, fault tolerance, service discovery, and load distribution.

Best Practices: Continuous Deployment at Telefónica
Watch Video

Telefónica is a global telecommunications company based in Spain. Tim Cheung is part of the U.K. division O2, which is the primary sponsor of the widely recognized O2 Arena in Greenwich Peninsula, London, host to the 2012 Summer Olympics.

Within O2, Tim works on the Wi-Fi team providing free Wi-Fi service to end users across the U.K. O2 has approximately 14,000 hotspots and 23 million registered users to date. Of those registered users, 2.5 million use the service daily. In this day and age these numbers aren’t astronomical, but they do present challenges in the way O2 operates. This talk will present some first-hand insight into the following:

  • How many times a day/week/month should you deploy to your production environment?
  • How to manage customer demand for delivery of products and services in increasingly shorter timeframes.
  • Is the production environment governed by a strict change management process?
  • How can you safely and reliably push implemented changes without service disruption?
Real World: How Alibaba Collaborates with MariaDB
Watch Video

Alibaba and MariaDB have a long-standing relationship around MariaDB Server and work closely together to enhance product features for both organizations. AliSQL is a cloud-friendly MySQL branch, which enables this collaborative relationship. In the past, we have worked together on sequence, design and code, multi-source replication, flashback and more. Today, MariaDB is merging AliSQL’s patches, with a plan to include more AliSQL features in the future. Join us in exploring this relationship and learning more about Alibaba and MariaDB.

Community: MariaDB Adoption in Linux and Dev Environments
Watch Video

Linux, Apache, MySQL and PHP used to be the most widely used web application stacks. As technology evolves, this is no longer the case. For the M part, MariaDB has replaced MySQL in numerous Linux distributions and development environments, and is becoming the new M in most production environments as well. This talk presents how the landscape looks today, and why and how web developers are migrating to MariaDB around the globe.

3:20 pm - 4:10 pm
Integration: Streaming Changes to Kafka in Real Time
Watch Video

MariaDB MaxScale offers a modular solution to stream binlog events from a master database to a data lake with the help of Apache Kafka, a distributed message broker. The solution consists of a binlog event replicator (binlogrouter), a binlog to Avro translator (avrorouter) and a client request interface (CDC).

The presentation describes the key components of the Change Data Capture solution, how each of the parts interact and how the data is stored in Avro format inside MaxScale. It also explains how the CDC data streaming service can be with other systems for further processing and in-depth analysis.

The final part of the presentation takes a short tour of the ready solutions provided with MariaDB MaxScale 2.0: in the example setup MariaDB MaxScale will act as the producer for a Kafka broker while big data platforms or analytics databases will be the consumer applications, consuming the data through the broker.

Overview: Implementing and Managing DBaaS at Tencent
Watch Video

Tencent is a very successful internet social networking company with several products including, QQ, WeChat and more, as well as China’s leading cloud service provider. In Tencent Cloud, a public cloud platform, DBaaS is critical as our Cloud has tens of thousands enterprise users to date. This presentation will focus on:

  • The multi-role design concept of Tencent DBaaS

  • How to solve challenges encountered by architects and DBA users

  • How to implement a database service that is easy to manage, reliable, available and high performing
Getting It Right: Online Schema Migration with gh-ost
Watch Video

MariaDB supports online alter for many types of changes; however, some alters still require a table copy, and an online schema change tool is desired. The GitHub online schema change transmogrifer, gh-ost, is a new tool that I have already had the pleasure of using in production environments successfully. I will present a use case for running the tool in a complex multi-source, multi-slave replication topology to make changes unsupported by the native MariaDB online alter. This presentation will include a demonstration of the operational tools within gh-ost to throttle or view the status of the running alter process.

Development: Building Microservices with MariaDB
Watch Video

You have architected and written the RPC mechanism, service discovery, and deployment of your microservice, but what about the database behind your microservice? In this technical session we will cover orchestration and deployment of your database’s service, high availability, scale-out, and schema impact along with other key considerations for making your service deployments with MariaDB successful. Worked code examples will be used to show how this can be achieved and should act as a launch pad for your future deployments.

Alvin Richards

Speaker

Alvin Richards
MariaDB
Director of Global Field Technical Services
4:20 pm - 4:45 pm
Open Source in a Dangerous World
Watch Video

Everyone agrees open source is driving the innovation for next-generation infrastructure, applications and digital experiences. But as with any technological movement, not all open source is created equal, and nearly every vendor is claiming some flavor of “open”. Add to this the fragmented markets around containers, cloud and analytics, and it’s hard to know where to place your bets and avoid expensive pitfalls. On top of that, it’s not practical to just rip out all your legacy infrastructure and apps and magically convert them to agile, open source environments. Red Hat's Director of Product Management, Gunnar Hellekson, discusses how you can leverage the amazing innovation coming out of open source communities while still plotting a journey with secure, stable, supported open source platforms. Hellekson will share customer use cases and examples of organizations using open source to not just innovate but add competitive advantage.

Gunnar Hellekson, Director of Product Management, Red Hat

4:45 pm - 5:30 pm
Keynote Session: Everything Old Is New: the Return of Relational
Watch Video

Hadoop and NoSQL have been the open source heralds of a changing the database landscape that is no longer locked into Oracle, IBM or Microsoft. And while NoSQL may work for a subset of use cases, no matter how fast they try to adapt to a SQL based world, they are decades away. Meanwhile, open source relational database are delivering capabilities for NoSQL use cases at a rapid pace. Join this fireside chat with Monty Widenius to hear how MariaDB is quickly becoming the world’s open source database choice. This session will include audience Q&A so everyone has a chance to get their questions answered.

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 customers

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