Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility

learn more… | top users | synonyms (1)

2
votes
3answers
1k views

What are alternatives to Replication to distibute data (Microsoft SQL Server)

Is anyone knowledgeable of alternatives to SQL Server replication? I have a scenario where separate databases will share a lot of the same data which complex queries will match against. We want to ...
1
vote
2answers
771 views

After Restore Log_reuse_wait_desc of Replication

I'm wondering if anybody has ran into this issue before and has any suggestions on what's causing it/how to fix it. We are restoring a database into lower Dev environments and after the restore the ...
1
vote
0answers
11 views
+250

Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?

We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this balancing works fine, the parameters wsrep_log_conflicts and cert.log_conflicts should never log any ...
1
vote
0answers
11 views

Error : Failed to Retrieve data for this request when expanding subscriptions in sql server 2008

We are getting error when expanding subscriptions to delete them, we have already dropped distribution database. The error text is "Failed to Retrieve data for this request.(Microsoft.SqlServer....
1
vote
2answers
2k views

mysql replication - missing table for foreign key on slave

i have the following situation: We're running a simple master slave replication with table filters, so the slaves doesn't have all the master tables. Master has table A with FK to table B Slave has ...
1
vote
1answer
153 views

How to measure or estimate the streaming replication lag in Postgres 9.2

I've been asked to reverse engineer an app that uses postgresql in the back end. I can see that there is some database replica tion going on... based on my reading, I *think it's called streaming ...
3
votes
1answer
407 views

Bi-directional replication for the same MySQL table

AppA stores/retrieves data from dbA.tableA AppB stores/retrieves data from dbB.tableA tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA (...
0
votes
1answer
179 views

New Master-Master replication has stopped working

We're building a new MySQL server pair for high availability, and of course it's not like managing a single server. We're working with Ubuntu 14.04 LTS and MySQL 5.5.43 I had master-master ...
1
vote
0answers
19 views

SQL Server Replication - Publication and Subscriber schema differ, need to sync

I have a SQL Server 2005 database where the publication and subscriber schema are different. This was intentionally done by turning the "Replicate Schema" option to False. However I now need to ...
-2
votes
0answers
29 views

How can I replicate some tables from one PostgreSQL database to another? [on hold]

How can I replicate some tables from one PostgreSQL database to another? I know I can replicate a database but I want to replicate 2 or 3 tables from one database to another.
1
vote
2answers
43 views

Slave_IO_Running: Connecting in Master-Slave Replication

I was trying to implement Master-Slave Database Replication on two systems. I followed the steps from the following links https://www.youtube.com/watch?v=DmQWcU2INqQ and Master Slave Replication ...
1
vote
0answers
25 views

SQL Replication Monitor does NOT show publication properties - Transactional Replication

The setup I have is as follows: a) Version SQL Server 2014 SP1 CU6. b) publication is on a separate availability group [AG1] and subscriber is part of another AG [AG2]. c) Distribution is ...
1
vote
0answers
18 views

How to convert MySQL master-slave to master-master

I've searched around, but can't find the exact details to point me in the proper direction. I currently have 2 MySQL instances under 5.5.41 running as a master-slave setup. I followed these ...
4
votes
1answer
3k views

SQL Server 2014 Replication - The process could not connect to Subscriber 'xxx'

I have just set up very basic transactional replication on SQL Server 2014. The Publisher and Distributor are one and the same. I have configured the Publisher to push to the Subscriber, so any and ...
0
votes
1answer
121 views

Laggy slave OK to have only one system user in processlist?

In all the examples of a processlist on a mysql slave I've seen, there are two system users. I have a slave that is very far behind the master. When I do show a processlist, there is only one system ...
1
vote
3answers
5k views

Automatic MySQL Replication Fail-over Strategy

I want to know that if replication is down due to some reason as if master is down then what strategy should be followed so that the replication is up instantly without manually intervening the ...
1
vote
1answer
159 views

Write-lock a whole table during transaction

I need to perform a delicate operation to my table in which I will solely insert, delete and select upon all of my rows and no God may interfere with the table during this operation: the table will be ...
0
votes
1answer
329 views

MySQL - Enabling Scheduled Event on Master and Slave Simultaneously

This may seem a bit strange, but I am trying to get a Scheduled Event to execute on both Master and Slave. I have two databases set up in a Master (A) to Master (B) replication environment. Master A ...
1
vote
1answer
2k views

Permanent count of waiting tasks (2) in Activity monitor

Now I'm observing in Activity Monitor permanent count of waiting tasks: and at "Resource waits" tab I see next: so, my question is: How to find and resolve this wait tasks? I suspect that it ...
0
votes
0answers
12 views

Replication issue SQL Server 2014

I set up a merge replication between one Publisher and a subscriber[ the same tables on both] and everything seems to be working fine and there was not a single conflict in the initial setup and ...
1
vote
1answer
298 views

Slave Waiting to reconnect

I have added new slave host to master for replication, but missing some of the parameters. mysql> show slave status\G *************************** 1. row *************************** ...
0
votes
1answer
1k views

SQL Server 2008R2 - how to install replication components

I am trying to install the Replication components for SQL Server 2008R2, on technet website it says: On the computer that is running IIS, insert the SQL Server 2008 R2, SQL Server 2008, or SQL ...
1
vote
1answer
28 views

Too many open connections with MongoDB 2.6 + PyMongo 2.7.2

I was running MongoDB 2.4 with a replica set which contains 1 primary, 1 secondary and an arbiter. We were using PyMongo 2.6 and MongoEngine 0.8.2. Recently, we performed an upgrade to MongoDB 2.6, ...
2
votes
1answer
478 views

Can a slave with a dynamic ip update the master

How can I setup mySQL replication in such a way that a slave on localhost with dynamic IP can update the master as well as get updates from the master which has a static IP. The slave will not be ...
1
vote
1answer
255 views

MongoDB to MySQL Replication Automatically

i have Mongodb server and mysql server. i want to use mongodb for "write" and mysql for "read". so i am looking for some tool or some process by which we can tranfer mongodb to mysql server on ...
0
votes
1answer
111 views

Error while doing in replicaset in windows (mongodb)

I tried doing the replicatset in windows, but im getting the below error. I checked the mongo process and killed the existing process. Even though the error exists. help me on this pls Thx ...
0
votes
1answer
384 views

Slave not getting replicated SERVER_UUID error

Unable to start replication Master-Slave, I have searched a lot for this but unable to get the Server-UUID of both the server. Do we have any solution for this. Scenario: I have created new slave ...
1
vote
0answers
43 views

MongoDB insert not replicating after db.dropDatabase()

I'm new to MongoDB (inherited a project using it), so this is especially confusing. I have a sharded replicaset between 3 ec2 instances. Everything works fine until I drop a database. The database ...
1
vote
1answer
292 views

mysql replication missed quite a lot SQL statement

I have set up a master/slave with mysql-5.1.73 The master's binlog format is "statement". The master and slave seemed running very well with slave status: Slave_IO_Running: Yes ...
1
vote
0answers
56 views

NOLOCK vs Read Uncommitted

in our environment, reports are running on the subscriber and resulting in deadlocks with MS Replication SPs, which are doing inserts/updates. What's the best way to eliminate the deadlocks? We have ...
0
votes
0answers
34 views

Replication and insert error

I set up a merge replication between one Publisher and a subscriber[ the same tables on both] and everything seems to be working fine and there was not a single conflict in the initial setup and ...
1
vote
1answer
35 views

Setting up Master-Master Replication in MySQL on a live system

I've just recently taken on the task of looking after our mySQL databases, and have been given the task of setting master-master replication. We have a live server which has a mySQL database which is ...
2
votes
1answer
203 views

MySQL slave server getting stopped after each replication request from Master

Basic master-slave MySQL configuration has been done on Windows machine. Master and slave servers are running on localhost with different ports. Now when executing update or insert in master server, ...
3
votes
2answers
27 views

What is the difference between mongod in standalone vs replica set

I've been running Mongodb as a replica set on 3 servers (primary, secondary and arbiter) but because I have to downscale I'm converting the primary to a standalone server. Before this change the ...
0
votes
1answer
24 views

MySQL Semi-synchronous replication with Multi-Master

Is it possible to use semi-synchronous replication with a Multi-Master setup? I've tried to follow this guide to setup a semi-synchronous replication for a master-slave setup: https://avdeo.com/2015/...
1
vote
1answer
512 views

Syncronize mysql databases between local and hosted servers automatically

We have many websites with Development, Staging and Production servers. We have many developers for many projects. We need a solution to synchronize the developer and staging databases. After that one ...
0
votes
1answer
6 views

Unexpected SLAVE STATUS after CHANGE MASTER

I'm trying to setup MySQL replication but I am getting duplicate keys when I start the slave. I've got master and relay. I've also got backup, which is intended to be slaved to relay, but my issue ...
-1
votes
1answer
40 views

Golden Gate Privilege Missing for using Encryption

dblogin userid ogg_user, password AADAAAAAAAAAAAIAKAQIJAGAMFUFKFBGQHXBJIWGECTEIAZHJFYALFFIBGHGJBPFBCPBKEPCRCRHAESJ, AES128, encryptkey securekey1 ERROR: Unable to connect to database using user ...
0
votes
1answer
348 views

Using non-replicated read/write databases on a MySQL slave server

I have a MySQL slave server that has two databases being replicated from a master. What I'd like to do is add a third database that I will exclude from replication and use as a read/write database. ...
1
vote
5answers
371 views

Replication in same server within different databases. Mysql 5.6

What I have : a windows machine with one instance of MySQL 5.6 Server. two database named test and test2. Test database has a table called activity with columns id and class What I need : ...
1
vote
1answer
150 views

PostgreSQL 8.4 replication of more than 100 tables

I am facing a problem with PostgreSQL version 8.4. I need to create an slave machine but when I look to all tutorials of slony or londsite its saying I will need to specify the tables that I want to ...
0
votes
0answers
26 views

Custom SQL Server replication

I want to have bidirectional replication and I don't want to reinitialize subscriptions after adding filtered tables because it's a pain (merge and transactional replication force to reinitialize ...
1
vote
3answers
2k views

Mysql Replication Automation Script

I am looking for something that will help us to create a lot of mysql slaves connected to the specified master, let's say kind of mass-replication. If there are any existing solution for this ...
0
votes
0answers
32 views

Howto fix replication failure with Galera - thousands of GRA_*.log files on all nodes

Galera Cluster generates a GRA log files if it fails to apply the writeset on the target node. This files exists in the MySQL data directory I use grareader to extract the SQL statement and get ...
1
vote
1answer
171 views

federated tables? synchronization? replication? [mysql]

I have a REMOTE suppliers table with, lets say, a code and a name, and several client databases will be creating new suppliers. Server database code | name ______________ 1 | Mark 2 | ...
0
votes
0answers
18 views

Merge replication snapshot folder cleanup

I have setup merge replication and facing some issues with the snapshot files cleanup. I understand the distribution agent is responsible for this cleanup but it does not seem to purge old files. It ...
1
vote
1answer
149 views

Indexed view doesn't exist on the subscriber

I am configuring transactional replication in SQL Server. The subscription is configured as push from 2008R2 publisher (distributor is the same server) to 2012 subscriber. The object I want to ...
0
votes
1answer
136 views

replication filtering replicate-rewrite and do-table Mysql 5.6 (innodb engine )

I have a master/slave replication setup based on statement based replication. On master database named DB1, I have 5 tables and I want to replicate only two table on slave's database named DB2. Also, ...
0
votes
3answers
71 views

MySQL row-based replication - Delete Fails

We have a Master - Master replication setup, MySQL 5.6. Only one Master is used, the other is for backup and failover (we'll call that the slave). The binlog_format is set to ROW, autoincrement ...