The last decade has seen businesses steadily increasing the virtualisation of desktop applications, servers, and storage, so it should be no surprise that database virtualisation offers some undeniable advantages. In addition to less physical hardware, savings in energy, and simplifying the management of databases, virtualisation works particularly well for very resource-hungry applications, such as CRM or ERP systems. This blog explores the benefits and disadvantages of virtualisation.
Key benefits of virtualisation
Live migration: Virtual databases can be migrated from one physical server to another without interrupting operation.
Flexible and cost-effective: Dynamic and automated deployment of new system instances and resources when needed.
Agile database development: Using different virtual machines (VM’s) with different database systems or versions enable the development or testing as part of the trial-and-error principle of agile software development. Different system stands can be adjusted, changed or deleted without much trouble, without the risk of impairing “finished” databases under certain circumstances.
Improved availability: By separating the VM’s from each other, the overall system can continue to run smoothly without sacrificing performance when problems occur with one VM.
Despite these advantages, if the organisation did not execute proper planning, it can also lead to significant issues.
What should I consider when implementing database virtualisation?
Hardware: Databases generally require a lot of resources, whether in a real or virtualised system. Virtualised database systems based on Microsoft SQL Server, as well as Oracle and others, need sufficient processing power. If the VM does not provide this, it may cause significant performance degradation.
Licences: In some cases, such as in older Oracle databases, it is not possible to transfer the previous database licences to a virtualised system since the charges refer to the “potential” performance of the system and not what it uses. Therefore, it is essential before a transition to size the environment and consider how many instances and processors to use, to make a comparison between the cost of a physically existing database server or its virtual counterparts.
Expertise: Databases, by nature, are complex, and that fact does not change virtualisation. The new technology comes with an additional layer that adds complexity for database administrators (DBA’s). If there is no differentiation between virtualisation administrators and DBA’s, then the employee has to gain profound knowledge of database virtualisation in addition to their normal “know-how.”
Accountability: Many database administrators have no real access to the depths of the virtualisation layer, as IT administrators manage this. When issues with a virtual database occur, either by an anomaly in the VM or virtual system, it often results in long delays in resolving the problem.
Virtualisation is the way many organisations have chosen to go, but it is not always the “answer” to managing the ever-increasing volume of data. In some cases, the old saying “If it ain’t broke, don’t fix it” may apply here. But if you find yourself on the investing end of virtualisation, you should consider aspects like organisational system and performance requirements, up-front investment costs, ongoing maintenance costs, and necessary internal resources. Integrating a solid plan early on will make managing your virtual environment much easier to manage and scale.
If you want more information on virtualisation, read our white paper or visit our website.
Image credit: Windorias / pixelio.de
Mikey has been with Ontrack for 6 years and is the Partner Program Manager, based out of the Epsom, UK office. He is a regular contributor to the Ontrack blog, usually writing about how different types of data storage technologies work. Outside of work you’ll find him either with a guitar in his hands or learning about rocket science.