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
50 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
60 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
52 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
40 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
58 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
39 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
40 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
45 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
185 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
23 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
93 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
71 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
45 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
115 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 ...
1
vote
1answer
31 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
36 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
50 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
19 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
17 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
31 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
36 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
11 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: ...
1
vote
0answers
12 views

How to implement sql replication when subsciber cannot acces the publisher

I have 2 servers Server A (Publisher) and Server B (Subscriber) However server A can access Server B but Server B cannot access Server A. There are no VPN between these servers Server A can access ...
1
vote
1answer
38 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 ...
1
vote
2answers
45 views

Synchronous SQL Server Replication only for specified subscribers

I would like to create database replication between multiple localisation. There will be one publisher and multiple subscribers. Is it possible to define that synchronisation is synchronous only for ...
0
votes
0answers
41 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
2answers
89 views

MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash

We have tables with MyISAM. The are out of sync, the number of records is different on each cluster node > select table_schema, table_name from tables where ENGINE = 'MyISAM' and table_schema != ...
2
votes
1answer
29 views

Taking load off the Master server by using a slave

My gameserver utilizes a Master and a slave on one server. The reason I am wanting to use a slave is because I want to beable to run select queries (read only) to get data without affecting the Master ...
0
votes
0answers
35 views

MySql master stopped writing to binlogs when tmp partition full

Percona MySql version is : mysql Ver 14.14 Distrib 5.5.46-37.5, for debian-linux-gnu (x86_64) using readline 5.1 OS Version is : Debian 7.9 MySql master has a separate tmp partition, of ...
0
votes
0answers
19 views

how to change relay log fie name on “Adding Slaves to a Replication Environment”?

MySQL document advised that "new slave relay log file name " should followed the "old slave relay log file name" to avoid this problem, use the same value for --relay-log on the new slave that was ...
1
vote
1answer
54 views

Mixed based replication between two databases on the same server

I have two apps with a current configuration as follows: App1 DB on server A/MySQL Instance A App2 DB on server B/MySQL Instance B Students can apply for internship using App1 and those ...
2
votes
1answer
76 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 ...
1
vote
1answer
39 views

Where does MySQL's “show slave status” information come from?

two files "master.info" and "relay-log.info" were deleted after I "reset slave" I want to know why slave information still exists ~ confused >_< I think it shouldn't display any message about ...
2
votes
1answer
34 views

Do Sequences Have the Same Replication Range Limits As Identities?

With merge replication, if the subscriber runs out of identities for a range when inserts occur into it, the subscriber will throw an error on the insert into the table, because it is the publication ...
0
votes
0answers
42 views

Replication Error_code: 1032

I an unable to fix this as I don't know what cause this error. Replication was stoped for maintenance activity and after completing the maintenance we started it and then after some point the ...
0
votes
0answers
25 views

MySQL Trigger Replication between Master and Slave

we are running a rather highly loaded MySQL Application replicating between Master and two Slave instances. We are using Statement-based replication. Recently, we have upgraded our hardware and a ...
0
votes
1answer
212 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 ...
3
votes
0answers
112 views

How to PUSH data between a Local DB Server to Cloud DB Server?

I have an implementation doubt regarding replicating data between SQL Server 2014 database servers (Replicating data from Local Premises SQL Server to Cloud DB Server, which are not in same domain or ...
2
votes
1answer
130 views

Can I get pg_rewind to show me lost data after a Postgres failover?

Say I have Postgres setup with a warm standby using the build in replication features. Now, imagine a scenario where the data centre the master loses power and the slave is in another data centre and ...
1
vote
0answers
60 views

how to force MySQL unsafe replication warnings to throw an error

I understand that MySQL WARNING statements, with respect to replication unsafe statements, are not 100% valid. That is, if you know what you are doing, if you understand the schema, there are indeed ...
0
votes
0answers
40 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
27 views

How should we be alerted of failures in the SQL replication distribution agent job?

When setting up SQL replication, the default retry count for the replication agent job step is 2147483647, retrying every minute. This means that if replication fails, the failure notification for the ...
0
votes
1answer
26 views

What service that lets you create records/data into an immutable database storage system that cannot be deleted?

I'm not sure if this exists or not, but is there a database storage system that is immutable, whereby it cannot be erased or be altered without someone knowning? Use case would be for public data that ...
0
votes
1answer
36 views

MariaDB Galera Cluster Replication

Does the replication between an async slave connected to a master withing the cluster affect the performance of the master in the cluster?