Tagged Questions

Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance. The replication process commonly involves continuously duplicating a "master" database to one or more additional "slave" databases.

learn more… | top users | synonyms

0
votes
0answers
7 views

jdbc:mysql:replication causes Unknown column in 'field list' exception at runtime

I am using JBOSS EAP 5.1 want to implement Master/slave mechanism. xyz-mysql-ds.xml (for ex. customer db) xyz-mysql-ds.common.xml (for common db) I have added master/slave ip in ...
0
votes
1answer
7 views

SQL Server Replication

I need to perform replication on MS SQL Server 2005 Standard Edition. The goal is, that I have several databases (for example 4 instances of SQL Server) and each must act as publisher to other sites. ...
0
votes
0answers
9 views

Can't add merge replication

I am moving database with some replication from server A to server B. Last thing I tried was to create a merge replication using following command: exec sp_addmergepublication @publication = ...
0
votes
0answers
17 views

“Could not create IPv6 socket” postgresql standby error [on hold]

I'm trying to create Postgresql hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
0
votes
0answers
10 views

golden gate initial load not working [migrated]

I recently started studying golden gate I read basic components of golden gate and started with installation written in following book click [link] ...
0
votes
1answer
38 views

How to handle this replication scenario?

Suppose there are some databases: P, S1, S2, S3 etc. P (publisher) has some tables that need to be replicated (cloned and synchronized) on S1, S2 and S3 (subscribers). The copies of those tables ...
0
votes
1answer
14 views

mysql 'replace into' fails only on replication slave

The purpose of this table is to collect multiple stats (specified by name column) by-the-minute, and then I wrote some sql that rolls up the sum( ) of the minutes into the hours by name, and the sum( ...
2
votes
0answers
40 views

Informix to Postgres, continuous data replication algorithm

The master server is Informix, version varies from 9.40 to the latest, database is unlogged by design that can't be changed. Slave server is the latest PostgreSQL. Master and slave are separate ...
0
votes
0answers
15 views

multi master replication [migrated]

Let us say I have a master(m) slave(s) replication. Now, in the scheme of things, I introduce another database/schema(foo) not associated with the master in any way and I want this schema to be ...
0
votes
2answers
12 views

Application fails to connect mongodb when primary node changes

I had followed the following tutorial to setup mongodb on ec2, http://docs.mongodb.org/ecosystem/tutorial/install-mongodb-on-amazon-ec2/#install-mongodb-on-amazon-ec2 I have limited to one primary ...
0
votes
0answers
13 views

How to use read preferences in mongoskin?

Is there any way to define read prefence in mongoskin in collection or db level here is the sample from mongodb native nodejs driver http://learnmongodbthehardway.com/ex22.html var readMongo = ...
0
votes
0answers
18 views

Broken mysql replication on slave server (error 1236) [migrated]

My question is: how to fix broken mysql replication on slave server (error 1236)? server 1 (192.168.1.105) server 2 (192.168.1.106) I ran these steps to re-sync: At the master - server 1 ...
1
vote
1answer
13 views

Encountered a MongoDB warning after converting a replica set to stand alone server

I encountered the following warning after converting a mongodb replica set to a stand alone server. I did rs.remove('host') and removed the replSet arguments when starting the mongo db. [root@sam ~]# ...
1
vote
1answer
30 views

Replicating data from mySQL to Hbase using flume: how?

I have a large mySQL database with heavy load and would like to replicate the data in this database to Hbase in order to do analytical work on it. edit: I want the data to replicate relatively ...
0
votes
1answer
19 views

SQL Server - Creating Distributor causes error

When I try to create a Distributor on a SQL Server 2012 database I get the following error. I have tried a lot of things over the last 6 hours and can't get anything to work. Does anyone have any ...

1 2 3 4 5 … 29
15 30 50 per page