Introducing MySQL Shell: Administration Made Easy with Python

MySQL Shell brings SQL work, scripting, and database administration into one command-line environment. In Introducing MySQL Shell: Administration Made Easy with Python, Charles Bell moves from getting the shell installed to using it in practical database and high-availability scenarios, with Python automation woven throughout.

The book pairs explanations of MySQL concepts with tutorials and example development projects. It also explores the Document Store and JSON, offering a view of how relational and document-oriented approaches can be used with MySQL.

Start with the Shell, Then Put It to Work

Early chapters introduce MySQL Shell, installation, connections, and a guided tutorial. From there, Bell shows how to use the shell with SQL databases, including database operations and Python scripts. This gradual structure gives readers a path from initial setup toward more involved development and administration tasks.

Relational Data Meets the Document Store

The book covers both SQL databases and MySQL’s Document Store. Its discussion of JSON and document-based data, followed by example application development, helps readers compare these approaches in the context of MySQL rather than treating them as unrelated technologies.

Administration and High Availability

Later chapters turn to Group Replication and InnoDB Cluster, with explanations and setup examples. Python scripting and shell-based management are central to the book’s treatment of automation, making these sections relevant to readers interested in repeatable administration workflows.

A Practical Reference for MySQL Professionals

Developers and database professionals looking to explore MySQL Shell, its Python APIs, database scripting, or MySQL high-availability features will find a structured introduction here. Published in 2019, the book reflects the MySQL 8 era; check version-specific instructions against the environment you use today.