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
26 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
8 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
35 views

Postgresql Hot Standby - How to determine it's fully mirrored?

I have set up a hot standby of a postgresql server. It all seems to be working, but I just want to be sure that I'm not missing something. In /var/lib/pgsql/9.2/data/pg_log/postgresql-Wed.log I have ...
0
votes
0answers
26 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
45 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
25 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
20 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
26 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
11 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
18 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
42 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
33 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
13 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
36 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
140 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
20 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
65 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
24 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
21 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
134 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
14 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
54 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 ...
0
votes
0answers
8 views

How to handle private local databases in a multiDB cloud environment

In context of Platform as a Service (PaaS), we would like to offer our clients a private platform. A platform includes a website and a database. A platform is not 100% separated. Users could "travel" ...
0
votes
0answers
13 views

Transactional Replication to a Version Two Versions Older--Count by Name or Number?

According to Microsoft SQL Server documentation, a "Subscriber to a transactional publication can be any version within two versions of the Publisher version." In this context, are versions named ...
0
votes
0answers
21 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
78 views

Is Automatic failover is possible in pgpool?

I have setup the 2 PostgreSQL 9.4 severs with master-slave(Hot standby streaming replication).Is this possible in pgpool-II 3.4 to configure,where it works for automatic failover(network or hardware ...
0
votes
0answers
22 views

How to block messages from Londiste?

This question is part postgres and part londiste. I have successfully upgraded PostgreSQL from 9.1 to 9.3 using Londiste. However, in the PostgreSQL 9.3 log, I am still getting some messages related ...
0
votes
0answers
26 views

Why are foreign keys ignored on subscribers?

We have a merge replication set up on Sql Server 2008 R2. There are many tables with foreign keys providing a logical dependence on each other. For this question, let's say there are the "User" and ...
0
votes
0answers
21 views

Oracle Mview - Get DML Type

I'm trying to create a replication of a table on a remote server. Table on remote Server : tbl_remote. i created a MATERIALIZED VIEW LOG on tbl_remote. also in my local server i created a ...
0
votes
0answers
38 views

Different Auto-increment values Mysql schema Replication

I have 6 Slave set up (EC-2, linux) and a Master ; 2 schemas getting replicated. Version info: mysql Ver 14.14 Distrib 5.5.34, for Linux (x86_64) using readline 5.1 Once in few months in one of the ...
0
votes
0answers
40 views

Percona Cluster 5.6 (PXC) and replication filters

I wanted to double confirm the following information: Percona Cluster 5.6 implements Galera for syncromnous replicatrion. Does Galera replication support any replication filtering rules? such as: ...
0
votes
0answers
133 views

Error configuring SQL Server as Distributor

I'm trying to configure replication on a new install (moving to SQL 2012) and I keep getting the same error even after messing with the service name, folder permissions, etc... Using the Configure ...
0
votes
0answers
31 views

Mongo Memory mapping file size issue

I am witnessing some performance issues in my Mongo Sharded cluster. I checked the serverStatus for the memory uses on my shards This is the output Shard one Primary RAM size 512 GB "mem" : { ...
0
votes
0answers
49 views

Did this trigger break replication?

I added a trigger to a replicated database. DELIMITER $$ USE `database`$$ DROP TRIGGER /*!50032 IF EXISTS */ `some_ins_after`$$ CREATE /*!50017 DEFINER = 'user'@'%' */ TRIGGER ...
0
votes
0answers
47 views

Replication Strategy for Multi-Office Database

I'm considering options for setting up a repository of large spatial datasets that can be used by employees across our company. We have offices scattered around the US. Our employees utilize ...
0
votes
0answers
33 views

What exactly should I backup in MongoDB when using replica sets?

I have several instances of MongoDB replica set servers with a primary and a failover machine for each replica set. The primary machine makes daily backups by creating an LVM snapshot and copying all ...
0
votes
0answers
20 views

MySQL replication error when an event is expired and dropped automatically

I have an event that ends at 2014-01-21 10:00:00, and a replication error was caused by drop event *** statement, coz the slave complains that the event does not exist at all. A little bit more ...
0
votes
0answers
33 views

Mongodb replication behind a gateway

I have a replicaset with 3 servers and I need to move two if them behind a gateway. The final setup would look something like this, Server 1 (PRIMARY) ________ | S | _____________ | _ _ _ _ _ _ _ ...
0
votes
0answers
49 views

Saving replication latency for monitoring purposes

I have SQL Server 2012 Enterprise edition, transactional replication. many servers, many DBs. This morning I come to the office and been told the latency on some databases was about 30 min behind. I ...
0
votes
0answers
130 views

Replication monitoring refresher for distribution job affecting performance

I have a performance problem due to a sql agent job executing dbo.sp_replmonitorrefreshjob. The environment is a 2 node Cluster with SQL Server 2005 SP2 and with transaction replication. The OS ...
0
votes
0answers
41 views

Error “Slony-I creation script not avilable ; only joining possible” in SlonyI replication using pgadmin3

I am facing the above issue while Creating a base replication objects like database etc.. As a workaround i have done the changes like editing the options of Binary Paths in Pgadmin Console but no use ...
0
votes
0answers
48 views

What should be the ideal network configuration for a Postgresql Streanming Replication and PgPool HA setup

I have the following configuration using Pgpool, Postgresql with streaming replication. Pgpool is used for load balancing and automatic failover. .-----. .--------. | | ...
0
votes
0answers
31 views

Mysql Master - Master Replication

i have established a master A and master B replication between two servers.Both are getting replicated.But it is limited with only one database. My questions 1.How to create a new database in ...
0
votes
0answers
24 views

MySQL multi masters with replicas

Currently I have a Master-Master setup, however there is a need to create replicas servers in geographical areas. I am trying to figure out the best method to handle this. The kicker is not all ...
0
votes
0answers
67 views

mysqldbcompare showing AUTO_INCREMENT differences but there are no missing records

I am encountering a strange issue when using mysqldbcompare to compare two MySQL DBs(one is a master, the other its slave). I noticed that the tool notes that the AUTO_INCREMENT values of this ...
0
votes
0answers
354 views

How to solve MySql Slave Error 1452 Foreign key constraint fails?

I am site administrator. We use to have a mysql 5.5.40 master(db01) - slave(db02) setup. One day our master server (db01) got down due to hardware failure. So we switched our site to slave (db02) ...
0
votes
0answers
21 views

Replication lag is causing issue on one shard

I am running a mongo db sharded cluster with two shards. Each shard has one primary, one arbiter and one secondary. On one shard I am facing an issue with replication as it is showing this result ...
0
votes
0answers
60 views

Mysql Multi master replication - auto_increment for tables with natural primary key?

I am thinking about using Master-Master replication using Mysql 5.6.19 with InnoDB as the engine. From what I have been reading, looks like I should be using auto_increment_offset and ...
0
votes
0answers
22 views

Sudden (and drastic) decrease in commands/second on replicated slave

On a slave that uses statement-based replication from a failover of master (all running mysql 5.6), the number of queries executed per minute has suddenly decreased from ~20k during peak traffic to ...
0
votes
0answers
22 views

MySQL Remote Database Failover: Need Advice

I run a network of sites all on 1 server. To improve performance, I'm (finally) moving the MySQL database to a remote machine. I'd love anyone's advice on how to appropriately approach failover. ...