514 reputation
1924
bio website devermind.com
location Germany
age 38
visits member for 5 years, 5 months
seen Oct 9 at 19:06
Please visit my development blog at http://devermind.com if you'd like to learn more about me.

Jun
22
asked Can't log anymore with RDP on my server after adding it in my domain
Jun
4
comment Server monitoring?
-1 I beg to differ. I've tried Polymon, but found anything but intuitive. I struggled for about an hour to get even a simple CPU usage monitor going and gave up after lots of trial and error and several softwre crashes. I wish I could recommend anything else instead, but so far I haven't found it.
Jun
3
accepted Looking for a DNS Hosting provider with automatic failover and role switching
May
30
comment Looking for a DNS Hosting provider with automatic failover and role switching
@Raffael: a): because I did not know of the solution I write in my answer below at the time of writing this OP. b): Because the DNS made easy API does not support anything with regards to failover. It can only be used to change regular DNS records, but not to flip primary / secondary server addresses in an automatic failover configuration.
May
30
comment Looking for a DNS Hosting provider with automatic failover and role switching
@Raffael: The web app I describes just tries to return the status of the local db. Tt does nothing with regards to switching the DNS record. That is what I need the DNS provider for. Have a look at this website if you are interested in the details: dnsmadeeasy.com/enterprisedns/dnsfailover.html
May
30
revised Looking for a DNS Hosting provider with automatic failover and role switching
added 4 characters in body
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?