509 reputation
1824
bio website devermind.com
location Germany
age 38
visits member for 5 years, 1 month
seen Feb 12 at 0:36
Please visit my development blog at http://devermind.com if you'd like to learn more about me.

May
30
revised Looking for a DNS Hosting provider with automatic failover and role switching
added 471 characters in body
May
30
comment Looking for a DNS Hosting provider with automatic failover and role switching
@Tom: I'm sorry, but I don't understand your objection. Please see my edit above for more details.
May
30
revised Looking for a DNS Hosting provider with automatic failover and role switching
added 298 characters in body; added 10 characters in body
May
30
comment Looking for a DNS Hosting provider with automatic failover and role switching
@Jesper: 1. It's trvial to write a small web app that monitors the db server and returns it's current state. 2. I did mention that I am going to set up two SQL Servers with mirroring. MSSQL Mirroring always supports automatic failover. 3. Problems with low TTL can be avoided quite easily if only the web server instances have to honor it. I agree it can be problematic if relying on end user clients to honor the TTL, but that is not the case in my scenario.
May
29
comment Looking for a DNS Hosting provider with automatic failover and role switching
Actually there is an easier way (as I just noticed). See my answer...
May
29
answered Looking for a DNS Hosting provider with automatic failover and role switching
May
29
comment Looking for a DNS Hosting provider with automatic failover and role switching
1. My sql servers are hosted on the same machines as my web servers, so I can simply monitor those without expsosing the database to the internet 2. This point is irrelevant. The DNS server does not even need to know what the A record it is serving points to. It just looks up an A entry and returns an IP address, plain and simple. SQL server is responsible for automatic failover, and that is completely independent of DNS lookups. Point 3 can be solved with a DNS entry has a very low TTL (60 seconds)
May
29
asked Looking for a DNS Hosting provider with automatic failover and role switching
May
29
accepted Implementing Automatic failover with SQL Server 2008 R2 Web Edition
May
29
comment Looking for smart DNS hosting
Couldn't the second issue be worked around by using a very low TTL paired with a DNS resolving the IP for the database server? In other words using something like sql.mydomain.com in your connection string. Then it does not matter if the user hits the secondary or primary web server. Both are using the same database.
May
29
comment Looking for smart DNS hosting
But doesn' that create a single point of failure on the load balancer?
May
28
accepted What's the risk of disabling Network level authentication with Windows Remote Desktop?
May
27
comment Implementing Automatic failover with SQL Server 2008 R2 Web Edition
Good points, thanks a lot!
May
27
asked What's the risk of disabling Network level authentication with Windows Remote Desktop?
May
27
revised Implementing Automatic failover with SQL Server 2008 R2 Web Edition
edited title
May
27
asked Implementing Automatic failover with SQL Server 2008 R2 Web Edition
Jan
29
awarded  Popular Question
Jan
26
accepted Do I need these incoming open ports?
Jan
26
comment Do I need these incoming open ports?
@Nick Kavadias: The one that comes with the OS.
Jan
26
revised Do I need these incoming open ports?
added 9 characters in body