• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 61 subscribers
  • Views 668 views
  • Users 0 members are here
Options
Related

High Availability Configuration

graziano santucci
10 months ago

Hello everyone,

I wanted to know if there is a configuration mode for achieving high availability in case of server failure. For instance, is it possible to set up a configuration like a farm with multiple servers using the same database?

Thank you and regards.

Parents
  • 0 9 months ago

    Hello, graziano.

    Indeed, Active Roles does support - and recommend as "Best Practice" - that you should always have at least two AR servers to eliminate single-point-of-failure. You could also use a DNS alias to connect to your AR servers, allowing you the opportunity to manage which server(s) the DNS alias resolves to. In some cases, customers may also opt to use a load-balancer or similar device to manage that DNS alias automatically, which would allow you to do things like load-balance by alternating which server the alias resolves to, and automatically remove servers from the resolution pool if they become unavailable.

    In turn, these servers should/can be connected to some kind of highly-available SQL infrastructure: cluster (most common), replicated, mirrored, or cloud-hosted.

    Hope that helps?

    Shawn

Reply
  • 0 9 months ago

    Hello, graziano.

    Indeed, Active Roles does support - and recommend as "Best Practice" - that you should always have at least two AR servers to eliminate single-point-of-failure. You could also use a DNS alias to connect to your AR servers, allowing you the opportunity to manage which server(s) the DNS alias resolves to. In some cases, customers may also opt to use a load-balancer or similar device to manage that DNS alias automatically, which would allow you to do things like load-balance by alternating which server the alias resolves to, and automatically remove servers from the resolution pool if they become unavailable.

    In turn, these servers should/can be connected to some kind of highly-available SQL infrastructure: cluster (most common), replicated, mirrored, or cloud-hosted.

    Hope that helps?

    Shawn

Children
No Data