[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference decwet::winnt-clusters

Title:WinNT-Clusters
Notice:Info directories moved to DECWET::SHARE1$:[NT_CLSTR]
Moderator:DECWET::CAPPELLOF
Created:Thu Oct 19 1995
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:863
Total number of notes:3478

733.0. "SQL master.dat on a shared disk???" by SUOIS2::SUFP02::stu01::Kluge (The answer is 42) Tue Apr 08 1997 02:07

High Folks !

I have a customer with 2 ALPHA 2100 A Windows NT 3.51, Cluster 1.0 SP2 and 
SQL 6.5.

The SQL-Database is installed on one node and the master.dat-File is on 
a shared disk, because the customer want to use the RAID5 on the shared
disk.

We want to upgrade to Windows NT 4.0 and Cluster 1.1, I have read I must
install on both servers the SQL-Database with a master.dat on the local
systemdisk. How I install SQL with a master.dat on a shared disk. 

When I have no possibility to install the master.dat on the shared disk, 
how must I config the SQL-Database in the cluster. 

When I have two local master.dat, how I must define the SQL-Server, that 
both server have the same SQL-Information?

I have read the SQL-Tips.doc, but I have nothing found for my problem.

Can anybody help me?

Reiner
T.RTitleUserPersonal
Name		DateLines
733.1install SQL on shared disk AEOENG::16.40.240.154::annecy::lehyTue Apr 08 1997 06:066
Do you really need to run two SQL in your cluster ? You may perhaps
install SQL server on a shared disk, and start/stop the service with a
cluster script.
733.2MPOS01::naiad.mpo.dec.com::mpos01::cerlingI'[email protected]Tue Apr 08 1997 11:3314
	The documentation explains fully how to install SQL Server.  Since
	you currently have master.dat installed on a shared disk, you are
	going to have to re-install and get it installed on the local disks.
	Failover of SQL with a shared master.dat is not supported.  Keeping
	the proper information in the two master.dat files is what the
	cluster software does.

	My recommendation is to start over, installing things the way the
	documentation tells you to install it.  If the customer wants to
	use RAID on the disk that has the master.dat on it, I would recommend
	that he use software RAID0 (shadowing) on the local disks.

tgc
733.3CSC32::HOEPNERA closed mouth gathers no feetTue Apr 08 1997 16:4411
    
    There is NO way on this green earth I would put a master on a shared
    device. 
    
    Please install SQL according to the documentation.  
    
    Besides which, why not use RAID 0+1 for your databases?  The
    performance is considerably (10 to 15%) better than on RAID 5 
    for any database engine (SQL Server, Oracle, Rdb, ...)
     
    Mary Jo
733.4SUOIS2::SUFP02::stu01::KlugeThe answer is 42Wed Apr 09 1997 03:138
Thanks for your many replies!

Where ist documentation, how I exactly install SQL on both cluster nodes.
And what happen during the failover? Is there a datareplication between
the two SQL-Databases, every SQL-Server should has the same informations?

Reiner
733.5MPOS01::CERLING[email protected]Wed Apr 09 1997 09:029
    Cluster documentation can be found at:
    
    	\\ljsrv1\nt_clstr
    
    I would really encourage you to read both the documentation and this
    notes conference.  They most likely contain answers to all your
    questions.
    
    tgc