| The solutions for achieving high Availability database system are range from complete hardware redundancy to software redundancy such as standby databases, replicated databases and database cluster of many kinds. The challenge in most HA databases system in compensate not only for unplanned outages but also for planed outages as well.In this thesis, firstly we examine the requirements for high availability, the measures used to express it, causes of downtime and system recovery technology. Secondly, we examine the method used to provide HA for systems. Which include hardware solutions,solutions for HA database and transactional HA solutions. The purpose of the present thesis is to find an economical solution for a HA intelligence handling system in university,which provides fast failover and recovery using Tuxedo software, a transactional middleware .It is a way to cording businesses transactions that modify database and keeps a write-ahead-log of all the modifications made to the database over a period time. The system allows use of heterogeneous. The system can take the failover from normal mode to degraded mode, in case of node/database failure. The performance of the system is no degraded. and no work is lost. No need for shutdown the machines, the system can recovery from degraded mode to normal mode. It is only needs administrator do a little of work. The HA solution for database system, which makes use of a transactional middleware to solve the synchronization and the recovery, compared with other HA database technology such as real application cluster, the low cost is an advantage. |
PDF Full Text Request