[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

SQL: Clustered SQL Server move PtoV

Hello Team,
I have a clustered SQL server and needs to be PtoV.
Can this be done while online and users being connected?
thx
0
John Esraelo
Asked:
John Esraelo
  • 5
  • 3
1 Solution
 
BeartlaoiCommented:
A P2V requires the original server be shut down after it is copied so the VM can start up in its place, so no the users cannot stay connected.

Can your users tolerate a small connection interrupt, like a failover?  If so then it can be done with minimal interruption.

The way I migrated my last cluster was to use P2V to create a clone and add it as an additional node to the cluster.
0
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
Beartlaoi,
Yes, the users may be offline for a short period of time.

We would ultimately want to shut-down and retire the cluster server.
Also, on the hardware level; should I be expecting possible snafu on hardware conversions? I know that this is not a perfect world and anything can happen, but, did you experience any?
thx
0
 
BeartlaoiCommented:
No problems, but I am a pessimist and do extra planning and testing.

Using the cloning method gives you time to bring up the third (and fourth) nodes in the cluster without impacting the original two.  You can do off hours testing and such.  Once you have confidence in the VMs then decomission the physical nodes.

What kind of shared storage is the cluster using?  FC, NAS, NFS, SCSI?  
One of the pre-tests I did was to create a test cluster to verify that my shared storage would work fine between VMs and physicals.  It could have been tricky in my case because new policy prevents us from using FC on new systems.  The old systems were of course using that and the new one had to use NAS, luckily our storage allows a LUN to be presented to both FC and NAS.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
The storage is a SAN.
I personally do not deal with the networking and the storage devices, but, had a chat with the manager of the technical side and I was informed that it the storage used is a SAN and what he was suggesting is that to take a node of the cluster down, ptov that one, shutdown the cluster server, rename / IP change on the vm and see how things go, and, take it from there.
I would personally create a VM with the same OS, install the same version of SQL on the newly built VM, restore the DBs onto the new vm and call it a day..
we will see what happens.
0
 
BeartlaoiCommented:
If you are using SAN then you do not have to restore the DB, the same SAN LUN will be presented to the VM, its a shared disk.
Creating a new VM from scratch is the cleanest and sometimes the quickest option if you have that OS as a fully developed template.
P2V requires a lot of uninstall of hardware specific stuff (especially for HP) then of course install of VM tools.
Another concept to plan for when creating a mixed cluster between physical and VM is the heartbeat.  If you are just using a crossover cable for your heartbeat you will need to replace that with a switch so that you can plug the ESX hosts into it and have the heartbeat VLAN available to the VMs.
When they say SAN are they talking Fiber Channel or iSCSI?  They are handled differently in VMWare.
0
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
Good morning Beartlaoi,
FYI
I am reading up on some best practices for SQL on vm in general:
http://www.vmware.com/files/pdf/solutions/SQL_Server_on_VMware-Best_Practices_Guide.pdf

Also, looking at my list of "task" for each DB if I had to take the other route, meaning, install OS and attach or restore DB(s).

I am going to share your paragraphs with the operations manager of the IT side and we are planning on doing the VM move practice on not tomorrow but the next Friday.
And of course keep you posted.
1-16-2014-7-35-08-AM.png
0
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
Beartlaoi
FYI
we are going to perform a test on this upcoming Friday
thx for all help
0
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
Thank you Beartlaoi
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now