Stack Overflow
Stack Overflow

Questions tagged [database-replication]

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.

Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending (and potentially re-sending until successfully applied) of subsequent updates.

1836 questions
0
votes
3 answers

Couchbase Lite pull with filtered replication from CouchDB

I did not manage to pull replication data from CouchDB. I am using CouchDB for my document storage. CouchDB Version: Apache CouchDB 1.6.1 Couchbase Lite: Couchbase Lite 1.4.0 Below are my sample data: { "_id": "ab33deeb074523e3c63c216b8c2952a8", …
KEN CHEONG
  • 13
  • 4
0
votes
2 answers

Mysql master-slave replication breaks when issuing commands from master's phpmyadmin

I have successfully configured MYSQL slave from existing master SQL server using this https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql The setup works fine and changes made to master through MySQL…
jugadengg
  • 99
  • 1
  • 3
  • 15
0
votes
0 answers

MySql Replication not updating slave - Relay log file updated

First time working with replication so apologies if I don't understand exactly how it works. Have two servers as masters to each other. Slave status on both show Slave_IO_Running and Slave_SQL_Running as YES. Seconds_Behind_Master show as 0. I…
David Ryland
  • 1
0
votes
1 answer

Mariadb master-slave replication stopped without errors

I have setup mariadb master slave replication about a week back.It worked fine for 3-4 days but later the replication has stopped without giving any errors.The value of seconds behind master parameter is increasing. I have posted the screenshot of…
ns15
  • 5,604
  • 47
  • 51
0
votes
1 answer

sp_dboption in SQL server 2012 for Published property

Currently working on migrating SQL server from 2008 to 2012 project. We aware that sp_dboption is deprecated and it will not work in SQL server 2012. In 2008, had code to set the value for Published property. EXEC master..sp_dboption DBName,…
Venkatesh R
  • 515
  • 1
  • 10
  • 27
0
votes
0 answers

Mongodb Master Slave Replica Sets

Is it possible to create two 3 node replica sets with mongodb but have one replica set be the master and the other be the slave? What I want is to have one replica set on the east coast, and one on the west coast. I'll only be writing to the west…
Khon Lieu
  • 4,295
  • 7
  • 37
  • 39
0
votes
2 answers

mysql multi-source replication stability

We use mysql multi-source replication, analysts and developers works with the databases, it's a main task of server(cross-bases queries, etc). Mysql slave replicates data from about 10-15 servers, some of them is realy big (400gb, 500gb, 1.5tb).…
Kostiuk Aleksandr
  • 509
  • 2
  • 14
0
votes
2 answers

What are the tools available for data replication on oracle and/or db2?

I just need to know the name of the tools in order to establish a start line.
gsb
  • 1,219
  • 1
  • 16
  • 31
0
votes
1 answer

Change postgres user password in hot standby read only mode

I want to change the password of the postgres user on my PostgreSQL Slave Server which is in read-only mode because of an active replication. SELECT pg_is_in_recovery(); returns true and because of this I can't change the password - so far so good.…
mxlse
  • 2,654
  • 17
  • 31
0
votes
1 answer

What is the "Replication" key for in a SQL Server connection string?

In a SQL Server connection string you can specify a boolean value for the Replication key, for example: Data Source=.;Initial Catalog=Example;Integrated Security=True;Replication=True; The closest I can find to documentation of this is here, which…
Adam Goodwin
  • 3,951
  • 5
  • 28
  • 33
0
votes
0 answers

What happens when mysql binlog reaches mysql-bin.999999

Lets say my mysql replication is enabled for long time, and the server has been quite busy, so new bin log files get created every few seconds. So in a few months, it is possible for latest bin log file to have name "mysql-bin.999999". Does the next…
Ouroboros
  • 1,432
  • 1
  • 19
  • 41
0
votes
0 answers

Cannot initiate mongodb (code 8)

Tried to initiate a replica set in MongoDB but failed. My mongod configuration file is as follows: dbpath=C:\data\db logpath=C:\data\log\mongo.log storageEngine=mmapv1 After starting mongod with the command: mongod --config "C:\data\mongo.conf"…
Hoai
  • 11
  • 2
0
votes
1 answer

xDB Replication Console unable to connect JRMP connection establishment

While trying to add a Oracle publication server to xDB Replication Console (v6.1.2), the following error is obtained: How do I fix this? Also, how can the DB name be specified while connecting as it only asks for host, port,username and password?
S_S
  • 1,276
  • 4
  • 24
  • 47
0
votes
1 answer

Two instances of database are not synchronized with load balancer

I have 2 instances of MySQL databases and they are being handled by Load Balancer. Now Spring application contacts load balancer with great amount of requests. Some transactions are locking one row in database (exclusive). In some occasions deadlock…
alxbxbx
  • 313
  • 1
  • 5
  • 18
0
votes
1 answer

is it possible to do the Merge Replication in databases that having two different database structures?

is it possible to do the Merge Replication in databases that having two different database structures ?
Sonal Muthukumarana
  • 39
  • 6
1 2 3
…
99 100