| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 733.1 | install SQL on shared disk | AEOENG::16.40.240.154::annecy::lehy | | Tue Apr 08 1997 09:06 | 6 |
| 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.2 | | MPOS01::naiad.mpo.dec.com::mpos01::cerling | I'm@witz.end | Tue Apr 08 1997 14:33 | 14 |
|
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.3 | | CSC32::HOEPNER | A closed mouth gathers no feet | Tue Apr 08 1997 19:44 | 11 |
|
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.4 | | SUOIS2::SUFP02::stu01::Kluge | The answer is 42 | Wed Apr 09 1997 06:13 | 8 |
| 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.5 | | MPOS01::CERLING | im@miwitz.end | Wed Apr 09 1997 12:02 | 9 |
| 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
|