Use the new MySQL Shell in MySQL 8, the first modern and advanced client for connecting to and interacting with MySQL. It supports SQL and Python. 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.  covers everything you need to know about the new MySQL Shell. You will learn how to use the new client 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, Group Replication, InnoDB Cluster, and more. The new 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 8 and the new MySQL Shell, you can do both! 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 new MySQL Shell that supports powerful automation through the Python scripting language. weiterlesen