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
39 views

Accidentally executed reset master on the live server

Turns out I have called RESET MASTER; accidentally on the live server. The slaves stopped replication now because they can not find the expected bin log files on the master. Is there a way to continue ...
0
votes
0answers
52 views

What is the sync time from master to slave in a mariadb setup?

I am trying to find out how long it takes for data to be synced between the master database and the slave database in a master-slave replication.
2
votes
1answer
62 views

Is there some kind of table-level replication in PostgreSQL?

I work with two databases in PostgreSQL 9.1, say A and B, one per application. Database B needs to read (and not write into) one table in database A (say users), but at the same time some tables from ...
0
votes
1answer
23 views

Mysql Replication backup and restoration failed multipal time

I tried restoring MySQL backup several time but unfortunately it gets failed by some or the new reason. I have 2 host Master & Slave with below details. Server1_Master os-centos6.7 mysql- ...
1
vote
0answers
70 views

MongoDB replicaSet keep 'syncing to' and only can be connect with shell

Hi I am new with MongoDB 2.6 Replica Set I have three DB service in Docker and DB work in Replica Set It works great I can connect to DB Read,Write in C#,MongoVUE but I didn't know why my db will ...
2
votes
2answers
91 views

PostgreSQL Server: Many-to-One replication / Transactional Replication

I have several PostgreSQL DBs in different geographical locations (local sites). Each local site DB have the same schema, but unique data. For example, Take a table with columns: Site_ID, ...
1
vote
2answers
25 views

MongoDB Replica Set Failure

Some background I had an issue with my replica set the last 24 hours, where the members could not connect to each other, and I got errors such as; could not connect to .... the machine actively ...
3
votes
1answer
37 views

Is it possible to use Change Tracking on a Replication target?

We have a setup where the production SQL Server databases are replicated to an offsite location using SQL Server Replication (transactional replication). I am looking at using SQL Server Change ...
0
votes
1answer
33 views

mixing binlog formats between master and slave

I have a pretty much straightforward Master --> Slave replication setup in MySQL 5.6 / Innodb. Both my Master and Slave are setup in MIXED binlog format. Now I need my slave to act as a master to ...
1
vote
3answers
57 views

MySQL Slave database size >> Master Database

I have a Percona MySQL Master-Master setup (5.6) with second master as passive master(read-only). Slave: mysql> SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / ...
1
vote
1answer
119 views

When can I clean up archived WAL files?

I need some help understanding the how archived WAL files are used and when I can clean them up. Currently we have a master database replicating to a slave, but every so often our master database ...
3
votes
1answer
66 views

Is replication a suitable method to move a SQL Server database to new hardware?

I need to move a live database with about 100 GB of data to a new machine. As I understand the easiest way to do that would be to take it offline, move the files and bring it back online. But: The ...
0
votes
1answer
23 views

6 datacenters running the same mysql database, replication layout design question

So each of the datacenters is around the conus. The Master slave replication route seems like my best option here. I have never done this with more then 1 slave and 1 master. Advice? Links? The ...
0
votes
0answers
11 views

Debian Server failover setup

I need to set up two servers with failover capability (Active - Passive model) sharing a common DB (Postgres)running over NAS. Could you please suggest me some workaround for the same ?
0
votes
0answers
73 views

Error Code: 1098. Can't generate a unique log-filename /data/mysql-binlog/relay-bin.(1-999)

After starting MySQL 5.5 I receive the error message: Error Code: 1098. Can't generate a unique log-filename /data/mysql-binlog/relay-bin.(1-999) Can anyone point me out what the problem is? The ...
0
votes
1answer
56 views

Mysql multi-master active-active replication : replication doesn't happen for all slaves

so i created a multi-master replication with bellow servers two for master and two for slave. hostname : master-1 ip : 192.168.120.107 hostname : master-2 ip : 192.168.120.111 hostname : slave-1 ip ...
0
votes
1answer
23 views

Restoring a MySQL database to a failed master

I have a master-master configuration in MySQL with two servers. One server should stay live on the network to serve requests (call it server A) and the other should be taken offline to push new code ...
1
vote
0answers
46 views

PostgreSQL Multi Master Single Slave Replication

I have multiple transaction PostgresQL 9.4 databases and a single publication read-only database. Is there any replication mechanism (asynchronous) to push every updated transaction from every ...
2
votes
1answer
401 views

Sql Server 2008r2 Replication Snapshot Agent Hang

I am setting up a new merge publication, but I can not get the snapshot agent to run successfully. In fact, I can not run any snapshot agents for any of the other publications on this server now. ...
1
vote
1answer
341 views

Amazon RDS replication with external slave

I've recently configured a replication with an external MySQL master and RDS as slave but now I need to reverse that config and use RDS as master and the other instance as slave. Actually I use a vpn ...
0
votes
1answer
34 views

Master Slave Error user specified as a definer ('dbadmin'@'%') does not exist

I setup mysql (version 5.5) master slave replication and when test it with root user from phpmyadmin data succesfully transferd. When start application slave have an error: mysql> show slave ...
0
votes
0answers
14 views

MySQL Delayed Replication - Reading events

Given MySQL is setup for master-slave replication, when delayed replication is set on the slave, does the slave still read the binlog while it is waiting for the delay period to pass? From MySQL ...
0
votes
2answers
60 views

Document Store & Relational DB Hybrid. Exists? Possible?

Does anyone know of any product or open source project that attempts to strap together Mongo DB and MySQL for instance? I hear a lot about how relational DBs being ACID compliant makes it nearly ...
1
vote
1answer
72 views

Will transactional replication break if there is a heavy update/delete query run on the publisher DB

For these specifications: Publisher: (prod OLTP DB server) SQL Server 2005, database size : 220 GB also acts as the distributor Subscriber (Prod reporting DB server): SQL Server 2005, DB gets ...
1
vote
0answers
42 views

SQL Server 2012 AG replication issues

We just went away from SQL Serer clusters in SQL Server 2008 to SQL Server 2012 with AG – have five servers with replicas in a secondary datacenter and syncing over a dedicated eline/LAN layer 2 ...
1
vote
1answer
86 views

WordPress with massive MySQL database slow. Would MySQL replication help?

Database Administration is usually not my strength, but one friend asked me if I can help him with his project. He is running a WordPress (MySQL) website with WooCommerce. The postmeta table stores ...
3
votes
0answers
63 views

Why does replication with SSL fail on my MySQL database in AWS RDS?

I'm trying to replicate from AWS RDS to my own server. It works without SSL. Whenever I include the SSL property to the slave, it breaks with this error: error connecting to master ...
2
votes
1answer
45 views

Slave stopped : Could not parse relay log event entry

My Slave machine stopped somehow, and when I ran START SLAVE to start replication, I got following error, SLAVE 1 !!! > show slave status \G *************************** 1. row ...
2
votes
3answers
2k views

MySQL Master/Slave replication on same VM instance?

I'm fairly new to databases so I hope this isn't a silly question! Is it possible to set up master/slave replication on the SAME server? I understand there are not any advantages to this in terms of ...
0
votes
2answers
43 views

Process to reclaim free space from mongodb ,replication is there

We are facing space pressure on production server so we are planning to reclaim space from prod instance.replication is there ,can anyone help me to know complete process in sequence to reclaim ...
3
votes
0answers
77 views

Recovery from Live to a new Slave Server - PostgreSQL - ERROR

I've started a new SLAVE PostgreSQL server set up. master: 192.168.100.1 slave1: 192.168.100.2 slave2(NEW SLAVE) 192.168.100.3 * NOTE: I run the pg_basebackup from another STANDBY SERVER. Not ...
1
vote
1answer
552 views

Replication Broken, List Out of Sync Tables

In a master-slave setup on MySQL 5.5 on RHEL 6.1, when db replication breaks (for whatever reason), what is a good way to: check (and alert) replication is broken? get a list of tables that are out ...
4
votes
1answer
38 views

Can I make my distribution database use In-Memory OLTP?

Is it possible to have all the distribution tables use In-Memory OLTP (formerly known as Hekaton) for enhancing performance of the distribution database? Have you tried it? Did that increase the ...
2
votes
3answers
103 views

Oracle : Redo / Undo for nologging table + Append + archivelog

I'm trying to replicate a table from an external Oracle DB to my system using a DB Link. First i tried doing it using an mview but it caused alot of redo/undo(I did the same steps as below but it ...
0
votes
0answers
31 views

Deploy Existing MongoDB Replica Set with MongoDB Ops Manager

I'm trying to use Ops Manager to automate my current deployment. I installed all of the automation agents on every server, and then tried to deploy with Ops Manager. Ops manager detects all the ...
2
votes
3answers
130 views

Replicating data between SQL Server 2014 to SQL Server 2005 - temporary solution

I will be installing a new SQL Server 2014 database system, which is based on our current SQL Server 2005 database system. The new system will be on a completely new infrastructure when we go live, ...
1
vote
1answer
64 views

How do I synchronize rows in tables in remote databases?

I'm actually developing a synchronization tool in vb.net, I have two database that have on each table records field GUID, this field help to have the same PK on both database. On each record there is ...
1
vote
1answer
395 views

MySQL RDS Error 1062

Normally we can skip 1062 duplicate error but in rds can we skip multiple 1062 errors in one go. For example we define slave skip error =1062 in my.cnf and restart slave. but in RDS MYSQL how can we ...
1
vote
0answers
30 views

Is log shipping good for periodic synchronization?

I have Postgresql 9.3 server on both my laptop and my desktop at home. I keep identical data on both system. Sometimes I work on the database on my laptop while other times I work on the database on ...
1
vote
0answers
31 views

How to sync incomplete replication records in MySQL

if replication breaks and you end up with a couple of records not pushed out to the slave, is there a way to update the slave without stopping locks on the master and manually transferring a new ...
1
vote
0answers
27 views

Classic vs. GTID replication MySQL 5.6 - how to identity which one used from errors?

Is that true? In classic replication (SQL_SLAVE_SKIP_COUNTER=1) you never see UUIDs in logs and show slave status like 3e11fa47-71ca-11e1-9e33-c80aa9429562:1-5? When you see an UUID, there is GTID ...
2
votes
0answers
124 views

Postgresql Streaming Replication Error: WAL segment removed

I want to set up PostgreSQL streaming replication, but get the following error: FATAL: could not receive data from WAL stream: ERROR: requested WAL segment 00000001000000000000006A has already ...
3
votes
0answers
30 views

Bandwidth-efficient, fail-safe database resync with long backlogs

I'm looking for a DB system that allows slaves to resync even if there exists a long backlog. In addition these resyncs must be as bandwidth-efficent as possible as the nodes are connected over ...
0
votes
1answer
51 views

How the statement based replication works internal on secondary node of mongodb?

Mongodb supports statement-based-replication. Would like to know, how the statement based replication converts the code internally on secondary node of mongodb. Is that working related to the ...
0
votes
0answers
24 views

Postgres 9.2 replica can't catchup to master

I have configured a master/replica setup for postgres 9.2 on Amazon Linux. PS output shows that the replica is connected and streaming, but also recovering. This has been going on for about 24 hours. ...
3
votes
0answers
40 views

NULL Agent Timing Out

Error: Replication-replication Distribution Subsystem: agent (null) scheduled for retry. Query timeout expired. Based on my research, this error appears when there is a lot of contention on ...
0
votes
2answers
68 views

How is it possible to convert a 3-node replica set to a 1-node replica set during low-usage hours

We have a chat application that runs on MongoDB. For the amount of users that we currently have, it is sufficient to have a 2 node+Arbiter set up during peak hours. However, during off-peak hours, we ...
0
votes
1answer
48 views

Multi master replication with MySQL and Django

I am working on scaling out a webapp and providing some database redundancy for protection against failures and to keep the servers up when updates are needed. The app is still in development, so I ...
0
votes
0answers
18 views

The process can not access the file because it is being used by other process

I have publisher and distributor on the same machine with 2012 sql server. Created a new subscription and it started downloading the snapshot. After a few snapshot downloads, it throws the following ...
1
vote
1answer
16 views

In a Serial 3-Server Replication Scenario (A>B>C), can server B preserve binlogs that server A has purged?

This is in the service of a live migration, where server A has heavy performance and space demands, so I would like to keep down the amount of disk-space used by logs - let's say expire_logs_days = ...