Past Meetup

MySQL InnoDB Cluster, Common Table Expressions, and Window Functions

This Meetup is past

41 people went

Location visible to members

Details

Common Table Expressions & Window Functions - Øystein Grøvlen (@ogrovlen)

Abstract:

Two new SQL features in MySQL 8.0 are presented in this session; Common Table Expressions (CTE) and Window Functions.In their simplest form, CTEs are a way of creating a view/temporary table for usage in a single query. However, they have many more use cases. In particular, when using the RECURSIVE form of CTEs, it is possible to perform advanced tasks with few lines of code. This session will present several examples on how you can benefit from using CTEs.A window function performs a calculation across a set of table rows that are somehow related to the current row. Such functions can be used in many ways to analyze your data. We will give an introduction and quick overview of the feature set and examples of interesting use cases.

Biography:

Øystein Grøvlen is a Senior Principal Software Engineer in the MySQL group at Oracle, where he works on the MySQL Query Optimizer.Dr. Grøvlen has a PhD in Computer Science from the Norwegian University of Science and Technology. Before joining the MySQL team 9 years ago, he was a contributor on the Apache Derby project and Sun's Architectural Lead on Java DB. Prior to that, he worked for 10 years on the development of Clustra, a highly available DBMS. Øystein lives in Trondheim, Norway.

MySQL InnoDB Cluster: MySQL HA made easy ;) - Frédéric Descamps (@lefred)

Abstract:

Compared to existing HA solutions for MySQL, MySQL InnoDB Cluster, being an internal implementation, is extremely easy to use. During this session, you will have to possibility to meet all the components being part of the solution like MySQL Shell, MySQL Router but also have detailed description on how the heart of the solution, MySQL Group Replication, is working.

Biography:

Frédéric Descamps is MySQL Community Manager for EMEA & APAC at Oracle. Frédéric is probably better known in the community as “LeFred”! He joined the MySQL Community Team in May 2016. "@lefred" has been an OpenSource and MySQL consultant for more than 15 years. His favorite topics are High Availability and Performance. LeFred is also a convinced devops believer that lives in Belgium.

------------- Logistics -------------

MIT's map with the building (E51) highlighted: http://whereis.mit.edu/map-jpg?selection=E5... (http://whereis.mit.edu/map-jpg?selection=E51&Buildings=go)

MIT's map with the Kendall square T stop highlighted: http://whereis.mit.edu/map-jpg?selection=L5... (http://whereis.mit.edu/map-jpg?selection=L5&Landmarks=go) (the stop is in red on that map, and you can see E51 in the bottom right)

MIT's maps with parking lot information: http://whereis.mit.edu/map-jpg?selection=P4... (http://whereis.mit.edu/map-jpg?selection=P4&Parking=go) and http://whereis.mit.edu/map-jpg?selection=P5... (http://whereis.mit.edu/map-jpg?selection=P5&Parking=go)

Note that MIT lots are free to park in after 3 pm or so, even if it says "reserved for faculty"

Free pizza and soda will be served, so please RSVP accurately.

To RSVP anonymously, please login to the Meetup site with the e-mail address "admin at sheeri dot com" and the password "guest". For more information, see: http://www.meetup.com/mysqlbos/calendar/