Solved

SQL: Clustered SQL Server move PtoV

Posted on 2014-01-13
8
221 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Resolve DNS query failed errors for Exchange
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

717 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