M|19

Speakers

Join the conversation

Guest Speakers

Alexander Aldev

Alexander Aldev

CTO
MammothDB

Alex is CTO at MammothDB, shaping the architecture and development of the flagship distributed database engine product. He has built business systems, BI and data warehousing solutions for companies like DHL, SBB, A1 and Convergys. Having been in business and engineering roles, he often finds himself translating between these two groups to deliver creative solutions.

Sessions
Tuesday, February 27
2:10 pm - 3:00 pm

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.

Alexander Krizhanovsky

Alexander Krizhanovsky

CEO/CTO
Tempesta Technologies, Inc.

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.

Sessions
Monday, February 26
5:00 pm - 5:50 pm

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.

Wednesday, April 12
11:10 am - 12:00 pm

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
Amy Kettlewell

Amy Kettlewell

Database Administrator
TradingScreen
Sessions
Tuesday, February 27
3:30 pm - 4:20 pm

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.

Andrew Ernst

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.

Sessions
Wednesday, April 12
1:10 pm - 2:00 pm

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

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.

Sessions
Wednesday, April 12
2:10 pm - 3:00 pm

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.

Aziz Vahora

Aziz Vahora

Head of Data Management
Pinger

Aziz Vahora is a Silicon Valley-based entrepreneur with a background in data management. He began his career in the IT field in 1997 as a DBA for well-established companies including CafePress, Quotient, and Zuora, and served as Head of Data Management at Pinger in 2016. With an entrepreneurial spirit he founded and leads TrackSubscription.com, an app designed to help people better manage their online subscriptions and bills by keeping track of fixed costs and recurring payments via a simple mobile and web interface. Aziz is bilingual in four languages, including English, Gujrati, Hindu, and Urdu, and holds a bachelor’s degree in computer science from CIC.

Sessions
Tuesday, February 27
10:00 am - 10:50 am

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.

Bill Montgomery

Senior Manager, IT, Software Applications
Red Hat
Sessions
Tuesday, February 27
10:00 am - 10:50 am

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.

Bin Cheng

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.

Sessions
Wednesday, April 12
3:20 pm - 4:10 pm

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
Christian Lees

Christian Lees

Chief Information Security Officer
InfoArmor

As a seasoned Enterprise technologist and security expert, Christian pioneers InfoArmor’s technology and information security systems as CTO and CSO. Throughout his career, he has played an active role in intrusion detection, Distributed Denial of Service (DDoS) mitigation and vulnerability assessment and management. He is adept with the information security forensics process, having acted as a professional witness for various law enforcement agencies. Christian is an avid surfer, and he’s known for skateboarding around the office handing out cookies.

Sessions
Tuesday, February 27
11:00 am - 11:50 am

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
Darin Briskman

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.

Sessions
Tuesday, April 11
3:00 pm - 3:50 pm

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.

Wednesday, April 12
9:00 am - 9:50 am

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!

David_Cohen

David Cohen

Storage Solutions CTO and Senior Principal Engineer, Data Center Solutions Group
Intel

Storage systems are undergoing huge, disruptive change. This change is partly driven by innovation in materials (3D NAND and various post-NAND flash technologies) and partly by high-bandwidth, tightly integrated interconnects. The result over the coming months and years will be to challenge fundamental assumptions about the role of volatile and non-volatile memory in applications, as well as how to support those applications with the right infrastructure. In this talk, David will explain the major trends in storage technology and the key questions that developers and architects should be asking themselves about their solutions if they wish to stay ahead of the pack.

Sessions
Monday, February 26
3:00 pm - 3:50 pm

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.

Dheeraj Golla

Dheeraj Golla

Senior Database Administrator
Copart
Sessions
Tuesday, February 27
1:10 pm - 2:00 pm

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.

Tuesday, February 27
10:00 am - 10:50 am

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.

Jian Fan

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.

Sessions
Wednesday, April 12
1:10 pm - 2:00 pm

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

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.

Sessions
Wednesday, April 12
10:00 am - 10:50 am

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.

Federico Razzoli

Federico Razzoli

DBA
Catawiki

Relational databases lover and open source supporter. I am a MariaDB Community Ambassador and I wrote "Mastering MariaDB" in 2014. Currently I work for Catawiki.

Sessions
Gabriel Ciciliani

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.

Sessions
Wednesday, April 12
1:10 pm - 2:00 pm

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.

Greg Henderson

Greg Henderson

Senior Manager, Architect - Global Business Systems
Ansell Healthcare

Greg Henderson has worked in software development for over 30 years across an absurdly wide swath of technologies, operating systems, databases, programming languages and hardware, knows just enough about networking to be dangerous, thinks Python is the best language ever, and is an admitted software generalist. He has spent most of the last decade managing development of the Ansell Guardian project. Greg would rather be playing tennis or hiking.

Sessions
Monday, February 26
4:00 pm - 4:50 pm

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.

Gunnar Hellekson

Director of Product Management
Red Hat

Gunnar Hellekson is the Director of Product Management for Red Hat’s Linux, Virtualization, and Atomic container product lines. Before that, he was Chief Strategist for Red Hat’s US Public Sector group.  He is a founder of Open Source for America, one of Federal Computer Week's Fed 100 for 2010, and was voted one of the FedScoop 50 for industry leadership. He was a founder of the Military Open Source working group, a member of the SIIA Software Division Board, the Board of Directors for the Public Sector Innovation Group, the Open Technology Fund Advisory Council, New America’s California Civic Innovation Project Advisory Council, and the CivicCommons Board of Advisors. He perks up when people talk about commoditization and the industrial mobilization of World War II. He is also co-host of the Dave and Gunnar Show.

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.

Gunnar’s CV is available in HTMLPDF, and on GitHub.

Sessions
Wednesday, April 12
4:20 pm - 4:45 pm

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

inaam_rana

Inaam Rana

Senior Technical Advisor
Alibaba

Inaam Rana is part of PolarDB team at Alibaba. An active developer of InnoDB since 2007, Inaam had been a part of InnoDB team at Oracle and had also worked as MySQL internal engineer at Twitter. He has been mostly working on the buffer cache layer, low level concurrency, IO subsystem and logging/recovery. Over the years, Inaam has had a chance to contribute to many scalability related features in InnoDB plugin, MySQL-5.5, MySQL-5.6 and WebscaleSQL. Inaam currently lives in Toronto, Canada.

Sessions
Monday, February 26
5:00 pm - 5:50 pm

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.

Ivan Groenewold

Ivan Groenewold

Lead Database Consultant
Pythian

Ivan is a database professional with 10+ years supporting mission-critical environments with a strong sysadmin background. Starting as an Oracle Administrator, he eventually became involved with MySQL and MongoDB as well, having co-developed the DBaaS platform for the biggest e-commerce site of Latin America. He currently works as a Lead MySQL Consultant for Pythian.

Sessions
Tuesday, February 27
2:10 pm - 3:00 pm

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.

Jack Sprague

Jack Sprague

Enterprise Architect
Center for Information Management

Jack Sprague is an Enterprise Architect with expertise in advanced data system solutions. His background includes operational and systems management responsibilities at a Fortune 50 firm and nearly twenty years in various IT capacities within the healthcare industry. Recent projects have included legacy MySql, Hadoop, Neo4j, Mongo, Oracle, and Mariadb products including the new Mariadb AX. Jack currently works for a boutique software firm in Ann Arbor, Michigan specializing in public-sector Medicaid population health management solutions for both states and managed care organizations.

Sessions
Tuesday, February 27
10:00 am - 10:50 am

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.

jianwei

Jianwei Zhao

Senior Database Engineer
Alibaba

Jianwei is an AliSQL kernel developer working at Alibaba, focusing on new feature development such as TDE, Sequence Engine, Add Columns Dynamically, and other enhancements adapted by proxy.

Sessions
Wednesday, April 12
2:10 pm - 3:00 pm

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.

Joan

Joan Tay Kim Choo

Executive Director of Technology
DBS Bank

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.

Sessions
Monday, February 26
1:15 pm - 2:45 pm

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.

Monday, February 26
1:45 pm - 2:15 pm

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.

Karsten Ronner

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.

Sessions
Tuesday, April 11
4:00 pm - 4:50 pm

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

Kayoko Goto

Director of Sales
Spiral Arms
Sessions
Wednesday, April 12
11:10 am - 12:00 pm

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
Kentoku Shiba

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.

Sessions
Wednesday, April 12
11:10 am - 12:00 pm

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
Lixun Peng

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.

Sessions
Wednesday, April 12
2:10 pm - 3:00 pm

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.

Louis Zircher

Louis Zircher

Director, Ansell Guardian® Technology Solutions
Ansell Healthcare

Lou Zircher has worked in the IT space for over 20 years and is responsible for transferring business needs into sustainable IT solutions. For Ansell, Lou leads a global team of Ansell and IT vendors which is responsible for the suite of management tools called Ansell Guardian®. Ansell Guardian® is focused on improving Safety, Productivity and Business Performance of Ansell’s Customers.

Sessions
Monday, February 26
4:00 pm - 4:50 pm

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.

Madan Sugumar

VP of Architecture, Engineering & Innovation
DBS Bank
Sessions
Wednesday, April 12
11:10 am - 12:00 pm

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.

Maxime Fouilleul

Maxime Fouilleul

Lead Database Architect
BlaBlaCar

I’m Max and I work at BlaBlaCar as Lead Database Engineer in the foundations team. With my team, I am responsible for the data infrastructure allowing 50M+ members to share a car for a long distance ride on 20+ countries. I always worked on various database technologies but currently focused on MariaDB, Cassandra & Redis. I am passionate about making databases frictionless by working on all DB as a service topics: orchestration, service discovery, smart monitoring & alerting, tooling…

Sessions
Tuesday, February 27
2:10 pm - 3:00 pm

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.

Mike Strickland

Mike Strickland

Director, Solutions Architect, Intel Programmable Solutions Group
Intel

Mike Strickland has more than twenty years of computer, networking and storage experience with companies such as Hewlett Packard, Silverback Systems, and Altera, which is now a part of Intel. He currently is leading the FPGA Data Analytics vision across the Programmable Solutions Group at Intel. Previously Strickland has led the development and launch of numerous products including networking, storage management, TCP/IP Offload and iSCSI. He holds a B.S. degree in electrical engineering from Brown University and a M.S. degree in management from the Sloan School of Management at M.I.T.

Sessions
Monday, February 26
3:00 pm - 3:50 pm

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.

Mikhail Sinyavin

Mikhail Sinyavin

Senior Applications Engineer
Intel
Sessions
Tuesday, April 11
4:00 pm - 4:50 pm

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.
Ng Peng Khim

Ng Peng Khim

Head of Institutional Banking Group & Future Ready Technology Group Technology & Operations
DBS Bank

Ng Peng Khim has over two decades of experience in delivering business strategies and technology architectural in the financial services sector. He is the current Head of Institution Banking Group and Future Ready Technology of DBS Bank. Under his leadership, the bank implemented core banking application Finacle across all its offices, built payment gateways including SWIFT and DBS IDEAL3. He was also the industry lead for the Singapore G3 FAST and GIRO Payment Initiative between 2012 to 2015. In the last 2 years, he also led the technology stack adoption to open source. This requires re-design and architecture thinking and building a next wave of better performance applications. Before joining DBS, he worked in Citi for 17 years where he held several senior positions covering both local and regional markets. Prior to Citi, Peng Khim was with Singapore’s Housing and Development Board. Peng Khim was a Singapore Public Service Commission scholar and graduated with first class honours from University of Melbourne.

Sessions
Monday, February 26
1:15 pm - 2:45 pm

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.

PatriceLinel

Patrice Linel

Head of Scientific Computing
Genus Plc.

Patrice Linel is the Head of Scientific Computing at Genus Plc. He holds an Engineering in Modeling and Applied Mathemtics from Polytech’Lyon and a PhD in Applied Mathematics from Universite Lyon1 with a strong interest in high performance computing. He joined the Biostatistics and Computational Biology department of University of Rochester Medical School in 2011 where he developed computational methodology for biomedical data. He is now leading a team on the challenges of genetic improvement using large data and computational approaches to breed better cows and pigs.

Sessions
Tuesday, February 27
10:00 am - 10:50 am

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.

phil-mazza

Phil Mazza

CEO
Financial Network, Inc.
Sessions
Tuesday, February 27
10:00 am - 10:50 am

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.

Piotr Jarmuz

Piotr Jarmuz

Senior Database Engineer
Allegro.pl

I started my career as a C later Java and Perl programmer in 2001 then I started working with relational databases as database developer and admin mainly with Oracle. I worked for GSK as a senior Oracle admin and system architect from 2007-2010. Since 2011, I've worked for Allegro.pl as a senior database engineer. We have multiple Oracle, Postgres and MySQL clusters as well as various NoSQL data stores. Allegro.pl is an online web marketplace operating mainly in Poland. We have 20M users.

Sessions
Tuesday, February 27
3:30 pm - 4:20 pm

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

Pravin Malali

Pravin Malali

Senior Database Administrator
Copart

Pravin is a senior database professional with more than 13 years of experience across multiple technologies, including Oracle, MySQL, MS SQL and MongoDB, that span various industries, such as travel/transport, media, banking and automotive. He started exploring MariaDB in depth about 8 months ago after joining Copart. Since then, the experience working on designing and setting up new applications has been great. He uses the latest and greatest including Galera Clustering, MariaDB ColumnStore and JSON functions. Up next, he is looking forward to implementing some robust HA solutions and analytics/reporting applications on MariaDB.

Sessions
Tuesday, February 27
1:10 pm - 2:00 pm

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.

Richard Heyns

Founder and CEO
Brytlyt

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.

Sessions
Tuesday, February 27
3:30 pm - 4:20 pm

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.

Rick Lane

Rick Lane

Consulting Member of Technical Staff
Nokia

I have worked in the telecom industry for over 37 years with AT&T, Lucent Technologies, Alcatel-Lucent, and now Nokia. I have been involved in the building of 5-9’s Linux HA platforms over the last 20 years, with focus on hardware management and resource failover. I have worked with MariaDB for two years in the Common Software Foundations (CSF) group, productizing deployment and life cycle management of MariaDB in both Cloud and Containerized environments for other Nokia product units.

Sessions
Monday, February 26
5:00 pm - 5:50 pm

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.

Rino Cavallucci

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.

Sessions
Tuesday, April 11
4:00 pm - 4:50 pm

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.
Rosalind Chan

Rosalind Chan

Database Administrator
TradingScreen

Rosalind has over 8 years of DBA experience with different flavors of MySQL. Having successfully managed mission critical production databases for Corporate Sectors and Individual Organizations. She has strong MySQL skills but also significant general system administration skills on Linux environment. She is experienced in Disaster Recovery, Performance Tuning, Query Optimization and Database Consistency Checks using different Utilities.

Sessions
Tuesday, February 27
3:30 pm - 4:20 pm

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.

Seppo Jaakola

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.

Sessions
Wednesday, April 12
1:10 pm - 2:00 pm

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

Tuesday, February 27
8:40 am - 9:30 am

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.

Shree Nair

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.

Sessions
Wednesday, April 12
1:10 pm - 2:00 pm

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.

Steve Olson

Lead Engineer
InfoArmor
Sessions
Tuesday, February 27
11:00 am - 11:50 am

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
Steve Shaw

Steve Shaw

Database Technology Manager
Intel

Lead, supervise and approve Oracle database performance and workload characterization by global team on forthcoming processor and memory technologies. Expert in Oracle database on Intel and proficient in SQL Server and DB2. Strategic migration of commerrcial databases to open source database solutions based on MariaDB/MySQL and PostgreSQL on Intel architecture. Lead customer facing database expert worldwide engaging with customers and delivering training and presentations on optimization of database workloads on Intel.

Sessions
Monday, February 26
3:00 pm - 3:50 pm

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.

Sveta Smirnova

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.

Sessions
Tuesday, April 11
3:00 pm - 3:50 pm

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

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.

Sessions
Wednesday, April 12
2:10 pm - 3:00 pm

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?
Tim Yim

Tim Yim

Director of Operations
ServiceNow

Tim Yim currently serves as a member of the Cloud Infrastructure Architecture group at ServiceNow. Mr. Yim has close to 20 years in the technology industry. He has held various leadership positions most recently Director of Cloud Operations and also participates on several advisory boards.

Sessions
Monday, February 26
1:15 pm - 2:45 pm

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?

Valerie Parham-Thompson

Valerie Parham-Thompson

Lead Database Consultant
Pythian

With experience as an open-source DBA and developer for software-as-a-service environments, Valerie has expertise in web-scale data storage and data delivery.

Sessions
Tuesday, February 27
2:10 pm - 3:00 pm

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.

Vishal Jaiswal

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.

Sessions
Wednesday, April 12
9:00 am - 9:50 am
Wenqi Guan

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.

Sessions
Wednesday, April 12
1:10 pm - 2:00 pm

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

William Wood

William Wood

Director of Database Architecture
Financial Network, Inc.

William has worked in the tech sector for approximately 18 years across multiple disciplines and around the country. He started off doing LAMP stack development for the Engineering Department at East Central College for dynamically generated web applications as a student. More recently, he ended up in product development at Blackboard which brought him back to database work, becoming the department Oracle SME. Ultimately, he landed back in Missouri at Financial Network Inc as a Database Administrator having responsibility over the database department and architecture.

Sessions
Tuesday, February 27
8:40 am - 9:30 am

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.

Yoshinori Matsunobu

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.

Sessions
Tuesday, February 27
1:10 pm - 2:00 pm

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.

Wednesday, April 12
10:00 am - 10:50 am

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.

Yuan Zhang

Senior Database Engineer
Alibaba
Sessions
Tuesday, February 27
10:00 am - 10:50 am

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.

Zhang Qinglin

Tencent
Sessions
Tuesday, February 27
11:00 am - 11:50 am

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.

Alexander Bienemann

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.

Sessions
Monday, February 26
4:00 pm - 4:50 pm

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.

Wednesday, April 12
11:10 am - 12:00 pm

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

Alvin Richards

Director of Global Field Technical Services
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.

Sessions
Wednesday, April 12
3:20 pm - 4:10 pm

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.

Wednesday, April 12
11:10 am - 12:00 pm

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

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.

Sessions
Tuesday, February 27
11:00 am - 11:50 am

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.

Wednesday, April 12
9:00 am - 9:50 am

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

Anders Karlsson

Principal Solutions 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.

Sessions
Tuesday, February 27
3:30 pm - 4:20 pm

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.

Tuesday, February 27
8:40 am - 9:30 am

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.

Wednesday, April 12
11:10 am - 12:00 pm

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.

Tuesday, April 11
3:00 pm - 3:50 pm

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.

Andrei Elkin

Andrei Elkin

Senior Software Engineer
MariaDB

Graduated from Kazan State University, USSR, in 1986. Studied as postgraduate in Leningrad (St. Petersburg) State University in the department of Mathematics & Mechanics where he defended a PhD thesis. During his studies, he got blinded by the emerging Internet, Linux and the beauty of programming languages such as Lisp which gradually shaped his professional career. His first professional challenge was to design and implement one of the first MySQL clustering projects in Continuent (2001-2005) and later continued with productive involvement into MySQL replication field. Recent years have seen the MySQL replication feature set growth including heartbeat, checksum, parallel replication, XA replication that he is the author of, apart from being a contributor to MySQL synchronous replication. He joined MariaDB in June 2017 to prove to himself that he is still not disenchanted with MySQL research and engineering. In his private life, he is a loving husband and the same kind of father, playing football (soccer) with one and chess with the other son.

Sessions
Tuesday, February 27
3:30 pm - 4:20 pm

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.

Andrew Hutchings

Andrew Hutchings

Lead Engineer
MariaDB

Andrew Hutchings (aka LinuxJedi) works for MariaDB Corporation as the Lead 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.

Sessions
Wednesday, April 12
10:00 am - 10:50 am

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.

 

Monday, February 26
3:00 pm - 3:50 pm

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.

Bjorge Staijen

Engineer
MariaDB
Sessions
Wednesday, April 12
3:20 pm - 4:10 pm

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

David Thompson

Vice President of Engineering
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.

Sessions
Monday, February 26
5:00 pm - 5:50 pm

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.

Wednesday, April 12
9:00 am - 9:50 am

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

Dipti Joshi

Director
MariaDB

Dipti Joshi is Director of Product Management at MariaDB Corporation. She is responsible for MariaDB AX and MariaDB MaxScale. Before joining the 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 herself building very large distributed OLAP databases and applications with MySQL, Oracle, purpose-built databases and columnar databases.

Sessions
Monday, February 26
4:00 pm - 4:50 pm

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.

Tuesday, April 11
4:00 pm - 4:50 pm

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

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.

Tuesday, February 27
8:40 am - 9:30 am

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.

Monday, February 26
3:00 pm - 3:50 pm

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.

Tuesday, April 11
3:00 pm - 3:50 pm

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
Esa Korhonen

Esa Korhonen

Software Engineer
MariaDB

Esa Korhonen joined the MaxScale team at MariaDB in 2016. Previously, he worked at a physics laboratory designing measurement control and analysis programs. In MaxScale, he has worked on the NamedServerFilter, QueryLogAll filter, proxy protocol support and failover/switchover.

Sessions
Tuesday, February 27
11:00 am - 11:50 am

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.

Gerardo Narvaja

Gerardo Narvaja

Senior Solutions Engineer
MariaDB

Gerry has spent more than 25 years in the software industry, mostly working with databases for various applications, from embedded to large-scale web products. Gerry first worked at MySQL and then Sun Microsystems supporting the Sales teams. In 2008, he transitioned into being a Senior MySQL DBA for 5 years, before returning to support the Sales team. Over the last 4 years, he has been with SkySQL and then MariaDB.

Sessions
Monday, February 26
3:00 pm - 3:50 pm

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.

Igor Babaev

Igor Babaev

Principal 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.

Sessions
Tuesday, February 27
11:00 am - 11:50 am

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.

Tuesday, April 11
4:00 pm - 4:50 pm

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
Tuesday, February 27
10:00 am - 10:50 am

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.

Jacob Mathew

Jacob Mathew

Senior Software Engineer
MariaDB

Jacob Mathew has been privileged to be part of the evolution of database management software for the past 40 years as a developer and a manager. Jacob is currently a Senior Software Engineer developing Spider and the MariaDB Server. Before joining MariaDB, Jacob has been part of the engineering team developing ScaleDB, the ANTs Data Server, Sybase ASE, Hyperion Essbase OLAP Server, Red Brick Warehouse, Tandem Nonstop SQL, Data General Infos II and Data General DG/DBMS. Jacob has also held hands-on management positions including Vice President of Research & Development at ScaleDB and Vice President of Engineering at Four J’s Development Tools. Jacob holds a Bachelor of Science degree in Computer Science from the University of Maryland.

Sessions
Monday, February 26
5:00 pm - 5:50 pm

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.

Jens Bollmann

Jens Bollmann

Principal Instructor
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.

Sessions
Wednesday, April 12
1:10 pm - 2:00 pm

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.

Wednesday, April 12
2:10 pm - 3:00 pm

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.

Tuesday, April 11
4:00 pm - 4:50 pm

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.

Tuesday, February 27
8:40 am - 9:30 am

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.

Jens Röwekamp

Jens Röwekamp

Engineering Intern
MariaDB

Jens is a professional computer science expert (in the subject area system integration) with more than three years of experience in administrating Linux and Windows systems and services. He holds a B. Eng. (Hons.) in Computer Systems and Networks from London South Bank University, a B. Sc. in Computer Engineering from University of Applied Sciences Bremen, and is currently finishing his dual degree Master program in ICT Innovation – Cloud Computing and Services at TU Berlin and KTH Royal Institute of Technology. Jens recently joined MariaDB’s ColumnStore team as engineering intern and is currently expanding the functionality of the new bulk data adapters.

Sessions
Monday, February 26
5:00 pm - 5:50 pm

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.

Johan Wikman

Johan Wikman

Lead Developer
MariaDB

Johan is a MaxScale developer at MariaDB that he joined in the fall of 2015. Prior to that, 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. When not working on MaxScale, Johan enjoys building treehouses.

Sessions
Tuesday, February 27
1:10 pm - 2:00 pm

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.

Wednesday, April 12
2:10 pm - 3:00 pm

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.

Wednesday, April 12
10:00 am - 10:50 am

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

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. 

Sessions
Wednesday, April 12
10:00 am - 10:50 am

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

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.

Sessions
Wednesday, April 12
10:00 am - 10:50 am

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.

Marko Mäkelä

Marko Mäkelä

Lead Developer InnoDB
MariaDB

In 2003, after submitting his doctoral thesis in theoretical computer science, 10 years after his first encounter with relational databases, Marko Mäkelä joined Innobase Oy as the first full-time employee. Since then, he is developing the InnoDB storage engine that provides transactions and multi-versioning to MySQL and MariaDB. Marko joined MariaDB in late 2016. His work include various ROW_FORMAT for InnoDB, crash recovery improvements, undo logging improvements, and various work on ALTER TABLE, most recently the instant ADD COLUMN feature in MariaDB Server 10.3.

Sessions
Tuesday, February 27
2:10 pm - 3:00 pm

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.

MarkusMäkelä.jpg

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.

Sessions
Wednesday, April 12
3:20 pm - 4:10 pm

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.

Tuesday, February 27
8:40 am - 9:30 am

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.

Tuesday, February 27
2:10 pm - 3:00 pm

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.

Massimiliano Pinto

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.

Sessions
Wednesday, April 12
3:20 pm - 4:10 pm

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

Max Mether

Head of Server Product Management
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.

Sessions
Tuesday, April 11
4:00 pm - 4:50 pm
Wednesday, April 12
10:00 am - 10:50 am
Michael "Monty" Widenius

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.

Sessions
Wednesday, April 12
4:45 pm - 5:30 pm

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 Danko

Michael Danko

Senior DevOps Engineer
MariaDB

Mike Danko works on DevOps solutions at MariaDB. Mike brings a diverse experience of Infrastructure Automation and Design to Full-stack web development from startups to large enterprises. Prior to working at MariaDB he's held positions at NewContext, Fooda, GiveForward, Neo, and Spectrum.

Sessions
Michaël de Groot

Michaël de Groot

Consultant
MariaDB

Michaël de Groot has been active in the database ecosystem for 14 years. During that time, he's held various positions from developer, DBA, IT Director and CTO. He was responsible for a 2000% growth of a real-time multiplayer games platform. Besides real-time communication with a server, there were 150 million dynamic requests per 12 hours. After some (interim) architect and CIO/CTO roles, he founded a FinTech start-up, and joined MariaDB as a consultant and trainer. Michaël's specialties are scalability and high availability.

Sessions
Tuesday, February 27
2:10 pm - 3:00 pm

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.

Michael Howard

Michael Howard

CEO
MariaDB Corporation

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.

Sessions
Monday, February 26
1:15 pm - 2:45 pm
Monday, February 26
1:15 pm - 1:45 pm

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

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.

Sessions
Wednesday, April 12
2:10 pm - 3:00 pm

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

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).

Sessions
Tuesday, April 11
3:00 pm - 3:50 pm

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
Roger Bodamer

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.

Sessions
Monday, February 26
2:15 pm - 2:45 pm

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.

Satoru Goto

Satoru Goto

Customer Solutions Engineer
MariaDB

Satoru has more than 20 years of experience in UNIX/Linux administration using various open source softwares. Joined MariaDB in 2017, based in Tokyo, works as Presales engineer in Asia-Pacific region.

Sessions
Tuesday, February 27
11:00 am - 11:50 am

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.

Sergey Petrunia

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.

Sessions
Monday, February 26
4:00 pm - 4:50 pm

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
Tuesday, February 27
11:00 am - 11:50 am

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.

Wednesday, April 12
9:00 am - 9:50 am

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.

 

Tuesday, April 11
4:00 pm - 4:50 pm

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
Tuesday, February 27
10:00 am - 10:50 am

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.

Shane Johnson

Shane Johnson

Senior Director of Product Marketing
MariaDB

Senior Director of Product Marketing

Prior to MariaDB, Shane led product and technical marketing at Couchbase. Before that, he performed technical roles in development, architecture and evangelism at Red Hat – specializing in Java and distributed systems.
Sessions
Monday, February 26
3:00 pm - 3:50 pm

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.

Stephane Varoqui

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.     

Sessions
Wednesday, April 12
11:10 am - 12:00 pm

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
Thomas Boyd

Thomas Boyd

Principal Solutions Engineer
MariaDB

Thomas joined MariaDB in 2017. He brings 25 years of experience in the IT industry, with a strategic focus on databases and data storage technologies. Prior to MariaDB, Thomas worked at Oracle, Hewlett-Packard, MongoDB, as well as with smaller startups and as an independent consultant in the San Francisco Bay Area.

Sessions
Tuesday, February 27
1:10 pm - 2:00 pm

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.

Tuesday, February 27
10:00 am - 10:50 am

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.

Ulrich Moser

Ulrich Moser

Senior Consultant
MariaDB

After graduating in Mathematics and Physics Ulrich Moser started as system software developer at the database management systems department at SIEMENS being responsible for the SQL Interpreter. After leaving SIEMENS he worked for several years as consultant for database applications. In 1996 he started as Senior Solution Architect with main focus on information management and information security for different companies from various industrial sectors as well as public sector in Germany and Switzerland before becoming a professor for information management at the Berne University for Applied Sciences (BUAS). Since 2011 he is working as trainer and consultant for MariaDB and MySQL. Besides this he is also working as trainer and business coach.

Sessions
Monday, February 26
3:00 pm - 3:50 pm

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.

Varun Gupta

Varun Gupta

Software Engineer
MariaDB

Varun Gupta is a Software Engineer at the MariaDB Corporation. He joined the company in 2017 and has been involved in focusing on optimizer related issues. His first contribution to MariaDB was implementing Custom Aggregate Functions. He has also taken part in implementing Window Functions notably the percentile functions and the MEDIAN function.

Sessions
Tuesday, February 27
1:10 pm - 2:00 pm

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.

Vicențiu Ciorbaru

Vicențiu Ciorbaru

Software Engineer
MariaDB Foundation

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.

Sessions
Wednesday, April 12
9:00 am - 9:50 am

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.

Tuesday, February 27
1:10 pm - 2:00 pm

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.

Wagner Bianchi

Wagner Bianchi

Principal Remote DBA
MariaDB

Bianchi has been working with the MySQL ecosystem for more than 12 years. He has been an Oracle ACE Director since 2014 and has worked on the most complex environments running Open Source solutions. Bianchi joined the MariaDB RDBA team in 2017 where he works as a Principal Remote DBA.

Sessions
Monday, February 26
4:00 pm - 4:50 pm

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.

Tuesday, February 27
11:00 am - 11:50 am

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.