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

filter mysql replication (ignore-db)

mysql ignore-db works according to server my.cnf AFAIK, i.e. binlog-ignore-db = mysql replicate-ignore-db = mysql I am not sure, if this works from client side too, can anyone explain the mechanism, how…
tike
  • 548
  • 3
  • 12
  • 22
10
votes
3 answers

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? Do I need a separate MySQL instance on the slave for each master server? Or is there a way to define multiple master hosts? We're…
HyderA
  • 20,651
  • 42
  • 112
  • 180
10
votes
1 answer

What is the difference between restart_lsn and confirmed_flush_lsn in Postgresql?

As documentation said - restart_lsn is: The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints unless this LSN gets behind more than…
Egor
  • 523
  • 4
  • 15
10
votes
5 answers

SQL Server : Replicate Schema changes to another database

I am working on a requirement in ASP.NET Web API which needs two identical databases. I have created two identical databases on the same server. Let's say one is for the development and another for testing. I want to replicate all schema (like…
sachin kulkarni
  • 737
  • 1
  • 13
  • 26
10
votes
0 answers

Setting up master/slave replication databases within my Vagrant box

Currently, I am using Vagrant 1.4.3 in-conjunction with VirtualBox running Unix (Centos) for my development server (using MariaDB). I didn't setup the box myself (so my knowledge of setting this up is limited) I would basically like to do the…
Zabs
  • 13,852
  • 45
  • 173
  • 297
10
votes
1 answer

What's the difference between pgpool II replication and postgresql replication?

I'm not exactly a DBA, so I would appreciate easy to understand responses. I have to provide replication to our DB and pgpool seems more convenient because if one postgresql instance fails, the clients are not required to change anything to keep on…
nique21
  • 101
  • 1
  • 4
10
votes
2 answers

MongoDB Capped collection equivalent in PostgreSQL

The very basics of MongoDB capped collections is that they let you set maximum size of the table and the system will clear old data when the size limit is reached. Has anyone came up with the similar setup in PostgreSQL and used it in production?
Uzbekjon
  • 11,655
  • 3
  • 37
  • 54
10
votes
3 answers

Why SQL Server doesn't allow to remove a Distributor exactly after Configuration?

I Configured a distribution in SQL Server 2008 using both Wizard and T-SQL but after it when I want to remove it Using Wizard (right clicking on Replication and choosing 'Disable Publishing and Distribution...') or executing following command with…
Mohammad Sheykholeslam
  • 1,379
  • 5
  • 18
  • 35
9
votes
2 answers

What can we do in MySQL 5.0 replication to address bandwidth concerns?

I am developing an application to run on the client PC (Win) which is configured with a MySQL server 5.1 instance that will act as read-only slave to the remote master. The remote master has dozens of schemas, but I only need one per client so I…
Abram
  • 784
  • 5
  • 11
9
votes
1 answer

How could we make use of ClusterListener in Mongo?

I was trying to look for an example or usage of the ClusterListener to optimize and improve the debugging information of a service integrated with MongoDB Java client. How could this be used by us effectively to improve on our Mongo cluster set…
Naman
  • 27,789
  • 26
  • 218
  • 353
9
votes
2 answers

How can I skip all errors on an RDS replica instance?

I use certain my.cnf settings like this. Does RDS instance allow such options? slave-skip-errors = 1062,1054 replicate-ignore-db=verv_raw …
shantanuo
  • 31,689
  • 78
  • 245
  • 403
9
votes
4 answers

Inserting into table with an Identity column while replication causes error in SQL Server

I have a table A_tbl in my database. I have created a trigger on A_tbl to capture inserted records. Trigger is inserting records in my queue table B_tbl. This table has an Identity column with property "Not for replication" as 1. A_tbl (Id, name,…
agm92
  • 314
  • 1
  • 3
  • 11
9
votes
3 answers

Setting `server-id` variable in MySQL doesn't work

I've been trying to set up two databases as master & slave. I followed the famous guide here: https://dev.mysql.com/doc/refman/5.1/en/replication-howto-existingdata.html But no luck on my slave server, The issue I'm having is setting the server-id…
RagZ
  • 149
  • 1
  • 1
  • 6
9
votes
2 answers

RDS Read Replica Considerations

We hired an intern and want to let him play around with our data to generate useful reports. Currently we just took a database snapshot and created a new RDS instance that we gave him access to. But that is out of date almost immediately due to…
Brad Dwyer
  • 6,305
  • 8
  • 48
  • 68
9
votes
6 answers

Amazon RDS MySQL and Master-master replication

I can't find it from documentation, but it seems Master-Master replication is not supported at this time. Is this correct?
DmitrySemenov
  • 9,204
  • 15
  • 76
  • 121
1 2
3
…
99 100