MySQL Shell Scripting

[Simon Tann]

Hi Guys

Background - I took over from my predecessor two years and have been using his python scripts and writing bash scripts to perform specific tasks on our DB's such as DB refreshes, creation of db users, etc.

We are now upgrading to MySQL 8.0.37 Replicasets and then to InnoDB Clustersets, so I want to learn MySQL Shell, and at the same time, I would like to enforce some consistency. We are also looking at modularising our scripts so that they can be called individually to do stuff like stop and start the DBs to make automating tasks easier.

So, while there is obviously more than one way to skin a cat, am I wondering if I am torturing myself for no reason for trying to script everything in javascript for use with MySQL Shell?

Is that what you folks would do, or would you instead create scripts using other languages (bash, etc) and call MySQL Shell from those?

Finally, are there any resources/tutorials that are helpful for scripting in MySQL Shell, as my Google results always return the wrong results due to the preponderance of articles about MySQL, Shell and Scripting that is not MySQL Shell Scripting!

Thanks in advance!