Category Archives: Replication

MongoDB Replica-Set

Posted on January 13, 2019 by

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

Posted on May 24, 2018 by

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

Posted on May 23, 2018 by

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…

Posted on May 4, 2018 by

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

Posted on February 22, 2014 by

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

Posted on October 16, 2013 by

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

Posted on November 27, 2011 by

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

Posted on April 25, 2011 by

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

Posted on January 27, 2010 by

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

Posted on January 19, 2010 by

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