Apress have been kind enough to invite me to write a blog in connection with my recently released book MySQL Connector/Python Revealed. I chose to write an introduction of MySQL Connector/Python including three examples illustrating the APIs and the difference between querying SQL tables and a JSON document store.
When you write programs that uses a database backend, it is necessary to use a connector/API to submit the queries and retrieve the result. If you are writing Python programs that used MySQL, you can use MySQL Connector/Python – the connector developered by Oracle Corporation.
Now there is a new book dedicated to the usage of the connector: MySQL Connector/Python Revealed, which is published by Apress. It is available in a softcover edition as well as an eBook (PDF, ePub, Mobi).
The book is divided into four parts spanning from the installation to error handling and troubleshooting. The four parts are:
Part I: Getting Ready This part consists of a single chapter that helps you to get up and running. The chapter includes an introduction to MySQL Connector/Python and getting the connector and MySQL Server installed.
Part II: The Legacy APIs The legacy APIs include the connector module that implements PEP249 (the Python Database API). The discussion of the mysql.connector module spans four chapters. In addition to query execution, the use of connection pools and the failover feature is covered. Finally, there is also a discussion about the C Extension.
Part III – The X DevAPI One of the big new features in MySQL 8 is the MySQL Document Store including the X DevAPI. It allows you to use MySQL through the NoSQL API as well as by executing SQL queries. The NoSQL API includes support both for working with MySQL as a document store where the data is stored in JSON documents and with SQL tables. Part III includes three chapters that are dedicated to the X DevAPI.
Part IV – Error Handling and Troubleshooting The final part of book goes through the two important topics of error handling and troubleshooting including several examples of how common errors and how to resolve them.
With the book comes 66 code examples that are available for download from Apress’ GitHub repository. See the book’s homepage for instructions.
MySQL Connector/Python is available from several sources including online bookshops. The following table shows some of the places, where you can buy the book. (The table if current as of 13 August 2018; changes to the available formats may happen in the future.)
I have had the opportunity to write a blog for Apress with a brief introduction to MySQL NDB Cluster. The blog gives a brief overview of the history and why you should consider it. The architecture is described before some key characteristics are discussed.
It is with great pleasure, I can announce that a new book dedicated to MySQL NDB Cluster has just been released. The book Pro MySQL NDB Cluster is written by my colleague Mikiya Okuno and myself and is a nearly 700 pages deep dive into the world of MySQL NDB Cluster. The book is published by Apress.
Tip: There are several ways to cluster MySQL. This book is about the product MySQL Cluster (often called MySQL NDB Cluster to clarify which cluster it is). There is also MySQL InnoDB Cluster, clustering using replication, and clustering through operating or hardware features. Pro MySQL NDB Cluster is only about the former.
We very much hope you will enjoy the book. Feedback and questions are most welcome, for example on Twitter (@nippondanji and @JWKrogh).
Note: At the time of writing, only the eBook is available for purchase. A softcover version will follow as soon as it has been possible to print it; this can also be pre-ordered now. – Update: The softcover version of the book is now also available.
The book is divided into five parts and 20 chapters.
Part I – The Basics
The first part provides some background information on the various parts in MySQL NDB Cluster and how it works. The chapters are:
Chapter 1: Architecture and Core Concepts
Chapter 2: The Data Nodes
Part II – Installation and Configuration
The second part focuses on the installation and configuration related topics, including replication between clusters. The chapter are:
Chapter 3: System Planning
Chapter 4: Configuration
Chapter 5: Installation
Chapter 6: Replication
Part III – Daily Tasks and Maintenance
In the third part, the topics include tasks that is part of the daily routine as a database administrator plus a tutorial where the tasks discussed in parts II and III are handled through MySQL Cluster Manager. The chapters are:
Chapter 7: The NDB Management Client and Other NDB Utilities
Chapter 8: Backups and Restores
Chapter 9: Table Maintenance
Chapter 10: Restarts
Chapter 11: Upgrades and Downgrades
Chapter 12: Security Considerations
Chapter 13: MySQL Cluster Manager
Chapter IV – Monitoring and Troubleshooting
The fourth part continues with two topics that are also part of the daily routine: monitoring and troubleshooting. The chapters are:
Chapter 14: Monitoring Solutions and the Operating System
Chapter 15: Sources for Monitoring Data
Chapter 16: Monitoring MySQL NDB Cluster
Chapter 17: Typical Troubles and Solutions
Chapter V – Development and Performance Tuning
The final part covers topics that are related to development and getting the tuning the cluster with respect to performance. The chapters are:
Chapter 18: Developing Applications Using SQL with MySQL NDB Cluster
Chapter 19: MySQL NDB Cluster as a NoSQL Database
Chapter 20: MySQL NDB Cluster and Application Performance Tuning