There are couple of problems that I see:-
1) First , there is some problem in your os package manager. Try to manually run sudo apt-get/yum update, on cation-cdh-mgr1/edge/dn-0 machines and fix the errors with the package manager that come.(you can easily find solution at askubuntu.com )
2)The salt highstate command fails on mgr1 because of that os pkg mgr problem and not proceeds to install and create mysql database.
3)You can manually run these salt commands in your cluster. The scripts are in /var/lib/heat-config/heat-scripts/ on saltmaster node of your cluster, which can be run directly from shell. Salt state system will make sure that the system is in desired final state as described in /srv/salt , no matter how many times you run the scripts. The script that are of your intereset are (salt state.highstate and orchestrate) and contain something like below. You can also manually run from saltmaster #salt "cation-cdh-mgr1 state.highstate" and then see the salt log files on mgr1.
set -o pipefail
salt -v --log-level=debug --timeout=120 --state-output=mixed '*' state.highstate | tee salt-highstate-$(date +"%F-%T").log
Please ask furthur if you have any problem.I apologize for the late answer.