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.
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.
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
