#clustering database servers

Having database servers running harmony virtual machines is now a reality. Some time to spare ago, ETHICAL SELF managers were hesitant to virtualize a certain database systems, but that has reborn due to the ever-increasing mandated territory of servers and many improvements way in virtualization software.<\p>

Highest, database servers were virtualized in non-production environments such parce que heterogenesis and QA. Later on, supplementary and more production database servers were being virtualized or built as VMs in fresh deployments. This was ok in preference to smaller systems which were not for heavy ironclad agreement forecasts and could tolerate the occasional outage or reboot. The control signals disks on such systems have typically been raw-mapped disks (I am using VMware® terminology, since this is the bulk of my experience).<\p>

Now, the bear is to start clustering database servers in virtual machines. Using raw-mapped disks in this projection presents the main point in reference to having the database VMs tied to specific gross hosts. Another option is to use a shared virtual table; this presents a alike poser, in that the clustered server frowst reside on the aforesaid physical host (at least in ESX or ESXi). This eliminates the redundancy and failover capability of the collocate, defeating the purpose entirely.<\p>

There is a way to achieve the objective of having fully effusive clustered database servers, embracing the funds in migrate to other physical hosts air lock the agglomerate as well as to migrate the storage to supernumerary storage systems. This folkway uses iSCSI as the connection technology in that the data volumes, and a virtual circus for the operating system. This fashion will work with Microsoft Windows®, Linux, and UNIX clusters.<\p>

When you hew the VM, you effect the VM with only the OS disk as a dormant disk. After inner self install the operating system and before you configure clustering or install the database, create at least bilateral extra virtual network cards which would be in respect to the same VLAN (or switches) as the iSCSI network. After that, install and configure the iSCSI smith software for the OS. The NICs should have place configured in addition to different IP addresses and should be assigned newfashioned such a way that the packets would travel down separate brutal paths and switches. This will enable multipathing up-to-date the iSCSI spear side. Also, configure jumbo frames by means of the virtual NICs and the iSCSI wharfage.<\p>

On the depot array, create your disk groups, logical units and masking. Go over the DB server initiators to the array targets and format the volumes.<\p>