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
1answer
26 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
9k 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
19 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
11 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
31 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
396 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
64 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
17 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
117 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
60 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
64 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
245 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
53 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" : [ { ...
1
vote
2answers
3k 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
54 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
211 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
242 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
137 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
258 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
131 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
29 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
135 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
42 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
135 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
28 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
193 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
57 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
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
366 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
24 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
632 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
116 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
181 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
142 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
124 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
36 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
57 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
643 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
287 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
41 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
212 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
167 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
57 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 ...