Synchronous or Asynchronous?

About this interactive

The lesson uses a database whose transactions are copied to a second site. Synchronous: before a transaction is entered, it is copied over, and then it is executed on both databases. There is no chance the two get out of step. The disadvantage: if copying to the other site is slow, every transaction waits for it. Asynchronous: the transaction is executed at the first site, then sent to the other site and applied whenever it can be. Nothing at the first site waits. The disadvantage: if a change never makes it over, the databases end up different. Replication is not a backup: a mistake executed on one database is replicated to the other too.

What you'll learn

Tell synchronous replication (each change reaches the replica before it completes, so no committed change is lost, at the cost of waiting on the link) from asynchronous replication (the primary commits first and the replica catches up, so it stays fast but can lose recent changes)

Aligned to

CompTIA Security+

3.4 Explain the importance of resilience and recovery in security architecture.

Key terms

Synchronous Replication: A replication method where data changes are committed to all copies simultaneously, ensuring consistency between systems at all times.
Asynchronous Replication: A replication method where data changes are committed to the primary system first and then sent to the replica at a later time.
Replication: The process of copying and continuously synchronizing data from one location to another to ensure availability and fault tolerance in the event of a failure.

Topics

Interactive Streak Sort

About TechKnowSurge

TechKnowSurge builds IT and cybersecurity professionals through hands-on, concept-first training built around real understanding — not memorization. Free interactive tools, structured programs, and 25+ years of real-world experience, all in one place.

Explore free tools and programs →