Аннотация

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 wasn’t 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.