Providing database performance report in restricted environment
Techniques for providing a database performance report in a restricted access environment are disclosed. In some embodiments, a computer system performs a method comprising: receiving, from a computing device of a user, a request to generate a database performance report for a first database that is hosted on a cloud computing platform, the request including a service key; obtaining administrative credentials from a second database using stateless authentication and the service key; obtaining one or more database performance metrics of the first database from the first database using the administrative credentials; and generating the database performance report based on the one or more database performance metrics.
1. A computer-implemented method performed by a computer system having a memory and at least one hardware processor, the computer-implemented method comprising:
receiving, from a computing device of a user, a request to generate a performance report for a first component that is hosted on a cloud computing platform, the request including a service key;
obtaining administrative credentials from a second component using stateless authentication and the service key, the second component being different from the first component and being hosted on the cloud computing platform;
obtaining one or more performance metrics of the first component from the first component using the administrative credentials; and
generating the performance report based on the one or more performance metrics.
2. The computer-implemented method of claim 1 , further comprising:
storing the performance report in a directory;
generating an expiring link to the performance report in the directory, the expiring link being configured to expire after a predetermined amount of time; and
displaying the expiring link on the computing device of the user.
3. The computer-implemented method of claim 2 , further comprising:
receiving a user selection of the expiring link from the computing device before the predetermined amount of time has passed; and
displaying the performance report on the computing device in response to receiving the user selection of the expiring link from the computing device before the predetermined amount of time has passed.
4. The computer-implemented method of claim 2 , further comprising:
determining that the predetermined amount of time has passed;
deleting the performance report from the directory in response to the determining that the predetermined amount of time has passed;
receiving a user selection of the expiring link from the computing device after the predetermined amount of time has passed; and
displaying an error message on the computing device in response to the receiving the user selection of the expiring link from the computing device after the predetermined amount of time has passed.
5. The computer-implemented method of claim 1 , wherein the obtaining the administrative credentials comprises:
attempting to connect to the first component using the service key;
determining that a connection to the first component was established using the service key; and
in response to the determining that the connection to the first component was established using the service key, retrieving the administrative credentials from the second component.
6. The computer-implemented method of claim 1 , wherein the first component comprises a component that is hosted within a user space dedicated to a user account of the user.
7. The computer-implemented method of claim 1 , wherein the second component comprises a master database.
8. The computer-implemented method of claim 1 , wherein the request further includes one or more types of performance checks, and the one or more performance metrics of the first component are obtained based on inclusion of the one or more types of performance checks in the request.
9. A system of comprising:
at least one hardware processor; and
a non-transitory computer-readable medium storing executable instructions that, when executed, cause the at least one hardware processor to perform operations comprising:
receiving, from a computing device of a user, a request to generate a performance report for a first component that is hosted on a cloud computing platform, the request including a service key;
obtaining administrative credentials from a second component using stateless authentication and the service key, the second component being different from the first component and being hosted on the cloud computing platform;
obtaining one or more performance metrics of the first component from the first component using the administrative credentials; and
generating the performance report based on the one or more performance metrics.
10. The system of claim 9 , wherein the operations further comprise:
storing the performance report in a directory;
generating an expiring link to the performance report in the directory, the expiring link being configured to expire after a predetermined amount of time; and
displaying the expiring link on the computing device of the user.
11. The system of claim 10 , wherein the operations further comprise:
receiving a user selection of the expiring link from the computing device before the predetermined amount of time has passed; and
displaying the performance report on the computing device in response to receiving the user selection of the expiring link from the computing device before the predetermined amount of time has passed.
12. The system of claim 10 , wherein the operations further comprise:
determining that the predetermined amount of time has passed;
deleting the performance report from the directory in response to the determining that the predetermined amount of time has passed;
receiving a user selection of the expiring link from the computing device after the predetermined amount of time has passed; and
displaying an error message on the computing device in response to the receiving the user selection of the expiring link from the computing device after the predetermined amount of time has passed.
13. The system of claim 9 , wherein the obtaining the administrative credentials comprises:
attempting to connect to the first component using the service key;
determining that a connection to the first component was established using the service key; and
in response to the determining that the connection to the first component was established using the service key, retrieving the administrative credentials from the second component.
14. The system of claim 9 , wherein the first component comprises a component that is hosted within a user space dedicated to a user account of the user.
15. The system of claim 9 , wherein the second component comprises a master database.
16. The system of claim 9 , wherein the request further includes one or more types of performance checks, and the one or more performance metrics of the component are obtained based on inclusion of the one or more types of performance checks in the request.
17. A non-transitory machine-readable storage medium tangibly embodying a set of instructions that, when executed by at least one hardware processor, causes the at least one processor to perform operations comprising:
receiving, from a computing device of a user, a request to generate a performance report for a first component that is hosted on a cloud computing platform, the request including a service key;
obtaining administrative credentials from a second component using stateless authentication and the service key, the second component being different from the first component and being hosted on the cloud computing platform;
obtaining one or more performance metrics of the first component from the first component using the administrative credentials; and
generating the performance report based on the one or more performance metrics.
18. The non-transitory machine-readable storage medium of claim 17 , wherein the operations further comprise:
storing the performance report in a directory;
generating an expiring link to the performance report in the directory, the expiring link being configured to expire after a predetermined amount of time; and
displaying the expiring link on the computing device of the user.
19. The non-transitory machine-readable storage medium of claim 18 , wherein the operations further comprise:
receiving a user selection of the expiring link from the computing device before the predetermined amount of time has passed; and
displaying the performance report on the computing device in response to receiving the user selection of the expiring link from the computing device before the predetermined amount of time has passed.
20. The non-transitory machine-readable storage medium of claim 18 , wherein the operations further comprise:
determining that the predetermined amount of time has passed;
deleting the performance report from the directory in response to the determining that the predetermined amount of time has passed;
receiving a user selection of the expiring link from the computing device after the predetermined amount of time has passed; and
displaying an error message on the computing device in response to the receiving the user selection of the expiring link from the computing device after the predetermined amount of time has passed.