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)

0
votes
0answers
34 views

MongoDB sharded Replica cluster AWS

I am currently evaluating where to run a sharded&replica MongoDB cluster right now I am looking into: self hosted, or either self made on AWS with a bunch of EC2 instances AWS cloudformation ...
0
votes
1answer
95 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
7 views

Is automatic failback on Postgres 8.4 possible via log shipping/PITR?

I have successfully setup continuous archiving and recovery of a master and slave node with PostgreSQL 8.4 via log shipping. I'm using keepalived to monitor both nodes and I can successfully trigger ...
4
votes
1answer
89 views

How does SQL Server Merge Replication maintain referential integrity?

Note: This is a curiosity question about SQL Server. I've been reading about SQL Server's Merge Replication feature, and there's one thing I just don't understand about it: How does Replication ...
2
votes
1answer
78 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
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 ...
2
votes
1answer
49 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 ...
1
vote
0answers
34 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 ...
1
vote
1answer
25 views

Changing tx_isolation and binlog format on master server - do i also need to adjust slave?

We are running a Drupal Commerce site with MariaDB 10.0 and master/slave replication. Because of the way our application works, we end up running in to a ton of deadlocks under heavy load. Apparently ...
1
vote
1answer
61 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 ...
3
votes
1answer
74 views

Merge Replication Validation Failure

We are getting a bizarre error with some of our users while syncing with SQL Server 2008 R2 Service Pack 3. Validation fails even though the row count and expected row count actually match! Error ...
0
votes
1answer
23 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
30 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
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 ...
0
votes
1answer
29 views

Multiple Replication Type Publications on Single DB

I have 2x critical DB's which until recently; I was reporting on as well as using in production. DB1 is a Vendor DB and DB2 an in-house DB used in conjunction with DB1 for custom tables and views (as ...
0
votes
2answers
48 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 ...
4
votes
2answers
101 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 ...
0
votes
1answer
20 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 ...
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
60 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
0answers
30 views

Mysql hung at 41% CPU Usage

We are using 3 servers. Master Server1 syncs data to Server2 & Server3. Server1 -- Debian -- MySQL 5.5.40 Server2 -- CentOS 6.6 -- MySQL 5.5.45 Server3 -- CentOS 6.6 -- MySQL 5.5.43 All 3 ...
1
vote
2answers
71 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
2answers
53 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: ...
0
votes
1answer
32 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
1answer
23 views

Is it possible to have MySQL slave outside firewall

For various reasons I need one of the databases from intranet MySQL server to be made available to (insecure) online server. Due to the requirements it was decided that a db dump will be used via cron ...
1
vote
2answers
113 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 ...
0
votes
0answers
33 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
104 views

MongoDB allocates chunks only to Primary when sharding is enabled

I'm setting up an instance of MongoDB with 3 shards. I've setup everything seemingly correctly by following the docs and comparing my config with that of a friend who has a similar setup but with a ...
1
vote
1answer
24 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 ...
0
votes
2answers
50 views

what's difference between sql_log_bin and log_bin in MySQL?

can anybody tell me what is the difference between them ?
0
votes
0answers
21 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
56 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] ...
1
vote
2answers
99 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 ...
0
votes
0answers
56 views
1
vote
1answer
23 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 ...
2
votes
1answer
57 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 ...
2
votes
1answer
44 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
1answer
69 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 ...
3
votes
0answers
42 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 ...
0
votes
2answers
51 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
1answer
50 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 ...
6
votes
3answers
208 views

Fault tolerance in mysql servers

I have built an application as part of my UG thesis that uses mysql database (community edition). Now, my professor wants me to provide fault-tolerance to the database (by parity!!)! I argued that we ...
1
vote
1answer
33 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
1answer
31 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 ...
0
votes
0answers
11 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
96 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 ...
0
votes
1answer
87 views

PostgreSQL : Master-Slave replication strategy and solution for 3 servers.

We have currently 3 servers(X,Y,Z) running Debian X64, two of them host projects(Y,Z), which don't require that much database, as they serve more static content, but the third server(X) is largely ...
1
vote
1answer
61 views

Change AWS's Read Replica's streaming replication to trigger based replication

We have a Postgres RDS instance for which we have created a read replica instance. The problem we are facing is that, that whenever there is a long running query(about 30-40 mins) on Read Replica, it ...
3
votes
1answer
138 views

Postgres 9.5 xlog fills all disk space in replication setup with replication slot

I have replication set up on Postgresql 9.5 using replication slot. I have one primary and one slave machine, both Ubuntu 14.04 with a cluster called main that is in a directory other than the ...