A distributed Server configuration comprises several sites, each with its own set of Servers and database instances. The Servers at each site are connected to the respective Server database servers at that site.
Deploying servers across multiple sites offers several advantages:
- Local communication and communication with the nearest server reduce cross-site traffic, improving bandwidth and response time.
- Users of other sites are not affected by the failure of a single server site.
- Multiple additional sites offer backup options for enhanced reliability.
Geographically distributed or multi-site deployments operate by spreading resources across different locations or sites
- Distributed Server setup consists of a main site and multiple satellite sites
- Satellite site Server configuration is similar to the main site, except for certain parameters
- Satellite sites can replicate local changes bidirectionally with the main site, while audit logs replicate unidirectionally from satellite to main site
Replication of databases involves copying and synchronizing data across multiple databases to ensure consistency and availability
- Different vendors offer various database replication technologies.
- Sureworks Security Access Manager for Enterprise Single Sign-On only supports DB2 database replication.
- The main site’s server hosts the master database, while each site can have a stand-alone, clustered, or mirrored database server for high availability.