Running agent on Galera cluster

[markwillis82]

Would there be a correct process to get this set-up monitoring a whole cluster? I am migrating from a single DB server to a 3 node XtraDB cluster and would like to keep cloud tools running.

Do I need to set the agent up on every node (but maintain the same user for each node)?

Thanks

[mirfan]

Yes, you need to install percona-agent on all nodes of the cluster but standard install on first node of cluster and for the remaining nodes you can specify same agent user.

[VictorT]

When attempting to install on the remaining nodes, I used the directions from http://cloud-docs.percona.com/Install.html#slave-install

However it appears that something is wrong.

I tested that I was able to login with the percona-agent username and password. Then passed them in using the
-agent-mysql-user and -agent-mysql-pass flags.

./install -interactive=false -create-mysql-user=false -agent-mysql-user=“percona-agent” -agent-mysql-pass=“PASSWORD” -api-key=“APIKEY”

I see the following output when attempting to install the agent:

Using provided user/pass for mysql-agent user. DSN: percona-agent:@unix(/var/lib/mysql/mysql.sock)
[MySQL] 2015/03/16 11:21:44 packets.go:118: write unix /var/lib/mysql/mysql.sock: broken pipe
Failed to set up MySQL (ignoring because interactive=false): Cannot connect to MySQL :@unix(/var/lib/mysql/mysql.sock)/?parseTime=true: Error 1045: Access denied for user ‘’@‘localhost’ (using password: NO)

[VictorT]

In order to get the slave agents installed I had to use switch to interactive mode.

./install -interactive=true -agent-mysql-user=“percona-agent” -api-key=“APIKEY”

It wouldn’t go into interactive mode using just

./install -interactive=true -api-key=“APIKEY”

Hope this helps anyone who might run into this issue.