Post reply

Load Balancing and fail over cluster

  • June 13, 2014 at 11:09 am

    #309145

    Is there such a thing called 'Load balancing' on fail over cluster? any input helps

  • June 13, 2014 at 3:47 pm

    #1721664

    Hello,

    Traditional failover clustering doesn't include any load balancing technologies, it's purpose is to make sure that you'll have service up and running in case one of the nodes has some sort of failure either in hardware, the operating system or in the SQL Server service itself.

    Starting with SQL Server 2012 there are some alternatives such as AlwaysOn Availability Groups that offer readable secondaries to offload, for example, reporting workloads. Here's a link to MSDN article about them.

    AlwaysOn Availability Groups

    There are also ways to scale-out SQL Server installations if you require multiple writable copies of the database, but they're bit more complicated requiring something like peer-to-peer replication and actual load balancers in front of the database servers.

    Mika Sutinen, Senior DBA
    @SQLFinn on Twitter
    Blogging at SQLStarters[/url]

  • June 14, 2014 at 6:33 am

    #1721742

    Thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply