python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - database-replication

Why are read-only nodes called read-only in the case of data store replication?

I was going through the article, https://learn.microsoft.com/en-us/azure/architecture/patterns/cqrs which says, "If separate read and write databases are used, they must be kept in sync". On...
test-img

Arvind Kumar Avinash

serverless

cqrs

database-replication

sharding

transactional-replication

Votes: 0

Answers: 1

Latest Answer

All of these have "it depends"-like answers... Yes, usually, although some implementations might choose to (try to) update read models transactionally with the update. With multiple nodes ...
test-img

sellotape

Deletion of data from replica db mysql

I was thinking of deleting millions of rows in a production database, but due to fear of downtime, I wanted to know how much time this bulk delete operation gonna take. That's why I thought why not gi...
test-img

Arif

mysql

database-replication

Votes: 0

Answers: 1

Latest Answer

Yes. they will come back. The best way to delete data is using a primary key from the prod db and use batch size. The <> will be a batch size of say 1000 or 5000 or so. where pk in (<<list...
test-img

user3327034

AWS DMS for MySQL Aurora

I am trying to replicate MySQL Aurora database to another MySQL Aurora. Always its creating the database with the same name as source. Is there any way to specify the target DB name? Mean, I want to r...
test-img

user18621231

amazon-web-services

database-replication

aws-dms

dms

Votes: 0

Answers: 1

Latest Answer

You can specify a table mapping rule for your DMS replication task as follows: { "rules": [ { "rule-type": "selection", "rule-id...
test-img

Mr Hash

SymmetricDS replication configuration for different schemas PostgreSQL

I want to replicate other schemas rather than the public schema. I have configured the sym_trigger table for the different schema but it doesn't work cause there were no sym_* tables in that particula...
test-img

Maly Mohsem Ahmed

postgresql

schema

database-replication

symmetricds

Votes: 0

Answers: 1

Latest Answer

The SymmetricDS tables will reside in the schema that is the default schema when you log in. If you want to access non-SymmetricDS tables in different schemas, you need to specify the source_schema_na...
test-img

Evan

Posts

Questions

Blogs

Jobs