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

0
votes
2answers
1k views

MySQL Slaves lag behind master

I have one master and four slaves. Sometimes all my slaves lag behind the master. I have implemented the heartbeat for monitoring replication lag. Now I am trying to find why the slaves are lagging ...
0
votes
1answer
35 views

Sync MySQL 4.0 table to MySQL 5.6 server every few minutes

I am tasked with getting a copy of a table on a MySQL 4.0 server synced to a completely different database on a MySQL 5.6 server every few minutes for the purposes of having that table available ...
3
votes
1answer
126 views

How to upgrade MySQL (5.5) production DB to 5.6 with minimal downtime

Our existing Database size around 200GB. We want to use consistent, parallel backups methods. For testing, I migrated my Development DB from 5.5 to 5.6 by running mysqldump with option ...
0
votes
0answers
23 views

Postgres sync database

I have two postgres databases. Master = master_database Slave = database All initial changes are made to master. Upon admin approval, the version is updated, and I want all changes to be copied ...
3
votes
0answers
54 views

Postgres multidisk master replicating to single disk slave

I have an odd situation. I have a postgreSQL database master with multiple large tablespaces divided across 3 physical disks. I am setting up a slave that will be used to offload long, ...
0
votes
0answers
19 views

Replication is broken because of events in wrong order in binlog

I have a master-master replication which is used rather like a master-slave because of replication breaks from time to time. It is always broken on the same table. To find the reason on this problem I ...
0
votes
0answers
51 views

MySQL Chain Replication without log-slave-updates

I have three server's say A -> B-> C B as both Master and Slave.I have enabled log-slave-updates in B server so that replication is possible on C. So what if happens when log-slave-updates is not ...
2
votes
1answer
99 views

PostgreSQL Automatic Failover (Trigger File Creation)?

Is there a way to detect if the master PostgreSQL (9.3) server becomes unresponsive, and if so, create the trigger file (that is specified in recovery.conf) that initiates the failover process? Or ...
7
votes
4answers
3k views

One slave, multiple masters MySql

Is it possible to set-up MySql Replication to have one slave listening to two different masters?
1
vote
0answers
37 views

Sync/Replication of 2 Oracle Databases with NetApp storage

I am working on a high availability setup of Oracle Enterprise Manager. I need the back-end repository replicated (preferably in real time, or something close) to another repository, in which I could ...
0
votes
1answer
30 views

Table Not Created On All MySQL Masters

Here is the multi master setup. Table is not created on middle master. log-slave-updates is not enabled in my.cnf file. Master 1 mysql> create database replication; mysql> use replication; ...
0
votes
1answer
151 views

MySQL replication error 1594

Is there a way to restart replication without going over MySQL :: MySQL 5.1 Reference Manual :: 16 Replication. I'm NOT seeing ANY errors on master and I'm not entirely sure why slave is ...
2
votes
1answer
893 views

Cannot get my slave - replication server to start

My replication server will not start. I have followed the instructions here: http://opensourcedbms.com/dbms/setup-replication-with-postgres-9-2-on-centos-6redhat-el6fedora/ As well as several other ...
1
vote
4answers
4k views

Single slave - multiple master MySQL replication

I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?
0
votes
1answer
25 views

Upgrade mysql from 5.0 to 5.5 in master-master configuration leads to broken replication

We created two new mysql servers running 5.5. Our old server were 5.0. The two servers are set up with master-master replication - this was the case for the two 5.0 servers which had no issues. We ...
4
votes
4answers
8k views

How to change a MySQL previous slave to be a master and remove slave status information?

I have a master -> slave configuration where the master failed. I've been able to reset the old-slave to be a master and the old-master to slave from it. Fine. What I can't seem to do is to remove ...
0
votes
0answers
16 views

Can it Possible to do Mysql Active - Active Replication between Redaht linux 6.4X and Ubuntu 12X?

I have small doubt regarding Mysql Active-Active Replication. Can it Possible to do Mysql Master-Master (Active-Active) replication in Mysql between Redhat Linux and Ubuntu? Thanks & regards, ...
0
votes
0answers
10 views

What is the preferred mode of replication for a MySQL Cluster?

Reading about MySQL Cluster, I'd like to know about what are the preferred models of replication. I understand that it supports asynchronous replication out of the box, but I'm not sure of how it ...
0
votes
1answer
27 views

Best scenario for replication type

We are using SQL Server 2012 and we have the Main office server. All modification on the product pricing table is done through the Main office. We have 10 remote sales branches. Those remotes ...
2
votes
0answers
367 views

oracle streams apply: how to get a reason why LCR message was not applied

I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't. ...
1
vote
0answers
57 views

MySQL replication of single DB to same server

I have a DB Server running CentOS 6.4 and MySQL 5.5 from RPMs (not source). I have dozens of databases but one of them is being hit quite hard with large selects which locks out other updates which ...
0
votes
0answers
7 views

MySQL replication of single DB to same server [duplicate]

I have a DB Server running CentOS 6.4 and MySQL 5.5 from RPMs (not source). I have dozens of databases but one of them is being hit quite hard with large updates which degrade the performance of ...
0
votes
0answers
14 views

offload DB for reporting

Need your expertise on this.. I have a requirement like this, I have an application database which currently users are running SSRS reporting against this DB. Now I want to offload the reports by ...
1
vote
1answer
111 views

MySQL: records, inserted via phpMyAdmin, do not replicate

As it says on the topic, for some reason records inserted/ modified via PMA do not get replicated to the slave, If I do exactly the same insert/modification on master via mysql command line, or ...
2
votes
1answer
54 views

Replication successful but slave skips certain quries

I am testing a MySQL master-slave replication. Here is the master my.cnf: log-bin=/var/log/mysql/mysql-bin.log server-id=1 innodb_flush_log_at_trx_commit=1 sync_binlog=1 Here is slave my.cnf: ...
0
votes
2answers
59 views

I have been tasked with Mysql Master-Master replication?

I have done some study and i came to know that Mysql master-master replication violates the ACID properties and there has been problem with primary key collision.Please Let me Know,Apart from these ...
1
vote
1answer
124 views

Master-Master Replication Duplicate Key

I have set two servers master-master replication mysql , i manage to set successfully but the problem is the duplicate key i got MASTER 1 Configuration /etc/my.cnf [mysqld] server-id=1 bind-address ...
0
votes
1answer
44 views

MongoDB only three of four shards being used

Using MongoDB 2.6, I've setup four replication sets: a, b, c & d: >rs.conf() a:PRIMARY> rs.conf() { "_id" : "name_of_replset", "version" : 1, "members" : [ { ...
0
votes
2answers
2k views

Distributed Database Architecture Using MySQL Replication

I've been task to move our web servers to the cloud for all countries that use our services for localization. The issue is, they must share the same data and therefore I need to set up some database ...
1
vote
1answer
53 views

Fastest way to set up MySQL replication from backup

Here's my scenario: I have a single database on network A that needs to be transferred to network B. on network B, I need a master-slave setup with 2/3 slaves. I need to run some significant updates ...
1
vote
1answer
134 views

Best backup strategy for MySQL (MariaDB) replication set

My main concern is getting a proper backup, even more so than a temporary outage. The data is golden. I've been doing reading through the documentation and a lot of the backup strategies seem to be. ...
0
votes
0answers
228 views

Percona XtraDB Cluster/MariaDB Galera Cluster - replication suddenly stops working, cluster thinks it is in “Synced” state

We are trying to populate an empty Galera cluster using myloader. We use the latest version of myloader from repo trunk, the command is as follows: /root/mydumper/myloader -d ...
1
vote
1answer
86 views

temp table (#sql-7a87_230c32.ibd along with its .frm) still exists on slave

I executed some alter statements on my master server, which have been successfully executed on master (now there is no temp table on master) and all alter also have been replicated on slave server ...
1
vote
2answers
197 views

trigger_file doesn't work

I set streaming replication. Replication works just fine but it doesn't care about trigger_file. I have nothing fancy there except all what many of tutorials advices: recovery.conf: standby_mode = ...
1
vote
1answer
103 views

Export synonyms content to tables

I have a distant database to replicate having huge data but I have access only to synonyms and I would like to use Oracle export/import tool to import these data into tables of local database. What ...
1
vote
1answer
27 views

Suggested ways to route traffic between master / slave

I have multiple Postgres servers up, running in master / slave streaming replication mode. I was wondering what the suggested methods of routing write traffic to the master, and the read traffic to ...
3
votes
1answer
78 views

When interrupting a query on a Master, does it replicate to the Slave?

In MySQL, when does the master send a query to the slaves? Here's a specific scenario that I'm trying to understand. Admin entered an update on master that took a long time to execute. Admin hits ...
5
votes
1answer
2k views

PostgreSQL: Unable to run repmgr cloned database

I'm running tests with PostgreSQL hot standby with 1 master, and exactly 1 slave. I am using the instructions on this guide: ...
2
votes
1answer
35 views

How to make snapshot for new tables only

If there is a replication running for a large set of data, and I want to add one or more new tables, I normally add the articles to the replication and start the snapshot agent. Since there's a lot ...
1
vote
1answer
1k views

What is the Best Way to detect if server is a Master inside a Stored Procedure?

I'm want to create a stored procedure/event to do some maintenance tasks. My setups are master/slave configured for failover scenarios (meaning the slave is not used for reporting, just might be ...
0
votes
0answers
119 views

High Availability in PostgreSQL with automated failover

I am currently working on designing an architecture for High Availability in PostgreSQL for a database of approximately 5TB in size. Also, I would like to re-direct my reads to a slave node(preferably ...
0
votes
1answer
27 views

Oracle structural synchronization [duplicate]

I'm having two oracle databases. A is used for production, B is some kind of staging instance where people are preparing content that is brought to the production system over night. It is a fully ...
1
vote
2answers
124 views

MySQL Database replication for high availability

configuration: 1 balancer 2 Azure machines(4 gb ram, 2 cores), with MySQL master-master replication enabled. X users connecting to the balancer to sync data. test: i've tested the MySQL ...
1
vote
1answer
44 views

Creating Replicas Across Servers

I'm having some issues creating a replica set of my MongoDB. I have server A. Currently, it is setup as a local standalone replica. rs0:PRIMARY> rs.status() { "set" : "rs0", ...
2
votes
1answer
36 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
245 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
21 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
529 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
106 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 ...