Types of Data Replication in Distribution System

 What is data replication?

 

Data replication is the process of storing data in more than one site or node. It is useful in improving the availability of data. It allows users to transfer the same data to different people without any error or deflection.   

 

The result is a distributed database in which users can access data relevant to their tasks without interfering with the work of others. It has numerous other advantages, such as,

 

1. High Availability of Data

2. Improves the performance for retrieval of global queries as

the result can be obtained locally from any of the local site

3. Faster execution of Queries

4. Higher availability

5. Reduced latency

 

Data replication is fairly easy when data on a node to be replicated on other nodes doesn’t change. However, replication becomes trickier when data is in constant flux.

 

Moreover, there can be full replication, in which the whole database is stored at every site. There can also be partial replication, in which some frequently used fragments of the database are replicated and others are not replicated.

 

 

Let’s discuss the types of data replication to have a deep understanding about the concept.

 

Types of data replication

 

1. Snapshot replication

 

Snapshot replication distributes data exactly as it appears at a specific moment in time and does not monitor for updates to the data. When synchronization occurs, the entire snapshot is generated and sent to Subscribers.

 

It means that the data that has been snapped will be distributed without any alteration or upgradation. It will be generated and distributed.

 

It moves multiple records simultaneously. Though it is slow, it is a good way to perform initial synchronization between the publisher and the subscriber.

 

2. Transactional replication

 

Transactional replication is a SQL Server technology that is used to replicate changes between two databases. The key components in transactional replication are the Publisher, Distributor, and Subscriber.

 

Data is copied in real time from the publisher to the receiving database(subscriber) in the same order as they occur with the publisher therefore in this type of replication, transactional consistency is guaranteed.

 

3. Merger replication

 

Merge replication is a method for copying and distributing data and database objects from one SQL Server database to another followed by synchronizing the databases for consistency. 

 

It is the most complex type of replication because it allows both publisher and subscriber to independently make changes to the database. 

 

In this replication updates are made at more than one node, the same data may have been updated by the Publisher and by more than one Subscriber.

 

Therefore, conflicts can occur when updates are merged and merge replication provides a number of ways to handle conflicts.

Comments

Post a Comment

Popular posts from this blog

Digital Printing Services- The Incessant Trend

Image
  When we talk about the printing industry, the first thing which strikes our minds are Digital Printing Services. The changing world has changed not only our lifestyle but also our way of doing things such as printing. We have come a long way from traditional printing to digital ones. We prefer to bestow the best printing services, but before enjoying them, you need to know about this ongoing trend!!      What is Digital Printing? We bestow the best Digital Printing Services , and to maintain the transparency of our bond, this article will enlighten you with every aspect of digital printing. To start with the basic, digital printing is the evolved form of traditional printing where everything is done technically. This process indulges in printing things with the help of complex computing. It involves an analysis of the image that is further printed via a digital printer. How does it work? If you think, digital printing is litho printing, then you are wrong. In litho printing,
Read more

The Importance of Printing to a Business & Its Success

Image
  With new technology, social media platforms, and approaches to reach audiences, people regularly believe that tried, tested, and true forms of print media have become undesirable. However, notwithstanding new mediums and forms of the contest, print media still assumes an important part in the success of businesses. Print is a substantial medium that actually delivers extraordinary outcomes for businesses that utilize it to help develop their customer base. Additionally, as different technologies have entered the brawl, printing technology has continued to advance and adapt to a steadily changing environment.    There are a few different ways that show that printing is still an entirely important data and advertising instrument for businesses. Computerized printing technology has given businesses more extraordinary approaches to reach out to customers to develop their business. Listed below are the 3 reasons so as to why digital printing services are important for your busine
Read more

Tips to make your booklet printing creative

Image
Booklets are probably the most ideal approaches to advance your items and administrations. They have been widely utilized as a promoting instrument alongside leaflets to sell items and administrations. This has likewise made the traditional booklet somewhat exhausting. The vast majority of the booklets have a similar rectangular shape and are printed four tones on high quality paper. Booklets give a wide scope of alternatives for your business advertising to flourish. Regardless of whether you choose to print 8 or 48 pages, booklets are an incredible method to grow your all around existing assortment of promotional insurance. On the off chance that you are on the chase for another approach to advance your items and administrations, consider putting resources into printing booklets. With a little plan guidance and an effective angle, booklet printing can take your promotion to another level. If you are in the business of promoting items, booklet printing is an advantageous method to ge
Read more