f Nagios 監控 AWS SQL Server RDS 的實務案例 ~ 迪貝之家

Pages

Nagios 監控 AWS SQL Server RDS 的實務案例

 

我也不曉得為什麼sql server rds會自己發生副本切換
管它的..反正我就mail發出去就對了
這是mail alert
Nagios Notification
這是rds的server log 的內容
2020-09-03 00:00:40.980 spid45s This instance of SQL Server has been using a process ID of 3924 since 5/22/2020 7:39:08 AM
2020-09-03 04:04:39.060 spid40s Error: 1479, Severity: 16, State: 1.
2020-09-03 04:04:39.060 spid40s The mirroring connection to "TCP://rdspartner:1120" has timed out for database "rdsadmin"
2020-09-03 04:04:39.060 spid40s Database mirroring is inactive for database 'rdsadmin'. This is an informational message o
2020-09-03 04:04:39.110 spid33s Error: 1479, Severity: 16, State: 1.
2020-09-03 04:04:39.110 spid33s The mirroring connection to "TCP://rdspartner:1120" has timed out for database "steven" af
2020-09-03 04:04:39.110 spid33s Database mirroring is inactive for database 'steven'. This is an informational message onl
2020-09-03 04:04:39.630 spid40s Database mirroring is active with database 'rdsadmin' as the principal copy. This is an in
2020-09-03 04:04:39.820 spid63s Error: 1479, Severity: 16, State: 1.
2020-09-03 04:04:39.820 spid63s The mirroring connection to "TCP://rdspartner:1120" has timed out for database "testdb" aft
2020-09-03 04:04:39.820 spid63s Database mirroring is inactive for database 'testdb'. This is an informational message only
2020-09-03 04:04:39.930 spid33s Database mirroring is active with database 'steven' as the principal copy. This is an info
2020-09-03 04:04:51.290 spid63s Database mirroring is active with database 'testdb' as the principal copy. This is an infor