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
0answers
7 views

Couldn't setup postgresql cluster with heartbeat pgsql ra

I'm trying to install postgresql cluster with the following configuration: 2 virtual hosts with RHEL 6.6 x64: postgresql 9.1 with hot standby replication pacemaker 1.1.12 resource-agents 3.9.6 I ...
1
vote
0answers
16 views

SQL Server 2014 Replication - The process could not connect to Subscriber 'xxx'

I have just set up very basic transactional replication on SQL Server 2014. The Publisher and Distributor are one and the same. I have configured the Publisher to push to the Subscriber, so any and ...
0
votes
1answer
18 views

Can I setup database triggers to run on a defined secondary set of servers only?

This might sound a bit off, but here's what I have been thinking for a while now: Use Case You want to build an activity log for each user action on your application using database (postgreSQL) ...
0
votes
1answer
21 views

Change MariaDB 10.0.17 (MySQL) master to a slave

I have a MySQL master/slave configuration -------- -------- | master | -> | slave1 | -------- -------- I want to kill my current master, transform slave1 to be the new ...
1
vote
0answers
5 views

Error on slave2 after promoting slave1 to master in cascaded streaming replication

I've a setup like MASTER -> SLAVE1 -> SLAVE2. MASTER and SLAVE2 are running on different ports on single server. SLAVE1 in on another server. For testing purpose I've powered off my first server ...
0
votes
0answers
16 views

Slave executing queries with different charset

I need to change a database charset because of this issue and I solved my issue in staging environment with the SQL command ALTER TABLE `articles` CONVERT TO CHARACTER SET utf8 COLLATE ...
0
votes
1answer
9 views

Setting up replication for various mongodb micro instances

We currently have 5 mongodb micro instances on aws, each of them serve different modules and the calls are made through REST services. We are planning to setup replication for these instances and my ...
0
votes
0answers
16 views

Replicated databases across locations; delay in application

I have a replicated instance of database on different locations different SANs which is utilized for running a vendor supported application. However, I notice that there is a significant delay between ...
0
votes
1answer
17 views

MySql Replicate different tables to different database

I have Database1 on server1 and Database2,Database3 on server2. Database1 has two tables T1, T2. I want to replicate T1 on Database2 and T2 on Database3. How can I accomplish it? I googled but only ...
0
votes
0answers
9 views

How to sync postgres roles between multiple servers

I am looking for a solution in which I can replicate the details of a role (most notably the password) between various postgres servers. (All running the same version). The idea behind this is that ...
1
vote
2answers
18 views

MySQL Replication Lag Check

we are about to replicate our database servers into several slaves in different physical locations. The company which is doing replication for us, has asked to give them a sql select statement on ...
0
votes
1answer
18 views

Delayed transactional replication setup?

I will need to setup transactional replication for a big database. I use backup/restore to initialize the database because it's too big to use snapshot over slow network. So the following steps are ...
0
votes
0answers
7 views

Moving Replicated & Partitioned SQL2005 Enterprise to SQL 2008R2 Enterprise

Our SQL2005 Enterprise has 4 databases which are all partitioned, each have 5 files and a handful of tables replicated, compatibility mode is 90. They are on an old Windows Server 2003 32bit machine ...
0
votes
1answer
8 views

Replication Issue - Changing the replication-do-db filter

I have a server that someone has setup which are acting as a master on both database. Since they have been configured as both master on the same database, changes one on end has caused all sorts of ...
1
vote
1answer
29 views

SQL Server 2014: missing replication option

This article details exact steps to set up basic database replication with SQL Server 2014. It starts with this: Right-click the Replication folder, and then click Configure Distribution. ...
0
votes
0answers
13 views

Does MySQL Backup Restore affect Master-Master Replication

Hello I got some problems with a MySQL shemas and it seems that the schemas got deleted for an unknown reason. I try to find in the binlog for more information of this but I didn't find the way to see ...
0
votes
0answers
38 views

Percona Master-Master lag issues

I have 2 servers with master-master replication using Percona MySQL 5.6 and I am having replication lag in the second server: db-02, however db-01 never had a lag situation. What could be causing ...
0
votes
0answers
15 views

MySQL replication error: Table doesn't exist

I just run a MySQL database master-slave replication using these instructions. The process seemed to be ok, but when I run some queries on the slave server I get this message on 3 of my tables. ...
1
vote
1answer
22 views

Is Neo4j 2 replication architecture a master-slave or multi-master?

In the new docs of Neo4j (23.1. Architecture) it says that: When running Neo4j in HA mode there is always a single master and zero or more slaves. Compared to other master-slave replication ...
0
votes
1answer
13 views

Maintaining permissions on a replicated view after reinitialization

When we were on SQL Server 2005, there was some way that I was able to keep custom permissions on a view at the subscriber. Now that I'm on SQL Server 2012, there doesn't seem to be a way to do ...
1
vote
1answer
21 views

What User Level is needed for Transactional Replication

I've been setting up Transactional Replication between two database servers I have running. My first experiment with setting it up I simply used SA and local Admin account for all of the agents. ...
0
votes
0answers
5 views

Mongo db replication issue in 3.0.0

I updated my replica set from Mongo 32.6.4 to 3.0.0. After that i saw frequent switch between primary and secondary server. When i check the log i found this in log [ReplicationExecutor] replset: ...
2
votes
0answers
25 views

After restarting Mysql replication, Slave commands are executed

up vote 0 down vote favorite I have a Mysql Master Slave Replication which is working fine. Unfortunately I got some serious problems on my slave and the only chance I saw was to restart the whole ...
0
votes
1answer
16 views

Should I exclude mysql database from multi master replication?

Running mysql in a two master replication setup. There are many databases and they are all replicating correctly including the mysql database itself. Is it safe to replicate mysql or should I exclude ...
1
vote
0answers
24 views

Configuring slave from EC2 master to Amazon RDS slave

I am configuring replication from EC2 master to Amazon RDS instance. After starting the slave, I don't see any errors but I see slave_IO _thread is connecting. Master version:5.6.23 Slave ...
1
vote
3answers
32 views

Can I remove the middle slave in a MySQL “master -> slave -> slave” setup?

Let's say I have the following setup: Master -> Slave1 -> Slave2 I would like to remove the middle slave, Slave1, and have the following: Master -> Slave2 My gut is that I can do the following: ...
0
votes
0answers
33 views

SQL Server Transactional replication - virtual box being the subscriber

I would like to ask if it is good practice to have the SQL Server transactional replication taking place from a physical box (publisher) to a virtual SQL Server (subscriber)? Regarding the ...
0
votes
2answers
33 views

Heavy load causing MySQL Slave threads to remain “locked” or “Sending data” indefinitely

We have been rapidly adding MySQL servers as slaves to our master database server to help alleviate a massive increase in search (read-only) traffic to our web service. This past week, I was tasked ...
1
vote
2answers
30 views

MySQL 5.6 Slave Stops Processing Binlog on Master Restart

I have a pair of Debian 7 servers with MySQL 5.6.23. The slave server is a clone of the master (but the uuid has been regenerated on the slave). For some reason, whenever MySQL is restarted on the ...
0
votes
1answer
12 views

What if we skip the slave by counter 1 when it failed at event 1 of a transaction which has events 2 and 3

We have a master-slave replication which has all Innodb data. I ran 3 update statements under one transaction on master. ============= start transaction update T1 update T2 update T3 end ...
0
votes
1answer
43 views

Continuous replication between Oracle Database and Microsoft Azure SQL [closed]

Background info: Our core ERP has it's data on Oracle. Our own applications are Microsoft SQL based. Almost every application reads data from this Oracle database and usually there is some sort of ...
0
votes
1answer
22 views

Can we disable binary logging for one specific session or user in AWS RDS

Currently we have a situation to disable binary logging for one set of queries on AWS RDS. We thought to set log-bin=0 for that specific session. As per Amazon, this is not possible. Is there any work ...
0
votes
0answers
37 views

Mongo db replication issue with 3.0.0

I updated my mongo instance to 3.0.0. Now i am seeing this error continuously in the replica set log 2015-03-12T15:24:23.141+0530 W NETWORK [ReplExecNetThread-74] Failed to connect to ...
1
vote
1answer
142 views

Which databases can meet these replication requirements?

I am doing research on database architectures for a large project, and I am looking for which software can meet my requirements. To try to explain the requirements simply: You have a master ...
0
votes
0answers
16 views

MySQL Replication 2003 error connecting (servers behind monowalls)

I'm trying to get MySQL replication, Master-Slave, configuration working. On my slave when I do a SHOW SLAVE STATUS\G; I get a 2003 error: Last_IO_Errno: 2003 Last_IO_Error: error connecting to ...
0
votes
0answers
8 views

How many postgresql / BDR database can be replicated from a server? [duplicate]

I've been reading the postgresql bdr docs found here: https://wiki.postgresql.org/wiki/BDR_User_Guide I came across this comment in the above doc: BDR operates per-database, not per-cluster ...
0
votes
0answers
37 views

Oracle 11g xe replication/cluster free license?

I am new to db clustering/replication and I want to set up a cluster/replication of a database backed by t2 nodes. I used docker and spun up a preconfigured oracle 11g xe database ...
0
votes
1answer
45 views

Doubts about Converting MyISAM to InnoDB (master/slave and more)

I want to convert my MySQL DB (46 Tables, 2.1 GB) from MyISAM to InnoDB. I have a couple of questions about this process. Since I have a Master/Slave structure, do I need to manage this and change ...
0
votes
0answers
54 views

postgresql 9.4 + BDR Fails

I'm trying to get postgresql 9.4 and BDR working. Following this tutorial: https://wiki.postgresql.org/wiki/BDR_Quick_Start Actually, my sysadmin provided me with a package to test with. He's taken ...
0
votes
1answer
50 views

Postgresql - Minor version upgrade 9.3.5 to 9.3.6 on Ubuntu

I am two servers: A & B. My master database is running on A and the version is 9.3.5. It's replica is running on B and the version is 9.3.6. I am trying to use B as UPSTREAM slave, and trying to ...
1
vote
2answers
27 views

Master/Slave desyncronisation

Some manual operations (writes) have been made on SLAVE instead of MASTER resulting in the replication being stopped. Could not execute Delete_rows_v1 event on table xxx.newsletter; Can't find ...
0
votes
0answers
15 views

Replication broken after copying .frm .myd .myi files

I copied .frm .myd .myi files for MyISAM tables from old_prod server to new_prod. Then I did a mysqlcheck on DB and repair tables whenever necessary. All is good for MyISAM tables in the new_prod. ...
0
votes
1answer
27 views

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again?

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again ? I know the below points exist means, there won't be any reset happen in binlogs. I ...
1
vote
1answer
47 views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...
0
votes
0answers
15 views

How to transform Streaming Replication Master-Slave to Cascaded Master-Slave1-Slave2 setup?

I've setup streaming replication as part of HA solution on my production enviroment. I've two ubuntu servers PROD1 and PROD2. PROD1 is master and PROD2 is slave. In case of failover the slave database ...
0
votes
0answers
62 views

FATAL: terminating walreceiver due to timeout

1/ DESCRIPTION: Machine 1 (slave): Centos 6.6 , x64 , installed PostgreSQL 9.3 (on Local) Machine 2 (master): Centos 6.6 , x64 , installed PostgreSQL 9.3 (on Cloud) Machine 1 (slave) and machine ...
0
votes
1answer
35 views

How to fix my Merge Replication upload order?

I have several Merge Replication instances in production on SQL 2008 R2. One of them has started to behave oddly in that it appears to attempting to upload the children tables before it uploads the ...
0
votes
0answers
60 views

Peer-to-Peer Transactional Replication Load Balancing in MS SQL Server

I'm looking at Peer-to-Peer Transactional Replication and it looks like a perfect fit for my requirements, but there's one unclear part - load balancing (see picture below). How it is implemented in ...
0
votes
0answers
13 views

What will happen when manager stops on source in goldengate?

As per my knowledge, manager is responsible for handshaking between source manager and target manager. Communication between the extract and pump process for providing reports Is there is a ...
0
votes
0answers
26 views

Failover_command in pgpool is not working?

I have setup the pgpool with load balancing and failover mode. Following is my failover_command='/usr/local/etc/failover.sh %d %P %H %R' The following is the script: !/bin/bash -x FALLING_NODE=$1 ...