I want to host a website with a database backend, for a client but availability is important.
I'm going to get 2 servers each duplicates of one another and I can do simple failover easy but I want to allow direct access to the database by the clients. Can I do this using DNS mapping?
I will use MySQL and replicate from master to slave. But I want an ODBC connection on a client PC to be mapped to the active database.
Thanks in advance