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
1 answer

Query a postgres database for the SQL which generates the tables

We want to replicate our local test DB automatically, given the structure of the production DB, on the fly / on demand. What would be nice, would be to query the prod DB and retrieve the SQL that generates the tables/views and then run that SQL…
Alexander Mills
  • 90,741
  • 139
  • 482
  • 817
0
votes
0 answers

Master-Master Mysql-Replication Error : 'Duplicate column name 'my_column'' on query

I Resync the Master Master replication and got following error. Last_Errno: 1060 Last_Error: Error 'Duplicate column name 'feed_order'' on query. Default database: 'example.com'. Query: 'ALTER TABLE wp_gf_addon_feed ADD COLUMN feed_order…
Anto
  • 3,128
  • 1
  • 20
  • 20
0
votes
1 answer

set up multi-source replication with mysql

I'm trying to setup the multi-source replication and I'm reading that tutorial : multi-source replication I think I've found exactly what we are looking for! But I have a few questions, since this is my first time I’m trying to configure a MySQL…
sincos
  • 127
  • 2
  • 18
0
votes
1 answer

rails application connect to a mongoid replicaset

I'm having difficulty connecting to a mongoid replicaset from a rails app. I have the following config: dev1: clients: default: database: opera_bounties_dev1 hosts: - 10.0.0.1:27017 - 10.0.0.2:27017 # read:…
Victor Pudeyev
  • 4,296
  • 6
  • 41
  • 67
0
votes
0 answers

PostgreSQL DB after replication inaccessible - "role "postgres" does not exist"

We have master-slave replication on PostgreSQL 9.4.9 CentOS 6.8 and till today we've had beautiful time with our replication between our two +- identical servers. But today I ran VACUUM FULL (on the master of course) which destroyed replication (as…
mkwinco
  • 1
0
votes
1 answer

How can I get the updates and Changes in all masters in a Multi-Master Replication?

I have configured Mysql Ring replication say as Servers A,B,C. I can get the changes and updates in B when I commit the updates in A. I get it in C when I make changes in B. I get updates in A when I make it in A. My issue is that I cannot get any…
Narasimman
  • 11
  • 3
0
votes
1 answer

Share 1 storage repository between 2 database

I'm having my project for my "distributed system development" class, and my project is making a minimal version of cloud storage (sth like Google Drive). my approach here is using 2 backend server written in Rails, with 1 proxy server to control…
user3448806
  • 897
  • 10
  • 22
0
votes
1 answer

MariaDB Master-Slave replication don't work without error

I have two MariaDB 10.1.16 server on two different host. I setup a Master-Slave replica and there aren't errors: SLAVE: MariaDB [(none)]> SHOW SLAVE STATUS\G *************************** 1. row *************************** …
iltizio
  • 1
  • 2
0
votes
0 answers

Newly created databases are not replicating in mongo database

I am relatively new to Mongo database. Let me explain the issue. I might be missing something very obvious. I have a 3 member replica set. One of the existing database is replicating properly (created a collection and verified), but when I create a…
vignesh28
  • 1
  • 5
0
votes
1 answer

Error Code: 1126. Can't open shared library 'C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\semisync_master.so'

I am using MySQL 5.6 running on 64-bit Microsoft Windows Server 2012R2, as I run the following query INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so'; there is an error will generates, "Error Code: 1126. Can't open shared library…
Prashith
  • 1
  • 3
0
votes
1 answer

redis vs mongo - replicating from master to slaves that are running in-memory databases

I know that redis is a different architecture from mongodb. From reading other posts here and on other sites, it looks like redis is good for scenarios where you don't have as much data... Mongo seems to shine when dealing with very large amounts…
dot
  • 14,928
  • 41
  • 110
  • 218
0
votes
1 answer

Access 2010 + replicated mdb: can't edit table in design view: 3251 error

I have replicated .mdb database on network share with only data (code, forms, etc. are on another mdb). Is was created while ago and there was no problems with it on previous Access versions, including 2007. Problem: When I open table in design view…
amber
  • 11
  • 2
0
votes
1 answer

MySQL The table is full on query

I can't find the source of the issue on our Master/Slave replication . Today i was updating the Master and suddenly got the following error from the slave Error 'The table 'caching_api' is full' on query. Query: ' ALTER TABLE `caching_api` ADD…
Tarek
  • 3,810
  • 3
  • 36
  • 62
0
votes
1 answer

What SQL Server Replication is right for me?

I want to setup replication between to databases. Every morning we do a data dump in a few databases. One database has 27 tables in it. We append records to 3 tables and insert records into a few others. After that no updates or inserts are made. I…
Kyle Johnson
  • 763
  • 1
  • 13
  • 31
0
votes
1 answer

SQL Server DLLs

I'm upgrading to 64 bits a Windows application that manages medical and research equipment and I'm soliciting some high-level just-get-started assistance... My stumbling block is .NET references to SQL Server DLLs, in particular, two "mysteries"…
We B Martians
  • 367
  • 2
  • 12
1 2 3
…
99
100