0

I set up a small mysql/percona/galera cluster using the percona cluster docker image, with 3 nodes.

I followed the documentation written here

After starting up the whole cluster, I'm missing some of the wsrep variables.

For instance wsrep_local_state_comment. (among many others)

Does anyone knows why is this happening ?

(I'd imagine it is not, strictly ,percona related, but I don't know)

Thank you

1

After starting up the whole cluster, I'm missing some of the wsrep variables.

I'm not sure if this is the issue, but wsrep_local_state_comment is not a wsrep variable, it's a status variable. Which means you have to use SHOW GLOBAL STATUS LIKE ... rather than SHOW GLOBAL VARIABLES LIKE ..., i.e. in this case:

SHOW GLOBAL STATUS LIKE 'wsrep_local_state_comment';

And more generally:

SHOW GLOBAL STATUS LIKE 'wsrep%';
  • You should probably do SHOW GLOBAL STATUS LIKE 'wsrep%'; for the heck of it. – Rick James Nov 20 '18 at 16:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.