I’ve created and another module for this besides the mysql_replication named mysql_variables.
The purpose of this module to get/set variables from running MySQL servers, and avoid to use shell module for this, because that is a bit frustrating, and there are long commands to run.
For example, when you wanna to set read_only mode via shell, you can do that like this: