Klienditugi: 7440010 (E-R 10-18)

Abi | Registreeri | Logi sisse

E-raamat: Introducing MySQL Shell: Administration Made Easy with Python

4.00/5 (3 hinnangut Goodreads-ist)

Charles Bell

Formaat: EPUB+DRM
Ilmumisaeg: 04-Sep-2019
Kirjastus: APress
Keel: eng
ISBN-13: 9781484250839

Teised raamatud teemal:

MySQL

Formaat - EPUB+DRM
Hind: 49,39 €*
* hind on lõplik, st. muud allahindlused enam ei rakendu
Lisa ostukorvi
Lisa soovinimekirja
See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.

Formaat: EPUB+DRM
Ilmumisaeg: 04-Sep-2019
Kirjastus: APress
Keel: eng
ISBN-13: 9781484250839

Teised raamatud teemal:

MySQL

DRM piirangud

Kopeerimine (copy/paste):

ei ole lubatud
Printimine:

ei ole lubatud
Kasutamine:

Digitaalõiguste kaitse (DRM)
Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

Vajalik tarkvara
Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

Seda e-raamatut ei saa lugeda Amazon Kindle's.

Intermediate-Advanced user level

Use MySQL Shell, the first modern and advanced client for connecting to and interacting with MySQL. It supports SQL, Python, and JavaScript. That’s right! You can write Python scripts and execute them within the shell interactively, or in batch mode. The level of automation available from Python combined with batch mode is especially helpful to those practicing DevOps methods in their database environments.

Introducing MySQL Shell covers everything you need to know about MySQL Shell. You will learn how to use the shell for SQL, as well as the new application programming interfaces for working with a document store and even automating your management of MySQL servers using Python. The book includes a look at the supporting technologies and concepts such as JSON, schema-less documents, NoSQL, MySQL Replication, Group Replication, InnoDB Cluster, and more.

MySQL Shell is the client that developers and database administrators have been waiting for. Far more powerful than the legacy client, MySQL Shell enables levels of automation that are useful not only for MySQL, but in the broader context of your career as well. Automate your work and build skills in one of the most in-demand languages. With MySQL Shell, you can do both!

What You'll Learn

Use MySQL Shell with the newest features in MySQL 8
Discover what a Document Store is and how to manage it with MySQL Shell
Configure Group Replication and InnoDB Cluster from MySQL Shell
Understand the new MySQL Python application programming interfaces
Write Python scripts for managing your data and the MySQL high availability features

Who This Book Is For

Developers and database professionals who want to automate their work and remain on the cutting edge of what MySQL has to offer. Anyone not happy with the limited automation capabilities of the legacy command-line client will find much to like in this book on the MySQL Shell that supports powerful automation through the Python scripting language.

About the Author

xiii

About the Technical Reviewer

Acknowledgments

xvii

Introduction

xix

Chapter 1 Introducing the MySQL Shell

(28)

Getting To Know the MySQL Shell

(7)

Overview

(3)

Features

(4)

Old Features New Again

(8)

JSON Data Type

(6)

X Plugin, X Protocol, and X DevAPI

(1)

InnoDB Improvements

(1)

New Features

(6)

Data Dictionary

(1)

Account Management

(2)

Removed Options, Variables, and Features

(2)

Paradigm Shifting Features

(3)

Document Store

(1)

Group Replication

(1)

InnoDB Cluster

(1)

Summary

(3)

Chapter 2 Installing the MySQL Shell

(46)

Preparing to Install the MySQL Shell

(3)

Prerequisites

(1)

How to Get the MySQL Shell

(2)

Installing on Windows with the MySQL Installer

(17)

Installing on macOS

(13)

Installing MySQL Server

(6)

Installing the MySQL Shell

(5)

Installing on Linux (Ubuntu) with the APT Repository

(11)

Downloading the APT Repository

(2)

Installing the APT Repository

(1)

Installing MySQL Server

(4)

Installing MySQL Shell

(3)

Summary

(2)

Chapter 3 MySQL Shell Tutorial

(44)

Commands and Options

(8)

Starting the MySQL Shell

(1)

Commands

(3)

Options

(3)

Getting Started with the MySQL Shell

(5)

Sessions and Modes

(3)

Using Connections

(5)

Using a URI

(2)

Using Individual Options

(1)

Using Connections in Scripts

(1)

Using SSL Connections

(2)

Working with the MySQL Shell

(25)

Installing the Sample Database

(3)

Working with Data

(8)

Using Formatting Modes

104

(4)

Code/Command History

108

(1)

Saving Passwords

109

(2)

Customizing the Shell

111

(4)

Working with Saved Passwords

115

(1)

Changing the Prompt

116

(2)

Summary

118

(1)

Chapter 4 Using the Shell with SQL Databases

119

(58)

Revisiting Relational Databases

119

(5)

Working with MySQL Commands and Functions

124

(22)

Terminology

124

(1)

Creating Users and Granting Access

125

(1)

Creating Databases and Tables

126

(3)

Storing Data

129

(1)

Updating Data

130

(1)

Deleting Data

131

(1)

Selecting Data (Results)

132

(7)

Creating Indexes

139

(1)

Creating Views

140

(1)

Simple Joins

141

(3)

Additional Advanced Concepts

144

(2)

Managing Your Database with Python

146

(29)

MySQL X Module

147

(7)

CRUD Operations (Relational Data)

154

(16)

Getting Started Writing Python Scripts

170

(5)

Summary

175

(2)

Chapter 5 Example: SQL Database Development

177

(54)

Getting Started

177

(15)

Sample Application Concept

178

(3)

Database Design

181

(9)

Code Design

190

(2)

Setup and Configuration

192

(2)

Demonstration

194

(36)

MyGarage Class

195

(7)

Location Class

202

(7)

Vendor Class

209

(9)

Handtool Class

218

(2)

Organizer Class

220

(1)

Place Class

221

(1)

Powertool Class

221

(1)

Storage Class

222

(1)

Testing the Class Modules

222

(8)

Summary

230

(1)

Chapter 6 Using the Shell with a Document Store

231

(44)

Overview

231

(5)

Origins: Key, Value Mechanisms

232

(2)

Application Programming Interface

234

(1)

NoSQL Interface

234

(1)

Document Store

235

(1)

JSON

235

(1)

Introducing JSON Documents in MySQL

236

(1)

Quick Start

237

(2)

Combining SQL and JSON

239

(33)

Formatting JSON Strings in MySQL

240

(1)

Using JSON Strings in SQL Statements

241

(3)

Path Expressions

244

(5)

JSON Functions

249

(23)

Summary

272

(3)

Chapter 7 Example: Document Store Development

275

(62)

Getting Started

275

(17)

Sample Application Concept

276

(5)

Schema Design

281

(10)

Code Design

291

(1)

Setup and Configuration

292

(18)

Converting Relational Data to a Document Store

293

(15)

Importing Data to a Document Store

308

(2)

Demonstration

310

(24)

MyGarage Class

311

(8)

Collection Base Class

319

(9)

Testing the Class Modules

328

(6)

Summary

334

(3)

Chapter 8 Using the Shell with Group Replication

337

(30)

Overview

338

(10)

What is High Availability?

338

(3)

MySQL High Availability Features

341

(1)

What is MySQL Replication?

342

(2)

What is Group Replication?

344

(4)

Setup and Configuration

348

(1)

Tutorial

349

(17)

Initialize the Data Directories

350

(1)

Configure the Master

351

(2)

Configure the Slaves

353

(2)

Start the MySQL Instances

355

(2)

Create the Replication User Account

357

(1)

Connect the Slaves to the Master

358

(2)

Start Replication

360

(3)

Verify Replication Status

363

(2)

Shutting Down Replication

365

(1)

Summary

366

(1)

Chapter 9 Example: Group Replication Setup and Administration

367

(26)

Getting Started

367

(4)

Concepts, Terms, and Lingo

368

(2)

Group Replication Fault Tolerance

370

(1)

Setup and Configuration

371

(1)

Tutorial

371

(17)

Initialize the Data Directories

373

(1)

Configure the Primary

374

(5)

Start the MySQL Instances

379

(2)

Create the Replication User Account

381

(1)

Start Group Replication on the Primary

382

(1)

Connect the Secondaries to the Primary

382

(1)

Start Group Replication on the Secondaries

383

(1)

Verify Group Replication Status

383

(5)

Shutting Down Group Replication

388

(1)

Demonstration of Failover

388

(3)

Summary

391

(2)

Chapter 10 Using the Shell with InnoDB Cluster

393

(20)

Overview

393

(12)

InnoDB Storage Engine

397

(6)

MySQL Shell

403

(1)

X DevAPI

403

(1)

AdminAPI

403

(1)

MySQL Router

404

(1)

Using InnoDB with Applications

405

(2)

Setup and Configuration

407

(5)

Upgrade Checker

407

(4)

Overview of Installing InnoDB Cluster

411

(1)

Summary

412

(1)

Chapter 11 Example: InnoDB Cluster Setup and Administration

413

(38)

Getting Started

413

(8)

dba

414

(5)

cluster

419

(2)

Setup and Configuration

421

(24)

Create and Deploy Instances in the Sandbox

423

(3)

Create the Cluster

426

(2)

Add the Instances to the Cluster

428

(2)

Check the Status of the Cluster

430

(2)

Failover Demonstration

432

(5)

Using MySQL Router

437

(8)

Administration

445

(5)

Common Tasks

446

(1)

Example Tasks

447

(3)

Summary

450

(1)

Chapter 12 Appendix

451

(42)

Setup Your Environment

451

(7)

Installing Flask

453

(1)

Installing Flask-Script

454

(1)

Installing Flask-Bootstrap

455

(1)

Installing Flask-WTF

456

(1)

Installing WTForms

457

(1)

Installing Connector/Python

457

(1)

Flask Primer

458

(22)

Terminology

459

(2)

Initialization and the Application Instance

461

(9)

HTML Files and Templates

470

(7)

Error Handlers

477

(2)

Redirects

479

(1)

Additional Features

480

(1)

Flask Review: Sample Application

480

(13)

Preparing Your PC

481

(2)

Running the Sample Application

483

(6)

How to Use the Application

489

(1)

CRUD Operations in the Application

490

(1)

Shutting Down the Sample Application

491

(2)

Index

493

Charles Bell conducts research in emerging technologies. He is a member of the Oracle MySQL Development team and is the team lead for the MySQL Utilities 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. Dr. Bell is an expert in the database field, with extensive knowledge and experience in software development and systems engineering. His research interests include 3D printers, microcontrollers, three-dimensional printing, database systems, cloud 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. Dr. Bell maintains a blog on his research projects and many other interests.

Lisainfo e-raamatute kohta