One of the greatest challenges of database management is the growing complexity. Databases are proliferating and users create new databases every time they add a new operational or analytical application or create a new data warehouse. They may even add a new server and provision for additional workloads until the data center is cluttered with discrete storage units.
Overtime this increases the data center management costs and there is mismatch between the resources that are being built up and used. The staff time is fragmented and costs escalate as procedures and plans for data center management becomes complex and requires precision engineering. There is a significant lack of flexibility; over provisioning resources, server pileup, and inefficiency of performance.
One approach to resolving the problem is to go in for database consolidation. The process pours all databases into a pool of resources and organizes these resources into a cluster of shared storage resources. Virtualization is used to reallocate resources as workloads shift. This helps the organization avoid over provisioning of resources and locking in available infrastructures. The entire data center can be driven off as a single image and patches and updates can be applied at a single point to have cascading impact. This results in large operational savings and flexibility of deployment of resources.
Organizations that believe in “do-it-yourself” will have to face a number of challenges. They will have to build the right server configuration, segregate the databases by workloads, and deal with changing data base needs and requirements as and when they arise. This can be very expensive and will demand the presence of highly skilled manpower on site.
Those organizations which are willing to try Cloud solutions for data base consolidation will have the benefit of working with a pre-engineered database consolidation platforms. These platforms use standard reference configurations, provide methods and templates for consolidation and provision for vendor support, and training 24x7x365. Organizations can accelerate application implementations; improve agility, and responsiveness with a decreased cost of deployment. The benefits of consolidation can be summarized as:
- Quick investment value realization,
- Reduction in capital and operational costs,
- Centralization of management,
- Reduction of implementation risks,
- Seamless scalability of resources, and
- Single point support.