Database Mirroring refers to creating copies of the database on multiple servers (located locally or at remote locations) and updating them immediately for every update on the primary database so that the primary and secondary copies are always the exact replicas. The objective behind mirroring of database is to increase the availability and reliability of the database system to the end users. Most sophisticated business applications require the database to be available all the time. Multi-platform database mirroring and multi-server database mirroring enables minimum downtime in case of server failures.
Multiplatform Database Mirroring
In this, mirror images of database can be created on servers with different operating platforms. One server may have Windows platform, and other have Linux or Solaris operating system.
Multi-server Database mirroring
Multi-server database mirroring refers to creating multiple copies of the database and storing them on different servers. Multi-server database mirroring offers great advantages like:
- Easy Availability and Low Response Time: Multiple copies can be kept at servers located at geographically distant locations to serve the local users of the region with a faster response time.
- Load balancing: With databases on different servers, various user groups mapping to each server can be created to reduce load on the main server.
- Real-time data replication: Multi-server database mirroring in real time leads to data synchronization across all databases.
- Disaster recovery: Multi-platform database mirroring and multi-server database mirroring are ideal solutions for disaster recovery.
Database Mirroring Software Tools
Implementation of above mentioned advanced database features require using sophisticated software tools. MMM (Multiple Master Mirroring) offers features, such as multi-platform database mirroring and multi-server database mirroring. Single Click Solutions offers other database software solutions for implementing these concepts like SMM (Single Master mirroring Software) and REPLICATOR softwares.
Read about :