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
vote
0answers
3k views

Oracle GoldenGate replication is stuck

I deployed Oracle GoldenGate to integrate many-to-one databases. After initial loading everything works fine. Until recently, some of the replicat seem to stuck and do not proceed to change ...
0
votes
0answers
17 views

MariaDB multi-master replication (star topology) - Bizarre out-of-sync behavior

This may look familiar, I've been learning about this stuff for a few days - but this is a new question. I have a setup like this: Every node is a master, and I have them all replicating to each ...
0
votes
0answers
36 views

MYSQL 5.6 replication occasional Lag

We use Mixed replication in RDS mysql 5.6 and we are noticing replication lag every few minutes or so, the lag appears momentarily and then disappears. On slaves when we do show processlist we saw ...
0
votes
0answers
27 views

What options exist for replicating SQL Server over the public internet

Specifically, I'd like to set up a reporting copy of a SQL Server 2012 transactional database. This primary runs in a managed services provider, and I want a copy in an AWS EC2 SQL Server instance. ...
0
votes
0answers
23 views

Setting up mysql replication (Master->Slave one direction)

I am struggling with the setup of a one way replication for a single mysql table. What I have done so far: Master: Added this into my my.cnf: server-id=5668439 log-bin=mysql-bin ...
0
votes
0answers
19 views

Unicode character replication MSSQL to MYSQL in Symmetric DS

I'm doing replication from MSSQL to MYSQL using symmetricds and it is working fine. Now , the problem is: In the SQL Server table , I have a column defined as NVARCHAR(20) which accepts unicode ...
0
votes
0answers
18 views

Deploying Shared MS Access DB — Summer Intern first time with Access

So to give a brief background I've got a summer internship and was asked to modify and add features to an already existing MS Access DB. I don't actually take databases until next semester, so I was ...
0
votes
0answers
19 views

Mysql replication to empty db

I had a db master/slave setup that had hardware break on the slave. Now the server is backup I reinstalled mysql and setup replication the issue being backups are off. Is there a way to start mysql ...
0
votes
0answers
31 views

Removing Replication from MS Access mdb file using External Data->Access, is anything lost?

The new version of MS-Access 365 does not support replication as evidenced by the following error message: "The current version of Microsoft Access does not support replicated databases. To use ...
0
votes
0answers
12 views

Amazon RDS Read Replica

I would like to know, is the Read Replica is nothing but the slave server, where only reads are there. I created two mysql instances in amazon RDS, one is Read Master, and another is Read Replica. ...
0
votes
0answers
11 views

mysql 5.5 statement based to rds mysql mixed replication

I am moving to rds mysql 5.6 that has by default mixed replication. I am moving from 5.5 where I have statement based replication. I was wondering if i enable replication between them i.e make rds ...
0
votes
0answers
10 views

Replication Conflict tables in SQL Server 2000

Due to previous several replications during these years in a database I'm working with, there are several tables with names with this format : *onflict_AllData_[Tablename] which * can be a, b, ... ...
0
votes
0answers
25 views

Replicating table level PostgreSQL 64bit windows

I need to replicate some tables on PostgreSQL 64bit for Windows (master -> slaves replication model) and I can't find any tool that can achieve that. Slony-I work very well for PostgreSQL 32bit for ...
0
votes
0answers
17 views

bdr_int_copy issues and confusion

I am hoping someone can clarify a few things for me. I am having issues getting my 2nd node to join the first node using bdr_init_copy In a nut shell here is my scenario on node 1, i create a couple ...
0
votes
0answers
20 views

migrating MYSQL 5.5 to percona xtradb cluster 5.6

if we have to migrate MYSQL 5.5 using statement based replication to percona xtradb 5.6 would that be possible. What we want to do is to make percona xtradb cluster a slave of our current MYSQL and ...
0
votes
0answers
25 views

Replicating from MySQL 5.1 master to 5.6 slave failing because 'INSERT … VALUES (NOW())' results in 'Error_code: 1062'

I am migrating away from some old MySQL 5.1 servers to some new MySQL 5.6 servers. During this process, I'm creating a new MySQL 5.6 slave from an existing MySQL 5.1 slave, using the procedure in the ...
0
votes
0answers
14 views

Maintaining Data Window

My specification requires that a remote machine maintain a 'data window' that consists of a subset of rows from a table in a local database. This window can move depending on the current value of a ...
0
votes
0answers
21 views

SQL Server Replication: Central Subscriber : Loading data in the same table

I have configured a Transactional Replication from Oracle (11g) to SQL Server 2014. I have many clients with the same database and we want to have a Multi-Publisher and only one Subscriber. The ...
0
votes
0answers
48 views

Column based replication in mysql 5.6

I want to do column based replication which means: In my server, I have table T1 in which columns are A, B, C, D, E I want to replicate this table on different server in mysql 5.6 only, but with ...
0
votes
0answers
32 views

MySQL: Replication is paused with both threads running, System Lock in ProcessList

I have just set up Master Slave replication from a MariaDB EC2 instance to a MySQL RDS instance. What can I do? The Seconds_Behind_Master are increasing, never decreasing. Slave_IO_State Waiting ...
0
votes
0answers
10 views

After merge replication setup, tables at subscriber not getting any data from publisher

I have created a merge replication setup through Replication Wizard. After sync, it is observed that the subscriber DB gets created with the exact tables in publisher as intended, but on the ...
0
votes
0answers
49 views

How to troubleshoot, find and fix query Percona 5.6 with error “SQLSTATE[HY000]: General error: 1785 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1”

i'm running Magento CMS, and underneath there are 2 physical servers both with Percona Server version: 5.6.23-72.1-log Percona Server (GPL), Release 72.1, Revision 0503478 in Master/Slave ...
0
votes
0answers
47 views

Converting MySQL master-master replication to master-standby

I set up two mysql servers in a master-master configuration. This was working fine until recently when I encountered a duplicate-key problem. After doing some research and evaluating my needs, I ...
0
votes
0answers
16 views

Is there Merge and Snapshot replication methods for MySQL?

In distributed database systems, is Merge and Snapshot replication supported in MySQL? I am thinking of something similar to MS SQL's types of replication: ...
0
votes
0answers
40 views

Best method to implement HA and DR, replication via 1 PUB and 2 SUB or replication and LS both

I need a advise on one of our projects where: We have 3 SQL database servers A, B and C: A is the live production server with around 200 users with a database of size 1.5 TB hosted. B is going to ...
0
votes
0answers
25 views

Transactional replication of stored proc execution and stored proc parameters

I'm trying to design how we might go about setting up replication of just the execution of a stored procedure. If the stored procedure on the source takes one or more parameters, will those same ...
0
votes
0answers
32 views

Replicate SQL Server tables between AWS RDS instances

We are running an RDS instance in AU region and would like to replicate some tables to RDS instances in other regions. A lag of a few hours is acceptable between master and slaves. As we're on RDS ...
0
votes
0answers
27 views

Heroku Postgres Follower

I'm currently looking at creating a follower db of a live production database. The follower will be used for analytics purposes only. And will not be inserting any data - if it did then it would be by ...
0
votes
0answers
38 views

Insanely slow replication after MHA promotion

I have a replication setup with 1 master and 3 slaves. I promoted the current master to one of the slaves using MHA. That went seemingly flawless, not errors reported, everything marked ok. Spot ...
0
votes
0answers
89 views

Mongodb replica set across AWS regions or subnets or data centers

I seem to have run into a blocking problem. I want a certain collection to be replicated across multiple AWS regions/subnets/data centers (eg a global lookup table or a global user credentials table) ...
0
votes
0answers
10 views

Find unpublished columns via RMO

The stored procedure sp_helpmergearticlecolumn will return all columns for a table and have a bit set if the column is published or not. The MergeArticle RMO object has the function ...
0
votes
0answers
40 views

How do I know Postgres streaming replication is working?

I have set up a standby server to follow a primary Postgres server following [this wiki page][1]. The issue is that I am not sure the primary server is sending anything to the replica because I don't ...
0
votes
0answers
100 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 ...
0
votes
0answers
35 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
0answers
22 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
0answers
43 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 ...
0
votes
0answers
22 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
0answers
23 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
45 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
49 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. ...
0
votes
0answers
18 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: ...
0
votes
0answers
45 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
0answers
291 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 ...
0
votes
0answers
25 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
118 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
0answers
39 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
0answers
32 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
181 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
0answers
19 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
97 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 ...