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
6 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
21 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
21 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
9 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
28 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
30 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
35 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
9 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
10 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
2answers
26 views

MySQL replication - how to read from slaves? manually?

MySQL Manual - Replication: "Scale-out solutions - spreading the load among multiple slaves to improve performance. In this environment, all writes and updates must take place on the master ...
1
vote
1answer
22 views

MySQL Replication Master Slave Architecture - Web app that is based on the SLAVE DB

We are developing a web application (Spring mvc based app) that uses a MySQL DB. (lets call it the "original app") The DB architecture uses a MASTER-SLAVE configuration with replication. The web app ...
0
votes
1answer
11 views

MySQL Replication, Can i add a trigger to the SLAVE db?

Is it possible to do so? The trigger will insert some rows into a unique table that exists only on the slave.
0
votes
0answers
6 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" ...
1
vote
2answers
23 views

Postgresql 9.4 high availability

I currently have a master postgresql 9.4 server containing many databases on Ubuntu 14.04. I tried to use Barman to setup backup, but would like to set up streaming replica so that when the master ...
1
vote
0answers
26 views

How does SIOS Data Keeper make consistent backups? [closed]

We are looking to change our DR solution to get our RTO and RPO as close to 0 as possible. We have around 80 databases on SQL Server 2012 sp2 that come to about 1TB in total including log files. I ...
1
vote
1answer
30 views

'accidentally' set 'CHANGE MASTER TO' on wrong server

while setting up the replication I accidentally did the 'CHANGE MASTER TO' on the master server instead the slave. When I noticed the mistake I just did a 'STOP SLAVE' on the master and setup the ...
0
votes
1answer
28 views

Mysql master master with high latency

We have a single master setup with many slaves in germany and some slaves in australia. To have faster writes in australia we want a master-master setup between germany and australia. Read slaves ...
1
vote
1answer
32 views

federated tables? synchronization? replication? [mysql]

I have a REMOTE suppliers table with, lets say, a code and a name, and several client databases will be creating new suppliers. Server database code | name ______________ 1 | Mark 2 | ...
0
votes
0answers
9 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
1answer
12 views

Error while doing in replicaset in windows (mongodb)

I tried doing the replicatset in windows, but im getting the below error. I checked the mongo process and killed the existing process. Even though the error exists. help me on this pls Thx ...
0
votes
0answers
16 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
29 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 ...
2
votes
1answer
29 views

Replicating to Older Versions of MS SQL Server

According to an old MSDN article (from the SQL Server 2008 R2 era), Microsoft SQL Server transactional replication subscribers need to be within two versions of the publisher. Does this hold true for ...
1
vote
1answer
26 views

Are CREATE INDEX statements replicated in row-based Mysql Replication?

I've not been able to find a simple explanation of what kinds of statements are or are not replicated from a master db to a slave in MySQL, row-based replication. Specifically I want to add a ...
1
vote
1answer
33 views

MySQL Master not sending events to another Master

We have Master-Master Replication and it is configured correctly as it transmit data for certain period of time and after that it does not send further events till we stop/start slave on both nodes. ...
1
vote
1answer
15 views

Why does most Galera cluster documentation recommend having at least 3 nodes as the typical set up?

The Galera documentation and most experts implementing this type of setup, recommend having at least 3 nodes in the Galera cluster. What is the reasoning behind this? Is a cluster setup with only two ...
1
vote
0answers
13 views

noobie to streaming replication in postgres 9.2

I've been asked to reverse engineer an app that uses postgresql in the back end. I can see that there is some database replica tion going on... based on my reading, I *think it's called streaming ...
0
votes
0answers
12 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
14 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
2answers
32 views

Looking to find a way to determine replicated objects from subscriber

I am trying to create a process to script out items that have been added to subscriber databases in transactional or snapshot replication - sometimes we find users have added a view or proc to a ...
1
vote
2answers
20 views

Disable MySQL replication

I'm running following: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.6 (Santiago) # uname -a Linux X 2.6.32-504.3.3.el6.x86_64 #1 SMP Fri Dec 12 16:05:43 EST 2014 x86_64 x86_64 ...
0
votes
0answers
15 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 ...
1
vote
1answer
19 views

How to transition from a statement based log to row based log for Galera replication?

I'm new to clustering and I'm trying to implement a Galera cluster. I'm transitioning from a standalone MySQL instance to a MariaDB Galera Cluster consisting of (at the moment) 2 nodes. I have ...
1
vote
1answer
27 views

Filtering data in a publication

I'm looking to replicate a table that has a particular column for deciding if a row should be replicated. If the column is set to 'Y', then replicate. From my searching, Static Row filters are my ...
1
vote
0answers
15 views

Does an “update-update” conflict get created from the same node in P2P replication?

I have been told that an update-update conflict is being created in a production environment, which is set up using p2p replication, because of concurrent update by stored procedures. The msdn ...
1
vote
1answer
49 views

PostgreSQL Replication on a daily basis

With PostgreSQL, I want to replicate a subset of all tables from Database A to B, but only once a day. Since I do not know what to search for: is there a technical term for such a scenario? Does e.g. ...
0
votes
0answers
18 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 ...
1
vote
0answers
19 views

Replicating Multiple SQL Servers to Azure and Accessing From Web Apps

I am setting up quite a large system with multiple servers (MS SQL Server), and Office 365 Access DB, and a custom SharePoint web app for reporting purposes. The system should work as follows: Each ...
0
votes
0answers
22 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
3answers
52 views

Keeping an up to date copy of a SQL Server database on another server [closed]

We outsourced some of our business functions to another company. That company makes use of the same software as we do and we would like to keep a update to date copy of their database on our servers ...
3
votes
0answers
77 views

Recovery when failover

1/ Description: I have 2 Centos machine: master, slave (streaming replication). Both of them are built on PostgreSQL 9.3 (image below) and configured failover event (failover PG 9.3 document). Last ...
0
votes
2answers
45 views

Sql server 2008 - server name changed

I have changed the computer name of the server where sql server 2008 r2 is installed. Old name was WIN-OUJEKRMGXXX and new server name is KASURDYYY When i configure replication following error ...
0
votes
1answer
33 views

Is it wise to create indexes for the replication server only?

At my workplace we have a requirement to have extra indexes on the replication server (we replicate data only). This is because we a bunch of reporting that runs off the replication server so some ...
1
vote
1answer
22 views

Recommendations for my.cnf on MySQL Replicant

I have replication environment running in a master-slave configuration. The replicant is doing all writes and doing selects only very rarely - and none in which high performance is a requirement. ...
0
votes
0answers
43 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
17 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" : { ...
1
vote
1answer
16 views

Mysql Master-Slave replication catchup and bin_logs

I have set up MYSql Replication using 2x 128gig ram 24 core cloud servers. we have a massive live database that cannot experience down time due to the high volume of data input. I have found while ...
0
votes
0answers
24 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 ...
1
vote
1answer
22 views

Setup MongoDB replica servers with different power?

Is it a good practice to setup replicas with the same machine size (wrt. CPUs, RAM, Bandwidth, etc.) or can replicas be based on smaller machines? One usecase might be to have a small non-voting ...
0
votes
0answers
34 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 ...