[WEBINAR] The New Normal: Dealing with the Reality of an Unsecure World

Transactional Replication

Definition - What does Transactional Replication mean?

Transactional replication is the automated periodic distribution of changes between databases. Data is copied in (or near) real-time from the primary server (publisher) to the receiving database (subscriber). Thus, transactional replication offers an excellent backup for frequent, daily databases changes.

Techopedia explains Transactional Replication

In most cases, transactional replication begins by taking a publisher snapshot, which is then copied to the subscriber. Then, any publisher changes are logged in real-time and replicated at the subscriber.
Transactional replication does not simply copy the net effect of data changes, but rather consistently and accurately replicates each change.

For example, a customer’s account balance in a commercial bank’s publisher database initially reads $2,000. Then, within the span of a few minutes, the customer deposits $500 and then withdraws $1000 from the ATM. The net effect is $2000+$500-$1000=$1500. However, a transactional replication does not simply update the subscriber client account as $1500. Each of these two transactions also must be written to the subscriber.

Because of its near real-time nature, transactional replication is frequently used by two or more database administrators (DBAs) as a failover mechanism where more than a few minutes of downtime is not an option, e.g. ATM networks and nuclear power stations. In this regard, transactional replication has proven to be a reliable mechanism for backup databases.

Other replication types include merge and snapshot replication.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
"Techopedia" on Twitter

Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Free Whitepaper: The Path to Hybrid Cloud
Free Whitepaper: The Path to Hybrid Cloud:
The Path to Hybrid Cloud: Intelligent Bursting To Amazon Web Services & Microsoft Azure
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.