backup connection DB into the server.
Primary conection:
Secundary conection:
If the primary conection fail go to secundary wiht no restart the server.
Daniel
Hi Daniel,
while this sounds nice it may be really a problem to detect that the primary connection got lost. Anf if you synchronize the databases with a “master” and “slave” setup you’'ll have some fun to switch back to the slave database.
The database engines are very stable and servers with 2xpower supply, 2xCPU, raid, … are also common, so it makes only very little sense to have two databases running.
Anyhow there are JDBC proxies available like http://ha-jdbc.sourceforge.net/ to access a database cluster - this is not exacly what you asked for but maybe you like the idea.
LG