Questions tagged [replication]

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

The concept of replication have been performed either asychronously/asychronously for DB and NFS Servers.

From the perspective of databases, this has been performed asychronously via log shipping: the copying of log files containing completed SQL transactions to be performed on one or more database servers setup as Slaves. MySQL, PostgreSQL, and SQL Server support this type of replication. MySQL has improved upon this in MySQL 5.5 with semisynchronous replication. PostgreSQL has improved upon this with Streaming Replication.

From the perspective of OS Disks, this has been accomplished by network RAID1 schemes such as DRBD. DRBD performs block-level synchronous replication betweent two disks over a network (preferably private netblocks). This type of replication does not perform well over geographic distances. On the other hand, a DRBD Server pair should be using crossover cabling on a local subnet for the fastest possible disk replication by shortening the network transmission distance. The use of DRBD can provide an additional layer of redundancy for products such as MySQL, PostgreSQL, SQLLite, and Ingres.

NoSQL databases, such as Cassandra and MongoDB, also perform replication. Excellent replication performance can be achieved with proper tuning and and enhancement of server networks.

3462 questions
2
votes
1 answer

Merge Replication between two Embedded Databases?

I have an application that uses SQL Server CE 3.5. I am trying to expand the database to have a remote database accessible from various locations. I will need both the local (which might or might not have consistent internet connections) and the…
Stuart
  • 123
  • 4
1
vote
1 answer

The process could not execute 'sp_replcmds' on 'S15415940'. Cannot execute as the database principal because the principal "dbo" does not exist

Can anyone show me the way to fix these error messages: The process could not execute 'sp_replcmds' on 'S15415940'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Cannot execute as the database principal because the principal "dbo" does…
vNext
  • 145
  • 2
  • 8
1
vote
0 answers

replication error involving ignore-db

I have simple master/slave replication set up between two servers. The master has several DB's I wish not to replicate at this time, in fact there is only DB I am trying to replicate. I have several ignore statements in the .ini file but today…
jason
  • 79
  • 1
  • 4
1
vote
1 answer

Failed to run Tarantool replication

I'm trying to reproduce the tarantool master-replication from documentation so I made master/master.lua, rep1/rep1.lua, rep2/rep2.lua, cd for each directory and run it, but it shows something like this (for 10+ minutes, no progress): @…
Kokizzu
  • 1,363
  • 6
  • 17
  • 34
1
vote
0 answers

How can I insure data transfer from a client to an SQL database server if the network connection goes down?

My scenario is likely common: Many product test stations sending test data to a centralized (master) database. (In my case the product being tested is a high frequency transceiver) My goal: Keep the test stations running if the network connection…
DavidG
  • 11
  • 3
1
vote
1 answer

RAID vs Replication

I'm kind confuse about it, can some one give me a hand with this... Differences. Which one is better. Which one do you use and why? Personal Opinion and advise.
jcho360
  • 1,999
  • 8
  • 23
  • 31
1
vote
1 answer

Is there a way to see if a SQL 2012 Replication publication is marked for initilazation and a way to unmark it?

We have a SQL (2102) Replication Database with a Realtime DB being the Publisher and a Historical Db as the Subscriber. All of the Tables/Articles have the setting of Do Not Delete. Thereby the Realtime DB is maintained with a max data of say 2…
J Baird
  • 13
  • 3
1
vote
0 answers

"Replication Support Only" - Error on LogReader

Brief explanation is I am trying to set up a basic publication / single subscription of about 5 tables using a remote distribution database. Servers involved include (Server A pub | Remote Distribution database Server B | Server C sub). All servers…
talktolee
  • 11
  • 2
1
vote
0 answers

How to implement sql replication when subsciber cannot acces the publisher

I have 2 servers Server A (Publisher) and Server B (Subscriber) However server A can access Server B but Server B cannot access Server A. There are no VPN between these servers Server A can access B over the internet but B cannot do the same
Quetoz
  • 11
  • 1
0
votes
0 answers

why is latency growing

I have a 4.4TB database that I've been transactionally replicating to 2 different subscribers just fine. Yesterday I added a 3rd subscriber that is all flash drives to test how much better it will be with all flash drives. The latency on the…
0
votes
0 answers

Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND in Standby MySQL DB server 8.0.31 (mysql-community-server-8.0.31-1.el7.x86_64)

I am running MySQL DB server 8.0.31 (mysql-community-server-8.0.31-1.el7.x86_64) on Red Hat Enterprise Linux Server release 7.9 (Maipo) operating system and have enabled replication between Master and Standby. I am currently encountering the error…
Kaushal
  • 1
  • 2
0
votes
0 answers

Postgres12.7 Replication - Terminating walreceiver process due to administrator command after primary or secondary is restarted

The replication "breaks" after either the primary or secondary nodes are restarted: This runs on ubuntu server 20.04 using ZFS ( see below for settings ) Replication that is broken Log: 2023-05-24 19:01:20.946 SAST [12] LOG: entering standby…
0
votes
1 answer

What are best practices for incremental replications?

I'm working on a tool to replicate data from several different source DBs (used by the same company, but different vendors and versions) to one centralized analysis platform (for the purpose of this question: just another database). We don't need…
venite
  • 101
  • 1
0
votes
1 answer

Why would you distribute replica shards across nodes and not mirror replicas?

I'm trying to understand how replicas work in Elasticsearch. This is a very basic question, but can someone explain why one node is not just all replicas? Surely in this example, if one node fails 50% of the shards will be lost?
F.D
  • 103
  • 1