Transaction Replication

Database Replication

Why:- If we store our entire data in one database or one server, there is much danzer to loose our data and whenever you want to retrieve it will take latency due to data loading so for that purpose we do this Transaction Replication

What :- Create two database instance and attach one database A instance to application, this application will store the data into this original database.

From that database you can do replication to B database

How:- Setup Publication:-

After creating two databases we need to establish connections between two instances, for that you need to amble remote access ON,

And create publication and subscription for that we need to execute database scripts in A original DB instance

Now you execute the script and see in the replica DB instance all the objects will replica will store in the database (Subscription)

Advantages:-

Easy Backup,

High Avlblty

Disaster mngmt

Low latency

#devops #database #Kubernetes

#transaction #replication #deployment #docker