Running agent on Galera cluster

  • Filter
  • Time
  • Show
Clear All
new posts

  • Running agent on Galera cluster

    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)?


  • #2
    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.


    • #3
      When attempting to install on the remaining nodes, I used the directions from http://cloud-docs.percona.com/Instal...#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)


      • #4
        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.