Re: Active/Active/Active without SAN

I prefer to assist on the public newsgroups where everyone can benefit from
the discussions. Private assistance is known as "consulting" and is
generally done for pay.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

"Lewis" <Lewis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:60368F4E-899E-4833-9ED6-591FF5A3535C@xxxxxxxxxxxxxxxx
> Sorry Geoff.N, if its not troublesome, may I communicate with u via email
> or
> MSN, I really appreciate if its possible to understand better on this
> subject.
>
> "Geoff N. Hiten" wrote:
>
>> What you are asking about is a Geo-cluster or a geographically separated
>> cluster. NSI makes some products that can give you this functionality.
>> Some
>> SAN vendors also handle SAN-level data replication for disaster
>> recovery/fault tolerance setups. There are no built-in features in SQL
>> Server 2000 to allow what you are asking for. SQL Server 2005 adds a new
>> technology called Database Mirroring that allows you to build a
>> multi-site
>> high-availability solution.
>>
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>> "Lewis" <Lewis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:CDB44275-9E6D-4BC7-AB9F-5AC68D0ECF77@xxxxxxxxxxxxxxxx
>> > My setup is a 2 data center, 2 server in location and 1 single in
>> > another.
>> > I
>> > would like to implement a fail safe SQL system. So this will be a 3
>> > node
>> > system and I am intending that at any single update to database, all 3
>> > will
>> > be updated instantly. Because its not in the same datacenter, therefore
>> > implementing a SAN is not possible, so with this in mind can my
>> > original
>> > question be possible and is there any Howtos document to follow..
>> > appreciate
>> > any assistance.
>> >
>> > "Geoff N. Hiten" wrote:
>> >
>> >> SCSI clusters only support two nodes. As far as Active/Active/Active
>> >> terminology, that really doesn't express what your intent is. The new
>> >> terminology is Multi-instance and you need to state how many nodes and
>> >> SQL
>> >> instances you are trying to build in your cluster. I.E I want to
>> >> build a
>> >> four node cluster with three SQL instances.
>> >>
>> >> --
>> >> Geoff N. Hiten
>> >> Senior Database Administrator
>> >> Microsoft SQL Server MVP
>> >>
>> >>
>> >> "Lewis" <Lewis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:3C882765-40EE-424E-8BEF-A5F768D2207D@xxxxxxxxxxxxxxxx
>> >> >I read that its possible to implement an Active/Active/Active with
>> >> >SQL
>> >> >2000
>> >> > on Win Server 2003 Ent without SAN but could not find a good step by
>> >> > step
>> >> > howtos to it.
>> >> >
>> >> > Could some kind gentlemen point me to a good article ? please and
>> >> > thanks
>> >> > in
>> >> > advance.
>> >>
>> >>
>> >>
>>
>>
>>


.

Relevant Pages

  • Re: Cluster will not fail over.
    ... >> Try and run comclust.exe on each node to set MSDTC to cluster mode. ... >> Senior Database Administrator ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Active/Active/Active/Passive and Database Mirroring
    ... Senior Database Administrator ... Microsoft SQL Server MVP ... In the active/active/active/passive configuration is it possible to load ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Scenario
    ... limited budget, but you may need to point out to management that they will ... I support the Professional Association for SQL Server ... > "Geoff N. Hiten" wrote in message ... >> Senior Database Administrator ...
    (microsoft.public.sqlserver.clustering)
  • Re: AWE Memory Question
    ... Are you talking about the PageLife Expectancy counter? ... > SQL Server that I saw this as an opportunity to gain insite on another ... >>>> severe memory pressure, this won't help much. ... >>>> Senior Database Administrator ...
    (microsoft.public.sqlserver.setup)
Loading