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
71 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
77 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
26 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
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
33 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
53 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
117 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
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 ...
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
72 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
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
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: ...
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
1answer
31 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
169 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
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
173 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
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 ...
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 ?
0
votes
0answers
27 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
79 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
2answers
172 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
59 views
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 ...
2
votes
1answer
63 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
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
1answer
87 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
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 ...
0
votes
2answers
88 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
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 ...
6
votes
3answers
255 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
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
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 ...
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
117 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
117 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
100 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
210 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 default....
1
vote
1answer
40 views

MySQL Replication: MASTER_LOG_POS never changes

I have a Master / Slave Setup in production and from time to time I add or remove a slave and recently I also removed the master and promoted a former slave to new master. This procedure usually ...
0
votes
1answer
41 views

MySQL Replication errors

Yesterday I installed the master-slave replication system here, and they see each other (the master accepted the slave), but the server throws an error at me: Error 'Table 'ohd.hashes' doesn't exist' ...
3
votes
1answer
71 views

Transactional Replication issues

I have a question, I am managing 2 SQL servers is Master Server (Publisher + Distributor) is Client Server (Subscriber) The client is basically owned by a client who is buying data from us. Both ...
0
votes
1answer
27 views

filter records within MySQL replication

I'm new to replication process. In one of Rails project it's necessary to share records of one table between two applications. Let's say share records between first application DB A and second ...
0
votes
1answer
28 views

how to disable delete in replication Cassandra datastax

my previous scenario i used Sql server one instance in amazon for live and the second in local network for archiving by disable delete in replication can i do this in Cassandra or what best ...
1
vote
0answers
18 views

Syncing writes and not deletes - mongoDB

Is it possible to have a secondary instance of mongoDB which syncs all the write operations to the database and not the delete operation? I'm looking for this solution so that I have a backup even if ...
1
vote
1answer
35 views

SQL Server transactional replication distributor

If I have a SQL Server 2012, with two databases, both publishers, replicating to a bunch of subscribers. Can each database go through a different distributor? Is the publisher the server or the ...
0
votes
1answer
40 views

Relationship between data independence and database schema

What is the relationship between data independence and database schema? I know both of them separately. But I don't know how to explain the relationship of these two.
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: ...