always on solution

  • In Always on would it be possible to have both an Active/Passive cluster and another Active cluster used for reporting?

  • not sure I understand right.

    In Always On you have 1 primary instance and up to 4 secondary instances.

    Whereas only the primary is writeable, all the secondarys are readable.

    You can either connect connect explicitly to one of the secondaries or you connect to the listener and configure it for read only routing.

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

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