Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 difference "Automatic Failover" With Redirection

Author  Topic 

m.esteghamat
Starting Member

47 Posts

Posted - 2015-02-15 : 06:46:17
Hi
I confused between automatic redirection and automatic failover.
Dose redirection , run after automatic failover?
Dose automatic failover run loanly? in which events ?
Dose automatic Redirection run loanly? in which events ?
Thank you

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-16 : 12:38:08
What techonology are you referring to? What is "loanly"?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

m.esteghamat
Starting Member

47 Posts

Posted - 2015-02-17 : 00:36:27
Availability Group .
No I dont want Use It Aloanly ?
I asked Why they are seperated ?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-18 : 12:34:01
I don't understand your post. But let me talk about AGs for a bit and hope it addresses your questions.

When a failover occurs and if the applications are pointing to the AG listener, the applications will automatically be redirected to the AG's new primary instance.

A failover can occur for many, many reasons. Here are some reasons: network issue, database files go offline because of a disk issue, Windows crashes, etc. If the cluster loses quorum due to any of these issues, a failover will occur. Quorum is dependent on the votes. If you have 2 nodes in the cluster, you will have a third resource that gives the cluster quorum. Sometimes that third resource is a file share on a another server, sometimes it's a SAN drive. If the inactive node goes down, you still have quorum since you still have two voting members available.

For read-intent workloads, the primary instance will redirect those queries to the read-only instance(s). Which one it goes to is dependent on the read-only routing list.

I still don't know what you mean by "loanly".

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -