Normal operation

Nagios should accurately report that the cluster is operating normally. In case you would like additional verification, the following are manual diagnostics to be certain of normal operation.

On denoted systems {master, slaves}:

  • master, slaves - # lsof -i | grep LISTEN | grep mysql shows mysqld listening on correct interface(s)
  • master, slaves - mysql> show variables like 'read_only'; shows read_only is OFF for master and ON for slaves
  • master, slaves - # mysqladmin status processlist shows a process on each host for replication
  • master - mysql> show master status\G shows one returned line of output.
  • slaves - mysql> show slave status\G shows one row of output with approximately 50 headers, including:
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes 
  • master - # pt-table-checksum --defaults-file=/etc/mysql/pt_checksum.cnf --replicate=percona.checksums --ignore-databases mysql --no-check-binlog-format
  • master - # ls -l /var/log/mysql/binlog.* returns a list of files; binlog.index and the most recent file should all have been written very recently today.
  • master, slaves - should be clean # ls -l  /var/log/mysql.err
Topic revision: r2 - 2016-04-07 - DanielAllen
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback