Database monitoring using shared infrastructure
A method for database monitoring may include sending, to a central database, a query on a database view at the central database. The database view may include a first operational data from a first local database and a second operational data from a second local database. An operational state of the central database may be determined based on the response to the query on the database view. Moreover, in response to receiving, from the central database, a response including the first operational data, a first operational state of the first local database may be determined based on the first operational data. Alternatively and/or additionally, in response to receiving, from the central database, a response including the second operational data, a second operational state of the second local database may be determined based on the second operational data. Related systems and articles of manufacture, including computer program products, are also provided.
1. A system, comprising:
at least one data processor; and
at least one memory storing instructions, which when executed by the at least one data processor, result in operations comprising:
sending, to a central database, a query on a database view at the central database, the database view comprising a result of a predefined query that includes a first operational data from a first local database coupled with the central database and a second operational data from a second local database coupled with the central database;
in response to receiving, from the central database, a response including the first operational data of the first local database, determining, based at least on the first operational data, a first operational state of the first local database; and
generating, based at least on the first operational state of the first local database, an alert.
2. The system of claim 1 , further comprising:
determining, based at least on the second operational data included in the response from the central database, a second operational state of the second local database; and
generating the alert further based at least on the second operational state of the second database.
3. The system of claim 1 , further comprising:
in response to the central database failing to respond to the query on the database view, detecting an error at the central database; and
generating the alert further based at least on the error at the central database.
4. The system of claim 1 , wherein the query comprises a structured query language (SQL) select statement selecting, from the database view, the first operational data of the first local database and/or the second operational data of the second local database.
5. The system of claim 1 , wherein the database view comprises a union view that includes a first view of the first operational data from the first local database and a second view of the second operational data from the second local database.
6. The system or claim 5 , wherein the central database responds to the query by at least translating the query into an open data protocol (OData) call to retrieve the first operational data from the first local database and/or the second operational data from the second local database.
7. The system of claim 1 , wherein the first operational data includes an operational status of the first local database, and wherein the alert is generated in response to the operational status of the first local database being not running.
8. The system of claim 1 , wherein the first operational data includes one or more operational metrics at the first local database, and wherein the alert is generated in response to the one or more operational metrics exceeding a threshold value.
9. The system of claim 8 , wherein the one or more operational metrics include a disk space usage, and/or a random access memory (RAM) usage.
10. The system of claim 1 , wherein the first local database stores a first data associated with a first tenant of a cloud-based software application, wherein the second local database stores a second data associated with a second tenant of the cloud-based software application, and wherein the central database stores data that is shared amongst the first tenant and the second tenant.
11. A computer-implemented method, comprising:
sending, to a central database, a query on a database view at the central database, the database view comprising a result of a predefined query that includes a first operational data from a first local database coupled with the central database and a second operational data from a second local database coupled with the central database;
in response to receiving, from the central database, a response including the first operational data of the first local database, determining, based at least on the first operational data, a first operational state of the first local database; and
generating, based at least on the first operational state of the first local database, an alert.
12. The method of claim 11 , further comprising:
determining, based at least on the second operational data included in the response from the central database, a second operational state of the second local database; and
generating the alert further based at least on the second operational state of the second database.
13. The method of claim 11 , further comprising:
in response to the central database failing to respond to the query on the database view, detecting an error at the central database; and
generating the alert further based at least on the error at the central database.
14. The method of claim 11 , wherein the query comprises a structured query language (SQL) select statement selecting, from the database view, the first operational data of the first local database and/or the second operational data of the second local database.
15. The method of claim 11 , wherein the database view comprises a union view that includes a first view of the first operational data from the first local database and a second view of the second operational data from the second local database.
16. The method or claim 15 , wherein the central database responds to the query by at least translating the query into an open data protocol (OData) call to retrieve the first operational data from the first local database and/or the second operational data from the second local database.
17. The method of claim 11 , wherein the first operational data includes an operational status of the first local database, and wherein the alert is generated in response to the operational status of the first local database being not running.
18. The method of claim 11 , wherein the first operational data includes one or more operational metrics at the first local database, and wherein the alert is generated in response to the one or more operational metrics exceeding a threshold value.
19. The method of claim 18 , wherein the one or more operational metrics include a disk space usage, and/or a random access memory (RAM) usage.
20. A non-transitory computer readable medium storing instructions, which when executed by at least one data processor, result in operations comprising:
sending, to a central database, a query on a database view at the central database, the database view comprising a result of a predefined query that includes a first operational data from a first local database coupled with the central database and a second operational data from a second local database coupled with the central database;
in response to receiving, from the central database, a response including the first operational data of the first local database, determining, based at least on the first operational data, a first operational state of the first local database; and
generating, based at least on the first operational state of the first local database, an alert.