Updates to Code for MySQL Concurrency – v1.1 and v1.2

When I wrote the book MySQL Concurrency I included a Python module for MySQL Shell that would help reproducing the examples in the book. Since things change, it has been necessary to update the code. In this blog I will explain what the changes are which also give me a chance to say thanks to those that have submitted pull requests.

MySQL Concurrency
MySQL Concurrency

Version v1.1 was mostly about correcting the directory structure of the repository which was not as it was meant to be – and different from the instructions in the book. Additionally some files with code listings and images were missing. Finally, I added a check whether the set_current_schema() method is available for the session in the load() method. This check is needed as only the new X Protocol (the default for MySQL Shell) supports setting the default schema in MySQL Shell modules.

Version v1.2 updates the load() feature to work with the new download location for the world schema. It has been moved from https://downloads.mysql.com/docs/world.sql.zip to https://downloads.mysql.com/docs/world-db.zip, and the world.sql file is now located inside the world-db folder after unzipping the file.

Thank You!

Thank you to shalk (xiao kun) for the patch updating the locations and to black-lotus (Dondon) for a similar patch.

If you do run into problems with the module or find any issues in the book, feel free to bring it to my attention, and I will do my best to rectify it.

I have worked with MySQL databases since 2006 both as an SQL developer, a database administrator, and for more than eight years as part of the Oracle MySQL Support team. I have spoken at MySQL Connect and Oracle OpenWorld on several occasions. I have contributed to the sys schema and four Oracle Certified Professional (OCP) exams for MySQL 5.6 to 8.0. I have written four books, all published at Apress.

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.