|
|
|
This chapter provides tutorials for a variety of replication use cases.
Before beginning with any of these tutorials, be sure to follow the procedures in Setting Up FairCom Servers for Replication.
The following tutorials are included in this chapter:
Read Scalability - Create a read-only copy of your data with minimal performance impact. Run reports and analytics on additional servers without impacting the primary server; create a live copy of your data for quick recovery; replicate to a geographically distant location for centralized data warehousing, reporting, analytics, machine learning.
Massive Read Scalability - Use asynchronous replication to replicate the entire database to many other servers in the same data center. Provide multiple duplicate copies of your data without impacting performance.
Global Shared Data - Selectively replicate shared data from a centralized database across and within data centers to globally distributed applications to ensure they all use the same master and lookup data.
Global Distributed Read Scalability - Use asynchronous replication to replicate an entire database or subsets of it across many remote servers and clients, horizontally scaling the data to support very large numbers of read-only users.
Automatic Database Failover - Set up a cluster of one or more servers. When the database detects a failure of the primary database server, it automatically fails over to a secondary database server without requiring the operating system to provide clustering.
For complete descriptions of the replication models described in these tutorials, see Use Cases for FairCom Replication.
