Clustering Status

Is the "Use Clustering" checked on the master JSS?

This is often due to using different user accounts per node in your mysql grants and is fine, just a little confusing in the gui. Such as:

grant all on databasename.* to FirstUser@IPofMaster identified by 'password'
grant all on databasename.* to SecondUser@IPofDMZserver identified by 'password'

FirstUser doesn't have access to view the process list connections for SecondUser and vice versa. But child nodes should still see the master defined, hence the DMZ seeing the master node.

This can be confirmed by logging into mysql as root an running the following command:

mysql -u root -p

use databasename;
show processlist;

Then if you were to log into mysql as your FirstUser and run the same commands you were see only the firstUser connections

mysql -u firstuser -p

use databasename;
show processlist;

Using different accounts can be more secure but if you want to have both accounts to be able to see each others connections you can follow the instructions in this pdf about MySQL: Securing Your JSS

What you would be looking for in there in particular would be the following command:

GRANT PROCESS ON *.* TO ‘<username>’@’<hostname>’ IDENTIFIED BY ‘<password>’;

Thanks Mike, that's perfect and what you have shown there is exactly how it is setup, with the user@hostname convention being used in MySQL.

I'll run the grant process and it should be clearer!