3,911 questions
-3
votes
0
answers
24
views
AWS Account Replication [closed]
Have anybody replicated an AWS Account to a new account? I have a requirement where I need to fully replicated resources from one production AWS Account to a new one if someone could help me out would ...
- 1
1
vote
1
answer
85
views
postgresql pglogical replication and Segmentation error on bidirectional replication
I am configuring a bidirectional replication between node1 and node2.
The configuration of node1 as publisher and node2 as subscriber is correct: the data is replicated and no errors occur.
The ...
3
votes
1
answer
42
views
Olake job CDC Replication failing at runtime ( I am using adls gen2 as destination iceberg catalag lakekeeper) [closed]
I have Olake job CDC Replication as described by Olake(https://olake.io/) with following:
mysql source
lakekeeper as catalog of parquet
ADLS gen2 as destination with app registraction steps
Source ...
- 11
0
votes
0
answers
59
views
Where to find logs for Backup Copy jobs in the Veeam database?
I've successfully traced the logs for standard Backup Jobs (Jobs -> Backup) in the Veeam database, but I'm unable to find the equivalent logs for Backup Copy Jobs (Jobs -> Backup Copy). The UI ...
- 223
1
vote
4
answers
132
views
Apply the same code, but in different columns
I already have the code I need. I just need to apply this code in different columns and I'm not being able to do it that. Right now, I'm only able to apply it in one column. That's the code below:
...
- 29
0
votes
0
answers
25
views
How do I replicate Oracle to PostgreSQL in real time with schema evolution support?
I want to replicate Oracle to PostgreSQL in real time with schema evolution support.
Is there is any open source tool available? I am not using Oracle Goldengate. It is too heavy and time consuming to ...
- 21
1
vote
2
answers
80
views
How to read from SASL_SSL cluster and write to PLAINTEXT cluster?
We have source cluster with security protocol SASL_SSL and target cluster without any authorization. Just PLAINTEXT. MirrorMaker2 in kafka conenct mode writes messages about connection problem:
INFO [...
- 21
0
votes
1
answer
67
views
How to know the character set use in mysql column row event
I have written a python program to parse mysql binlog. In the Query Event, there is a Q_CHARSET_CODE which indicate what character set is used for the logged query. This indicated that the logged ...
- 127
0
votes
0
answers
39
views
I cannot download a crate from a remote registry
I need your help with an issue that has left me dumbfounded for days.
I have a setup with 2 artifactory servers:
server 1, which hosts my private cargo registry, a repo of type "local". I ...
- 1
0
votes
0
answers
43
views
Is there a problem having min.insync.replicas < half the RF?
Many examples of Kafka topic configuration have RF = 3, min.insync.replicas = 2.
In the case of a cluster of 5 brokers, if we use RF = 5, should min.insync.replicas = 3? That seems "natural" ...
- 130
0
votes
0
answers
56
views
Distributor name as database name in SQL Server database
I was starting to configure replication on SQL Server database.
I created a distributor with the following command:
exec sp_adddistributiondb @database = N'prod_database',
@...
0
votes
1
answer
58
views
Fire trigger in logical replication table
I'm using PostgreSQL logical replication, and both the origin and destination databases have the same table structure — table A (a int primary key, b int).
I'm trying to create a trigger that ...
- 11
0
votes
0
answers
33
views
How to do a Replication in Apache SOLR?
I'm trying to set up a replication for my Apache SOLR which runs on a linux Server. The Slave is also on a debian12 distribution.
Sadly I havent found any useful guide to set up the replication. I ...
- 1
0
votes
1
answer
105
views
Share Specific Table from One Snowflake Account to Another Snowflake Account in Different Regions
I'm trying to share a single table (MY_TABLE) from the MY_DATABASE.MY_SCHEMA schema in a Snowflake source account (SOURCE_ACCOUNT) to a target account (TARGET_ACCOUNT) in the same organization but ...
- 399
2
votes
1
answer
92
views
S3 Cross-Region Replication Not Working Despite Valid IAM Role and Bucket Policies [closed]
I'm attempting to configure cross-region replication between two S3 buckets in different AWS accounts and regions, but replication is not occurring. There are no relevant errors in CloudTrail or ...
- 146
1
vote
0
answers
56
views
How to perform Geo-Replication in Apache Pulsar without creating duplicate messages?
I’m designing a multi-datacenter architecture using Apache Pulsar with geo-replication enabled.
Architecture Overview:
Apache Pulsar version: 4.0.2
Helm Chart version: pulsar-3.9.0
BookKeeper: 5 ...
0
votes
0
answers
53
views
How can I replicate build artifact via a snapshot-style file system under Windows and Linux for build testing
I am building a large software art project including a number of data files and build artifacts locally. The size of the entire generated set is around 20 gigabytes. Contained in the build results are ...
- 720
0
votes
0
answers
182
views
Postgres 16/Patroni START_REPLICATION SLOT Hangs
I have a problem on a PG16 cluster (under Patroni) with two tasks that seem to be blocked given the start time of the transaction.
I don't know if I can stop the processes without crashing the ...
- 453
0
votes
0
answers
259
views
Snowflake Share & Replication Issue. Replicating a single schema object
I work in an organization with multiple divisions, perhaps each one is in a different region and their Snowflake account is set up in a different region. It is not an uncommon need for my division to ...
0
votes
0
answers
207
views
Redis Sentinel Failover Issue with ACL Authentication in Redis Replication
I have encountered a problem when using ACL authentication in a Redis Replication + Sentinel configuration.
First, to exclude any questions about permissions, I will use a user with full access to all ...
1
vote
0
answers
116
views
mongodb 8.0.4 repl set (3 members, PSA) repeatedly logs AuthenticationAbandoned
We are running a self-hosted mongodb deployment as a three member replica set (PSA), recently upgraded from mongodb 6.0.3 to 8.0.4. We are running in a containerized environment. Every so often, I see ...
- 421
0
votes
0
answers
21
views
HBase consistency model(within the same cluster)
Background :
HBase reads seem to fall under the 'strong consistency' model, as : All reads are served from the master where the data has already been committed. As a result, the clients seem to always ...
- 1,331
1
vote
1
answer
66
views
How to replicate SQL queries generated by the ORM nHibernate?
In a C# application, using nHibernate & fluent nHibernate, we're looking to capture certain INSERT, UPDATE, DELETE queries performed on a Sqlite database in order to replicate them.
We'd like to ...
- 11
0
votes
1
answer
127
views
AWS step functions and replication across regions
I want to have AWS step functions created in two different regions.
Let's say us-east-1 and eu-central-1.
When I invoke the step functions they run in their own region and will have their execution ...
- 2,675
1
vote
1
answer
115
views
pg13 streaming replication empty pg_replication_slot on SLAVE replica
pg13 streaming replication returns empty pg_replication_slot on SLAVE replica.
select * from pg_replication_slots;
returns nothing on SLAVE replica
when do
select status,slot_name, ...
- 13
0
votes
1
answer
38
views
Oracle replication with limited range
Due to performance reasons I want to have a portion of my data to be available on a second system (Reporting).
I expect the data to be distributed like: (abstract)
Production (today)
todays data &...
1
vote
1
answer
254
views
Unreal Engine Replication of TArrays of Object type
My Goal is to replicate a TArray<UHealthComponent*> in a ListenServer configuration for 2 players
For more context the TArray is inside of an ActorComponent named ShipStats attached to the ...
- 61
0
votes
1
answer
113
views
Database snapshot replication Invalid object name, Wipe of all data
We have created new publication and then subscription replicate data from D to E database.
Publication is set to run every 10 seconds
Subscription is set to run continuously.
It was working fine and ...
- 1,340
1
vote
0
answers
88
views
Postgresql trigger on logical replication doesnt see data within transaction
I have an issue with catching all the data with AFTER INSERT trigger on my PostgreSQL 16 logical replication.
I simplified my tables into
create table customer (id serial, email text);
create table ...
- 422
0
votes
1
answer
292
views
Postgres logical replication, need to get only the changed column values, not all column values, on update event row
I am writing a client implementation of the Postgres logical replication protocol, but I encountered an unexpected behavior, in the DML UPDATE event
I always get all the values of the table columns, ...
- 101
0
votes
1
answer
345
views
Storage replication change from LRS to ZRS
I was considering changing the replication from LRS to ZRS and i've found the description, which says no downtime is needed: "During a conversion, you can access data in your storage account with ...
- 1,505
0
votes
0
answers
39
views
Do Model.find() on replicate MongoDB
Hi everyone i have a problem and i need to solve for my project of university. One of my teachers said i needed a replicate database but when i make a simple request Model.find() return a error ...
- 19
0
votes
0
answers
82
views
When using PostgreSQL cascading replication - How to promote standby to primary
I have 3 servers running PostgreSQL 9.6. I have cascading streaming replication working.
primary -> standby1 -> standby2
Any DB changes in primary reach standby2. So all good to this point.
...
- 161
1
vote
1
answer
87
views
Client can’t call RPC Server even with a valid NetOwner
This is the first Actor I built for Multiplayer with replication so if you think I should have used another technique tell me.
I'm running UE5.4 with two player and as net connection I use listen ...
- 43
1
vote
1
answer
185
views
DDL Replication Issue with SymmetricDS: New fields do not replicate inserted data
I'm using SymmetricDS to replicate a table structure (DDL), and I ran the following sequence of commands to sync the triggers and send the table schema:
bin\symadmin.bat -e rada-000 --node=001 sync-...
- 13
0
votes
0
answers
331
views
PostgreSQL Logical Replication Slot size is getting bigger without new records beeing generated
I have a postgresql source database where I have enabled logical replication to replicate data in another postgresql destination database. Publication contains only one table which is arround 3MBs of ...
- 1,517
0
votes
1
answer
121
views
How to handle DC replication delay when enabling users and setting properties?
I am working on an application where I need to perform some operations on users fetched from a Domain Controller (DC). The operations involve enabling the users and then setting properties for them. ...
- 3
1
vote
0
answers
346
views
The merge process was unable to deliver the snapshot to the Subscriber
I am setting up replication on SQL Server and I get this error, if I open the replication monitor there is this error, if I open the agent logs, there is also this error. What else can I check?
No ...
- 35
0
votes
1
answer
240
views
Push replication server error: The process could not connect to Subscriber
I am trying to set up merge replication with push transactions. I have SQL Server on google server and my local PC, I installed the radmin vpn program, I can connect through SQL Server Management ...
- 35
-2
votes
1
answer
142
views
Schemabind a SQL view with a linked server
I have to index a view to query much faster, but this view has underlying view with a linked server that I cannot schema bind. Which I can't because it is in a linked server and don't have direct ...
0
votes
0
answers
39
views
Flip between standalone and replicaset
I've been running a 3 member replicaset for 8 months, but due to failures at a host, 2 members failed.
I got my surviving member to restart in standalone mode.
Question: now that the host failures are ...
- 159
0
votes
0
answers
58
views
SQL Server Merge Replication across internet
I have been trying to configure the Merge replication in our small company for several people.
My conditions:
Publisher is on Google cloud behind a firewall
Publisher is accessible only via IP ...
- 169
0
votes
1
answer
878
views
Postgres logical replication stuck at LSN value. I want to advance past it with pg_replication_origin_advance
Postgres 13 on AWS RDS
Replication slot is growing in size
CPU and I/O are low on both master and slave
The subscriber seems to be stuck at 33533/7D2841D8 even though the received LSN keeps advancing. ...
- 6,469
0
votes
1
answer
1k
views
How to reduce replication lag for read replica in Google Cloud SQL for PostgreSQL?
I have a Google Cloud SQL PostgreSQL instance with 1 read replica. The replication lag is usually 100~200ms. I have the same setup with 2 VM instances that are also on Google Cloud and the lag is ...
- 101
0
votes
0
answers
127
views
How to enable read write operations on a logical replica on RDS?
I have a blue green deployment on AWS RDS Postgresql which is basically using logical replication of Postgresql. Whenever an insert takes place on table A on green env I would like to be inserted on ...
0
votes
0
answers
51
views
Not able to select database for database queries in django
I'm trying to direct my read queries to my read replica in a production setup. Django allows defining multiple databases, so I added two databases like:
DATABASES = {
"default": {
...
- 9,620
0
votes
1
answer
173
views
InfluxDB replication to cloud in Docker
Issue: local to cloud replication works only manually. Trying to automate.
--
Environments:
Local in Docker (via docker-compose)
Cloud on influxdata.com
Following this tutorial: https://docs....
0
votes
1
answer
343
views
Replication vs Sharding (for read scalability vs write scalability)
Can someone explain why they say db replication is more ideal for read scalability while sharding is more ideal for write scalability?
From my current understanding:
replication allows read traffic ...
1
vote
1
answer
20
views
Sharing Database tables data across 2 micro-services
We have couple of microservices, first microservice A has some data which is like reference data, we plan to share these data with other microservices, plan is to have copies of the data in ...
1
vote
0
answers
256
views
What is the meaning of the namespace in Harbor replication rule
What is the meaning of the namespace during the creation of Harbor replication rule.
I have seen this: (https://goharbor.io/docs/2.0.0/administration/configuring-replication/create-replication-rules/),...
- 49