Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Geo Clustering SQL Server 2008 R2

Posted on 2014-02-05
7
Medium Priority
?
297 Views
Last Modified: 2014-03-29
I would like to help to plan the prerequisites for the implementation of SQL Server Clustering Geo.

I have a total of 4 servers for this purpose. two on the Site A and two at Site B.

Need to determine the servers that act as actives and inactives. And all the tools I need

Thanks!
0
Comment
Question by:JnavarroMc
[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
  • 4
  • 3
7 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 39838473
you need to start from Data Centers Vendors abilities\distance \Network possibilities
and Windows setup,

for sql 2008 you may consider Mirroring\Logshipping\sql replication\etc.  instead of GeoClustering.
...
You may start from upgrading sql2008 to sql 2012 and use Geo Clustering
via Always On sql 2012 new feature
/ http://technet.microsoft.com/en-us/sqlserver/gg490638.aspx /

SQL Server Multi-Subnet Clustering (SQL Server
http://technet.microsoft.com/en-us/library/ff878716.aspx

if just you need for DR - you may need just Logshipping solution ( http://technet.microsoft.com/en-us/library/ms187103(v=sql.105).aspx )
0
 

Author Comment

by:JnavarroMc
ID: 39838815
the project has already been established by geo clustering.

I have 2 nodes on the main site and 2 nodes on the secondary site. The replication of storage is also provided.

What I can not understand so far is how could structure these four nodes.

We were planning to have an active and passive node on the main site and the other two nodes in the same way at the remote site.

What I can not understand is how this solution could work as it would have two main nodes. Or is that only would have a major node on the main site and the other three nodes would be passive?
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 39840883
what are you going to run and A node in each DC?
explain your servers topology

Active means -something will run there-
does it mean 1 site A and 2md site P
and  vice versa?
please clarify
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:JnavarroMc
ID: 39840961
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 39840979
very good.
what about my question about how are you going to use these windows A/P Geon nodes for your sql server?
if it was sql 2012 - Always on feature may be not so bad idea to use for these nodes settings
for sql 2008 what is your plan?
0
 

Author Comment

by:JnavarroMc
ID: 39841024
I have licenses  of SQL 2008 R2. what is the difference with SQL 2012 Always on?
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 1500 total points
ID: 39841541
SQL 2012 is next version of sql

Always on is a new feature of sql 2012  -- check posted above link about this
0

Featured Post

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

715 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