Main navigation

Speakers

Guest Speakers

Alexander Krizhanovsky

CEO

NatSys Lab

Alexander is CEO at Tempesta Technologies, Inc., and is lead developer of Tempesta FW, a Linux application delivery controller. He's also founder and CEO of NatSys Lab, a company providing consultancy and custom software development in high performance network traffic processing and databases. Alexander was responsible for the design and performance of several products in the areas of network traffic processing and databases. He designed the core architecture of WAF, mentioned in the Gartner Magic Quadrant.

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

Andrew Ernst

Assistant Director of Infrastructure

University of Washington IHME

Andrew is the Assistant Director of Infrastructure at the Institute for Health Metrics and Evaluation (IHME), an independent global health research center at the University of Washington (UW) in Seattle. In 2011, Andrew joined IHME after working with UW Medicine, UW Bioengineering, and The Seattle Times in a variety of Linux, Oracle and MySQL-related positions. Andrew leads the team at IHME responsible for designing, implementing and managing the environment used to generate, store, and disseminate the Global Burden of Disease (GBD) findings.

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

Ashraf Sharif

Senior Support Engineer

Severalnines

Ashraf Sharif is Senior Support Engineer at Severalnines. He was previously involved in hosting world and LAMP stack, where he worked as principal consultant and head of support team and delivered clustering solutions for large websites in the South East Asia region. His professional interests are on system scalability and high availability.

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.

Bin Cheng

Software Engineer

Tencent

Cheng Bin is the Cloud Database Team Leader at Tencent Technology and Engineering Group. He has almost 10 years of experience in Internet. He is an expert in mass storage technology and database technology. He and his team are responsible for the development and operation of the cloud database platform on Tencent Cloud. Tencent Cloud is China's leading cloud computing service provider.

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

Darin Briskman

Technical Evangelist & Developer Outreach

Amazon

Darin Briskman leads Developer Outreach for Amazon Web Services Database offerings, connecting developers with the AWS engineering team and helping technical professionals worldwide get the greatest benefit from Amazon ElastiCache, Elasticsearch and other database services. He joined Amazon in 2016 after 30 years of experience in Enterprise Technologies, including work at NASA, IBM and Silicon Valley startups. Darin studied Physics at the Georgia Institute of Technology and the Technical Institute of Tel Aviv.

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.

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!

Dr. Jian Fan

Director of Platform Architecture

Huatai Securities

Dr. Fan Jian graduated from Shanghai University with a major in Computer Applications. He is an expert in cloud computing and big data, and was granted the Prize for Progress of Science and Technology of Shanghai. Dr. Fan has published numerous papers, 15 indexed by SCI/EI/ISTP. He has published a book, and currently has 20 patent applications pending. Dr. Fan joined Huatai Securities Co., Ltd. in April, 2015 as the Director of Platform Architecture and is responsible for the company's overall platform architecture planning, research and development work.

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

Elmar Eperiesi-Beck

CEO

eperi GmbH

Elmar Eperiesi-Beck is founder and CEO of eperi GmbH, a leading provider of Cloud Data Security (CDP) solutions. With its experienced team and powerful partners such as MariaDB, IBM, Microsoft, Salesforce, SAP or T-Systems, eperi provides solutions for several hundred international customers that need to reliably encrypt databases and information in the cloud or on premise. Eperiesi-Beck started his career as Principal at IBM Deutschland GmbH, managing major international projects dealing with SAP, e-Business and Security, and was later responsible for building up e-Business startup Mareon AG as a Senior Project Manager before he founded eperi in 2003.

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.

Gabriel Ciciliani

Internal Principal Consultant

Pythian

Gabriel has been dedicated to databases as a DBA and consultant for the last 10 years. He has lead and participated in multiple projects across many technologies, including Oracle, MySQL, SQL Server and MongoDB. Gabriel defines himself as an automation super fan, he is one of the developers of the MySQL/MongoDB DBaaS solution currently in use in MercadoLibre, the largest e-commerce platform in Latin America and top ten world wide.

Gabriel holds a college degree in electronics, a degree in industrial engineering and he is currently studying for his masters in systems information engineering. He is also an Oracle and Microsoft certified professional. Currently he is an Internal Principal Consultant at Pythian specializing in MySQL and MongoDB.

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.

Prior to joining Red Hat, he worked as a developer, systems administrator, and IT director for a number of Internet businesses. He has also been a business and IT consultant to not-for-profit organizations in New York City. During that time, he spearheaded the reform of safety regulations for New York State’s electrical utilities through the Jodie Lane Project.

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.

Karsten Ronner

CEO

Swarm64

Karsten is CEO of Swarm64, the developers of Swarm64DB, a storage engine plus FPGA-based accelerator plug-in for MariaDB and other databases. Swarm64DB empowers MariaDB to ingest 10 times higher data rates than in native mode and to process those huge data streams in real-time. Thereby, MariaDB becomes capable of handling vast IoT networks and other applications that create floods of data and require those to be analysed and acted upon instantly. Karsten has co-founded and invested in numerous start-ups with several successful exits to date.

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.

Kayoko Goto

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

Kentoku Shiba

CEO

Spiral Arms

Kentoku Shiba created and continues to improve the Spider Storage Engine for database sharding. He also developed the Vertical Partitioning Storage Engine for column base table partitioning. He is a developer of the Mroonga Storage Engine for fast full-text searching especially for CJK languages.

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

Lixun Peng

Staff Database Engineer

Alibaba

Lixun has an in-depth knowledge of MySQL and MariaDB, fixing bugs for Alibaba in the MySQL codebase and contributing Multi-Source Replication and Thread Memory Monitor to MariaDB 10.0. He has also translated "High Performance MySQL, 3rd Edition" to Chinese and is currently working on a book on maintaining MySQL in a production environment.

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.

Madan Sugumar

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.

Mikhail Sinyavin

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.

Ms Joan Tay Kim Choo

Executive Director of Technology & Operations

DBS

Possessing 18 years of industry experience in Banking and HR with previous experiences in Standard Chartered, Joan graduated from the University of Queensland with Bachelor of Commerce. She is an advocate for DBS 'Be Datasmart' initiative and is an aspirational role model for women in technology.

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.

Rino Cavallucci

Strategic Relationship Manager

Intel

Rino joined Intel 1999 and acquired solid work experience during the past 18 years in various positions and business groups. Creating and maintaining technical and business collaborations with software developers (ISV) to ensure their products would run best on Intel latest platforms and Technologies, was always his main objective. Gennaro is currently based in Munich/Germany. He holds a diploma as industrial engineer in computer science.

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.

Seppo Jaakola

CEO

Galera Cluster

Seppo Jaakola has over 20 years experience in software engineering. He started his professional career in Digisoft and Novo Group Oy working as a software engineer in various technical projects. He then worked for 10 years in Stonesoft Oy as a Project Manager in projects dealing with DBMS development, data security and firewall clustering. In 2003, Seppo Jaakola joined Continuent Oy, where he worked as team leader for MySQL clustering product. This position linked together his earlier experience in DBMS research and distributed computing. Now he’s applying his years of experience and administrative skills to steer Codership to a right course. Seppo Jaakola has MSc degree in Software Engineering from Helsinki University of Technology.

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

Shree Nair

Product Manager

Webyog

Shree is Product Manager at Webyog, Inc. He is responsible for driving global product development, marketing & sales for Webyog’s MySQL tools - SQLyog & Monyog. Previously he has worked with a power company in New Zealand and further helped other businesses in the USA with global expansion.

Shree studied MBA in General Management at Coventry University, England.

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.

Sveta Smirnova

Principal Technical Services Engineer

Percona

Sveta Smirnova works as MySQL Support engineer since year 2006, she is also author of book "MySQL Troubleshooting" and author of JSON UDF functions for MySQL. In years 2006 - 2015 she worked in in Bugs Analysis MySQL Support Group in MySQL AB, then Sun, then Oracle. In March 2015 Sveta joined Support Team in Percona. In years 2012-2015 she worked on bugs priority in Oracle, in year 2016 she restarted this role at Percona. She was also Support representative in MySQL Backup Development Team. She works on tricky support issues and MySQL software bugs on a daily basis. Before starting at MySQL in 2006, she worked as web developer on several closed CRM systems. In years 2012-2015 she worked on MySQL Labs project "JSON UDFs for MySQL". She is active participant in the open source community. Her main interests in recent years is solving DBA problems, finding ways to semi-automate this process and effective backup techniques.

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

Tim Cheung

Head of DevOps

Telefónica

Tim is an Infrastructure Engineer at Telefonica UK (O2), a Swiss army knife. He leads the Wi-Fi DevOps team and is responsible for the core Wi-Fi infrastructure. Tim’s goal is to improve efficiency and reliability of the service by automating everything, including himself.

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?

Valerie Parham-Thompson

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.

Vishal Jaiswal

Manager, Data Services

Bandwidth

Vishal Jaiswal is leading the Data Services team at Bandwidth. He has more than a decade of experience in database technologies, designing & implementing scalable back-end database architecture in high volume OLTP & Data warehouse environments. His team is responsible for managing & architecting back-end database infrastructure at Bandwidth.

Wenqi Guan

System Architect

Huatai Securities

Wenqi Guan graduated from Hohai University with a major in Computer Science and Application. He has over 10 years of experience as an Oracle and MariaDB DBA, and has published many papers in the field of databases. He joined Huatai Securities Co., Ltd. in April, 2015 as the System Architect and is responsible for the company's database platform architecture planning, research and development work.

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

Yoshinori Matsunobu

Database Engineer

Facebook

Yoshinori Matsunobu is a Production Engineer at Facebook, and is leading MyRocks project and deployment. Yoshinori has been around MySQL community for over 10 years. He was a senior consultant at MySQL Inc since 2006 to 2010. Yoshinori created a couple of useful open source product/tools, including MHA (automated MySQL master failover tool) and quickstack.

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.

MariaDB Speakers

Alexander Bienemann

Migration Practice Manager

MariaDB

Dr. Alexander Bienemann is working as a consultant and expert in relational database systems. Over the years he has been conducting complex migration projects as database architect and as project manager. At the MariaDB Corporation he is leading the Migration Practice, which is supporting customers with migrating their existing legacy applications to MariaDB.

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.

Alvin Richards

Field CTO

MariaDB

Alvin Richards is the field CTO at MariaDB, the leading high-performance open source relational database, where he connects the dots between practitioners and innovators and MariaDB’s products. In prior lives, Alvin was vice president of product at Aerospike; ran engineering teams at Docker and MongoDB, leading the revolution of microservices and NoSQL; was technical director at NetApp, working to integrate databases and virtual infrastructures with storage; and worked at Oracle on data warehousing products.

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.

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.

Amy Krishnamohan

Director of Product Marketing

MariaDB

Amy is Director of Product Marketing at MariaDB. She has diverse experience across product marketing, marketing strategy and product management from enterprise software companies such as Teradata, SAP, Accenture, Cisco and Intuit. Amy holds a master’s degree in software management from Carnegie Mellon University.

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.

Anders Karlsson

Principal Sales Engineer

MariaDB

After some 15 years with commercial databases as consultant, Sales Engineer and in many other roles, I joined MySQL in 2004 to work as a Sales Engineer. In 2010 I decided I needed some more technical experience, so I join Recorded Future as database Architect. After 2 years with that, I realized I missed the close customer contacts and decided to join SkySQL, again as Sales Engineer. In 2014 SkySQL completed the merged with Monty Program, creating MariaDB Corp, which is where I now work as a Principal Sales Engineer.

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.

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.

Andrew Hutchings

Senior Software Engineer

MariaDB

Andrew Hutchings (aka LinuxJedi) works for MariaDB Corporation as a Senior Software Engineer on the ColumnStore project. He is physically based in the middle of nowhere in the United Kingdom but works with a global team. Before joining MariaDB he worked for NGINX, HP, SkySQL, Rackspace, Oracle and Sun specialising in the development and improvement of Open Source software. He is also a co-author of the book MySQL 5.1 Plugins Development.

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.

Bjorge Staijen

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.

David Thompson

VP Engineering, North America

MariaDB

David is VP Engineering, North America for MariaDB. David brings a diverse experience in development both building and scaling out data driven applications. David started his career with Oracle and subsequently built out data archiving solutions at OuterBay which was acquired by HP. David gained experience in scaling out transactional database applications at Deem and then a big data sales analytics application at C9 which was acquired by InsideSales.com.

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.

Dipti Joshi

Director of Product Management

MariaDB

Dipti Joshi is Senior Product Manager at MariaDB Corporation. She is responsible for MariaDB MaxScale and MariaDB ColumnStore. Before joining MariaDB Corporation in 2014, Joshi spent 2 years leading big data and analytics product at InfiniDB - a columnar Big Data storage engine for MySQL. She started her career building traditional OLTP database applications, then transitioned to building core telecommunication software, and found her self building very large distributed OLAP databases and applications with MySQL, Oracle, purpose built databases and columnar databases.

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.

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.

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:

Igor Babaev

Principal Software Engineer

MariaDB

Igor Babaev is a developer at MariaDB focusing mainly on optimizer related features. He developed the code that supported hash join, extended keys, engine-independent table statistics. He was core developer to add common table expressions.

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

Jens Bollmann

Principal Instructor/Consultant

MariaDB

Jens Bollmann is a consultant and trainer at MariaDB Corporation, delivering advanced classes. For more than 10 years, he has been optimizing MariaDB and MySQL installations, providing performance tuning consulting, making recommendations on the architecture of database servers, and high availability configurations.

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.

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.

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.

Johan Wikman

Lead Developer

MariaDB

Johan is a MaxScale developer at MariaDB, where he has now been for a year and a half. Prior to joining MariaDB, Johan worked at Nokia for many years, all over the software stack; from the Linux kernel below to end-user applications on the top. During the last years at Nokia he worked on a in-house multi-master document database.

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.

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.

Jonathan Day

Senior Solutions Engineer

MariaDB

Jon has worked for MariaDB since 2012 as Senior Sales Engineer. His IT career began over 25 years ago having various roles as a System Programmer, Systems Admin, Programmer Consultant, and Product Manager. He most recently worked several years as a Solution Architect at both IBM and Netezza where he specialized in the areas of Security, Security Monitoring, Auditing, and Compliance.

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.

Kolbe Kegel

Technical Lead

MariaDB

Kolbe Kegel is the MariaDB Enterprise Tech Lead at MariaDB Corporation. Kolbe has worked with MySQL since 2005, first at MySQL, later at Sun Microsystems after its acquisition of MySQL Inc., then at Oracle after its acquisition of Sun.

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.

Markus Mäkelä

Software Engineer

MariaDB

Markus Mäkelä is a software engineer working on MariaDB MaxScale. His first contribution to MaxScale was the `mqfilter` RabbitMQ filter module. Other modules authored or co-authored by Markus are the `schemarouter` sharding router, the `dbfwfilter` firewall module and the `insertstream` data streaming module. When Markus is not working on MaxScale, he enjoys working on robotics and artifical intelligence.

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.

Massimiliano Pinto

Senior Software Solutions Engineer

MariaDB

Massimiliano is a Senior Software Solutions Engineer mainly working on MaxScale which he has been contributing to since its very first day. Massimiliano has worked for almost 15 years in Web Companies playing the roles of Technical Leader and Software Engineer. Prior to joining MariaDB he worked at Banzai Group and Matrix S.p.A, big players in the Italy Web Industry, leading custom solutions with Apache modules and PHP extensions.

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.

Max Mether

VP Professional Services

MariaDB

Max Mether joined MySQL AB in 2001 as a consultant and instructor. He created the MySQL training program and managed the curriculum under MySQL AB, and later at Sun Microsystems. A MariaDB co-founder, Max now manages the professional services department, and helps advance the MariaDB ecosystem. He is a frequent speaker at LinuxFests and other conferences around the globe. Max is a native of Finland and earned a M.Sc. (Eng.) in physics and mathematics from Helsinki University of Technology.

Michael "Monty" Widenius

Chief Technology Officer

MariaDB

Monty is the “spiritual father” of MariaDB, a renowned advocate of the open source software movement, and one of the original developers of MySQL, the predecessor to MariaDB. Monty continues to stay involved hands-on in the development of MariaDB. His work in developing and advocating for Free and Open Source Software spans to 1995. Most recently, Monty has served on the boards of MariaDB Corporation and the MariaDB Foundation, the non-profit organization charged with promoting, protecting and advancing the MariaDB codebase, community, and ecosystem, where he was also CTO. He was a founder of SkySQL, and the CTO of MySQL AB until its sale to Sun Microsystems (now Oracle). Monty was also the founder of TCX DataKonsult AB (a Swedish data warehousing company). He is the co-author of the MySQL Reference Manual, was awarded in 2003 the Finnish Software Entrepreneur of The Year prize and in 2015 Monty was selected as one of the 100 most influential persons in the Finnish IT market. Monty studied at the Helsinki University of Technology and lives in Finland.

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.

Michael Howard

Chief Executive Officer

MariaDB

Michael Howard brings decades of leadership in the enterprise software, data management, and big data industries. Most recently, Michael was CEO at C9, which he transformed into one of the leading predictive analytics companies in the CRM space and led through its acquisition by Inside Sales. Previously, Michael was CMO at Greenplum (now Pivotal), the Big Data division of EMC. He was CEO at Ingrian Networks and Outerbay, and VP of the Internet Division at Veritas and of Data Warehousing at Oracle, where he led the acquisitions of Thinking Machines, OneMeaning, and Carleton Corporation. Michael has served on the boards of Acunu and FireEye, and keynoted at a variety of conferences, including EMC World, Oracle Open World, Green Data Center Conference, Data Science Series, and many others. Michael studied Computer Science and Slavic Languages and Literatures at University of California, Berkeley.

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.

Otto Kekäläinen

CEO

MariaDB Foundation

Otto Kekäläinen is the CEO of the MariaDB Foundation, CEO of Seravo Oy and the chairman of the FUUG Foundation. Otto has been using Linux and other open source technologies for over 15 years, and has been advocating open source for almost as long. The list of projects and organizations Otto has been involved in is long, with the most prominent ones being COSS in Finland and FSFE in Europe. As a software developer Otto has insight into the technical side of open source, and as a CEO and entrepreneur he also knows how to use open source in business successfully. Otto likes to share his experiences on how to use open source to its full potential and how the world can keep increasing the benefits of open source software and the its methodologies.

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.

Ralf Gebhardt

Product Manager

MariaDB

Ralf Gebhardt is Product Manager at MariaDB Corporation. He is responsible for MariaDB Server and MariaDB Connectors. He joined MariaDB/SkySQL in 2011 as Principal Sales Engineer.

After 10 years professional experience in Software Development, Support, Training and Consulting, He started working at MySQL GmbH as Sales Engineer in 2002. In the course of the acquisition of Sun Microsystems I joined Oracle, still responsible for MySQL.

He holds a masters degree in Computer Engineering from the University of Cooperative Education (in cooperation with IBM Deutschland).

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:

Roger Bodamer

Chief Product Officer

MariaDB

Roger joined MariaDB in June 2016. He has more than 20 years of experience building and delivering innovative products to market, as well as deep expertise and knowledge of database architectures. Roger holds several patents for database and middleware technology. His experience leading product development and engineering teams include 12 years with Oracle’s Database and Application Server development organization where he pioneered products that delivered heterogeneous interoperability, as well as several years as SVP of product operations and engineering at Apple’s PowerSchool division. Roger served as GM at 10gen (now MongoDB Inc.). He was a founder and CEO at software company UpThere, Inc. Roger also held leadership positions at OuterBay and Efficient Frontier. He earned a Bachelor’s degree in computer science from Saxion Hogescholen in the Netherlands.

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.

Sergei Petrunia

Senior Software Engineer

MariaDB

Sergei Petrunia is a developer at MariaDB specializing in query optimizer and storage engines. He has worked on window functions in MariaDB 10.2, ANALYZE command for statements in MariaDB 10.1, SHOW EXPLAIN in MariaDB 10.0, and numerous other optimizer improvements. Prior to MariaDB, he was a query optimizer/general server developer at MySQL Ab and Sun Microsystems.

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.

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

Stephane Varoqui

Senior Consultant

MariaDB

Stephane is a Senior Consultant at MariaDB. Stephane originally started working at MySQL in 2005, he took co-management of the MySQL European professional services for SUN and Oracle. With a previous experience on software development and support of various embedded databases, Stéphane helped many clients to scale their storage layer from top 100 web sites to the bank industry.

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

Vicențiu Ciorbaru

Software Engineer

MariaDB

Vicențiu Ciorbaru is a Software Engineer at the MariaDB Foundation. His first involvement with MariaDB was to implement SQL Standard Roles. Since then he has been involved in multiple areas, focusing on optimizer related issues. He has taken part in implementing Window Functions for MariaDB, as well as replication related issues. Being part of the MariaDB Foundation, he also helps with making sure MariaDB is adopted by Linux distributions, and that any specific issues present in them with regards to packaging are resolved.

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.