dbTalk Databases Forums  

Help Needed:SQL2000->2008 Migration with Active/Active MutliCluste

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.clustering Help Needed:SQL2000->2008 Migration with Active/Active MutliCluste

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Help Needed:SQL2000->2008 Migration with Active/Active MutliCluste in the microsoft.public.sqlserver.clustering forum.



Reply
Page 2 of 2 < 1 2
 
Thread Tools Display Modes
  #11  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Help Needed:SQL2000->2008 Migration with Active/Active MutliCluste - 10-31-2008 , 08:22 AM





Let's take these in opposite order, because I think there may be some
confusion.

First, a multi-instance cluster ( the correct name for "active-active") does
not offer any native scale-out capabilities. You have two independent
instances reading and writing to two sets of databases. If the second
instance can be "read-only" from the application's perspective, then you can
get some benefit.


As for the upgrade, there are certainly some compatibility issues that have
to be tested, identified, and remediated. Much of the time and effort on my
migration engagements focuses on compatibility. The actual upgrade is much
easier with SQL 2008 now that Microsoft added rolling upgrades as a feature.
Short version is you upgrade a passive node for each instance, failover the
instance to that node and then upgrade the remaining node(s). You always
have an available node to run SQL on if something goes wrong.


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP





"TechNeedy" <TechNeedy (AT) discussions (DOT) microsoft.com> wrote

Quote:
I've assigned to suggest proposing a solution in which the stakeholders
are
interested in having their SQL upgrade from 2000 to 2008. They would also
like to have their clusters (2 different clusters) be Active / Active with
the 2nd one have transactional replication from the 1st cluster.

The expectation of having 2 clusters with Active/Active is to enable HA
when
the traffic is really spikes.
Pls Adv:
Potential issues & challenges in migrating from 2000to2008?
Clustering :- Is this a good design? what are the challenges?
how else this can be tackled?

thanks & appreciate your advice/suggestion.


Reply With Quote
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top