Solved

SQL: Clustered SQL Server move PtoV

Posted on 2014-01-13
8
219 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
Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

 

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

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

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

Suggested Solutions

I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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 extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

735 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