• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

MS SQL server 2008 clustering (Multi instance)

Hi Experts,

I need some clarifications on below mentioned questions related to SQL 2008 Active-Active clustering (Multi-Instance).

Planned SQL 2008 clustering on new environment (VM’s):
a.Number of SQL instances: 2 (SQL_SP & SQL_BI)
SQL_SP: This SQL instance contains 40 DB’s.
SQL_BI: This SQL instance contains 5 DB’s.

b.Number of nodes (VM’s): 2 (VM_1_SharePoint & VM_2_BIPROD)

Related to Windows Clustering:
1.      On VM_1_SharePoint & VM_2_BIPROD
a.      Windows 2008/2012 OS: Windows clustering configuration is completed with A-A clustering method.

Related to SQL:
1.      Install SQL 2008 R2 on VM_1_SharePoint with named instance SQL1_SP and Install SQL 2008 R2 on VM_2_BIPROD with named instance SQL2_SP
After installation, restore first 20 DB’s backup on SQL1_SP (A, B, C drive) and remaining 20 DB’s backup on SQL2_SP (D, E, F drive) (Split backups on two SQL instances).

2.      Install SQL 2008 R2 on VM_1_SharePoint with named instance SQL1_BI and Install SQL 2008 R2 on VM_2_BIPROD with named instance SQL2_BI
After installation, restore first 3 DB’s backup on SQL1_BI (A, B, C drive) and remaining 2 DB’s backup on SQL2_BI (D, E drive) (Split backups on two SQL instances).

Question:  
1.      Can I configure SQL A-A clustering (Multi-Instance) between SQL1_SP and SQL2_SP? If Yes, Which SQL instance name or IP is required to user to connect the application (configuration file) i.e., SQL1_SP or SQL2_SP or other?
2.      Can I configure SQL A-A clustering (Multi-Instance) between SQL1_BI and SQL2_BI? If Yes, Which SQL instance name or IP is required to user to connect the application (configuration file) i.e., SQL1_BI or SQL2_BI or other?

Appreciate your answers.

Thanks in advance.
0
sg05121983
Asked:
sg05121983
1 Solution
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
If you are using 2 nodes simply build a single clustered instance and host all of your 45db's on that instance.  Active-Active on a server pair is in fact the sum of two Passive-Active clusters which has little advantage for too many drawbacks.  In other words, spare yourself some pain and keep things simple.
0
 
sg05121983Author Commented:
--
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now