Jobs in the Cluster and replication category
| Control Center Jobs | Description |
|---|---|
| Oracle | |
| Blocking detector for RAC | Checks if a session is waiting on a TX (transaction) lock. (RAC only) |
| Memory session load for RAC | Records the load memory of RAC active sessions over time. |
| MV Refresh Group | Checks refresh date of scheduled jobs in refresh group(s). |
| Dataguard apply time | Checking apply time in dataguard standby nodes |
| Dataguard archive sequence apply lag | Checking lag of applied archive logs on dataguard standby node |
| Dataguard standby archivelog gap | Checking for archivelog gap between threads on primary and standby instances in a replication/service group. Metadata “replicationgroup” must be set on all instances to the same as parameter replicationgroup. For upto 10 redo threads. |
| Dataguard startup time | Checking startup time on dataguard standby nodes |
| Dataguard transport time | Checking transport time in dataguard standby nodes |
| RAC instances status | Reacts if one or more RAC instances are not available. |
| Session load Rac | Records the number of active sessions over time (RAC only). |
| Snapshot Log(s) rows count | Checks row count on all snapshot logs for given schema. |
| Snapshot Log(s) size | Checks size of all snapshot logs. |
| Data Guard role switch | This job checks if Primary/Standby switch occurs. |
| MS SQL Server | |
| Database mirroring | Checks state information of all mirrored databases. |
| Failover cluster host switch | Checks if an instance switched to a differen host i a Windows Server Failover Cluster (WSFC). |
| Health state | Checks groups health state. |
| Log shipping monitor | Monitor the primary database in each log shipping configuration, including information about the last backup file and last restored file. |
| Log shipping monitor | Monitor the secondary database in each log shipping configuration. |
| Member state | Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members. |
| AlwaysOn database backup alert | Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members. |
| AlwaysOn transaction log backup alert | Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views sys.dm_hadr_cluster_members. |
| Replica states | Checks role state for all alwayson groups. |
| Replication status | The following check provides general info in regards to any replication going on in a server. |
| PostgreSQL | |
| BDR Replication lag | Checks for BDR replication lag |
| Replication delay alert | Checks for BDR replication lag |
| Replication slave client alert | Checks for BDR replication lag |
| Replication slave client alert | Checks for BDR replication lag |
| MySQL | |
| NDB data memory usage check | NDB data memory usage check |
| NDB data node status | NDB data node status |
| Innodb cluster status | This job checks state of all members in Innodb cluster |
| Innodb cluster switch | This job checks if Innodb cluster PRIMARY/SECONDARY switch occurs. |
| Replica count | This job checks all of replicas currently registered with the source. |
| Replica delay | This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread and the replication I/O (receiver) thread. |
| Replica state | This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a replica. |
| MariaDB | |
| NDB data memory usage check | NDB data memory usage check |
| NDB data node status | NDB data node status |
| Replica count | This job checks all of replicas currently registered with the source. |
| Replica delay | This job checks how “late” the replica is, and measures the time difference in seconds between the replication SQL (applier) thread and the replication I/O (receiver) thread. |
| Replica state | This job checks if replica changes occurs. For example, if an instance becomes a replica or if an instance is no longer a replica. |
Post your comment on this topic.