Introducing the MySQL 8 Document Store
:
Charles Bell
:
Introducing the MySQL 8 Document Store
:
Apress
:
9781484227251
:
1
:
CHF 50.40
:
:
Informatik
:
English
:
545
:
Wasserzeichen/DRM
:
PC/MAC/eReader/Tablet
:
PDF
Learn the new Document Store feature of MySQL 8 and build applications around a mix of the best features from SQL and NoSQL database paradigms. Don't allow yourself to be forced into one paradigm or the other, but combine both approaches by using the Document Store.
MySQL 8 was designed from the beginning to bridge the gap between NoSQL and SQL. Oracle recognizes that many solutions need the capabilities of both. More specifically, developers need to store objects as loose collections of schema-less documents, but those same developers also need the ability to run structured queries on their data. With MySQL 8, you can do both!
?
< >Introducing the MySQL 8 Document Store presents new tools and features that make creating a hybrid database solution far easier than ever before. This book covers the vitally important MySQL Document Store, the new X Protocol for developing applications, and a new client shell called the MySQL Shell. Also covered are supporting technologies and concepts such as JSON, schema-less documents, and more. The book gives insight into how features work and how to apply them to get the most out of your MySQL experience. The book covers topics such as:
The headline feature in MySQL 8
MySQL's answer to NoSQL
New APIs and client protocols
Wh t You'll Learn
Create NoSQL-style applications by using the Document Store
Mix the NoSQL and SQL approaches by using each to its best advantage in a hybrid solution
Work with the new X Protocol for application connectivity in MySQL 8
Master the new X Developer Application Programming Interfaces
Combin SQL and JSON in the same database and application
Migra e existing applications to MySQL Document Store
Who This Book Is For
< r>
Developers and database professionals wanting to learn about the most profound paradigm-changing features of the MySQL 8 Document Store
Charles Bell
conducts research in emerging technologies. He is a member of the Oracle MySQL Development team, and is a senior software developer for the MySQL Enterprise Backup team. He lives in a small town in rural Virginia with his loving wife. He received his Doctor of Philosophy in Engineering from Virginia Commonwealth University in 2005.
Charles is an expert in the database field and has extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, software engineering, and sensor networks. He spends his limited free time as a practicing Maker, focusing on microcontroller projects and refinement of three-dimensional printers.
Table of Contents
5
About the Author
12
About the Technical Reviewer
13
Acknowledgments
14
Introduction
15
Chapter 1: Introducing MySQL 8 A New Beginning
20
Old Features New Again
22
JSON Data Type
23
MySQL Shell
27
X Plugin, X Protocol, and X DevAPI
31
InnoDB Improvements
33
New Features
35
Data Dictionary
36
Account Management
37
Removed Options, Variables, and Features
38
Paradigm Shifting Features
39
Group Replication
40
InnoDB Cluster
44
Summary
53
Chapter 2: Getting Started with MySQL
55
Getting to Know MySQL
55
How Do I Connect to MySQL?
57
How to Get and Install MySQL
60
Configuring and Managing Access to MySQL
66
Configuration Files
66
Creating Users and Granting Access
69
Configuring the Document Store
70
A MySQL Primer
72
Creating Databases and Tables
72
Searching for Data
75
Creating Data
79
Updating Data
80
Deleting Data
81
Using Indexes
82
Views
83
Triggers
83
Simple Joins
84
Stored Routines
87
Summary
88
Chapter 3: JSON Documents
90
Concepts and Technologies: Jargon Explained
91
Origins: Key, Value Mechanisms
91
JSON
93
Application Programming Interface
93
NoSQL Interface
94
Document Store
95
Introducing JSON Documents
96
JSON Format Rules
96
Using JSON in MySQL
98
Path Expressions
103
JSON Functions
111
Creating JSON Data
113
Modifying JSON Data
119
Searching JSON Data
122
Utility Functions
132
Combining SQL and JSON - Indexing JSON Data
142
Summary
150
Chapter 4: The MySQL Shell
151
Getting Started
152
Features
153
Shell Commands
155
Options
157
Sessions and Modes
160
Session Objects
160
Modes Supported
162
Connections
162
Using a URI
163
Using Individual Options
164
Using Connections in Scripts
165
Using SSL Connections
166
Set Up and Install
166
Install the MySQL Shell
167
Setup the X Plugin
171
Enable the X Plugin Using the MySQL Shell
172
Enable the X Plugin Using the MySQL Client
172
Tutorial: MySQL Shell by Example
174
Installing the Sample Database
175
SQL
178
JavaScript
185
Python
188
Summary
190
Chapter 5: X Developer API
191
Overview
192
Clients
193
Target Language
