Secondary database server
Encyclopedia
A secondary database server or SDS is a database server
that is kept in synchronisation with the main database so that if the main database goes offline, the secondary database server can be used instead. This is important for a live system that must be online 24 hours a day, and most DBMS systems that support SDSs are capable of automatically detecting and switching to the secondary server within seconds of the main server going offline. The secondary database server can also be used to run read-only queries to take load off the first database server and increase system performance.
Database server
A database server is a computer program that provides database services to other computer programs or computers, as defined by the client–server model. The term may also refer to a computer dedicated to running such a program...
that is kept in synchronisation with the main database so that if the main database goes offline, the secondary database server can be used instead. This is important for a live system that must be online 24 hours a day, and most DBMS systems that support SDSs are capable of automatically detecting and switching to the secondary server within seconds of the main server going offline. The secondary database server can also be used to run read-only queries to take load off the first database server and increase system performance.