S
S
softshape2020-03-13 05:59:57
Database
softshape, 2020-03-13 05:59:57

Replication via REST service - are there ready-made solutions?

Hello everyone,

there is a task that suggests itself for master-master replication, but I don’t want to use it in its pure form because of questions about its reliability.
We have several services that work with common lookup tables. Each of them can write and read. The idea is as follows - each service works with a local copy of the tables, plus there is a separate REST service for replication. When a record is changed in one of the services, it is sent to the REST service and replicated to other services from there. The REST service keeps the last few versions of each entry, which allows conflicts to be resolved at the application level, not the database.

Actually, the question is, has anyone come across a similar ready-made solution?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vitaly Karasik, 2020-03-13
@vitaly_il1

which begs for "master-master" replication, but I don't want to use it in its pure form because of questions about its reliability.

As far as I understand, you need to look at distributed databases, for example
https://en.wikipedia.org/wiki/Spanner_(database)
https://vitess.io/
https://www.yugabyte.com/

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question