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
2answers
26 views

PostgreSQL: What is data replication?

I read from a post about comparing MySQL and PostgreSQL, there is one who said: The biggest disadvantage of PG for me had been the lack of replication, but it's recently gotten both asynchronous ...
0
votes
1answer
125 views

Postgresql Streaming replication - monitoring

I have setup streaming replication for my postgres servers. I am using PostgreSQL 9.2.6. Replication seems to be working fine. I am monitoring this with two ways using nagios: Log_delay and ...
2
votes
1answer
64 views

SQL Server replication over internet error

I have 2 SQL Servers connected over internet, I can connect (with no problem) from each one to other using SQL Server Management Studio by using publicIP,1433\server as server address. So, I created ...
2
votes
2answers
176 views

ssms - how to format T-SQL scripts?

as part of the process to add articles to my publication I use the stored procedure sp_addarticle: use [Returns] exec sp_addarticle @publication = N'USReturns', @article = ...
0
votes
0answers
75 views

Mysql server does not start if binary logging is disabled

I have been trying to disable binary logging on a slave server, since I do not use it as a master for another one, I have no use for the logs and I am trying to reduce lag so cut out everything that ...
1
vote
1answer
47 views

Replication not updating all tables

Master db MySQL db Server 2012 Slave db MySQL Win7 XAMPP DB size 500MB Table count 42 I have setup the replication successfully however it stopped last week and my slave was showing the error ...
0
votes
1answer
112 views

Error 1236 'Found old binary log without GTIDs' after master restart

So after quite a few attempts to build a slave and getting the error above, I decided to start with no binlogs from scratch so on the latest slave rebuild I issued PURGE ALL BINLOGS BEFORE NOW() on ...
0
votes
0answers
40 views

How do you create a custom replication between normalized and denormalized form using SQL Server

I have a table (on SQL Server 2008) that is denormalized like so: Table: PhoneNumbers Field: Partial varchar(8) -- 123-1234 Field: [Data] -- Refers to 800-123-1234 Data Field: ...
1
vote
4answers
85 views

Execute a script after transactional replication setup completes

We successfully set up transactional replication with 15 articles. After successful of article changes Done in subscriber, we need to execute ".SQL File" at subscriber database. Please help on this. ...
0
votes
0answers
30 views

Replication of MySQL databases, but only some of the data

I need to set up a system to do basically a partial backup/replication of a couple of MySQL databases (actually Percona XtraDB 5.5, all tables are InnoDB). There are a few hundred tables in one of ...
0
votes
0answers
37 views

restart master == slave breaks

I have been struggling with keeping replication working. This is what happened before (also my topic): mysql 5.6 gtid replication slave stuck (system lock)? on top of this getting into system lock ...
1
vote
1answer
70 views

PostgreSQL Streaming Replication - corruption on master

We have PostgreSQL 9.3.9 streaming replication between Master DB and Slave DB. Is there issues can happen on Master that can cause persistency problems or full failure of Master and Slave DB both ...
1
vote
1answer
95 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
1
vote
1answer
142 views

Promoting warm standby to master with Postgresql 9.4 using streaming replication

I've currently got 2 database servers running Centos 6 and Postgresql 9.4 (identical clones on the same network). They are set up as a primary and a backup created using pg_basebackup from the ...
0
votes
1answer
33 views

MySQL Database Replication in Fedora 21

I have a MySQL 5.6 Community Edition server running on a machine with Fedora 21 which was installed via the YUM repository. I want to enable MySQL replication on the Server, but since I am limited to ...
0
votes
1answer
99 views

MySQL percona 5.6 to MySQL 5.5 replication

Scenario 1 I am having a MySQL DB on 5.5 which is compliance, So need to upgrade it to MySQL 5.6. while doing this we see that 5.6 is running slow, were as it runs perfectly on 5.5 backup. Scenario ...
1
vote
1answer
585 views

mysql 5.6 gtid replication slave stuck (system lock)?

I have set up 5.6 gtid based replication (on 5.6.26) it seemed to work when I did it, it replicated my random test db over that I created beside normal data. However at some point something must have ...
1
vote
2answers
64 views

MySQL Replication - Accidentally Dropped Database on Slave

I am using MySQL replication and I executed DROP DATABASE against my slave by accident (long story). Can I execute DROP DATABASE IF EXISTS against my master to safely drop the schema on my master ...
0
votes
1answer
156 views

MySQL replication : Query partially completed on the master (error on master: 1053)

I got the below error. Query partially completed on the master (error on master: 1053) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your ...
0
votes
0answers
84 views

What happens if there is missing data in the slave MySQL server

At the data center there was electricity outage. And it appears that at that time my replication stopped syncing because it said something like this; "I cannot find the next position. Last proper ...
3
votes
0answers
90 views

transaction replication causing too many deadlocks after adding a indexed view - what to monitor in order to avoid this?

I have created the following indexed view and its clustered index: This view was created on a subscriber database and all the tables used in the view are constantly being written to through the ...
0
votes
1answer
18 views

Prevent MySQL to connect Master

We switched a slave to master today and after restarting the new master it tries to connect to the old master. Even with stop slave;, it tries to connect after restarting.
0
votes
1answer
56 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
649 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
21 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
114 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
66 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
40 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
34 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
681 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
53 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
38 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
59 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
127 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
79 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
112 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
823 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
636 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
90 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
221 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
64 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
85 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
140 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
110 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
40 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
41 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
59 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
115 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 ...