Home Forums SQL Server 2008 SQL Server 2008 High Availability Failover clustering with Database Mirroring RE: Failover clustering with Database Mirroring

  • January 23, 2013 at 5:28 am

    #1580019

    SQL* (1/23/2013)

    hi all,

    I'm learning these HA/DR things.

    "Failover clustering with Database Mirroring"

    What does it means?

    Clustering: Two nodes being synchronized. (Physically & SQL Server level)

    Mirroring: Primary & Secondary (Standby server).

    Not quite right my friend, this is more accurate.

    • Clustering: Has a standby node which takes ownership of cluster resources after failover. Nodes are synchronised in that all information regarding the cluster resources is synchronised between the nodes.
    • Mirroring: Principal and Mirror, Two nodes being synchronized. at database level

    SQL* (1/23/2013)

    What is benefit over individuals?

    Basically, Clustering provides redundancy at the SQL Server instance level, Mirroring provides redundancy at the database level.

    SQL* (1/23/2013)

    How can we combined these two?

    Combining clustering and mirroring is possible, although with AlwaysOn groups in SQL Server 2012, you may not need to do this. It all depends on your requirements. What makes you think you require both these technologies combined?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉