Category Archives: Replication

MongoDB Replica-Set

The most important feature of MongoDB is its easy setup and use of Replica set. in mongo db you can easily setup it here is the link for it which I am used by Soham Kamani Create a network: Docker … Continue reading

Posted in Disaster Recovery, High Avaliability, MongoDB, Others, Replication | Tagged , , , | Leave a comment

Day 24 Replication Setup

Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed Connection to both servers are accessible. On Master Server: Edit my.cnf with following information: [mysqld] Log-Bin =MySQL_Binlog Server_ID=1 Create … Continue reading

Posted in Disaster Recovery, High Avaliability, Internal, MySQL, Others, Replication, What I learned today | Tagged , , | Leave a comment

Day 23 Replication

Replication means making copy of the objects and moving transaction from primary server to secondary/standby/Slave server. There are two type of Replication Master-Master Replication Master-Slave Replication Like other RDBMS MySQL works replication on Transactions. The pre requisite of replication is … Continue reading

Posted in MySQL, Others, Replication, What I learned today | Tagged , | Leave a comment

Day 4: MySQL Architecture Continue…

MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL works on following options: Option/configuration file (my.cnf) System variables (Local /Global) Status variables My.cnf option file will have various Groups and … Continue reading

Posted in Basic, DB Design, High Avaliability, MySQL, Others, RDBMS, Replication, What I learned today | Tagged , | Leave a comment

Re-initialize replication not working

For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask for- do you want to generate snapshot now, if you say “yes” it will create a metadata of the articles … Continue reading

Posted in Add/remove, High Avaliability, Replication, Troubleshooting | 1 Comment

LogReader agent failed

You may get an error on log reader agent failed with following error:   Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission. … Continue reading

Posted in Replication, Transaction Log, Troubleshooting, What I learned today | Leave a comment

Day 26: Replication Errors

Day 26: Replication Errors Replication is one of my favorite topic, I worked on Transaction Replication, and Blogged about it here. Replication is possible from higher version to lower version. configure replication… remember to configure from higher version to lower … Continue reading

Posted in Replication, Troubleshooting | Tagged , | Leave a comment

Powershell Day 25

Day 25 RMO   I have observed that no body has written anything about RMO. And replications is one of my favoriate topic, so tried to write this blog. Please DO NOT TRY THIS SCRIPT ON PRODUCTION, I AM NOT … Continue reading

Posted in Replication | Tagged | Leave a comment

Adding Articles to and Dropping Articles from Existing Publications

While checking on the forum found many questions about how to add/drop articles from existing replication. so though of blogging on it. Everyone should follow this (must read) which is the base/reference for this blog . >>Snapshot/Transactional Replicaiton:- Adding Articles:- … Continue reading

Posted in Add/remove, Replication | Tagged | Leave a comment

Rename Distribution job

Whenever we create a replication (transaction replication) whether it is from Wizard or script, the respective agent (log reader, distributor and snapshot) job created automatically with their default naming conversion as Snapshot Agent: [PublisherServerName]-PublisherDB-PublisherDB- [# of time replication script/wizard run … Continue reading

Posted in Others, Replication | Tagged | Leave a comment