Managing databases in data storage systems

摘要

There is disclosed a method for use in managing databases in data storage systems comprising a plurality of nodes. A request is received to provision storage for a specified application intending to use a database. Based on application-awareness, the storage system is provisioned for storing the database in response to receiving the request. Database tables are distributed across the nodes based on a forecasted first I/O profile between application and database. Information is captured in connection with the activity between the application and database. A second I/O profile is determined based on the captured information. The second I/O profile is an actual in-running I/O profile between application and database. The first I/O profile and second I/O profile are compared. The database tables are re-organized on the nodes based on the comparison identifying a discrepancy between first and second I/O profiles such that storage system is rebalanced.

主权项

1. For a system comprising a plurality of nodes, a method for use in managing data-storage for a database application executing on a server coupled to the system based on application awareness, the method comprising:
storing application settings corresponding to the database application; receiving an instruction to provision storage for the database application; in response to receiving the instruction, accessing the application settings to automatically provision storage for the database application that includes distributing database tables across the plurality of nodes; capturing I/O activity information in connection with the database application; performing an operation to detect an imbalance in connection with the database tables, wherein the performed operation detects the imbalance by detecting for each node whether there exists a discrepancy between the captured I/O activity and a forecasted I/O activity used to distribute the database tables across the plurality of nodes, further wherein the performed operation detects the imbalance by detecting for each node whether fragmentation exists in connection with the database tables by comparing a number of deletions in connection with each of the nodes to a threshold; determining to reorganize the database tables on the one or more nodes based on the performed operation; and in response to said determination, reorganizing the database tables, wherein the reorganizing includes dumping the database tables and redistributing the database tables to one or more nodes of the plurality of nodes.