1

I have a Percona/Galera cluster and see this when i monitor the different cluster nodes. What does this really mean? And is this something erroneous that needs to be taken care of?

This is how one of the nodes looks like.

Thanks in advance.

Cluster node 1

All other nodes in the cluster looks like this The other cluster nodes

Improve this question
1
  • One factor could be tables opened for reading, which would only be opened on the server being queried. Another could be writes that were rolled back, since Galera replicates transactions among servers at commit time, not before. Commented Jan 5, 2016 at 13:01

1 Answer 1

Reset to default
0

You are writing to the 'one' node? That is, you are treating it as the only Master? Galera does "Row Based Replication", so it probably does not need to open the table definition on the 'Slaves'?

Do you have the same values for SHOW VARIABLES LIKE 'table%'; on all nodes?

Improve this answer
11
  • Yep, they are exactly the same. Well it could have been that one we bootstrapped the cluster with. Commented Jan 7, 2016 at 7:22
  • Are all writes going to one node? Commented Jan 7, 2016 at 7:26
  • Otherwise they are all load balanced so number of connections should be similar for all the nodes. Commented Jan 7, 2016 at 7:28
  • "Connections" and "tables opened" are separate things. Commented Jan 7, 2016 at 7:31
  • I might have found it. Could a SHOW CREATE TABLE spark a 'Table Definitions Opened'? Commented Jan 7, 2016 at 8:33

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.