Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

MySQL document store: SQL and NoSQL united

MySQL document store: SQL and NoSQL united

 24 April - 9:30 AM - 12:30 PM @ Ballroom H
Experience level: 
Intermediate
Duration: 
3 hours tutorial
Tracks:
Developer
Topics:
MySQL
Programming
NoSQL

Description

MySQL 5.7 has introduced another protocol for communication with the database, which allows asynchronous operations and native document store handling. Since the changes are huge, both developers and DBAs are uncertain about what can be done and how. This tutorial will guide the attendees through the basics of the X-Protocol, with examples of using the document store using the new shell and programmatically. The tutorial covers: * Architecture * Plugin and shell installation * Simple shell usage * Programmatic usage * Loading JSON data * Search methods * CRUD operations * Internals: how the data is stored in the database * Document store in replication * Exporting data to MongoDB * Importing data from MongoDB Attendees will learn the basics of document store architecture and operations, and be able of importing and exporting data using X-Protocol.

Speakers

Giuseppe Maxia's picture

Giuseppe Maxia

Quality Assurance Architect, VMware

Biography:

Quality Assurance Architect at VMware. Formerly at MySQL AB, and then through acquisitions at Sun Microsystems and Oracle. Then at Continuent, Inc and currently at VMware through a merge. I am active member of the MySQL community and long timer open source enthusiast. During the past decades I have worked in various IT related fields, with focus on databases, object oriented programming, system administration, quality assurance. Fluent in Italian, English, Perl, Python, SQL, Spanish, C, Bash, and good speaker of C , French, Java. I work in cyberspace, with a virtual team.

Share this talk