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
138 views

How to setup a Postgres-xc streaming replication with master-slave(for HA)?

Can you guys please help me about how to make streaming replication with master-slave configuration using Postgres-xc to confirm an HA environment? Thanks
2
votes
1answer
204 views

All four data nodes in MySQL Cluster in same node group

I am testing MySQL Cluster 7.2. I have two servers, mysql1 and mysql2. I want the management server and two data nodes to run on mysql1 and two other data nodes to run on mysql2. My config.ini file ...
0
votes
0answers
37 views

How should I arrange a database replication for my site?

Here is my problem. I have a busy Drupal site struggling under high load. After applying all caches I see that database is the bottleneck. I have two servers to handle the site: A and B, on the same ...
0
votes
0answers
49 views

Issue with slony-I replication on postgres master and slave database

I have two system with OS windows 8 and windows XP. I installed the postgres plus advance server for database replication on both system. I followed this link for whole process. But there is one issue ...
1
vote
0answers
80 views

CouchDB - painfully slow replication

we intend so replicate a database around 500GB in size from one host to another and use a loadbalancer splitting up the requests. On small test databases that worked great, yet repliating the main ...
1
vote
1answer
113 views

Repairing Broken Binary Replication in PostgreSQL 9.0

I have a binary replication that was stopped for so long that the WALs were removed and as a result, it ended up being old. I'm trying to reestablish the replication and the best way I've found so far ...
0
votes
1answer
413 views

SQL Server: subscriber as publisher and hierarchical replication

In Oracle Streams one way replication from one DB to another is a basic block for many replication topologies (N-way, hierarchical, combined and so on), and changes could be captured and applied for ...
0
votes
0answers
106 views

postgres-xc: ERROR: cannot set transaction read-write mode during recovery!

I am trying to make a HA in postgres-xc After creating an environment of streaming replication I am trying to create a table in default database as coordinator logged in. But it gives me the following ...
0
votes
1answer
220 views

MySQL asynchronous multi master replication conflict resolution

I have setup Multi Master replication, following this blog thread: http://0wned.it/geek-bits/guides/mysql-multi-master-replication/ And now it synchronizes perfectly, up until the moment the ...
0
votes
0answers
63 views

Data deleted from replicated table

I have two servers (one publisher and other is subscriber). The replication is succesfully running for a long time. I am using transactional replication with updateable subscription. Couple of days ...
0
votes
0answers
46 views

MySQL Err 1032 on only 1 Slave

I'm getting a very strange error on one of my MySQL servers and I'd appreciate some help. The Setup I have a separate environments. * Environment 1 consists of the Master Server and 1 Slave. * ...
1
vote
1answer
114 views

How to achieve this sql server replication scenario?

I want to achieve below illustrated scenario via sql server replication. Client A and Client B are client databases containing same article Table A. This article needs to be published by Client A ...
5
votes
1answer
526 views

Best strategies to have a backup of an RDS MySQL database

I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited. I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup. I know ...
3
votes
1answer
78 views

Will creating a view on a MySQL replication slave break the replication?

We need to run some very ugly queries on a MySQL replication cluster. Does anyone know if creating a view directly on the slave will break the replication of the other, otherwise untouched data ...
2
votes
1answer
856 views

Percona Node fails to join: Operation not permitted

Joining a new Percona node fails with: 130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group ...
1
vote
2answers
148 views

Replicating schema changes between production and development databases [duplicate]

Not too sure if this would be a good and proper way to go about things, so I apologize if I'm kind of far off. Currently running Microsoft SQL Server 2005, and in this we have a database for a ...
5
votes
1answer
114 views

How to schedule PostgreSQL replication?

I was reading postgresql replications solution but, even I just starting understaning how it works, another doubt has arrisen. I'll be using postgres internal replication solution but as far as I ...
1
vote
2answers
252 views

Which one to use? InnoDB Replication or MySQL Cluster?

I am building a url shortener and I use InnoDB as the storage engine for link data. I will start with a single VPS containing both application instance and MySQL database instance on the same Virtual ...
0
votes
2answers
114 views

MySQL Master/Slave. Actual use of Slave Machine

We have a MySQL server running in a mobile production trailer. The trailer is out on the road for weeks at a time. We have cell internet and wifi access is nearly all of our locations. Our office ...
0
votes
3answers
108 views

Master/Slave without populating tables

So I have some Zabbix instances which are using MySQL for their backends. What I would like to do is, for DR purposes, backup the DBs for each instance using a Master/Slave configuration, with the ...
1
vote
0answers
216 views

How to sync mysql remote database daily ?

I have a database that contains orders , products ..etc. I have another system that generates reports based on this database. Due to heavy load i want to separate those systems Where i have the master ...
0
votes
1answer
282 views

How to install and configure Postgres-XC in windows?

Can anybody suggest me any resources of the complete installation procedure of postgres-XC in windows. I've installed postgresql-9.2 in my windows and can use it. Now I need to know the installation ...
0
votes
1answer
100 views

distribution.dbo.MSdistribution_history comments explanation

The comment column of distributor.dbo.MSdistribution_history contains comments such as <stats state="2" fetch="11554" wait="214007" cmds="17898546" callstogetreplcmds="106880"> ...
0
votes
3answers
2k views

mysql replication successful but slave not replicating

I have created a mysql master-slave configuration and things look fine . the " show master status;" on slave doesnt show any error . this is the output Slave_IO_State: Waiting for master to send ...
1
vote
1answer
500 views

SQL Server-MySQL master-master replication

We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
1
vote
1answer
176 views

Merge Statement + Replication difference for SQL Server 2012

We have a SSIS package that will pull from a source database and run a merge statement to put the data into a "Master" database. (Eventually the "Master" database will be the source of truth, but we ...
0
votes
1answer
42 views

Is it possible to upgrade mongodb cluster without upgrading arbiters?

Is it possible to have running real nodes with version 2.4 and arbiter nodes with 2.0 or 1.8 in the replica set? Upgrade guides for version 2.2 and 2.4, did not tell anything about upgrading ...
0
votes
1answer
614 views

MySQL Replication and Triggers

I have stumbled upon an interesting MySQL Error message that I do not really know how to interpret. The setup: There are two tables A and B. When data is written or updated in the table A, then a ...
2
votes
1answer
344 views

Is replication from SQL Server 2008 to PostgreSql possible?

Is it possible ? Sql Server as publisher(master) and PostgreSql as slave(subscriber) ? Any type of replication really.
2
votes
2answers
326 views

Modifying replication distributor & publisher

I have a SQL Server 2008 transactional replication setup as follows: 192.168.100.1 <-- Distributor 192.168.100.2 <-- Publisher 192.168.100.3 <-- Subscriber Our network team want to change ...
2
votes
3answers
208 views

Does MySQL 5.6 support fan-in replication?

I've known for quite awhile that Continuent's Tungsten Replicator supports fan-in replication (example). By fan-in replication I mean combining multiple datasources into a single instance (like a ...
1
vote
2answers
193 views

How to avoid lagging when enabling log-slave-updates?

Master: 48GB RAM 16-core my.cnf: https://clbin.com/hlkUo Slave: 64GB RAM 24-core my.cnf: https://clbin.com/viLm0 Both are running 5.5.28. For the incremental backup purpose, I need to enable ...
0
votes
0answers
162 views

MM Replication and Zabbix in slave, Error code 1032

I have multi-master replication and using Zabbix for server monitoring. Since the replication is row based, I get this error in slave everytime which also breaks my replication. The error I get is: ...
1
vote
1answer
185 views

Master updates Slave but not Master itself

I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color. ...
0
votes
0answers
244 views

PostgreSQL: Slave doesn't replicate the Master's data

I'm using PostgreSQL 9.2.3 on both computers, both of which run Win2008R2. I've setup streaming replication by following this guide: ...
5
votes
2answers
349 views

“Arithmetic overflow” when initializing SQL Server 2012 replication from backup

I'm initializing SQL Server replication from a backup, by following instructions from here: http://www.mssqltips.com/sqlservertip/2386/initialize-sql-server-replication-using-a-database-backup/ ...
3
votes
2answers
952 views

MySQL replication: most important config parameters for performance on slave server?

I'm setting up a mysql master-slave configuration, where slave is located on a much weaker sever. Since, if I understand correctly, slave only works on updates/inserts, what are the most critical ...
2
votes
2answers
3k views

Is it safe to delete mysql-bin files?

I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these mysql-bin files inside /var/db/mysql/ There are hundreds of those ...
0
votes
1answer
57 views

mysql replica ignoring server-id [closed]

I've setup a mysql replica slave a couple months ago. After a couple hickups lately, I've decide to restore it from a clean master export. I'm trying to start my mysql instance with this command : ...
0
votes
0answers
49 views

Can i use XAMMP mysql server with Percona Xtradb cluster?

I just wanted to know if I can use a normal MySQL server (XAMPP) as part of the cluster on my EC2 Server running Percona XtraDB Cluster. Can I just change the my.cnf config file on XAMPP with the ...
4
votes
2answers
555 views

Transactional Replication Concerns

We are debating an architecture that employs sql server 2012 and transaction replication. Idea is to offload reporting activity to a secondary server and have the ability to include/exclude what is ...
0
votes
0answers
125 views

Oracle Downstream Log transfers

I am attempting to create a downstream capture process for two Oracle 11 databases running on Linux servers. The replication will be one-way and asynchronous using archive logs as the transfer ...
0
votes
0answers
63 views

MySQL replication is not happening when piping sql into mysql client

Today I noticed a very strange issue where if I cat a SQL file and then pipe it to MySQL client, replication doesn't happen. These MySQL statements aren't also written to the binlog. But replication ...
3
votes
1answer
200 views

Switch MySQL lag slave to new master and keep lagging (5.1)

We have the following scenario: Set of slaves replicate from the master, separate standby master (a.k.a slave with binlogs) replicates from the same master; lag slave, powered by pt-slave-delay, ...
1
vote
1answer
601 views

SQL Server Replication: “ALTER TABLE ALTER COLUMN” is not propagated to subscribers

We are running SQL Server 2008 R2 SP1 as publisher & distributor, and SQL Server 2005 SP3 as subscriber. The replication of schema changes is activated, and the replication has been running for ...
1
vote
1answer
445 views

MySQL replication — issue with mysql.proc during replication from 5.0 to 5.5 host

We are replicating from a mysql 5.0.45 host to a 5.5.26 host over WAN. Every once in a while one of our databases does not accept a query and halts the replication. "'Column count of mysql.proc is ...
1
vote
2answers
2k views

Is there a way to stop MySQL Replication on the master?

I want the master to stop replicating data to the slave. I know I can do that on the slave with STOP SLAVE;, but I wonder if there is a way to do it in the master. One possible solution might be to ...
1
vote
2answers
926 views

Loading data in mysql using LOAD DATA INFILE, replication safe?

I am trying to load data into mysql database form CSV file. I found that we could use LOAD DATA INFILE command to do it. But as per the mysql documentation it is not replication safe. (See here) Is ...
0
votes
2answers
596 views

Pull Subscription: process cannot read file due to OS error 5

I am trying to migrate a working pull subscription for transactional replication from one subscribing server to a new one. The subscribing server is at another site and is connected via a VPN tunnel. ...
1
vote
3answers
2k views

Single slave - multiple master MySQL replication

I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?