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 :
1 2 3