Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

mysql_info: add support for global status #63189

Merged
merged 1 commit into from
Oct 10, 2019

Conversation

sayap
Copy link
Contributor

@sayap sayap commented Oct 7, 2019

SUMMARY

This allows the mysql_info module to also include the output of SHOW GLOBAL STATUS.

ISSUE TYPE
  • Feature Pull Request
COMPONENT NAME

mysql_info

ADDITIONAL INFORMATION

For my specific use case, we are checking whether the global status wsrep_local_state_comment is equal to Synced, after adding a node to galera replication.

@ansibot ansibot added affects_2.10 This issue/PR affects Ansible v2.10 community_review In order to be merged, this PR must follow the community review workflow. database Database category feature This issue/PR relates to a feature request. module This issue/PR relates to a module. mysql needs_triage Needs a first human triage before being processed. support:community This issue/PR relates to code supported by the Ansible community. test This PR relates to tests. labels Oct 7, 2019
@ansibot ansibot removed the needs_triage Needs a first human triage before being processed. label Oct 7, 2019
@Andersson007
Copy link
Contributor

Andersson007 commented Oct 7, 2019

Thank you! I’ll try to look at this tomorrow morning

Copy link
Contributor

@Andersson007 Andersson007 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@sayap , good job! thank you for the PR!
I tried it manually - works as expected.
IMO global_status looks better that just status, more obvious and it corresponds to the SQL.
Would you mind to change it, please ?

@@ -25,8 +25,8 @@
filter:
description:
- Limit the collected information by comma separated string or YAML list.
- Allowable values are C(version), C(databases), C(settings), C(users),
C(slave_status), C(slave_hosts), C(master_status), C(engines).
- Allowable values are C(version), C(databases), C(settings), C(status),
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Suggested change
- Allowable values are C(version), C(databases), C(settings), C(status),
- Allowable values are C(version), C(databases), C(settings), C(global_status),

Copy link
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Agree, I have renamed it to global_status

Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

good job! thank you

@ansibot ansibot added needs_revision This PR fails CI tests or a maintainer has requested a review/revision of the PR. and removed community_review In order to be merged, this PR must follow the community review workflow. labels Oct 8, 2019
Signed-off-by: Yap Sok Ann <sokann@gmail.com>
Copy link
Contributor

@Andersson007 Andersson007 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

shipit

@ansibot ansibot added community_review In order to be merged, this PR must follow the community review workflow. and removed needs_revision This PR fails CI tests or a maintainer has requested a review/revision of the PR. labels Oct 10, 2019
@bmalynovytch
Copy link
Contributor

shipit

@ansibot ansibot added shipit This PR is ready to be merged by Core and removed community_review In order to be merged, this PR must follow the community review workflow. labels Oct 10, 2019
@resmo resmo merged commit eca33b8 into ansible:devel Oct 10, 2019
@Andersson007
Copy link
Contributor

thanks all!

@ansible ansible locked and limited conversation to collaborators Nov 13, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
affects_2.10 This issue/PR affects Ansible v2.10 database Database category feature This issue/PR relates to a feature request. module This issue/PR relates to a module. mysql shipit This PR is ready to be merged by Core support:community This issue/PR relates to code supported by the Ansible community. test This PR relates to tests.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

5 participants