LitArk » Books » Home and family

Charles Bell - Introducing MySQL Shell: Administration Made Easy with Python

Here you can read online Charles Bell - Introducing MySQL Shell: Administration Made Easy with Python full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2019, publisher: Apress, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:

Romance novel Science fiction Adventure Detective Science History Home and family Prose Art Politics Computer Non-fiction Religion Business Children Humor

Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.

Book:
Introducing MySQL Shell: Administration Made Easy with Python
Author:
Charles Bell
Publisher:
Apress
Genre:
Books / Home and family
Year:
2019
Rating:
4 / 5
Favourites:
Add to favourites
Your mark:
- 80
- 1
- 2
- 3
- 4
- 5

Description
Author's other books
Similar books

Introducing MySQL Shell: Administration Made Easy with Python: summary, description and annotation

We offer to read an annotation, description, summary or preface (depends on what the author of the book "Introducing MySQL Shell: Administration Made Easy with Python" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.

Use MySQL Shell, the first modern and advanced client for connecting to and interacting with MySQL. It supports SQL, Python, and JavaScript. Thats 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 Youll 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.

Charles Bell: author's other books

Who wrote Introducing MySQL Shell: Administration Made Easy with Python? Find out the surname, the name of the author of the book and a list of all author's works by series.

Introducing MySQL Shell: Administration Made Easy with Python — read online for free the complete book (whole text) full work

Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Introducing MySQL Shell: Administration Made Easy with Python" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.

Light

Font size:

↓

↑

Reset

Interval:

↓

↑

Bookmark:

Make

Contents

Landmarks

Charles Bell

Introducing MySQL Shell

Administration Made Easy with Python

Charles Bell

Warsaw, VA, USA

Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub via the books product page, located at www.apress.com/9781484250822 . For more detailed information, please visit http://www.apress.com/source-code .

ISBN 978-1-4842-5082-2 e-ISBN 978-1-4842-5083-9

https://doi.org/10.1007/978-1-4842-5083-9

Charles Bell 2019

This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed.

Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights.

While the advice and information in this book are believed to be true and accurate at the date of publication, neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or omissions that may be made. The publisher makes no warranty, express or implied, with respect to the material contained herein.

Distributed to the book trade worldwide by Springer Science+Business Media New York, 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail orders-ny@springer-sbm.com, or visit www.springeronline.com. Apress Media, LLC is a California LLC and the sole member (owner) is Springer Science + Business Media Finance Inc (SSBM Finance Inc). SSBM Finance Inc is a Delaware corporation.

I dedicate this book to my big brother, William E. Bell, who left this world too soon. I miss you, Bill.

Introduction

MySQL has been around a long time. I have had the pleasure of witnessing its evolution firsthand as a software developer for Oracle working on MySQL. I have watched MySQL grow from a small database server for web applications to an enterprise-grade high availability database system. The road has not always been smooth as there have been some bumps along the way, but overall Oracle has demonstrated its commitment to the product and continued its evolution.

A perfect example of this dedication is shown in the creation of MySQL Shell, which is a completely new look at how to create a MySQL client. Not only does it replace the existing venerable client, it expands productivity to include programmatic access to the new MySQL Document store (a NoSQL interface) as well as mechanisms for working with MySQL InnoDB Cluster the next iteration of MySQL high availability.

If you have used the older MySQL client, you will be especially surprised to see how much easier the new MySQL Shell is to use. If that wasnt enough of an incentive, consider you can now write, debug, and execute Python and JavaScript code right from the shell! Yes, we now have scripting capability native to the new client. Yippee!

This book will give you an introduction to MySQL Shell and teach you how to use it for SQL development, working with databases (SQL), writing scripts to interact with the MySQL Document Store to create NoSQL applications, and even how to use Python to work with high availability features such as MySQL Replication, Group Replication and InnoDB Cluster. As you will see, MySQL Shell is the one source for all these uses.

Intended Audience

I wrote this book to share my passion for MySQL and the giant leap forward for MySQL users. I especially wanted to show just how easy and sophisticated MySQL Shell has become. Now, anyone can use MySQL Shell to increase their productivity no matter whether theyre working with SQL, NoSQL, or even InnoDB Cluster. The intended audience includes anyone interested in learning about working with MySQL such as database administrators, developers, information technology managers, systems architects, and strategic planners.

How This Book Is Structured

The book was written to guide the reader from a general knowledge of MySQL Shell by introducing its features using example scenarios such as SQL and NoSQL development with the X Developer API (X DevAPI) via Python examples, managing MySQL Replication and Group Replication, working with MySQL InnoDB Cluster via Python scripts, and how to set up and configure MySQL Shell.

The first several chapters cover general topics such as what MySQL Shell is, its features, and how to install it on your system. Later chapters present four scenarios for using MySQL Shell including working with SQL databases with Python, working with MySQL Document Store with Python, configuring MySQL Replication and Group Replication, and setup and managing MySQL InnoDB Cluster with Python. Each of these chapters is presented with an introduction for each topic followed by a companion chapter that presents a detailed example to illustrate the concepts.

Chapter , Introducing MySQL Shell: This chapter introduces MySQL Shell including a brief tour of the new features in MySQL realized in the shell.
Chapter , Installing the MySQL Shell: This chapter discusses and presents an example of how to download and install MySQL Shell on Windows, macOS, and Linux.
Chapter , MySQL Shell Tutorial: This chapter presents a short tutorial on the commands and options used in MySQL Shell, how to use the shell to connect to MySQL servers, and how to work with the shell.
Chapter , Using the Shell with SQL Databases: This chapter briefly discusses working with relational databases including a brief look at the more common SQL commands and functions.
Chapter , Example: SQL Database Development: This chapter presents a complete Flask Python web application that demonstrates how to use MySQL Shell to develop the Python modules for the SQL application.
Chapter , Using the Shell with a Document Store: This chapter briefly introduces JSON documents and the MySQL Document Store including a brief demonstration of the Document Store. The chapter also demonstrates how to use JSON in SQL databases.
Chapter , Example: Document Store Development: This chapter presents a complete Flask Python web NoSQL application that demonstrates how to use MySQL Shell to develop the Python modules for the NoSQL application.
Chapter , Using the Shell with MySQL Replication: This chapter presents an overview of the high availability features in MySQL including a brief tutorial on MySQL Replication.
Chapter , Example: Group Replication Setup and Administration: This chapter presents a short tutorial on Group Replication including a demonstration of how to use MySQL Shell to configure MySQL Group Replication. The chapter also demonstrates how failover works in MySQL Group Replication.

Light

Font size:

↓

↑

Reset

Interval:

↓

↑

Bookmark:

Make

Similar books «Introducing MySQL Shell: Administration Made Easy with Python»

Look at similar books to Introducing MySQL Shell: Administration Made Easy with Python. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.

Sveta Smirnova

MySQL Cookbook: Solutions for Database Developers and Administrators

KUMAR

Python Beginner To Pro: Python Tutorial, File Handling, Python NumPy, Python Matplotlib, Python SciPy, Machine Learning, Python MySQL,Python MySQL, Python Reference, Module Reference, Python Examples

Zaitsev Peter

High Performance MySQL

Feuerstein Steven

MySQL stored procedure programming [building high-peformance web applications with PHP, Perl, Python, Java & .NET ; covers MySQL 5]

King Tim

Managing and using MySQL

David Stokes

MySQL and JSON: A Practical Programming Guide

Jesper Wisborg Krogh

MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers

Boronczyk T.

Jump Start MySQL

Bagaria G.

MySQL for Beginners

Charles Bell

MySQL High Availability: Tools for Building Robust Data Centers

Steve Suehring

PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies

Kevin Yank

PHP & MySQL: Novice to Ninja

Reviews about «Introducing MySQL Shell: Administration Made Easy with Python»

Discussion, reviews of the book Introducing MySQL Shell: Administration Made Easy with Python and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.