search

geerlingguy / ansible-role-mysql

Ansible Role - MySQL
https://galaxy.ansible.com/geerlingguy/mysql/
MIT License
1.05k stars 865 forks source link

Fix role failure for slave check. #434

Closed iphizic closed 3 years ago

iphizic commented 3 years ago

Replication user is no set on slave, because use their permission for check slave status is incorrect. Fix replication check to root.

iphizic commented 3 years ago

Hello @geerlingguy! Please review this little fix.

stale[bot] commented 3 years ago

This pull request has been marked 'stale' due to lack of recent activity. If there is no further activity, the PR will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark pull requests as stale.

stale[bot] commented 3 years ago

This pull request has been closed due to inactivity. If you feel this is in error, please reopen the pull request or file a new PR with the relevant details.

iphizic commented 3 years ago

@geerlingguy, this fix is nee for mysql master-slave installations.

geerlingguy commented 3 years ago

I'm not sure why this would be the case—if you have a mysql_replication_user set with the proper permissions, then that should work...