3 Replies Latest reply on Feb 10, 2020 3:03 PM by Dave Stokes-MySQL Community Team-Oracle

system check

1549662 Feb 9, 2020 6:15 PM

Hi All,

MySQL 5.7 with InnoDB cluster;

1) Is there any scripts to do the health/system check of db & cluster

2) any monitoring tool to check the cluster status and outages if any

Thanks

1. Re: system check

Gaz in Oz Feb 10, 2020 6:30 AM (in response to 1549662)

2) https://www.mysql.com/products/enterprise/monitor.html
1) https://duckduckgo.com/?q=mysql+healthcheck+script+-sqlserver&t=ffab&ia=web
Or perhaps even https://www.mysql.com/news-and-events/health-check/
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: system check

Sunny kichloo Feb 10, 2020 6:31 AM (in response to 1549662)

You want you can use this to check status from master/primary database server:

SHOW PROCESSLIST;
SHOW SLAVE HOSTS;

With respect to tool have a look into this:

https://www.mysql.com/products/cluster/mcm/
Like Show 0 Likes(0)

Actions
3. Re: system check

Dave Stokes-MySQL Community Team-Oracle Feb 10, 2020 3:03 PM (in response to 1549662)

You can use the new shell to issue a cluster.status() message to see the status of the InnoDB cluster
Like Show 0 Likes(0)

Actions