No results found

Your search did not match any results.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
  • Try one of the popular searches shown below.
  • Start a new search.
Trending Questions

Oracle Developer Live—MySQL

Explore the World’s #1 Open Source Database. Join us for technical sessions, hands-on labs, demos, panels and live Q&A with experts.

#OracleDevLive

Oracle Developer Live—MySQL

MySQL is the world’s leading open source database. This is your opportunity to discover the latest developments in MySQL 8.0 and the new MySQL Database Service directly from the software engineering team. Learn from experienced developers and DBAs who use MySQL to power some of the world’s most well-known web properties.

MySQL logo

Featured Speakers

Sugu Sougoumarane

Sugu Sougoumarane

Chief Technology Officer, Vitess

Sugu is the co-creator of Vitess, and has been working on it since 2010. Prior to Vitess, Sugu worked on scalability at YouTube and was also part of PayPal in the early days. His recent interest is in distributed systems and consensus algorithms. He occasionally shares his thoughts on his blog sougou.io.

Tomas Ulin

Tomas Ulin

Vice President, MySQL Engineering, Oracle

Tomas Ulin has been working with the MySQL team since 2003, based in Sweden. He is Vice President for the MySQL Engineering team, responsible for the development and maintenance of the MySQL Server, MySQL Cluster, MySQL Connectors, MySQL Workbench, MySQL Enterprise Backup, and MySQL Enterprise Monitor. He is also responsible for the MySQL Database Service on Oracle Cloud, as well as MySQL Support. Prior to working with MySQL he has a background in the telecom industry, working for the Swedish telecom operator Telia and Telecom vendor Ericsson. He has a Masters degree in Computer Science and Applied Physics from Case Western Reserve University and a PhD in Computer Science from the Royal Institute of Technology.

Mark Leith

Mark Leith

MySQL Software Development Director, Oracle

Mark Leith joined MySQL in 2005 as a Support Engineer, and is now a Software Development Director in Oracle's MySQL Database Service Control Plane team, where he helps lead development of the MySQL Database Service Control Plane and Site Reliability Engineering for the service. He also leads development of MySQL Enterprise Monitor and the Oracle Enterprise Manager Plugin for MySQL. He is the original developer of the sys schema, a collection of views, procedures and functions, that can be used to help interpret Performance Schema and Information Schema data. He also works closely with the MySQL server team on the Performance Schema and MySQL instrumentation in general.

Kenny Gryp

Kenny Gryp

MySQL Product Manager, Oracle

Kenny is a MySQL expert with a lot of experience in performance and architecture. While he has focused on MySQL and automation for over a decade, he has also developed expertise in other areas. He’s a well-rounded, multidimensional nerd who is skilled in many things: making a coffee on the side of a mountain, electrical building codes for single family dwellings in the US, the perfect ratio of cumin and asafoetida in tadka dal, and providing occupational therapy to a shy rabbit named Winston. He’s adept at talking, so don’t feel the need to limit in-session questions to MySQL.

>Harin Vadodaria

Harin Vadodaria

Principal MTS, Oracle

Harin Vadodaria is security lead at MySQL Engineering team. Harin has been part of MySQL team for more than 8 years and his main focus is MySQL database security. At MySQL, Harin has worked on design and implementation of various features in areas like authentication, user account management, authorization, privileges management, data encryption, keyring integration and communication security. He has overall experience of over 12 years working on database security.

Rui Quelhas

Rui Quelhas

Principal Software Developer, Oracle

Rui Quelhas is a Software Developer at Oracle, part of the MySQL Middleware and Clients team, and he is the lead developer of the MySQL X DevAPI Connector for Node.js. His talks have already been a feature on conferences such as Oracle Code One and Percona Live. He’s been an active member of the Node.js community for more than 8 years and has his share of open source contributions both for personal projects or as part of larger organizations such as the node-forward movement and the hapijs maintainer’s network.

Jesper Wisborg Krogh

Jesper Wisborg Krogh

Principal Database Reliability Engineer, Okta

Jesper has worked with MySQL databases since 2006 both as an SQL developer, a database administrator, and for more than eight years as part of the Oracle MySQL Support team. Currently, he is a database reliability engineer with Okta. He has contributed to the sys schema and four Oracle Certified Professional (OCP) exams for MySQL 5.6 to 8.0. He is the author/co-author of several MySQL books including MySQL 8 Query Performance Tuning. He lives in Sydney, Australia and likes going for walks, listening to music, read, and learning new technologies and features.

Johannes Schluter

Johannes Schlüter

MySQL Scripting Connectors, Oracle

Being a member of the MySQL development team for more than 10 years, Johannes Schlüter currently serves as an Software Engineering Manager leading the development of MySQL Connectors for Node.js, PHP and Python. He is a contributor to multiple OpenSource projects, including the PHP language and runtime, where he served as release manger for PHP 5.3. Being fluent in multiple programming languages he loves switching between technologies as needed for the best results.

Miguel Araujo

Miguel Araújo

Principal Software Developer, Oracle

Miguel Araújo is a Principal Software Engineer on the MySQL Team, at Oracle. He’s the Tech Lead of the AdminAPI, core component of MySQL InnoDB Cluster, at the MySQL Shell team. In the past, he has worked on different projects and teams, mostly related to Middleware and High-Availability. He has a Computer Science Engineering degree and Master’s degree, from the University of Minho, Portugal, where he was also a researcher. His backgrounds are on distributed systems, scalability, database replication and high-availability. He is based in Portugal.

Geir Hoydalsvik

Geir Høydalsvik

Senior Software Development Director, Oracle

Geir Høydalsvik has been working with MySQL Database team since 2008. He is currently employed by Oracle, based in Norway. He is Senior Software Development Director and responsible for the development and maintenance of MySQL Database. He has a background in the database industry, working for the database startup company Clustra Inc. on the Clustra database and for Sun Microsystems on Java DB. He has a Master degree in Computer Science and a PhD in Software Engineering from the Norwegian University of Science and Technology.

Morgan Tocker

Morgan Tocker

Vitess Maintainer, Community Development Manager, PlanetScale

Morgan is the former product manager for the MySQL Server, where he was responsible for both schema and schemaless (JSON) functionality. He is currently a maintainer of Vitess, a CNCF project.

Markus Winand

Markus Winand

Author, Trainer, Coach, winand.at

As the SQL Renaissance Ambassador, it is Markus Winands mission to make developers aware of the evolution of SQL in the 21st century. His book “SQL Performance Explained” has been published in five languages and can be read online free of charge at use-the-index-luke.com. His next book is currently in the works and can already be read online as it’s being written (modern-sql.com). Markus is available as a trainer, speaker and consultant for all companies and developers interested in SQL. You'll find more info at winand.at.

Juan Rene Ramirez Monarrez

Juan Rene Ramirez Monarrez

Software Developer Manager, Oracle

Rene leads the MySQL Shell project and has been a software engineer for almost 20 years.

He joined Oracle in 2011 into the MySQL Workbench team and moved to the MySQL Shell since it initiated, which has given him the opportunity to contribute in almost every feature with a unique objective in mind: turning it into the #1 frontend for the MySQL product family.

Prior to Oracle he worked as a software engineer for IBM and Freescale Semiconductor (now NXP). He also spent some time on a master degree where he spent lot of time on fun projects: image processing, augmented reality, animation, video games and robotics.

Nicolai Plum

Nicolai Plum

Database Engineer, Booking.com

Nicolai Plum works in the Database Engineering team of Booking.com managing database product features and service design. His previous roles at Booking.com have ranged widely from Linux systems administration team lead through storage and systems architecture to regulatory compliance and construction project management. Previously he managed UNIX systems for the Internet backbone of UUNET UK and MCI Worldcom. In his spare time he travels the world and takes pictures.

Mike Frank

Mike Frank

Product Management Director, MySQL, Oracle

Over the past 20 years, Mike has helped organizations formulate and implement complex new products and strategies.

His background spans database development, tools, packaging, security, and backup. He's brought well over 15 new to market products. During 9 years at MySQL he's been instrumental in working with various database and development tools, the MySQL repos, and various security products and features. In 2020, he’s been laser focused on security, bringing many new features to market in MySQL as well as authoring various security guidelines such as CIS and DISA STIG.

Bill Karwin

Bill Karwin

Chief Architect, Karwin Software Solutions LLC

Bill Karwin has many years of experience as a database developer, consultant, and trainer. He published the popular book "SQL Antipatterns: Avoiding the Pitfalls of Database Programming." Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

Frederic Descamps

Frédéric Descamps

MySQL Community Manager, Oracle

Frédéric Descamps has been consulting OpenSource and MySQL for over 15 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the first Belgian start-up dedicated 100% to free projects around GNU/Linux. It is in 2011 that lefred joined Percona, one of the leading MySQL-based specialists. He decided to join the MySQL Community Team in 2016 as a MySQL Community Manager for EMEA & APAC. Frédéric is also a regular speaker of OpenSource Conferences.

Luis Soares

Luís Soares

Software Development Director, Oracle

Luís Soares is the MySQL Replication Development Director at Oracle. His research interests include replication technologies, dependable systems and high availability. Before joining the MySQL team, he was both a post-graduate student and a researcher at the University of Minho, Portugal, where he designed and implemented group-based replication protocols. Before that, he worked for a Portuguese multi-national company as a system analyst.

Agenda in Pacific Daylight Time (PT)

8 : 00 AM

Welcome
8:00 AM8:10 AM

8 : 10 AM

Keynote: MySQL 8.0: A Giant Leap for SQL
Tomas Ulin
Mark Leith
8:10 AM8:55 AM
Keynote: MySQL 8.0: A Giant Leap for SQL
8:10 AM8:55 AM
This talk will highlight what is new in MySQL 8.0—a huge step forward for our users. MySQL 8.0 delivers significant improvements on all fronts, such as dramatically improved SQL, GIS, and JSON support. The talk will also cover the MySQL Document Store (MySQL = NoSQL + SQL) and MySQL InnoDB Cluster (HA out of the box) as well as MySQL Shell, which ensures power, freedom, and flexibility for the developer.

Tomas Ulin
Tomas Ulin Vice President, MySQL Engineering Oracle

Tomas Ulin has been working with the MySQL team since 2003, based in Sweden. He is Vice President for the MySQL Engineering team, responsible for the development and maintenance of the MySQL Server, MySQL Cluster, MySQL Connectors, MySQL Workbench, MySQL Enterprise Backup, and MySQL Enterprise Monitor. He is also responsible for the MySQL Database Service on Oracle Cloud, as well as MySQL Support. Prior to working with MySQL he has a background in the telecom industry, working for the Swedish telecom operator Telia and Telecom vendor Ericsson. He has a Masters degree in Computer Science and Applied Physics from Case Western Reserve University and a PhD in Computer Science from the Royal Institute of Technology.

Mark Leith
Mark Leith MySQL Software Development Director Oracle

Mark Leith joined MySQL in 2005 as a Support Engineer, and is now a Software Development Director in Oracle's MySQL Database Service Control Plane team, where he helps lead development of the MySQL Database Service Control Plane and Site Reliability Engineering for the service. He also leads development of MySQL Enterprise Monitor and the Oracle Enterprise Manager Plugin for MySQL. He is the original developer of the sys schema, a collection of views, procedures and functions, that can be used to help interpret Performance Schema and Information Schema data. He also works closely with the MySQL server team on the Performance Schema and MySQL instrumentation in general.

9 : 05 AM

MySQL 8 at Booking.com
Nicolai Plum
9:05 AM9:45 AM
MySQL 8 at Booking.com
9:05 AM9:45 AM
Booking.com has used MySQL for more than 15 years and has built one of the world’s leading online travel agents on MySQL technologies. This talk will describe how we’re using MySQL at Booking.com with a focus on new MySQL 8 features and data processing at large scale.

Topics: Group replication, binary log compression, relational and document data models, database cluster management, and more.

Nicolai Plum
Nicolai Plum Database Engineer Booking.com

Nicolai Plum works in the Database Engineering team of Booking.com managing database product features and service design. His previous roles at Booking.com have ranged widely from Linux systems administration team lead through storage and systems architecture to regulatory compliance and construction project management. Previously he managed UNIX systems for the Internet backbone of UUNET UK and MCI Worldcom. In his spare time he travels the world and takes pictures.

MySQL Shell: The Best MySQL DBA Tool
Miguel Araújo
9:05 AM9:45 AM
MySQL Shell: The Best MySQL DBA Tool
9:05 AM9:45 AM
MySQL Shell is the new, advanced command-line client and editor for MySQL. It sends SQL statements to MySQL server, supports both the classic MySQL protocol and the newer X protocol, and provides scripting capabilities for JavaScript and Python. But there's more to MySQL Shell than meets the eye. It delivers a natural and powerful interface for all DevOps tasks related to MySQL by providing APIs for development and administration. This session covers MySQL Shell's core features, along with demonstrations of how to use the various APIs and how to extend MySQL Shell. We’ll address the regular interaction with databases, the built-in tools that make DBAs and developers’ lives easier, the easy and flawless set up of HA architectures, and the plugins and extensions framework.

Miguel Araújo
Miguel Araújo Principal Software Developer Oracle

Miguel Araújo is a Principal Software Engineer on the MySQL Team, at Oracle. He’s the Tech Lead of the AdminAPI, core component of MySQL InnoDB Cluster, at the MySQL Shell team. In the past, he has worked on different projects and teams, mostly related to Middleware and High-Availability. He has a Computer Science Engineering degree and Master’s degree, from the University of Minho, Portugal, where he was also a researcher. His backgrounds are on distributed systems, scalability, database replication and high-availability. He is based in Portugal.

9 : 50 AM

Sharding MySQL with Vitess and Kubernetes
Sugu Sougoumaran
9:50 AM10:30 AM
Sharding MySQL with Vitess and Kubernetes
9:50 AM10:30 AM
Vitess is a cloud native clustering and sharding MySQL. With Kubernetes gaining traction as the platform of the future for distributed systems, it’s important for storage systems to find a way to run in such environments. Vitess was originally designed to run on Google’s Borg, which is the predecessor of Kubernetes. In this session, we’ll show how Vitess combines its ability to run in Kubernetes while being able to scale massively.

Sugu Sougoumarane
Sugu Sougoumarane Chief Technology Officer Vitess

Sugu is the co-creator of Vitess, and has been working on it since 2010. Prior to Vitess, Sugu worked on scalability at YouTube and was also part of PayPal in the early days. His recent interest is in distributed systems and consensus algorithms. He occasionally shares his thoughts on his blog https://sougou.io.

Developing NodeJS Applications with MySQL 8.0
Rui Quelhas
9:50 AM10:30 AM
Developing NodeJS Applications with MySQL 8.0
9:50 AM10:30 AM
The last few years saw the advent of JavaScript in the server, and particularly Node.js. The dynamic functional nature of the language and the key philosophy of using schemaless literal objects or the corresponding JSON counterparts to express data-structures. Matching this environment, MySQL recently introduced the MySQL Document Store, which enables using a regular MySQL database to manage schemaless data. This presentation will describe the key concepts of the Document Store alongside the new X protocol that supports it, and will show how to use the X DevAPI with the MySQL Node.js connector.

Rui Quelhas
Rui Quelhas Principal Software Developer Oracle

Rui Quelhas is a Software Developer at Oracle, part of the MySQL Middleware and Clients team, and he is the lead developer of the MySQL X DevAPI Connector for Node.js. His talks have already been a feature on conferences such as Oracle Code One and Percona Live. He’s been an active member of the Node.js community for more than 8 years and has his share of open source contributions both for personal projects or as part of larger organizations such as the node-forward movement and the hapijs maintainer’s network.

10 : 35 AM

Moving On-Premises MySQL Installations to MySQL Database Service Made Fast and Easy
Juan Rene Ramirez Monarrez
10:35 AM11:15 AM
Moving On-Premises MySQL Installations to MySQL Database Service Made Fast and Easy
10:35 AM11:15 AM
The new MySQL Database Service is a fully managed service that brings the feature set of the MySQL Server to the cloud, taking advantage of the computing power and tooling available in Oracle Cloud Infrastructure. A key aspect for the adoption of this new technology is “how to get there?” Moving data from an on-premises MySQL instance to the MySQL Database Service is an important step, and the MySQL Shell provides the functionality to do this operation in an easy and extremely performant way. This solution performs the data backup, restore, and compatibility verification using a parallelized approach at several levels, reducing the time to complete the process to a fraction of the time required by other solutions.

Juan Rene Ramirez Monarrez
Juan Rene Ramirez Monarrez Software Developer Manager Oracle

Rene leads the MySQL Shell project and has been a software engineer for almost 20 years.

He joined Oracle in 2011 into the MySQL Workbench team and moved to the MySQL Shell since it initiated, which has given him the opportunity to contribute in almost every feature with a unique objective in mind: turning it into the #1 frontend for the MySQL product family.

Prior to Oracle he worked as a software engineer for IBM and Freescale Semiconductor (now NXP). He also spent some time on a master degree where he spent lot of time on fun projects: image processing, augmented reality, animation, video games and robotics.

MySQL Replication Performance, Efficiency, and the Cloud
Luís Soares
10:35 AM11:15 AM
MySQL Replication Performance, Efficiency, and the Cloud
10:35 AM11:15 AM
Designing and operating MySQL replication deployments requires knowledge of the intricacies of the underlying technologies. Furthermore, deploying a database system in the cloud makes us deal again with new incarnations of old problems. Slow storage, expensive computing power, and limited and shared network bandwidth are things that one has to deal with again, and that the availability of cheap, highly multicore machines with flash storage was making us forget.

Josh Spiegel
Luís Soares Software Development Director Oracle

Luís Soares is the MySQL Replication Development Director at Oracle. His research interests include replication technologies, dependable systems and high availability. Before joining the MySQL team, he was both a post-graduate student and a researcher at the University of Minho, Portugal, where he designed and implemented group-based replication protocols. Before that, he worked for a Portuguese multi-national company as a system analyst.

11 : 20 AM

MySQL Security Model in Oracle Cloud
Harin Vadodaria
Mike Frank
11:20 AM12:00 PM
MySQL Security Model in Oracle Cloud
11:20 AM12:00 PM
This session provides an overview MySQL security architecture and user model used by MySQL in the cloud. The session explains these features such as roles, system user, partial revokes, and many more.

Harin Vadodaria
Harin Vadodaria Principal MTS Oracle

Harin Vadodaria is security lead at MySQL Engineering team. Harin has been part of MySQL team for more than 8 years and his main focus is MySQL database security. At MySQL, Harin has worked on design and implementation of various features in areas like authentication, user account management, authorization, privileges management, data encryption, keyring integration and communication security. He has overall experience of over 12 years working on database security.

Mike Frank
Mike Frank Product Management Director, MySQL Oracle

Over the past 20 years, Mike has helped organizations formulate and implement complex new products and strategies.

His background spans database development, tools, packaging, security, and backup. He's brought well over 15 new to market products. During 9 years at MySQL he's been instrumental in working with various database and development tools, the MySQL repos, and various security products and features. In 2020, he’s been laser focused on security, bringing many new features to market in MySQL as well as authoring various security guidelines such as CIS and DISA STIG.

As a founder and VP of Products at Gazzang (acq. by Cloudera) he brought to market Linux TDE and a SaaS key management products. As a co-founder and head of products at Idera (acq. by HGGC) he brought to market 5 database management products including SQL Secure, SQL Compliance Manager, and SQLsafe. At PentaSafe (acq. By NetIQ), as Product Author and Product Line Manager, he created a line of products for Security and Risk assessment of Linux and Web Servers. Mikes experience spans databases, operating systems, security, e-business, and trading systems.

MySQL High Availability—InnoDB Cluster and InnoDB ReplicaSet
Kenny Gryp
11:20 AM12:00 PM
MySQL High Availability—InnoDB Cluster and InnoDB ReplicaSet
11:20 AM12:00 PM
MySQL InnoDB Cluster provides a complete, high-availability solution for MySQL. MySQL Shell includes AdminAPI, which enables you to easily configure and administer a group of at least three MySQL server instances to function as an InnoDB cluster. Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB clusters, with built-in failover. MySQL InnoDB ReplicaSet is similar, but does the same for classic MySQL Replication as InnoDB Cluster did for group replication. We take a strong technology that is very powerful but can be complex, and provide an easy-to-use AdminAPI for it in the MySQL Shell. We will show, with a few easy-to-use Shell commands, how to set up a MySQL database architecture.

Kenny Gryp
Kenny Gryp MySQL Product Manager Oracle

Kenny is a MySQL expert with a lot of experience in performance and architecture. While he has focused on MySQL and automation for over a decade, he has also developed expertise in other areas. He’s a well-rounded, multidimensional nerd who is skilled in many things: making a coffee on the side of a mountain, electrical building codes for single family dwellings in the US, the perfect ratio of cumin and asafoetida in tadka dal, and providing occupational therapy to a shy rabbit named Winston. He’s adept at talking, so don’t feel the need to limit in-session questions to MySQL.

12 : 05 PM

MySQL Performance Tuning
Jesper Wisborg Krogh
12:05 PM12:45 PM
MySQL Performance Tuning
12:05 PM12:45 PM
This session explores topics related to MySQL performance tuning. We will look at Performance Schema and sys schema to identify candidates for optimization, and will use EXPLAIN, EXPLAIN ANALYZE, and Visual Explain to analyze the queries. Based on the analysis, we will add indexes, change the configuration, and rewrite the queries to improve the performance. We will also explore how to use the Performance Schema and sys schema to identify and analyze hot tables, I/O bottlenecks, and lock contention.

Jesper Wisborg Krogh
Jesper Wisborg Krogh Principal Database Reliability Engineer Okta

Jesper has worked with MySQL databases since 2006 both as an SQL developer, a database administrator, and for more than eight years as part of the Oracle MySQL Support team. Currently, he is a database reliability engineer with Okta. He has contributed to the sys schema and four Oracle Certified Professional (OCP) exams for MySQL 5.6 to 8.0. He is the author/co-author of several MySQL books including MySQL 8 Query Performance Tuning. He lives in Sydney, Australia and likes going for walks, listening to music, read, and learning new technologies and features.

Panel: SQL or NoSQL? Schema or Schemaless?
Morgan Tocker
Markus Winand
Bill Karwin
Moderator: Frédéric Descamps
12:05 PM12:45 PM
Panel: SQL or NoSQL? Schema or Schemaless?
12:05 PM12:45 PM
Whether using a NoSQL store or a relational database, people using modern applications now have a choice in how they structure their data: they can opt for schema or schemaless. But what are the pitfalls of either approach, and what should really be the default choice for new applications? We invite panelists to debate between the advantages of schema and schemaless, so you can make the best choice for designing future applications.

Frédéric Descamps
Frédéric Descamps MySQL Community Manager Oracle

Frédéric Descamps has been consulting OpenSource and MySQL for over 15 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the first Belgian start-up dedicated 100% to free projects around GNU/Linux. It is in 2011 that lefred joined Percona, one of the leading MySQL-based specialists. He decided to join the MySQL Community Team in 2016 as a MySQL Community Manager for EMEA & APAC. Frédéric is also a regular speaker of OpenSource Conferences.

Morgan Tocker
Morgan Tocker Vitess Maintainer, Community Development Manager PlanetScale

Morgan is the former product manager for the MySQL Server, where he was responsible for both schema and schemaless (JSON) functionality. He is currently a maintainer of Vitess, a CNCF project.

Markus Winand
Markus Winand Author, Trainer, Coach winand.at

As the SQL Renaissance Ambassador, it is Markus Winands mission to make developers aware of the evolution of SQL in the 21st century. His book “SQL Performance Explained” has been published in five languages and can be read online free of charge at use-the-index-luke.com. His next book is currently in the works and can already be read online as it’s being written (modern-sql.com). Markus is available as a trainer, speaker and consultant for all companies and developers interested in SQL. You'll find more info at winand.at.

Bill Karwin
Bill Karwin Chief Architect Karwin Software Solutions LLC

Bill Karwin has many years of experience as a database developer, consultant, and trainer. He published the popular book "SQL Antipatterns: Avoiding the Pitfalls of Database Programming." Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

12 : 50 PM

Hands-on labs
Develop and Deploy a Modern Application in NodeJS on MySQL Database Service
Johannes Schlüter
12:50 PM2:50 PM
Develop and Deploy a Modern Application in NodeJS on MySQL Database Service
12:50 PM2:50 PM
It’s time to put things in practice. In this hands-on-session we’ll take the MySQL Database Service in practice and build a cloud-native application using Node.js. Even when you are using a different language, this will provide useful practical experience for building server-less or micro-service architectures using MySQL.

Johannes Schlüter
Johannes Schlüter MySQL Scripting Connectors Oracle

Being a member of the MySQL development team for more than 10 years, Johannes Schlüter currently serves as an Software Engineering Manager leading the development of MySQL Connectors for Node.js, PHP and Python. He is a contributor to multiple OpenSource projects, including the PHP language and runtime, where he served as release manger for PHP 5.3. Being fluent in multiple programming languages he loves switching between technologies as needed for the best results.

Hands-on labs
Deploying InnoDB Cluster on Oracle Cloud Infrastructure using Terraform/Resource Manager
Frédéric Descamps
12:50 PM2:50 PM
Deploying InnoDB Cluster on Oracle Cloud Infrastructure using Terraform/Resource Manager
12:50 PM2:50 PM
MySQL InnoDB Cluster provides a complete, high-availability solution for MySQL. MySQL Shell includes AdminAPI, which enables you to easily configure and administer a group of at least three MySQL server instances to function as an InnoDB cluster. Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB clusters, with built-in failover.

Frederic Descamps
Frédéric Descamps MySQL Community Manager Oracle

Frédéric Descamps has been consulting OpenSource and MySQL for over 15 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the first Belgian start-up dedicated 100% to free projects around GNU/Linux. It is in 2011 that lefred joined Percona, one of the leading MySQL-based specialists. He decided to join the MySQL Community Team in 2016 as a MySQL Community Manager for EMEA & APAC. Frédéric is also a regular speaker of OpenSource Conferences.

Agenda in Central European Summer Time (CEST)

9 : 00 AM

Welcome
9:00 AM9:10 AM

9 : 10 AM

Keynote: MySQL 8.0: A Giant Leap for SQL
Tomas Ulin
Mark Leith
9:10 AM9:55 AM
Keynote: MySQL 8.0: A Giant Leap for SQL
9:10 AM9:55 AM
This talk will highlight what is new in MySQL 8.0—a huge step forward for our users. MySQL 8.0 delivers significant improvements on all fronts, such as dramatically improved SQL, GIS, and JSON support. The talk will also cover the MySQL Document Store (MySQL = NoSQL + SQL) and MySQL InnoDB Cluster (HA out of the box) as well as MySQL Shell, which ensures power, freedom, and flexibility for the developer.

Tomas Ulin
Tomas Ulin Vice President, MySQL Engineering Oracle

Tomas Ulin has been working with the MySQL team since 2003, based in Sweden. He is Vice President for the MySQL Engineering team, responsible for the development and maintenance of the MySQL Server, MySQL Cluster, MySQL Connectors, MySQL Workbench, MySQL Enterprise Backup, and MySQL Enterprise Monitor. He is also responsible for the MySQL Database Service on Oracle Cloud, as well as MySQL Support. Prior to working with MySQL he has a background in the telecom industry, working for the Swedish telecom operator Telia and Telecom vendor Ericsson. He has a Masters degree in Computer Science and Applied Physics from Case Western Reserve University and a PhD in Computer Science from the Royal Institute of Technology.

Mark Leith
Mark Leith MySQL Software Development Director Oracle

Mark Leith joined MySQL in 2005 as a Support Engineer, and is now a Software Development Director in Oracle's MySQL Database Service Control Plane team, where he helps lead development of the MySQL Database Service Control Plane and Site Reliability Engineering for the service. He also leads development of MySQL Enterprise Monitor and the Oracle Enterprise Manager Plugin for MySQL. He is the original developer of the sys schema, a collection of views, procedures and functions, that can be used to help interpret Performance Schema and Information Schema data. He also works closely with the MySQL server team on the Performance Schema and MySQL instrumentation in general.

10 : 05 AM

MySQL 8 at Booking.com
Nicolai Plum
10:05 AM10:45 AM
MySQL 8 at Booking.com
10:05 AM10:45 AM
Booking.com has used MySQL for more than 15 years and has built one of the world’s leading online travel agents on MySQL technologies. This talk will describe how we’re using MySQL at Booking.com with a focus on new MySQL 8 features and data processing at large scale.

Topics: Group replication, binary log compression, relational and document data models, database cluster management, and more.

Nicolai Plum
Nicolai Plum Database Engineer Booking.com

Nicolai Plum works in the Database Engineering team of Booking.com managing database product features and service design. His previous roles at Booking.com have ranged widely from Linux systems administration team lead through storage and systems architecture to regulatory compliance and construction project management. Previously he managed UNIX systems for the Internet backbone of UUNET UK and MCI Worldcom. In his spare time he travels the world and takes pictures.

MySQL Performance Tuning
Jesper Wisborg Krogh
10:05 AM10:45 AM
MySQL Performance Tuning
10:05 AM10:45 AM
This session explores topics related to MySQL performance tuning. We will look at Performance Schema and sys schema to identify candidates for optimization, and will use EXPLAIN, EXPLAIN ANALYZE, and Visual Explain to analyze the queries. Based on the analysis, we will add indexes, change the configuration, and rewrite the queries to improve the performance. We will also explore how to use the Performance Schema and sys schema to identify and analyze hot tables, I/O bottlenecks, and lock contention.

Jesper Wisborg Krogh
Jesper Wisborg Krogh Principal Database Reliability Engineer Okta

Jesper has worked with MySQL databases since 2006 both as an SQL developer, a database administrator, and for more than eight years as part of the Oracle MySQL Support team. Currently, he is a database reliability engineer with Okta. He has contributed to the sys schema and four Oracle Certified Professional (OCP) exams for MySQL 5.6 to 8.0. He is the author/co-author of several MySQL books including MySQL 8 Query Performance Tuning. He lives in Sydney, Australia and likes going for walks, listening to music, read, and learning new technologies and features.

10 : 50 AM

Sharding MySQL with Vitess and Kubernetes
Sugu Sougoumaran
10:50 AM11:30 AM
Sharding MySQL with Vitess and Kubernetes
10:50 AM11:30 AM
Vitess is a cloud native clustering and sharding MySQL. With Kubernetes gaining traction as the platform of the future for distributed systems, it’s important for storage systems to find a way to run in such environments. Vitess was originally designed to run on Google’s Borg, which is the predecessor of Kubernetes. In this session, we’ll show how Vitess combines its ability to run in Kubernetes while being able to scale massively.

Sugu Sougoumarane
Sugu Sougoumarane Chief Technology Officer Vitess

Sugu is the co-creator of Vitess, and has been working on it since 2010. Prior to Vitess, Sugu worked on scalability at YouTube and was also part of PayPal in the early days. His recent interest is in distributed systems and consensus algorithms. He occasionally shares his thoughts on his blog https://sougou.io.

Developing NodeJS Applications with MySQL 8.0
Rui Quelhas
10:50 AM11:30 AM
Developing NodeJS Applications with MySQL 8.0
10:50 AM11:30 AM
The last few years saw the advent of JavaScript in the server, and particularly Node.js. The dynamic functional nature of the language and the key philosophy of using schemaless literal objects or the corresponding JSON counterparts to express data-structures. Matching this environment, MySQL recently introduced the MySQL Document Store, which enables using a regular MySQL database to manage schemaless data. This presentation will describe the key concepts of the Document Store alongside the new X protocol that supports it, and will show how to use the X DevAPI with the MySQL Node.js connector.

Rui Quelhas
Rui Quelhas Principal Software Developer Oracle

Rui Quelhas is a Software Developer at Oracle, part of the MySQL Middleware and Clients team, and he is the lead developer of the MySQL X DevAPI Connector for Node.js. His talks have already been a feature on conferences such as Oracle Code One and Percona Live. He’s been an active member of the Node.js community for more than 8 years and has his share of open source contributions both for personal projects or as part of larger organizations such as the node-forward movement and the hapijs maintainer’s network.

11 : 35 AM

Moving On-Premises MySQL Installations to MySQL Database Service Made Fast and Easy
Juan Rene Ramirez Monarrez
11:35 AM12:15 PM
Moving On-Premises MySQL Installations to MySQL Database Service Made Fast and Easy
11:35 AM12:15 PM
The new MySQL Database Service is a fully managed service that brings the feature set of the MySQL Server to the cloud, taking advantage of the computing power and tooling available in Oracle Cloud Infrastructure. A key aspect for the adoption of this new technology is “how to get there?” Moving data from an on-premises MySQL instance to the MySQL Database Service is an important step, and the MySQL Shell provides the functionality to do this operation in an easy and extremely performant way. This solution performs the data backup, restore, and compatibility verification using a parallelized approach at several levels, reducing the time to complete the process to a fraction of the time required by other solutions.

Juan Rene Ramirez Monarrez
Juan Rene Ramirez Monarrez Software Developer Manager Oracle

Rene leads the MySQL Shell project and has been a software engineer for almost 20 years.

He joined Oracle in 2011 into the MySQL Workbench team and moved to the MySQL Shell since it initiated, which has given him the opportunity to contribute in almost every feature with a unique objective in mind: turning it into the #1 frontend for the MySQL product family.

Prior to Oracle he worked as a software engineer for IBM and Freescale Semiconductor (now NXP). He also spent some time on a master degree where he spent lot of time on fun projects: image processing, augmented reality, animation, video games and robotics.

MySQL Replication Performance, Efficiency, and the Cloud
Luís Soares
11:35 AM12:15 PM
MySQL Replication Performance, Efficiency, and the Cloud
11:35 AM12:15 PM
Designing and operating MySQL replication deployments requires knowledge of the intricacies of the underlying technologies. Furthermore, deploying a database system in the cloud makes us deal again with new incarnations of old problems. Slow storage, expensive computing power, and limited and shared network bandwidth are things that one has to deal with again, and that the availability of cheap, highly multicore machines with flash storage was making us forget.

Josh Spiegel
Luís Soares Software Development Director Oracle

Luís Soares is the MySQL Replication Development Director at Oracle. His research interests include replication technologies, dependable systems and high availability. Before joining the MySQL team, he was both a post-graduate student and a researcher at the University of Minho, Portugal, where he designed and implemented group-based replication protocols. Before that, he worked for a Portuguese multi-national company as a system analyst.

12 : 20 PM

MySQL Security Model in Oracle Cloud
Harin Vadodaria
Mike Frank
12:20 PM1:00 PM
MySQL Security Model in Oracle Cloud
12:20 PM1:00 PM
This session provides an overview MySQL security architecture and user model used by MySQL in the cloud. The session explains these features such as roles, system user, partial revokes, and many more.

Harin Vadodaria
Harin Vadodaria Principal MTS Oracle

Harin Vadodaria is security lead at MySQL Engineering team. Harin has been part of MySQL team for more than 8 years and his main focus is MySQL database security. At MySQL, Harin has worked on design and implementation of various features in areas like authentication, user account management, authorization, privileges management, data encryption, keyring integration and communication security. He has overall experience of over 12 years working on database security.

Mike Frank
Mike Frank Product Management Director, MySQL Oracle

Over the past 20 years, Mike has helped organizations formulate and implement complex new products and strategies.

His background spans database development, tools, packaging, security, and backup. He's brought well over 15 new to market products. During 9 years at MySQL he's been instrumental in working with various database and development tools, the MySQL repos, and various security products and features. In 2020, he’s been laser focused on security, bringing many new features to market in MySQL as well as authoring various security guidelines such as CIS and DISA STIG.

As a founder and VP of Products at Gazzang (acq. by Cloudera) he brought to market Linux TDE and a SaaS key management products. As a co-founder and head of products at Idera (acq. by HGGC) he brought to market 5 database management products including SQL Secure, SQL Compliance Manager, and SQLsafe. At PentaSafe (acq. By NetIQ), as Product Author and Product Line Manager, he created a line of products for Security and Risk assessment of Linux and Web Servers. Mikes experience spans databases, operating systems, security, e-business, and trading systems.

MySQL High Availability—InnoDB Cluster and InnoDB ReplicaSet
Kenny Gryp
12:20 PM1:00 PM
MySQL High Availability—InnoDB Cluster and InnoDB ReplicaSet
12:20 PM1:00 PM
MySQL InnoDB Cluster provides a complete, high-availability solution for MySQL. MySQL Shell includes AdminAPI, which enables you to easily configure and administer a group of at least three MySQL server instances to function as an InnoDB cluster. Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB clusters, with built-in failover. MySQL InnoDB ReplicaSet is similar, but does the same for classic MySQL Replication as InnoDB Cluster did for group replication. We take a strong technology that is very powerful but can be complex, and provide an easy-to-use AdminAPI for it in the MySQL Shell. We will show, with a few easy-to-use Shell commands, how to set up a MySQL database architecture.

Kenny Gryp
Kenny Gryp MySQL Product Manager Oracle

Kenny is a MySQL expert with a lot of experience in performance and architecture. While he has focused on MySQL and automation for over a decade, he has also developed expertise in other areas. He’s a well-rounded, multidimensional nerd who is skilled in many things: making a coffee on the side of a mountain, electrical building codes for single family dwellings in the US, the perfect ratio of cumin and asafoetida in tadka dal, and providing occupational therapy to a shy rabbit named Winston. He’s adept at talking, so don’t feel the need to limit in-session questions to MySQL.

1 : 05 PM

MySQL Shell: The Best MySQL DBA Tool
Miguel Araújo
1:05 PM1:45 PM
MySQL Shell: The Best MySQL DBA Tool
1:05 PM1:45 PM
MySQL Shell is the new, advanced command-line client and editor for MySQL. It sends SQL statements to MySQL server, supports both the classic MySQL protocol and the newer X protocol, and provides scripting capabilities for JavaScript and Python. But there's more to MySQL Shell than meets the eye. It delivers a natural and powerful interface for all DevOps tasks related to MySQL by providing APIs for development and administration. This session covers MySQL Shell's core features, along with demonstrations of how to use the various APIs and how to extend MySQL Shell. We’ll address the regular interaction with databases, the built-in tools that make DBAs and developers’ lives easier, the easy and flawless set up of HA architectures, and the plugins and extensions framework.

Miguel Araujo
Miguel Araújo Principal Software Developer Oracle

Miguel Araújo is a Principal Software Engineer on the MySQL Team, at Oracle. He’s the Tech Lead of the AdminAPI, core component of MySQL InnoDB Cluster, at the MySQL Shell team. In the past, he has worked on different projects and teams, mostly related to Middleware and High-Availability. He has a Computer Science Engineering degree and Master’s degree, from the University of Minho, Portugal, where he was also a researcher. His backgrounds are on distributed systems, scalability, database replication and high-availability. He is based in Portugal.

Panel: SQL or NoSQL? Schema or Schemaless?
Morgan Tocker
Markus Winand
Bill Karwin
Moderator: Frédéric Descamps
1:05 PM1:45 PM
Panel: SQL or NoSQL? Schema or Schemaless?
1:05 PM1:45 PM
Whether using a NoSQL store or a relational database, people using modern applications now have a choice in how they structure their data: they can opt for schema or schemaless. But what are the pitfalls of either approach, and what should really be the default choice for new applications? We invite panelists to debate between the advantages of schema and schemaless, so you can make the best choice for designing future applications.

Frédéric Descamps
Frédéric Descamps MySQL Community Manager Oracle

Frédéric Descamps has been consulting OpenSource and MySQL for over 15 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the first Belgian start-up dedicated 100% to free projects around GNU/Linux. It is in 2011 that lefred joined Percona, one of the leading MySQL-based specialists. He decided to join the MySQL Community Team in 2016 as a MySQL Community Manager for EMEA & APAC. Frédéric is also a regular speaker of OpenSource Conferences.

Morgan Tocker
Morgan Tocker Vitess Maintainer, Community Development Manager PlanetScale

Morgan is the former product manager for the MySQL Server, where he was responsible for both schema and schemaless (JSON) functionality. He is currently a maintainer of Vitess, a CNCF project.

Markus Winand
Markus Winand Author, Trainer, Coach winand.at

As the SQL Renaissance Ambassador, it is Markus Winands mission to make developers aware of the evolution of SQL in the 21st century. His book “SQL Performance Explained” has been published in five languages and can be read online free of charge at use-the-index-luke.com. His next book is currently in the works and can already be read online as it’s being written (modern-sql.com). Markus is available as a trainer, speaker and consultant for all companies and developers interested in SQL. You'll find more info at winand.at.

Bill Karwin
Bill Karwin Chief Architect Karwin Software Solutions LLC

Bill Karwin has many years of experience as a database developer, consultant, and trainer. He published the popular book "SQL Antipatterns: Avoiding the Pitfalls of Database Programming." Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

1 : 50 PM

Hands-on labs
Develop and Deploy a Modern Application in NodeJS on MySQL Database Service
Johannes Schlüter
1:50 PM3:50 PM
Develop and Deploy a Modern Application in NodeJS on MySQL Database Service
1:50 PM3:50 PM
It’s time to put things in practice. In this hands-on-session we’ll take the MySQL Database Service in practice and build a cloud-native application using Node.js. Even when you are using a different language, this will provide useful practical experience for building server-less or micro-service architectures using MySQL.

Sanjay Goil
Johannes Schlüter MySQL Scripting Connectors Oracle

Being a member of the MySQL development team for more than 10 years, Johannes Schlüter currently serves as an Software Engineering Manager leading the development of MySQL Connectors for Node.js, PHP and Python. He is a contributor to multiple OpenSource projects, including the PHP language and runtime, where he served as release manger for PHP 5.3. Being fluent in multiple programming languages he loves switching between technologies as needed for the best results.

Hands-on labs
Deploying InnoDB Cluster on Oracle Cloud Infrastructure using Terraform/Resource Manager
Frédéric Descamps
1:50 PM3:50 PM
Deploying InnoDB Cluster on Oracle Cloud Infrastructure using Terraform/Resource Manager
1:50 PM3:50 PM
MySQL InnoDB Cluster provides a complete, high-availability solution for MySQL. MySQL Shell includes AdminAPI, which enables you to easily configure and administer a group of at least three MySQL server instances to function as an InnoDB cluster. Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB clusters, with built-in failover.

Frederic Descamps
Frédéric Descamps MySQL Community Manager Oracle

Frédéric Descamps has been consulting OpenSource and MySQL for over 15 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the first Belgian start-up dedicated 100% to free projects around GNU/Linux. It is in 2011 that lefred joined Percona, one of the leading MySQL-based specialists. He decided to join the MySQL Community Team in 2016 as a MySQL Community Manager for EMEA & APAC. Frédéric is also a regular speaker of OpenSource Conferences.

Agenda in India Standard Time (IST)

12 : 30 PM

Welcome
12:30 PM12:40 PM

12 : 40 PM

Keynote: MySQL 8.0: A Giant Leap for SQL
Tomas Ulin
Mark Leith
12:40 PM1:25 PM
Keynote: MySQL 8.0: A Giant Leap for SQL
12:40 PM1:25 PM
This talk will highlight what is new in MySQL 8.0—a huge step forward for our users. MySQL 8.0 delivers significant improvements on all fronts, such as dramatically improved SQL, GIS, and JSON support. The talk will also cover the MySQL Document Store (MySQL = NoSQL + SQL) and MySQL InnoDB Cluster (HA out of the box) as well as MySQL Shell, which ensures power, freedom, and flexibility for the developer.

Tomas Ulin
Tomas Ulin Vice President, MySQL Engineering Oracle

Tomas Ulin has been working with the MySQL team since 2003, based in Sweden. He is Vice President for the MySQL Engineering team, responsible for the development and maintenance of the MySQL Server, MySQL Cluster, MySQL Connectors, MySQL Workbench, MySQL Enterprise Backup, and MySQL Enterprise Monitor. He is also responsible for the MySQL Database Service on Oracle Cloud, as well as MySQL Support. Prior to working with MySQL he has a background in the telecom industry, working for the Swedish telecom operator Telia and Telecom vendor Ericsson. He has a Masters degree in Computer Science and Applied Physics from Case Western Reserve University and a PhD in Computer Science from the Royal Institute of Technology.

Mark Leith
Mark Leith MySQL Software Development Director Oracle

Mark Leith joined MySQL in 2005 as a Support Engineer, and is now a Software Development Director in Oracle's MySQL Database Service Control Plane team, where he helps lead development of the MySQL Database Service Control Plane and Site Reliability Engineering for the service. He also leads development of MySQL Enterprise Monitor and the Oracle Enterprise Manager Plugin for MySQL. He is the original developer of the sys schema, a collection of views, procedures and functions, that can be used to help interpret Performance Schema and Information Schema data. He also works closely with the MySQL server team on the Performance Schema and MySQL instrumentation in general.

1 : 35 PM

MySQL 8 at Booking.com
Nicolai Plum
1:35 PM2:15 PM
MySQL 8 at Booking.com
1:35 PM2:15 PM
Booking.com has used MySQL for more than 15 years and has built one of the world’s leading online travel agents on MySQL technologies. This talk will describe how we’re using MySQL at Booking.com with a focus on new MySQL 8 features and data processing at large scale.

Topics: Group replication, binary log compression, relational and document data models, database cluster management, and more.

Nicolai Plum
Nicolai Plum Database Engineer Booking.com

Nicolai Plum works in the Database Engineering team of Booking.com managing database product features and service design. His previous roles at Booking.com have ranged widely from Linux systems administration team lead through storage and systems architecture to regulatory compliance and construction project management. Previously he managed UNIX systems for the Internet backbone of UUNET UK and MCI Worldcom. In his spare time he travels the world and takes pictures.

MySQL Performance Tuning
Jesper Wisborg Krogh
1:35 PM2:15 PM
MySQL Performance Tuning
1:35 PM2:15 PM
This session explores topics related to MySQL performance tuning. We will look at Performance Schema and sys schema to identify candidates for optimization, and will use EXPLAIN, EXPLAIN ANALYZE, and Visual Explain to analyze the queries. Based on the analysis, we will add indexes, change the configuration, and rewrite the queries to improve the performance. We will also explore how to use the Performance Schema and sys schema to identify and analyze hot tables, I/O bottlenecks, and lock contention.

Jesper Wisborg Krogh
Jesper Wisborg Krogh Principal Database Reliability Engineer Okta

Jesper has worked with MySQL databases since 2006 both as an SQL developer, a database administrator, and for more than eight years as part of the Oracle MySQL Support team. Currently, he is a database reliability engineer with Okta. He has contributed to the sys schema and four Oracle Certified Professional (OCP) exams for MySQL 5.6 to 8.0. He is the author/co-author of several MySQL books including MySQL 8 Query Performance Tuning. He lives in Sydney, Australia and likes going for walks, listening to music, read, and learning new technologies and features.

2 : 20 PM

Sharding MySQL with Vitess and Kubernetes
Sugu Sougoumaran
2:20 PM3:00 PM
Sharding MySQL with Vitess and Kubernetes
2:20 PM3:00 PM
Vitess is a cloud native clustering and sharding MySQL. With Kubernetes gaining traction as the platform of the future for distributed systems, it’s important for storage systems to find a way to run in such environments. Vitess was originally designed to run on Google’s Borg, which is the predecessor of Kubernetes. In this session, we’ll show how Vitess combines its ability to run in Kubernetes while being able to scale massively.

Sugu Sougoumarane
Sugu Sougoumarane Chief Technology Officer Vitess

Sugu is the co-creator of Vitess, and has been working on it since 2010. Prior to Vitess, Sugu worked on scalability at YouTube and was also part of PayPal in the early days. His recent interest is in distributed systems and consensus algorithms. He occasionally shares his thoughts on his blog https://sougou.io.

Developing NodeJS Applications with MySQL 8.0
Rui Quelhas
2:20 PM3:00 PM
Developing NodeJS Applications with MySQL 8.0
2:20 PM3:00 PM
The last few years saw the advent of JavaScript in the server, and particularly Node.js. The dynamic functional nature of the language and the key philosophy of using schemaless literal objects or the corresponding JSON counterparts to express data-structures. Matching this environment, MySQL recently introduced the MySQL Document Store, which enables using a regular MySQL database to manage schemaless data. This presentation will describe the key concepts of the Document Store alongside the new X protocol that supports it, and will show how to use the X DevAPI with the MySQL Node.js connector.

Rui Quelhas
Rui Quelhas Principal Software Developer Oracle

Rui Quelhas is a Software Developer at Oracle, part of the MySQL Middleware and Clients team, and he is the lead developer of the MySQL X DevAPI Connector for Node.js. His talks have already been a feature on conferences such as Oracle Code One and Percona Live. He’s been an active member of the Node.js community for more than 8 years and has his share of open source contributions both for personal projects or as part of larger organizations such as the node-forward movement and the hapijs maintainer’s network.

3 : 05 PM

Moving On-Premises MySQL Installations to MySQL Database Service Made Fast and Easy
Juan Rene Ramirez Monarrez
3:05 PM3:45 PM
Moving On-Premises MySQL Installations to MySQL Database Service Made Fast and Easy
3:05 PM3:45 PM
The new MySQL Database Service is a fully managed service that brings the feature set of the MySQL Server to the cloud, taking advantage of the computing power and tooling available in Oracle Cloud Infrastructure. A key aspect for the adoption of this new technology is “how to get there?” Moving data from an on-premises MySQL instance to the MySQL Database Service is an important step, and the MySQL Shell provides the functionality to do this operation in an easy and extremely performant way. This solution performs the data backup, restore, and compatibility verification using a parallelized approach at several levels, reducing the time to complete the process to a fraction of the time required by other solutions.

Juan Rene Ramirez Monarrez
Juan Rene Ramirez Monarrez Software Developer Manager Oracle

Rene leads the MySQL Shell project and has been a software engineer for almost 20 years.

He joined Oracle in 2011 into the MySQL Workbench team and moved to the MySQL Shell since it initiated, which has given him the opportunity to contribute in almost every feature with a unique objective in mind: turning it into the #1 frontend for the MySQL product family.

Prior to Oracle he worked as a software engineer for IBM and Freescale Semiconductor (now NXP). He also spent some time on a master degree where he spent lot of time on fun projects: image processing, augmented reality, animation, video games and robotics.

MySQL Replication Performance, Efficiency, and the Cloud
Luís Soares
3:05 PM3:45 PM
MySQL Replication Performance, Efficiency, and the Cloud
3:05 PM3:45 PM
Designing and operating MySQL replication deployments requires knowledge of the intricacies of the underlying technologies. Furthermore, deploying a database system in the cloud makes us deal again with new incarnations of old problems. Slow storage, expensive computing power, and limited and shared network bandwidth are things that one has to deal with again, and that the availability of cheap, highly multicore machines with flash storage was making us forget.

Josh Spiegel
Luís Soares Software Development Director Oracle

Luís Soares is the MySQL Replication Development Director at Oracle. His research interests include replication technologies, dependable systems and high availability. Before joining the MySQL team, he was both a post-graduate student and a researcher at the University of Minho, Portugal, where he designed and implemented group-based replication protocols. Before that, he worked for a Portuguese multi-national company as a system analyst.

3 : 50 PM

MySQL Security Model in Oracle Cloud
Harin Vadodaria
Mike Frank
3:50 PM4:30 PM
MySQL Security Model in Oracle Cloud
3:50 PM4:30 PM
This session provides an overview MySQL security architecture and user model used by MySQL in the cloud. The session explains these features such as roles, system user, partial revokes, and many more.

Harin Vadodaria
Harin Vadodaria Principal MTS Oracle

Harin Vadodaria is security lead at MySQL Engineering team. Harin has been part of MySQL team for more than 8 years and his main focus is MySQL database security. At MySQL, Harin has worked on design and implementation of various features in areas like authentication, user account management, authorization, privileges management, data encryption, keyring integration and communication security. He has overall experience of over 12 years working on database security.

Mike Frank
Mike Frank Product Management Director, MySQL Oracle

Over the past 20 years, Mike has helped organizations formulate and implement complex new products and strategies.

His background spans database development, tools, packaging, security, and backup. He's brought well over 15 new to market products. During 9 years at MySQL he's been instrumental in working with various database and development tools, the MySQL repos, and various security products and features. In 2020, he’s been laser focused on security, bringing many new features to market in MySQL as well as authoring various security guidelines such as CIS and DISA STIG.

As a founder and VP of Products at Gazzang (acq. by Cloudera) he brought to market Linux TDE and a SaaS key management products. As a co-founder and head of products at Idera (acq. by HGGC) he brought to market 5 database management products including SQL Secure, SQL Compliance Manager, and SQLsafe. At PentaSafe (acq. By NetIQ), as Product Author and Product Line Manager, he created a line of products for Security and Risk assessment of Linux and Web Servers. Mikes experience spans databases, operating systems, security, e-business, and trading systems.

MySQL High Availability—InnoDB Cluster and InnoDB ReplicaSet
Kenny Gryp
3:50 PM4:30 PM
MySQL High Availability—InnoDB Cluster and InnoDB ReplicaSet
3:50 PM4:30 PM
MySQL InnoDB Cluster provides a complete, high-availability solution for MySQL. MySQL Shell includes AdminAPI, which enables you to easily configure and administer a group of at least three MySQL server instances to function as an InnoDB cluster. Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB clusters, with built-in failover. MySQL InnoDB ReplicaSet is similar, but does the same for classic MySQL Replication as InnoDB Cluster did for group replication. We take a strong technology that is very powerful but can be complex, and provide an easy-to-use AdminAPI for it in the MySQL Shell. We will show, with a few easy-to-use Shell commands, how to set up a MySQL database architecture.

Kenny Gryp
Kenny Gryp MySQL Product Manager Oracle

Kenny is a MySQL expert with a lot of experience in performance and architecture. While he has focused on MySQL and automation for over a decade, he has also developed expertise in other areas. He’s a well-rounded, multidimensional nerd who is skilled in many things: making a coffee on the side of a mountain, electrical building codes for single family dwellings in the US, the perfect ratio of cumin and asafoetida in tadka dal, and providing occupational therapy to a shy rabbit named Winston. He’s adept at talking, so don’t feel the need to limit in-session questions to MySQL.

4 : 35 PM

MySQL Shell: The Best MySQL DBA Tool
Miguel Araújo
4:35 PM5:15 PM
MySQL Shell: The Best MySQL DBA Tool
4:35 PM5:15 PM
MySQL Shell is the new, advanced command-line client and editor for MySQL. It sends SQL statements to MySQL server, supports both the classic MySQL protocol and the newer X protocol, and provides scripting capabilities for JavaScript and Python. But there's more to MySQL Shell than meets the eye. It delivers a natural and powerful interface for all DevOps tasks related to MySQL by providing APIs for development and administration. This session covers MySQL Shell's core features, along with demonstrations of how to use the various APIs and how to extend MySQL Shell. We’ll address the regular interaction with databases, the built-in tools that make DBAs and developers’ lives easier, the easy and flawless set up of HA architectures, and the plugins and extensions framework.

Miguel Araujo
Miguel Araújo Principal Software Developer Oracle

Miguel Araújo is a Principal Software Engineer on the MySQL Team, at Oracle. He’s the Tech Lead of the AdminAPI, core component of MySQL InnoDB Cluster, at the MySQL Shell team. In the past, he has worked on different projects and teams, mostly related to Middleware and High-Availability. He has a Computer Science Engineering degree and Master’s degree, from the University of Minho, Portugal, where he was also a researcher. His backgrounds are on distributed systems, scalability, database replication and high-availability. He is based in Portugal.

Panel: SQL or NoSQL? Schema or Schemaless?
Morgan Tocker
Markus Winand
Bill Karwin
Moderator: Frédéric Descamps
4:35 PM5:15 PM
Panel: SQL or NoSQL? Schema or Schemaless?
4:35 PM5:15 PM
Whether using a NoSQL store or a relational database, people using modern applications now have a choice in how they structure their data: they can opt for schema or schemaless. But what are the pitfalls of either approach, and what should really be the default choice for new applications? We invite panelists to debate between the advantages of schema and schemaless, so you can make the best choice for designing future applications.

Frédéric Descamps
Frédéric Descamps MySQL Community Manager Oracle

Frédéric Descamps has been consulting OpenSource and MySQL for over 15 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the first Belgian start-up dedicated 100% to free projects around GNU/Linux. It is in 2011 that lefred joined Percona, one of the leading MySQL-based specialists. He decided to join the MySQL Community Team in 2016 as a MySQL Community Manager for EMEA & APAC. Frédéric is also a regular speaker of OpenSource Conferences.

Morgan Tocker
Morgan Tocker Vitess Maintainer, Community Development Manager PlanetScale

Morgan is the former product manager for the MySQL Server, where he was responsible for both schema and schemaless (JSON) functionality. He is currently a maintainer of Vitess, a CNCF project.

Markus Winand
Markus Winand Author, Trainer, Coach winand.at

As the SQL Renaissance Ambassador, it is Markus Winands mission to make developers aware of the evolution of SQL in the 21st century. His book “SQL Performance Explained” has been published in five languages and can be read online free of charge at use-the-index-luke.com. His next book is currently in the works and can already be read online as it’s being written (modern-sql.com). Markus is available as a trainer, speaker and consultant for all companies and developers interested in SQL. You’ll find more info at winand.at.

Bill Karwin
Bill Karwin Chief Architect Karwin Software Solutions LLC

Bill Karwin has many years of experience as a database developer, consultant, and trainer. He published the popular book "SQL Antipatterns: Avoiding the Pitfalls of Database Programming." Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

5 : 20 PM

Hands-on labs
Develop and Deploy a Modern Application in NodeJS on MySQL Database Service
Johannes Schlüter
5:20 PM7:20 PM
Develop and Deploy a Modern Application in NodeJS on MySQL Database Service
5:20 PM7:20 PM
It’s time to put things in practice. In this hands-on-session we’ll take the MySQL Database Service in practice and build a cloud-native application using Node.js. Even when you are using a different language, this will provide useful practical experience for building server-less or micro-service architectures using MySQL.

Sanjay Goil
Johannes Schlüter MySQL Scripting Connectors Oracle

Being a member of the MySQL development team for more than 10 years, Johannes Schlüter currently serves as an Software Engineering Manager leading the development of MySQL Connectors for Node.js, PHP and Python. He is a contributor to multiple OpenSource projects, including the PHP language and runtime, where he served as release manger for PHP 5.3. Being fluent in multiple programming languages he loves switching between technologies as needed for the best results.

Hands-on labs
Deploying InnoDB Cluster on Oracle Cloud Infrastructure using Terraform/Resource Manager
Frédéric Descamps
5:20 PM7:20 PM
Deploying InnoDB Cluster on Oracle Cloud Infrastructure using Terraform/Resource Manager
5:20 PM7:20 PM
MySQL InnoDB Cluster provides a complete, high-availability solution for MySQL. MySQL Shell includes AdminAPI, which enables you to easily configure and administer a group of at least three MySQL server instances to function as an InnoDB cluster. Each MySQL server instance runs MySQL Group Replication, which provides the mechanism to replicate data within InnoDB clusters, with built-in failover.

Frederic Descamps
Frédéric Descamps MySQL Community Manager Oracle

Frédéric Descamps has been consulting OpenSource and MySQL for over 15 years. After graduating in Management Information Technology, Frédéric Descamps started his career as a developer for an ERP under HPUX. He will then opt for a career in the world of open-source by joining one of the first Belgian start-up dedicated 100% to free projects around GNU/Linux. It is in 2011 that lefred joined Percona, one of the leading MySQL-based specialists. He decided to join the MySQL Community Team in 2016 as a MySQL Community Manager for EMEA & APAC. Frédéric is also a regular speaker of OpenSource Conferences.

Join Virtual Hands-on Labs

All you need is your laptop. Oracle Cloud Free Tier accounts will be provided.

  • Develop and Deploy a Modern Application in NodeJS on MySQL Database Service
  • Deploying InnoDB Cluster on Oracle Cloud Infrastructure using Terraform/Resource Manager