Solved

SQL: Clustered SQL Server move PtoV

Posted on 2014-01-13
8
220 Views
Last Modified: 2014-01-21
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
Comment
Question by:John Esraelo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 9

Expert Comment

by:Beartlaoi
ID: 39777681
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
 

Author Comment

by:John Esraelo
ID: 39777793
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
 
LVL 9

Accepted Solution

by:
Beartlaoi earned 500 total points
ID: 39777859
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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 

Author Comment

by:John Esraelo
ID: 39779877
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
 
LVL 9

Expert Comment

by:Beartlaoi
ID: 39780552
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
 

Author Comment

by:John Esraelo
ID: 39785637
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
 

Author Comment

by:John Esraelo
ID: 39797392
Beartlaoi
FYI
we are going to perform a test on this upcoming Friday
thx for all help
0
 

Author Closing Comment

by:John Esraelo
ID: 39797393
Thank you Beartlaoi
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question