Post reply

Reporting/HA design advice- FCI with AG

  • April 8, 2018 at 4:04 pm

    #334202

    Looking for advice on design for Reporting solution.
    What we currently have- WSFC1 with 2 nodes (Act/Act) and 2 FCIs (sqlserver 2016 Ent Ed).
    For DBs from 1 instance Business came with request to createseparate Reporting instance (real time copy of OLTP) and DataWarehouse one (ETLfrom Reporting DBs)- again- with HA. Therefore our plan is:
    - to create 2-nd WSFC2 (2 nodes, Act/Act with 2FCIs) and
    - to tie these 2 WSFC via AG- Primary Replica on OLTP instance andSecondary (Read only)- on Reporting instance. Hence Replicas will be ondifferent WSFC Distributed AG should be created.
    Questions:
    1) Is is doable? Any caveats in that design? 2)Other suggestions for design?

    Thanks

  • April 9, 2018 at 5:47 am

    #1985935

    Yuri55 - Sunday, April 8, 2018 4:04 PM

    Looking for advice on design for Reporting solution.
    What we currently have- WSFC1 with 2 nodes (Act/Act) and 2 FCIs (sqlserver 2016 Ent Ed).
    For DBs from 1 instance Business came with request to createseparate Reporting instance (real time copy of OLTP) and DataWarehouse one (ETLfrom Reporting DBs)- again- with HA. Therefore our plan is:
    - to create 2-nd WSFC2 (2 nodes, Act/Act with 2FCIs) and
    - to tie these 2 WSFC via AG- Primary Replica on OLTP instance andSecondary (Read only)- on Reporting instance. Hence Replicas will be ondifferent WSFC Distributed AG should be created.
    Questions:
    1) Is is doable? Any caveats in that design? 2)Other suggestions for design?

    Thanks

    Are the cluster nodes running Windows 2016 or a lower version?

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

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

  • April 9, 2018 at 7:17 pm

    #1986053

    2012

  • April 10, 2018 at 3:28 am

    #1986076

    Yuri55 - Monday, April 9, 2018 7:17 PM

    2012

    you're rather limited there to be honest.
    If you can upgrade the nodes to Windows 2016 you'll have better options with the WSFC

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

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

  • April 10, 2018 at 6:11 am

    #1986094

    Thanks Perry

Viewing 5 posts - 1 through 4 (of 4 total)

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