Join this Viscosity webinar to uncover differences between High Availability and Load Balancing along with the two main types of replication used. Additionally, we will discuss Log Shipping and any hybridization of Log-Shipping with Replication (Cascading and Synchronous).
What you can take away from this webinar:
Physical Replication
- the architecture involved
- flavors of physical replication (asynchronous and synchronous)
- considerations and implications for either types’ use-case (database size, etc.), as well limitations.
- Demo: setting such up along with monitoring.
Logical Replication
- the architecture involved
- publisher and subscriber models and roles, advantages and limitations of each
- Demo: setting up both modes, along with monitoring.
Log Shipping
- the architecture
- roles involved
- Primary and StandBy, and any implications with using such.
- prepping both the Standby and Primary Servers
- authentication implications
- Multiple-Synchronous Standby setups
- cross pollination with Cascading and cross pollination with Synchronous Replication along with the Cascading Replication features allowed in Log Shipping.
- Demo: setting up Log Shipping and monitoring such.
