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)

1
vote
1answer
105 views

Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs

How can I use Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database? I want to have a replication/slave database to have all the ...
0
votes
1answer
124 views

ReplicaSet MongoDB

I'am trying to create replcaSet in MongoDB and I'am facing a problem. This is what I did step by step: 1- I entered this command to create these repertories: mkdir \data\rs1 \data\rs2 \data\rs3 ...
2
votes
1answer
81 views

Inserting data into table in server B whenever table in server A gets updated

I want to synchronize data from table 1 in server A to tables 2 and 3 in server B, whenever table 1 gets updated. Tables from server A are not related to tables from server B, so I'd have to specify ...
0
votes
2answers
342 views

Can we disable binary logging for one specific session or user in AWS RDS

Currently we have a situation to disable binary logging for one set of queries on AWS RDS. We thought to set log-bin=0 for that specific session. As per Amazon, this is not possible. Is there any work ...
1
vote
1answer
70 views

High Availability for MariaDB and Postgres : replication or active-passive (SAN)

During the last weeks I did a lot of research on High Availability for Postgres and MariaDB. Both by my own research and also recommended by vendor's, replications seems to have more advantages. Some ...
0
votes
1answer
25 views

Slave (SQL thread) replicates very slowly

See this video: https://mckay.media/Yxjp2 I have two MySQL replication slaves which are replicating from the same master. Both slaves are running on identical hardware. Each has its data directory ...
0
votes
1answer
32 views

Adding a db for replication into mysql

Currently I have these settings. I am adding a new db called mydb3. How to enable the replication for this new db? Currently I have copied the table schema into both master and slave. What other ...
0
votes
1answer
21 views

Default binary log position for change_master_to in MySQL circular replication?

I have two MySQL servers set up with replication - lets say A and B for ease. Currently B is a slave of A To allow me to switch over to A in event of failure, I want to make this replication ...
0
votes
0answers
46 views

MySQL Bin-Log Courupped

In the recent time we have found that the bin log is getting corrupted, 20% binlog files were having errors, which couldn't even pass the sanity check by mysqlbinlog -u user -p mysql-bin.000021 | head ...
0
votes
0answers
12 views

I can't create a transactional replication

I have two databases identically in two SQL Server 2014 instances. The problem is as follows. I can access from server A to B, I can create the publication in server A and access to that publication ...
2
votes
1answer
61 views

Hybrid Synchronous / Asynchronous Replication?

We have a situation where we would like to have synchronous replication in our main data center, but replicate asynchronously to another region. Our second data center is 3,000 miles away (Site B) and ...
0
votes
1answer
21 views

Multi master single slave replication mysql

I have a scenario in which there are two masters master 1 and master 2 and i want to add slave to master 2 , so when i update in master 1 it will replicate for master 2 so how do i get slave of master ...
1
vote
1answer
78 views

Which error codes are safe for `slave_skip_errors` with MySQL Innodb

Does anyone know which error codes are safe to ignore during replication, meaning the slave will remain consistent with the master? For example [mysqld] slave-skip-errors=1007,1008,1050,1051,1054,...
1
vote
0answers
38 views

Merge Replication query causing slow performance

I have three databases (one publisher, two subscribers) running merge replication and this morning noticed very slow performance. They sync on 10 second intervals but this morning it was taking much ...
0
votes
2answers
70 views

what's difference between sql_log_bin and log_bin in MySQL?

can anybody tell me what is the difference between them ?
4
votes
2answers
116 views

Is there a way to create a MySQL/Percona Slave without using a dump?

I haven't been able to find anything so I'm sure the answer is no, what are you, a noob? but I feel the need to ask anyway :) Is there a simple utility that would allow a new slave server to be ...
2
votes
1answer
62 views

Sync two SQL Server database

Currently we have one SQL Server 2008 R2 database server in location X. All application users are in location X. All instances of the application can add data to database table and which may be ...
4
votes
1answer
677 views

SQL Server Replication :: Dedicated Distributor Hardware Requirements

Does anyone know any rules of thumb (or better) with regards to hardware requirements for a dedicated distributor server? i.e. Based on estimate metrics (e.g. number of subscribers, publishers, ...
4
votes
1answer
5k views

MySQL Replication: Seconds Behind Master super high

I've set up a slave db server for my production database, but when I checked the show slave status, I noticed a super big number in seconds behind master. This is the output: ...
0
votes
2answers
52 views

Mysql - How can I replication structure, not data

I have master with 2 slaves (4 but other 2 not relevant). One slave is full replication, ability to switch to be master if needed. Second slave was designed to replicate certain tables and leave out ...
0
votes
0answers
11 views

Replicated data from 2 databases into 1 on a server - Don't know how to revert

I am not SQL certified enginner however company doesn't care when it comes to protect the data. I have a site with two databases: Live Test In the testDB there were several entries created in ...
1
vote
2answers
163 views

For a standby workload of long running analytical queries, is it better to turn on hot_standby_feedback or set max_standby_*_delay settings to -1?

When spinning up a hot standby server specifically for BI/Analytics purposes where long running queries may be common, is it better to turn on hot_standby_feedback or set the max_standby_*_delay ...
1
vote
2answers
72 views

Running pt-table-checksum with replicate-do-db option on

I've read the documentation on percona page, but still a bit confused, especially about the --replicate option. My setting is that the slave is only replicating certain databases from master, say db1 ...
0
votes
0answers
34 views

Replication vs extracting just the data we need?

I recently did a project with a developer who wrote a desktop app. This is used by a few businesses, and each business has their own database installed locally. The app does not use any Internet ...
3
votes
1answer
71 views

Replicating redis foreign table via postgresql synchronous replication

I have synchronous replication between db server, DB1 and DB2. Tested, working. I have a redis server (RD1), integrated with DB1 (master) via redis_fdw, no issues here. I was expecting foreign redis ...
0
votes
2answers
66 views

replication error

I am getting error for connect to master (mysql 5.1) from slave (mysql5.7) Slave I/O for channel '': error connecting to master 'replica@hostname' - retry-time: 60 retries: 6, Error_code: ...
1
vote
1answer
2k views

How to generate replication snapshot without locking tables

When I reinitialize subscription and generate new snapshot it locks all tables and makes the database unusable for a very long time (never waited it out). Is there anyway to do this without locking?
0
votes
1answer
35 views

Replication/log shipping to a standby site [closed]

I need to replicate a SQL Server database on my standby site. Regarding Log Shipping, I have the following concerns: Is there any data type or primary key dependency exists if I use log shipping? ...
1
vote
2answers
165 views

Can MongoDB be configured to sit behind a load balancer?

According to this post: In a single replica set, you cannot distribute writes, they all must go to the primary. You can distribute reads to the secondaries already, via Read Preferences as you ...
1
vote
1answer
25 views

Changing replication snapshot folder, require re-snapshot?

We have SQL Server 2012 SP2 running on Windows Server 2012. We need to change the snapshot folder for all (including default) transaction replication publications. I have read that this means the ...
2
votes
1answer
631 views

Replication monitoring refresher for distribution job affecting performance

I have a performance problem due to a sql agent job executing dbo.sp_replmonitorrefreshjob. The environment is a 2 node Cluster with SQL Server 2005 SP2 and with transaction replication. The OS ...
7
votes
2answers
683 views

Creating an incremental database copy in PostgreSQL

Virtual machine software like VirtualBox allow one to make incremental VM clones. That is data, once "touched" (opened writable), will be copied and stored in the incremental cache of the new clone. ...
0
votes
0answers
39 views

MySQL Master-Master - different bin logs

We have Master <> Master replication. After some start-stop issues - I found some odds in replication. First - on both boxes we have an error: 160226 10:08:59 [Note] Slave I/O thread: connected ...
1
vote
1answer
50 views

MySQL Replication - 1 Master - 2 Slaves. Inserting works for One, not the other

I am a Python developer, working with 3 databases, configured in Master -> slave,slave style. Each slave has their own application associated with it. I am not too familiar with database ...
2
votes
1answer
96 views

SQL AlwaysOn & System Center Configuration Manager TP 4 1601

Recently Microsoft released Technical Preview 4 for Configuration Manager (1601). Per TechNet, "Configuration Manager now supports using a SQL Server AlwaysOn availability groups to host the site ...
0
votes
0answers
26 views

I am using tungsten replicator for my database from master 5.0.92 to slave 5.6.25

During replication i am facing statement failed error on slave but succeeded on master. Although its going in sequence but i don't understand why its failing. Status from slave: ==> user.log <== ...
1
vote
1answer
25 views

Sql server 2012 replication scenario

I am under a really specific scenario. I have a database on a customer's site and a website on Azure cloud that connects to that database. User is on a 50mbit fiber but this is obviously slow. So I ...
1
vote
1answer
399 views

MySQL Replication: How to restore master FROM slave?

TL;DR: given a master/slave setup between two MySQL databases, where the connection from the master to the slave is read only, how can you restore the master from the slave in the event of a failure ...
0
votes
1answer
159 views

Why does MongoDB give me the cannot use 'w' > 1 when a host is not replicated Error message?

Here is the information about my development environment: •Microsoft Visual Studio Community 2015 •.NET Framework 4.6 •ASP.NET MVC assembly System.Web.Mvc Version=5.2.3.0 •MongoDB.Driver 2.0.1.27 •...
0
votes
1answer
86 views

Replication compatibility between minor MySQL versions

I have a dedicated server running MySQL 5.7, installed using MySQL's Yum repository. Yum always installs the latest version, which is MySQL 5.7.11 at the time of this writing. I want to replicate ...
2
votes
1answer
48 views

Log Shipping vs Data Replication in SQL Server 2012

Just wonder if anyone has tried to use Log Shipping on SQL Server 2012 collecting data from SQL Server 2008R2 and SQL Server 2005 databases? I heard it would be an easier option to implement compared ...
0
votes
2answers
84 views

Mysql FLUSH LOGS in live server with replication

I need to run the slow query and unindexed query logging for some time on a live production db with replication. Changing GLOBAL const value sounds like a good solution. This article also provides ...
0
votes
1answer
25 views

Is there any way to find the exact Query responsible for replication lag?

I've tried checking slowquery.log and binlog. Slow query log kind of helps but not all the time. Binlog entries are inaccurate. I used the following command to check binlog. show binlog events in &...
3
votes
0answers
44 views

What is Data Virtualisation?

I've just been asked whether our company should consider Data Virtualisation for our test environments. The benefits are given as: Screening of sensitive data Fast data refreshes in our test ...
3
votes
1answer
54 views

Identity management in Transaction replication with updatable subscription

I have migrated my publisher DB to new server yesterday. For migration what I did was removed subscriptions and publication completely backed up DB on which publication was configured restored DB ...
1
vote
1answer
34 views

Is MSMerge_History.time in GMT or local server time?

Is the time column in the MSMerge_History table GMT or local distribution server time?
0
votes
0answers
13 views

SQL server is replicating to wrong subscriber

I have a publication which is intended to push data to a subscriber over the internet from a remote server to our onsite local subscriber but it ends up on a wrong subscriber.Here is the scenario: ...
0
votes
1answer
36 views

Can't promote PostgreSQL warm standby server to start serving data

Scenario: Two CentOS 7 machines, with ips 10.0.2.15 and 10.0.2.4 Both running PostgreSQL 9.4.6. First one (10.0.2.15) as master, and second one (10.0.2.4) as slave, not listening for clients (just ...
2
votes
1answer
112 views

High Availibility Solution to send data to multiple locations

I inherited a very interesting environment and I'm tasked with finding and implementing High Availability/Disaster Recovery solution as soon as possible. Simply speaking our environment looks like ...