Upgrading a database management system deployed in a cloud platform
A system, for example, a multi-tenant system performs upgrades of database management systems deployed on a cloud platform. The database management system is stored on the cloud platform in a data storage unit for storing data of the database, and an instructions storage unit for storing executable instructions. A cloud platform image comprising instructions for the database management system is received. A cloud platform image is deployed on a new instructions storage unit. An upgraded database management system is built by providing the new instructions storage unit with access to the data storage unit. In an embodiment, the database management system is used by a multi-tenant system and stores a multi-tenant schema. The structure of the multi-tenant schema is defined using a multi-tenant schema template that is included in the instructions storage unit.
1. A computer implemented method for upgrading database management systems deployed on a cloud platform for a multi-tenant system, the method comprising:
receiving a request to upgrade a database management system deployed on a cloud platform, the database management system stored using:
an instructions storage unit storing instructions of the database management system for processing data of a database; and
a data storage unit storing data of the database;
receiving a cloud platform image comprising:
instructions for the database management system, and
a multi-tenant schema template;
creating a new instructions storage unit at the cloud platform;
deploying the cloud platform image on the new instructions storage unit;
determining whether a multi-tenant schema exists on the database stored on the data storage unit;
responsive to determining that the multi-tenant schema exists on the data storage unit, determining the multi-tenant schema template of the cloud platform image has a newer version of multitenant schema compared to the database;
executing instructions stored in the cloud platform image for upgrading the multi-tenant schema of the database stored in the data storage unit;
building an upgraded database management system by detaching the instructions storage unit from the data storage unit, and attaching the new instructions storage unit to the data storage unit, such that the instructions storage unit no longer has access to the data storage unit, and the new instructions storage unit is provided access to the data storage unit; and
providing access to the upgraded database management system to tenants of the multi-tenant system.
2. The method of claim 1 , wherein the data storage unit is configured to be attached to any instructions storage unit.
3. The method of claim 1 , wherein the instructions storage unit comprises:
a system storage unit storing operating systems instructions; and
an application storage unit storing instructions of the database management system.
4. The method of claim 3 , wherein the application storage unit further stores:
one or more database configuration files;
one or more schema templates; and
provisioning instructions.
5. The method of claim 4 , wherein the one or more schema templates comprise the multi-tenant schema template for configuring the database management system for storing data of multiple tenants.
6. The method of claim 1 , wherein the cloud platform image is configured to be deployed on any one of a plurality of cloud platforms.
7. The method of claim 1 , further comprising:
preventing sharing of data across the instructions storage unit and the data storage unit.
8. The method of claim 1 , further comprising:
responsive to determining that the multi-tenant schema does not exist on the data storage unit, creating the multi-tenant schema based on the multi-tenant schema template.
9. A computer implemented method for upgrading database management systems deployed on a cloud platform, the method comprising:
receiving a request to upgrade a database management system deployed on a cloud platform, the database management system comprising:
a data storage unit for storing data of a database; and
an instructions storage unit for storing executable instructions;
receiving a cloud platform image comprising:
instructions for the database management system, and
a multi-tenant schema template;
creating a new instructions storage unit at the cloud platform;
deploying the cloud platform image on the new instructions storage unit;
determining whether a multi-tenant schema exists on the database stored on the data storage unit;
responsive to determining that the multi-tenant schema exists on the data storage unit, determining the multi-tenant schema template of the cloud platform image has a newer version of multitenant schema compared to the database;
executing instructions stored in the cloud platform image for upgrading the multi-tenant schema of the database stored in the data storage unit;
building an upgraded database management system by detaching the instructions storage unit from the data storage unit, and attaching the new instructions storage unit to the data storage unit, such that the instructions storage unit no longer has access to the data storage unit, and the new instructions storage unit is provided access to the data storage unit; and
providing access to the upgraded database management system to users.
10. The computer implemented method of claim 9 , wherein the cloud platform image further stores a schema template, the method further comprising:
responsive to determining that a schema exists on the data storage unit, determining whether the schema template of the cloud platform image has a newer version compared to the schema of the data storage unit; and
executing instructions stored in the cloud platform image for upgrading the schema of the database stored in the data storage unit.
11. The method of claim 10 , further comprising:
responsive to determining that the schema does not exist on the data storage unit, creating the schema based on the schema template.
12. The method of claim 9 , further comprising:
preventing sharing of data across the instructions storage unit and the data storage unit.
13. A computer system comprising:
a computer processor; and
a non-transitory computer readable storage medium for storing instructions that when executed by the computer processor cause the computer processor to perform steps comprising:
receiving a request to upgrade a database management system deployed on a cloud platform, the database management system stored using:
an instructions storage unit storing instructions of the database management system for processing data of a database; and
a data storage unit storing data of the database;
receiving a cloud platform image comprising:
instructions for the database management system, and
a multi-tenant schema template;
creating a new instructions storage unit at the cloud platform;
deploying the cloud platform image on the new instructions storage unit;
determining whether a multi-tenant schema exists on the database stored on the data storage unit;
responsive to determining that the multi-tenant schema exists on the data storage unit, determining the multi-tenant schema template of the cloud platform image has a newer version of multitenant schema compared to the database;
executing instructions stored in the cloud platform image for upgrading the multi-tenant schema of the database stored in the data storage unit;
building an upgraded database management system by detaching the instructions storage unit from the data storage unit, and attaching the new instructions storage unit to the data storage unit, such that the instructions storage unit no longer has access to the data storage unit, and the new instructions storage unit is provided access to the data storage unit; and
providing access to the upgraded database management system to tenants of the database.
14. The computer system of claim 13 , wherein the data storage unit is configured to be attached to any instructions storage unit.
15. The computer system of claim 13 , wherein the instructions storage unit comprises:
a system storage unit storing operating systems instructions; and
an application storage unit storing instructions of the database management system.
16. The computer system of claim 15 , wherein the application storage unit further stores:
one or more database configuration files;
one or more schema templates; and
provisioning instructions.
17. The computer system of claim 16 , wherein the one or more schema templates comprise the multi-tenant schema template for configuring the database management system for storing data of multiple tenants.
18. The computer system of claim 13 , wherein the cloud platform image is configured to be deployed on any one of a plurality of cloud platforms.
19. The computer system of claim 13 , wherein the instructions further cause the computer processor to perform steps comprising:
preventing sharing of data across the instructions storage unit and the data storage unit.
20. The computer system of claim 13 , wherein the instructions further cause the computer processor to perform steps comprising:
responsive to determining that the multi-tenant schema does not exist on the data storage unit, creating the multi-tenant schema based on the multi-tenant schema template.