Not the answer you need?
Register and ask your own question!

Running agent on Galera cluster

markwillis82markwillis82 EntrantCurrent User Role Beginner
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

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    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.
  • VictorTVictorT Contributor Current User Role Beginner
    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:<password-hidden>@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 :<password-hidden>@unix(/var/lib/mysql/mysql.sock)/?parseTime=true: Error 1045: Access denied for user ''@'localhost' (using password: NO)
  • VictorTVictorT Contributor Current User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.