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
1answer
45 views

Prevent replication of ALTER commands

I am using MariaDB 10.0 multi-source replication for a specific use case. For security reasons, I would like to prevent ALTER commands on master to replicate (such as CREATE, ALTER, DROP...) whatever ...
0
votes
2answers
268 views

How to replicate data between two SQL Server 2012?

I have two SQL Server 2012 databases running on two different Windows Server instances, I want the Server A (DB1) to be in full sync with the new Server B (DB2). How can I make this connection ...
0
votes
0answers
19 views

events not getting completely written in binary log file MySQL 5.0.32

referring this question : Records not getting replicate from Mysql 5.5.32 to MySQL 5.6 i found that binary log files which has been created at master database server , i see following surprising ...
3
votes
1answer
80 views

PostgreSQL + Docker: incorrect resource manager data checksum in record at 46F/6A7B6D28

I'm running PostgreSQL 9.3.9, Docker 1.8.2 and Ubuntu 14.04. I have an issue where my hot standby keeps failing with the following error message: incorrect resource manager data checksum in record at ...
1
vote
1answer
43 views

how to find the name of the distributor server and publisher server from the subscriber server/subscriber database

Having in mind that I can add computed columns to the subscription tables according to this link: SQL Server : Transactional Replication Computed Column That I am already doing, and also adding ...
1
vote
0answers
35 views

How to manage old replication issue

Background We are using SQL Server 2008 and we had a merge replication configured (before i joined the company). After that they stopped using it and the didn't delete it and configured transactional ...
0
votes
1answer
24 views

Mysql general log

I enabled my general log to check some of the queries in my database and i found out that there are inserts on my selects db (using a master slaves where inserts are on master and selects on slave). ...
2
votes
1answer
393 views

How do I configure AWS Aurora to separate write/read operations

I want to migrate my database instance from AWS RDS MySQL to Aurora, but I have a doubt about replication and how Aurora management the write/read operations. I have my application and I want to ...
0
votes
0answers
45 views

Is it a good idea to disable lock escalation while adding new calculated columns to a table?

Having in mind that I can add computed columns to the subscription tables according to this link: SQL Server : Transactional Replication Computed Column Is it a good idea to disable lock escalation ...
1
vote
0answers
35 views

Effect of upgrading windows server 2012 data center

I have a production windows server 2012 data center server where IIS and SQL server was installed and replication was configured in SQL Server. It is infected with a malware. After cleaning it with an ...
1
vote
0answers
49 views

How can we plan for a High Availability/Disaster Recovery setup in Postgresql 9.3? [closed]

I am working for mission critical project. We are planning for High Availability. At any point of time irrespective of the failure (network, hw, or db) one db server should be available for the ...
0
votes
0answers
41 views

MySQL Multi-source - Single Slave Setup. Adding Unique Master ID on Master's tables definition

this is a design question. I understand that Replication, is like mirroring. So this would mean, whats on the master, should be mirrored on the slave. (Is this always the case, like strictly same ...
0
votes
1answer
71 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 ...
7
votes
1answer
71 views

Capturing change deltas when database replication or CDC breaks

The company I work for is in the process of implementing change data capture on a Microsoft BI stack for the purpose of capturing incremental changes that need to be loaded into the data warehouse. So ...
1
vote
0answers
80 views

Merge Replication: Error “The insert failed. It conflicted with an identity range check constraint”

For one of our SQL server 2005 enterprise, configured with merge replication, we suddenly start seeing the below error message: The insert failed. It conflicted with an identity range check ...
1
vote
2answers
443 views

ERROR Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

We are facing the issue in replication that we are not getting any error in Show slave status\G output rather facing the following issue in Error Log File [ERROR] Error reading packet from server: ...
0
votes
1answer
368 views

MongoDB replica set configuration error

I am trying to set up a MongoDB replica set on Digital Ocean. I edited /etc/mongo.conf and specified replica set id: replSet=rs1 and did not change anything else. I did rs.initiate() on the first ...
1
vote
1answer
63 views

Is it possible to Clone an Existing MYSQL Slave Database into Amazon RDS with the RDS clone being a slave to an external Master?

We are interested in migrating our data from one of our MYSQL slave databases to an Amazon RDS instance such that the new RDS database is a slave database to an external master DB from our ...
0
votes
1answer
151 views

MySQL: Recover Master from Slave after failover

I have replication running between two MySQL instances on two separate servers. Let's say M is the master and S is the slave. It's setup as one way replication M->S. I currently have S as read only ...
1
vote
2answers
53 views

Is binary logs required on the slave in order to do replication?

I have a MySQL database setup with a master and a slave. As far as I understand, the master writes transaction events to a binary log, which is read and executed by the slave, thus making the slave a ...
0
votes
1answer
60 views

MySQL DB Replication

Okay so here's my scenario. I have two applications that share some tables from the same DB. Let's call them App1 and App2. Lets also assume the DB used here is called DB1. App1 and App2. App1 is on ...
2
votes
1answer
73 views

MySQL set one db in server to slave

I have two MySQL servers (A and B) running on separate machines. I want to replicate database X on A to B. B is still master for other databases. How do I set this up so that B is only slaved for X ...
2
votes
0answers
81 views

PostgreSQL count() works extremely slow on replication slave

I'm using postgres replication. I have one master and 2 slaves. I have table first with 1 500 000 rows. If I perform select count(*) from first on master, it takes less than a second, but on both ...
0
votes
0answers
34 views

Manually overwrite data in replicated server

I'm not very familiar with SQL Server. I am using SQL Server 2012 Management Studio. I have two databases (one internal and one external). Our external DB has been hacked and I need to overwrite all ...
1
vote
1answer
36 views

Two SQL Servers cross-mirroring each other?

I'm looking to see if I can create a "Brother's Keeper" environment in SQL Server 2008 Standard Edition. I have a large number of databases across multiple servers. I'm not worried about scalability ...
0
votes
1answer
29 views

Posibilities for bi-directional replication

Here i found an article on Bi-Directional replication. I had tried that way and it works fine for me. here my question is that, is that the right way to achieve this? any other possibilities for this? ...
1
vote
1answer
55 views

Database migration - Simply change connection string?

We are migrating our database (MySQL/MariaDB) onto a dedicated server. Previously, our web server hosted the database. I've already set up master-slave replication between the web server and the new ...
1
vote
0answers
89 views

SQL Server using Linked Server to Oracle - table definition not updating with refresh

Is there some trick for SQL Server Linked Server to update the ODBC connection to a changed table? SQL Server provides Oracle with a view. Oracle runs a materialized query to basically make a table ...
2
votes
2answers
100 views

Should I enable binlog binary logging on slave server?

What are the benefits of enabling binary logging in MySQL slave server? I'm thinking that doing a switchover from master to slave and back to master would be easier in this way?
4
votes
1answer
156 views

Two-way replication between SQL Server 2008 R2 and SQL Server 2008 R2 SP3

I know that in SQL Server you can't have two-way replication between different versions. I wanted to know if SQL Server 2008 R2 and SQL Server 2008 R2 SP3 are considered "different versions"? Did ...
5
votes
0answers
67 views

Low performance, high availability, replicated key/value store with audit trail

I'm looking for a database system with fairly specific specs. I've looked most of the major relational databases and NoSQL products out there and did not find one that even remotely satisfied my ...
0
votes
1answer
136 views

How to setup sync between MongoDB and C# .NET Application

What is the best practice to synchronize a MongoDB remote database with a C# .NET App that would allow queries to be responded to within the local file system and update itself when there is a change ...
0
votes
0answers
18 views

Finding the least binary logs amount multiple slaves connected in master

I have the master server with multiple slaves (for ex: 4). I would like to purge the binary logs after checking the processed binlogs on all slaves. I wrote the below script to find the least ...
4
votes
1answer
111 views

missing indexes on distributor database

Looking for missing indexes on my distributor databases, I surprisingly find too many. the tables that need to be indexed are generally 3: MSrepl_commands MSlogreader_history ...
5
votes
2answers
183 views

Copy data from multiple databases to a central database for reporting and analysis

I have more than 8 databases and all are in a SQL Server environment. I need to extract data from specific tables (more than 50 tables) of each database and dump into a central database for reporting ...
1
vote
0answers
201 views

Records not getting replicate from Mysql 5.5.32 to MySQL 5.6

1. I have a MySQL 5.5.32 server (community edition) on one Linux server which is master. 2. I have a MySQL 5.6 server (community edition ) on another Linux server which is ...
2
votes
0answers
28 views

Impact of adjusting Time of Mongodb server?

Using Ubuntu 14.04 and mongodb 2.6.10 I have time difference between a replica machine and primary , my secondary isn't configured with NTP what are the implications of adjusting time on the ...
4
votes
1answer
55 views

What exactly are secondary members acknowledging in replicasets with MongoDB?

I try to understand the mechanics and behavior of MongoDB's replica-features better. I hope to get some insightful information from someone who is familiar with mongo's internals and behaviour. My aim ...
1
vote
1answer
87 views

Table replication with extra TIMESTAMP column on slave

I have a table on master and same table on slave with an extra column like InsertTime timestamp DEFAULT CURRENT_TIMESTAMP I want to keep record of time when there is update on slave. Replication ...
0
votes
1answer
47 views

Importing MySQL tables from other database in live site with mysqldump can cause trouble?

Scenario: I want to replicate MySQL tables from one database to other database. Possible best solution: May be to use MySQL Replication feature. Current solution on what I'm working as workaround ...
1
vote
1answer
45 views

Binary log backups in MySQL

I'm running a master-master replication with read-only second master. Now since my binary logs are not getting replicated in my passive master. Should I need to enable --log-slave-updates? If I ...
0
votes
1answer
45 views

Replication from log shipping database

I have a secondary database on a standby and read only mode. The question is .. Can I replicate this database ?
3
votes
2answers
204 views

TDE on Replicated Databases

I have implemented Master-Slave replication between two databases, now i have to implement Transparent Data Encryption(TDE) in master database. is it possible to implement TDE in master only? whether ...
1
vote
1answer
59 views

Table does not exist even if there is one

I have MySQL master-slave replication setup in Amazon EC2. For the sake of resilience, I have set up LVM on RAID 10 array, on both master as well as slave. I have been using ec2-consistent-snapshot ...
2
votes
0answers
85 views

Replication of specific tables using Postgres 9.4.4 and Amazon Web Services

I have currently setup a Postgres 9.4.4 RDS instance on Amazon Web Services. On this instance I hold 20 tables. In addition I also have Postgres 9.4.4 installed on my local server (OS: 64-bit Linux) ...
1
vote
0answers
40 views

Transactional replication taking hours to replicate

I have a bunch of tables replicated from my_publisher to my_subscriber via my_distributor. Some of these tables, not all of them, when updated on my_publisher, take a couple of hours to be updated on ...
1
vote
5answers
71 views

Anyway to identify mysql slaves have read upto which binary logs

I have multiple slaves reading from one master.. But few of them are keep disconnecting due to network issue. Is there any way that i can make sure before setting up the bin log purging script on ...
1
vote
2answers
163 views

Disaster recovery solution for MySQL

I have set a Master-master replication with the second Master running as read-only. This master-master setup is on the same location. Now I will have to setup an DR for this production at a different ...
0
votes
2answers
73 views

Setting up MySQL master-slave replication

I am trying to setup master-slave replication on MySQL 5.6. When I update my database in the master, the change is not reflected on the slave. When I show the process list on the slave it shows this ...
2
votes
1answer
88 views

How to:: Master-Master replication

I have setup Master-Master replication on two servers. Now, my question is that if I need to have the second master as only read-only, what should I do? I tried doing mysql> flush tables with ...