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

2
votes
1answer
37 views

How can I know whether postgres is currently running synchronous or asynchronous replication?

I see from ps that: postgres: wal sender process replicator X.X.X.X(38681) streaming 0/17AF5438 But is there any way for me to know whether it is synchronous or asynchronous? I made the relevant ...
0
votes
1answer
320 views

MongoDB - Adding a new server to an existing replica set with auth enabled

Short version: Is there a way to add a new SECONDARY server to an existing production MongoDB replica set without downtime, and without temporarily disabling the "auth" and "keyfile" config settings ...
0
votes
1answer
22 views

How To Prevent Replication Failure

If I become a MySQL DBA, will I had to deal all day with those kind of issues or do you have tips to prevent from breaking the whole replication? I received this message because I removed manually ...
1
vote
1answer
19 views

CREATE TABLE not issued on other masters

Database is created on all multi masters. Why CREATE TABLE doesn't being replicated to other masters. some explanations?
3
votes
2answers
595 views

Excessive replication snapshot size causing failure

I am searching for an explanation of a replication snapshot being in excess of 5 times what we're predicting Following a replication failure we are attempting to reinitialise subscriptions with a new ...
8
votes
1answer
114 views

How do data checksums interact with streaming replication?

Data checksums are a new feature introduced in 9.3, and: there is a new GUC parameter "ignore_checksum_failure" which will force PostgreSQL to continue processing a transaction even if corruption ...
0
votes
0answers
178 views

MySQL SSL encryption

Does setting MASTER_SSL to 1 in change master ensure encryption without specifying options MASTER_SSL_CA, MASTER_SSL_CAPATH, MASTER_SSL_CERT, MASTER_SSL_KEY ? After setting MASTER_SSL to 1, show ...
3
votes
1answer
128 views

Can Postgres synchronous replication stall a cluster if secondary/standby crashes?

In a setup with Postgres synchronous replication, let's say one of the secondary/standby machines crashes, will that lock/halt the master? That is, since the Postgres master always waits for ...
0
votes
0answers
121 views

How to set up MySQL 5.6 Master- Slave Replication step by step

I am new to Mysql replication. I want to have 2 MySQL servers, a Master and a Slave, running on two Ubuntu 14.04 Computers. Their IP addresses will be 10.0.0.1 (Master) and 1.0.0.02 (Slave). I need to ...
1
vote
0answers
34 views

replication error involving ignore-db

I have simple master/slave replication set up between two servers. The master has several DB's I wish not to replicate at this time, in fact there is only DB I am trying to replicate. I have several ...
6
votes
2answers
2k views

PostgreSQL: Can I do pg_start_backup() on a live, running db under load?

Our established replication has broken ("requested WAL segment has already been removed" during downtime) We cannot easily stop the master again. Can we do pg_start_backup(), rsync ${PGDATA}/ ...
0
votes
1answer
54 views

Modify an Oracle Dataguard destination database

I'd like to set up some Oracle triggers to take action after rows are inserted, but I can't do this on our production database because it's controlled by a vendor. One alternative I was looking at is ...
0
votes
1answer
472 views

MySQL: What happens to the row when skip-errors=1062 is set

I found out that I can set skip-errors=1062 in the my.cnf but I need to know what happens to the row when the error happens. Does it get silently dropped? Or is that config option the equivalent to ...
0
votes
2answers
253 views

Replication Blocks Code Deployment

We have a database (SQL Server 2008r2) that is being transactionally replicated, namely tables, sprocs, views, indexed views and UDFs only, to another server (SQL Server 2014) as part of a cautious ...
1
vote
0answers
39 views

Sybase Replication rs_subcmp can ignore length?

I want to use rs_subcmp utility to sync one table. I've created a config file but I got the following error: Length mismatch for column #9 between the primary (50) and the replicate (100). ...
8
votes
3answers
12k views

How do you re-sync the Master MySQL DB with Slave DB changes if the Master goes offline?

MySQL Server 1 is running as Master. MySQL Server 2 is running as Slave. With both DBs online, they are in "perfect sync". If Slave goes offline, there's no problem if Master still online; they will ...
2
votes
1answer
190 views

MySQL Seconds behind Master fluctuation

I have two servers set up in Master-Master with one additional Slave connected to the first master. Lately I've started getting alerts from monyog that Master 1 has a seconds_behind_master value of ...
0
votes
1answer
155 views

Postgres live backup

Goal: Maintaining a constant live backup of a postgres cluster. In case of cluster failure, backup/Secondary will contain most up to date view of Primary cluster. This is not a hot standby ...
0
votes
0answers
55 views

PostgreSQL manual way of sharding like behaviour

I've a main server with low space available and good internet connection that has a postgres database in production for a zabbix system. Also, I've another secundary server plenty of space but with ...
3
votes
3answers
1k views

Slave SQL thread got hanged

We have a master - slave setup with ROW based replication. We are seeing huge delay's on the salve even though there is no activity running wither on master or slave. When we looked in, we observed ...
0
votes
0answers
144 views

MySQL Replication thread hangs on flush tables with read lock

I have a MySQL master/slave set up with row-based replication. At times of higher load we've been seeing replication halt and all slave thread activity commands just hang. STOP SLAVE, SHOW SLAVE ...
0
votes
0answers
121 views

Mirror database on same server instance for better read performance?

I am developing a somewhat big web application, which uses data which is aggregated using a crawler. The crawler is constantly writing to the database and updates many tables at the same time. For the ...
0
votes
0answers
85 views

Transactional Replication

SQL server 2008 R2. I have set up transactional replication on 40 tables in a database (other tables don't replicate). There was an issue in the morning and it is fixed now. I resynchronised the ...
0
votes
0answers
39 views

MySQL Create Table Statements not being replicated

I have a one master 5 slave MySQL replication setup. When I create a table on my master, it gets replicated on 3 of the 5 slaves. The other slaves however do not replicate the "CREATE TABLE" ...
0
votes
0answers
55 views

ORACLE 10.2.0.5 DB: How can I start replication of an existing schema into a new database with zero downtime

Please, note that I'm limited to Materialized view replication and datapump, so my question is whether the above can be done within my specified scope: Ensure no transactions in the database for ...
3
votes
2answers
162 views

How to create a secondary read-only reporting database with < 15 minute latency

We have a 2012 standard edition instance that is doing log-shipping of 2 related databases every 15 minutes to a secondary 2012 standard edition instance for DR purposes. Although it provides ...
0
votes
1answer
240 views

Abnormally high MySQL writes and larger than normal Binary Log files. How can I determine what caused this?

We have a MySQL master database which replicates to a MySQL slave. We were experiencing issues where MySQL was showing a high number of writes (but not an increased number of queries being ran) for a ...
1
vote
1answer
219 views

Sync postgreSQL with SQL Server database- on data change event

I have one PostgreSQL database and its data are being changed regularly. I want to sync all its data with my SQL Server database. One thing I can do is use query to check all required tables and ...
1
vote
1answer
37 views

How to read queries of master that sends to slaves?

I want to see queries that Master sends to slaves in Mysql ? Is there a way to see that ?
2
votes
2answers
543 views

postgreSQL 9.3 streaming replication delay

I'm running a fairly simple WAL streaming replication setup between two postgreSQL 9.3 servers that are on a private 1Gb LAN, but recently I've noticed that there is an increasing amount of ...
1
vote
0answers
89 views

PostgreSQL 9.3 slaves don't recognize hstore as a type

I am using the postgres built in replication with two slave nodes and a single master. On the master node (as well as the slaves) the hstore extension is installed. But whenever a query using hstore ...
1
vote
1answer
434 views

Design for active/passive Master-Master mysql Setup

I have a dozen virtual machines running application + mysql instances (version 5.1 up to 5.5). Due to the bad I/O of the virtualization I want to buy a physical server for mysql and move all mysqldata ...
4
votes
1answer
149 views

PostgreSQL replication for archiving

I've looked around a bit and haven't found a very clear strategy or method for what I'm trying to do, which is surprising because I would think it would be a fairly common practice. I currently use ...
2
votes
1answer
189 views

MySQL Replication : Duplicate entries - SQL_SLAVE_SKIP_COUNTER or delete row?

I have a system which replicates one database to four slave servers. Every now and then, when traffic is high, one or more of the slave servers hits a duplicate insert error and the slave stops ...
2
votes
2answers
133 views

MySQL 5.6 showing wrong “second_behind_master”

mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: 10.10.7.98 ...
1
vote
1answer
52 views

SQL server replication - Does not ask for the snapshot folder

SQL SERVER 2008 When I created a publisher for the first time, it asked for the snapshot folder path. I deleted that replication and tried to recreate the publisher. This time it doesn't even ask for ...
2
votes
0answers
49 views

Postgres Replication From Different Masters?

I'm getting a Postgres 9.3.3 install sorted out. My application is Drupal (so read/write), but low-traffic, so all application traffic is sent to the primary master. I have two sites (main and ...
1
vote
1answer
380 views

Moving SQL server 2008 to a new Server with all DBs, replication and Jobs

We have to move our Production SQL server 2008 to a new Server (with latest SKU and more RAM). So we need to move all DBs, replications setup (publisher) and all jobs, means everything :). Also we ...
0
votes
1answer
632 views

SQL Server Transactional Replication over Internet

I have 2 instances with SQL Server 2008R2 and i would like to build Transactional replication between those server, one is in the Local Network (Local_Instance) and the second server is over Internet ...
2
votes
1answer
217 views

Postgresql 9.2.6 ignoring archive_command

I'm attempting to set up a 3-server chain by leveraging WAL-E. I've done this in the past with replication/wal segments and I'm attempting the exact same method, just with using WAL-E in between. My ...
0
votes
1answer
100 views

Change posgresql 9.3 slave roll password

I need to change the password on my slave posgresql server, because the person who set it up left the password the same as the password for the super user account on our other server. When I run ...
2
votes
3answers
9k views

Broken mysql replication on slave server (error 1236)

My question is: how to fix broken mysql replication on slave server (error 1236)? server 1 (192.168.1.105) server 2 (192.168.1.106) I ran these steps to re-sync: At the master - server 1 ...
1
vote
1answer
1k views

Replicating data from Oracle to MySQL

I work with a vendor that does data analytics, and they currently receive a replication stream from some of our databases using a product called Goldengate (which is very expensive). Goldengate has ...
2
votes
1answer
502 views

Replication from EC2 Master to RDS Slave - Connecting to master

I am migrating my company's database from an EC2 instance to an RDS instance. I have already migrated a snapshot of data and am now trying to set up replication to get the data that has been added ...
1
vote
2answers
50 views

Mysql Master Offline

In a unidirectional Master-Slave setup, should the slave be manually stopped in cases where the Master is offline due to Maintenance, Crash etc. ? Or should one just leave it so that it keeps trying ...
1
vote
1answer
84 views

Fan-In replication 4 Master -> 1 slave

I am trying to merge 4 source db's (one for each region) into a global db. We use ID ranges as primary key on the tables in each region and so the merge should happen nicely. I have a fairly high ...
0
votes
1answer
76 views

Impact of replication compression & encryption on performance, traffic?

What is the impact of MySQL compressed-slave-protocol on replication traffic? According to High performance MySQL it can lower the traffic to a third of the same replication without the compression. ...
0
votes
0answers
129 views

How to use Select query just right after Insert on master in a query.?

I have a question on mysql replication. As usual, I deployed my db structure like the Update on master db, the select on slave. My questions. If I use SELECT query just right after INSERT in a query, ...
0
votes
2answers
119 views

MySQL Slave not updated

This might be a duplicate of questions on the same problem asked before. But all the suggestions to the previous questions do not seem to work in my case. I have set up Replication using SSH Tunnel. ...
3
votes
1answer
101 views

How can we achive the replica of databases for SQL Server?

I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server. In the ...