RE: Another clustering question (MS SQL 7.0).
Distributed Partitioned Views are real the only way 2 load balance in MS SQL but u will need MS SQL 2000 Enterprise Edition. >From Rif Kiamil -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:32 To: CF-Talk Subject:RE: Another clustering question (MS SQL 7.0). Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB and 2 SQL servers. One of the SQL servers is live and the other is passive, both sharing a disk array containing the databases. If server 1 fails then server 2 takes over. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:29 To: CF-Talk Subject: Another clustering question (MS SQL 7.0). Dear subscribers, talk me please about clustering software you use for cluster MS SQL Server 7.0 (or 2000). I would like to solve two problems - the first: solution must provide fault tolerance, the second: load balancing very desirable for me. I tried MS Cluster Service and Legato Cluster Server - those products are good for solving first problem, but I can't find any product that can provide load balancing - it possible in common case for MS SQL Server? Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Re[2]: Another clustering question (MS SQL 7.0).
Don't think so..I think it only controls SQL services. I have not set one up myself. Our ISP set the cluser up for us and just tell us what each bit does. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:43 To: CF-Talk Subject: Re[2]: Another clustering question (MS SQL 7.0). Thank you, Andrew! please tell me, can Co-Standby control IIS and ColdFusion services? Alexandr. AE> Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB AE> and 2 SQL servers. One of the SQL servers is live and the other is passive, AE> both sharing a disk array containing the databases. If server 1 fails then AE> server 2 takes over. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Another clustering question (MS SQL 7.0).
Thank you, Andrew! please tell me, can Co-Standby control IIS and ColdFusion services? Alexandr. AE> Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB AE> and 2 SQL servers. One of the SQL servers is live and the other is passive, AE> both sharing a disk array containing the databases. If server 1 fails then AE> server 2 takes over. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Another clustering question (MS SQL 7.0).
Try a product called Co-Standby. I am running a site on 4 servers - 2 WEB and 2 SQL servers. One of the SQL servers is live and the other is passive, both sharing a disk array containing the databases. If server 1 fails then server 2 takes over. -- Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -Original Message- From: Alexandr Timchur [mailto:[EMAIL PROTECTED]] Sent: 17 May 2001 12:29 To: CF-Talk Subject: Another clustering question (MS SQL 7.0). Dear subscribers, talk me please about clustering software you use for cluster MS SQL Server 7.0 (or 2000). I would like to solve two problems - the first: solution must provide fault tolerance, the second: load balancing very desirable for me. I tried MS Cluster Service and Legato Cluster Server - those products are good for solving first problem, but I can't find any product that can provide load balancing - it possible in common case for MS SQL Server? Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Another clustering question (MS SQL 7.0).
Dear subscribers, talk me please about clustering software you use for cluster MS SQL Server 7.0 (or 2000). I would like to solve two problems - the first: solution must provide fault tolerance, the second: load balancing very desirable for me. I tried MS Cluster Service and Legato Cluster Server - those products are good for solving first problem, but I can't find any product that can provide load balancing - it possible in common case for MS SQL Server? Thank you, Alexandr Timchur. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
