Setting up an SQL server on a four-node SAN cluster

Setting up an SQL server on a four-node SAN cluster

I am planning to setup an SQL server on a four-node SAN cluster. I am being offered Fibre hubs and Fibre Switches. What do you recommend? What are the pros/cons of each?

    Requires Free Membership to View

    When you register for SearchStorage.com, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics, the latest news and the biggest challenges you face as a storage professional today.

    Rich Castagna, Editorial Director

    By submitting your registration information to SearchStorage.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchStorage.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

My recommendation would be to skip the hubs, and go with the switches for your four-node cluster. The reason being is that while hubs may be cheaper than switches, you also get what you pay for. Given that you are clustering your services, I presume for high availability, why take any chances on hubs with shared bandwidth and shared loop access? Switches have the ability to support loop devices -- for example, an older tape drive, should you have the need. With a hub all ports share the common bandwidth of the hub, which could impact your performance. Beyond performance, switches also have the advantage of providing better isolation of ports and subsequently various devices. Since you are clustering, I would also recommend implementing a pair of switches to create to separate paths to your storage for redundancy. The price of Fibre Channel switches and adapters continue to decrease in price, which makes redundant paths more affordable.

This was first published in July 2004