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
3,005
questions
-1
votes
0answers
13 views
Azure SQL Managed Instance replication
I'm working on legacy application migration to the cloud, currently on planning and estimation stage, the question I wasn't able to google is:
Can a Subscriber database be in the same Azure SQL ...
0
votes
0answers
19 views
MySQL replication error 1452
could you help me to figure out the solution for a MySQL replication error?
mysql replication error: (Last_Errno: 1452)
Last_SQL_Error: Error
'Cannot add or update a child row: a foreign key ...
0
votes
0answers
14 views
MySQL / MariaDB - Start multi-source replication with mariabackup (xtrabackup)
Many times I successfully performed procedure described in the https://mariadb.com/kb/en/setting-up-a-replication-slave-with-mariabackup/ - it's fastest and easiest because replica is restored by ...
1
vote
0answers
13 views
CREATE or ALTER when using replication
I am using CREATE OR ALTER in the scripts for all of my views and stored procedures, as they are pushed frequently from a CD pipeline. I am also using replication to push certain tables, views, and ...
0
votes
0answers
7 views
Is it possible to replicate different Galera MAIN-MAIN clusters (MariaDB) with another Galera MAIN-MAIN cluster but as MAIN-SECONDARY asynchronously?
We are a small team of developers and we usually deal with single database access locally or remotely. We are working on a project that needs to have not only replication on the local network (we'll ...
0
votes
0answers
16 views
The Replication Time in Short Time? [closed]
Background info:
Apply CQRS model in relation to SQL server.
Two similar database and its content.
Database 1 is only used for add, update and delete.
Database 2 is only used for read only.
Database 2 ...
0
votes
0answers
30 views
Oracle DB Replication/Data Transfer
I need to replicate an oracle database without updating each other just for backup purposes.
I have a Main DB(MDB) that have jobs to send to be processed data to interface DB(IDB). IDB will be ...
1
vote
0answers
8 views
MySQL replication setup for high load Master
We have simple replication set up with 1 master and 1 slave.
However, setting this up (after restart for instance) is always a difficult task.
The moment between taking my database dump, noting the ...
0
votes
1answer
14 views
MongoDB - count current read/write operations
is it possible to count the current read or write operations on a mongodb replica set? (including all databases not just a single database)
Thank you!
Best regards
0
votes
0answers
19 views
MYSQL Error: 1026: Error writing file 'binlog' (errno: 2 - No such file or directory)
We are using MYSQL 8.0.20 Community Edition on Oracle Linux 7.8 (RHEL). On one server we are running master database and using row based replication to a slave on another server via bin-log. ...
0
votes
0answers
14 views
Create hot standby on top of Barman streaming backup
I set up a Barman server that uses pg_basebackup and pg_receivewal for streaming replication. It is pretty much the same setup as described in the Barman documentation (scenario 1).
Is there a ...
0
votes
0answers
9 views
mongo replica is down
I have A mongo replica with 6 nodes, not sure why but 4 of them went down and two entered to recovery state. each time I tried to start the service of one of the down nodes it fails with error there ...
1
vote
1answer
25 views
What are version vectors?
Folks, I am currently learning about distributed data systems via the book "Designing Data-Intensive Applications".
I think I have a pretty strong understanding about how version numbers in ...
1
vote
1answer
59 views
Transaction Logs: How much log data generated (hourly or daily)?
I am trying to find out the amount of transaction-log data generated by SQL Server 2016 during every hour or every day. By "data generated" I mean how much data (in bytes/KBs/etc) was ...
0
votes
1answer
13 views
Add column to database, used with logical replication generates large WAL files
I have a PostgreSQL 10 master database with a logical replication, but I faced with an issue.
I added one more column (int, without default value) to a big table in master (weight 39gb, over 100 ...
0
votes
2answers
29 views
SQL Replication using Two Availability Group
Is it possible to setup SQL Replication with Two Availability Group Cluster? one is Publisher(or Distributor if not in different server) and the other AG is Subscriber?
2
votes
0answers
40 views
Replication error masked by sp_MSdetect_nonlogged_shutdown returning 'String or binary data would be truncated'
One of our replication jobs is failing on step 3, which runs sp_MSdetect_nonlogged_shutdown, returns a 'String or binary data would be truncated'. Which of course led us down the path of trying to ...
0
votes
1answer
26 views
mysql_upgrade affect replication mariadb from mysql
I have one master (MySQL 5.7.29 ) and slave (MariaDB 10.4.12) I have a problem with events after inserting a dump to MariaDB from MySQL.
MariaDB [mysql]> show events;
ERROR 1545 (HY000): Failed to ...
0
votes
0answers
12 views
Where is SQL Server merge replication snapshot synchronization log location?
I have an issue with SQL Server 15 -> 13 merge replication process. It got stuck locking MSsnapshotdeliveryprogress table. So I have to look into logs to be able to determine what is causing this, ...
0
votes
1answer
30 views
Database syncronization
I am working on a student project and I need some guidance on what solution I can use.
The goal of the project is to create a dummy web page that would send
dummy data to 2 databases(or read from one ...
0
votes
1answer
46 views
How do I get article properties from query in a merge replication
I would like to know if there are any queries to get article properties in a SQL Server merge replication. I'm able to get properties only by GUI. I select a publication properties then I get the page ...
0
votes
0answers
12 views
Derby DB : Replication Error
I am trying to setup replication b/w two Derby databases. Its embedded with an application. Configuration for replication is done as per the documentation here
When the application tries to start ...
0
votes
1answer
18 views
Database replication from local Postgres to live
I have a software whose data from its local Postgres server has to be synced to live database, so that I can query data from that live Postgres server via api. I am new to Postgres. So after a small ...
0
votes
0answers
7 views
MySQL group-replication error
We have MySQL 5.7 cluster with 4 nodes. We get a problem with one node in this cluster often.
Our applications write data to node1 and node1 replicates data to other 3 nodes.
In node1, I keep getting ...
0
votes
1answer
34 views
invalid integer value “CONNECTION” for connection option “port” Previous connection kept
I'm new to postgres and I'm trying to configure table level logical replication(PUBLICATION/SUBSCRIPTION) on postgres-12.
I have updated postgresql.conf file and updated wal_level=replica. Also, then ...
0
votes
0answers
8 views
how long can your replica be offline when using repmgr with Barman?
I'm setting up some postgres database EC2 instances that I'd like to use for load balancing. The application I'm running has some very expensive and very unique queries so CPU usage is a concern. ...
0
votes
0answers
10 views
Manual Binary logging in Amazon's Aurora
How would I enable binary logging in RDS? I get the following error:
Binary logging is disabled for MySQL server [1020418] (mysql_endpoint_capture.c:352)
What parameters do I need to change in ...
3
votes
2answers
32 views
Replicate_Do_DB and Replicate_Wild_Do_Table - Replication does not work
I have been tasked to set replication up on a slave host. The master database is a "data store" where tables are dropped, recreated, and reloaded on a daily basis.
My initial setup of the ...
0
votes
0answers
59 views
ERROR 3911 (HY000) at line 24: Cannot update GTID_PURGED with the Group Replication plugin running
heyy all, we want to move our current mysql 5.6 server to mysql-8 innodb cluster. for this, we are setting up a replication like 5.6 -> temporary 5.7 -> mysql-8 cluster. We already have the ...
0
votes
0answers
24 views
SQL Replication Subscriber with AlwaysON setup
We have 2 AlwaysON cluster and we want that to set up as a SQL Replication server which is the Always-on Cluster 1 is the Publisher and Always-on Cluster 2 is the SUBSCRIBER, my question is it ...
0
votes
0answers
16 views
How to synchronize a local database with an external database continuously without replication
I created a database on our internal network (localDB), it receives data via CSV (LOAD DATA INFILE) coming from our ERP, it is continuously updated
I have an external database (remoteDB) with which ...
0
votes
0answers
45 views
Large number of connections to an SQL server results in read write bottleneck on hard drive?
I have the following problem which I can't find a solution for.
We have a learning School System for more than 10000 students that upload photos and PDF of Homeworks as binary to an SQL server. During ...
2
votes
2answers
17 views
In mysql master-slave Replication which server requests the other?
I want to setup mysql replication between two servers one of them is my localhost and the other is online server.
I have all availability to make any one of them the master.
But according to that my ...
0
votes
0answers
24 views
db choice for activity log
I'm working on a geo-replicated web platform, composed of an ecosystem of microservices.
We need to improve and rework the user activity tracing pipeline and I'm looking for "the best" ...
0
votes
0answers
8 views
Transfer data from RO PostgreSQL (readonly) server to other MySQL server
I've got a PostgreSQL (v10) DB with a 5 tables (3GB+ per table) which get new records on a rate of 15-20/second. Every day records older than 90 days are deleted.
I need to run analytics on the data ...
2
votes
1answer
33 views
How to deal with data repetition? [closed]
I am unsure if this has been asked already. Tried searching but couldn't find one.
I'll explain with a close example (I call it the tags problem). Consider a basic CMS. A post can have many tags and ...
0
votes
0answers
10 views
Replication refuses to use SSL
I have two MySQL 5.7 Servers (5.7.29 and 5.7.31)
I have created a set of SSL certificates and copied them to both the source and replica DB's so they both have the same certificates in place.
On my ...
1
vote
1answer
20 views
Why is it not a good idea to use MariaDB's extra_port for replication?
MariaDB has an extra_port for administrative access that helps in cases the thread pool or main port is locked up.
MariaDB's documentation says it's use case is primarily administrative access and it ...
3
votes
0answers
20 views
Logical Replication/Foreign Data Wrapper Connectivity between Two Aurora Serverless Databases (PostgreSQL 10.7)
I have two Aurora PostgreSQL Serverless databases running in the same region and have PostgreSQL version 10.7. I'm wondering if logical replication is available? The official docs say that it's ...
0
votes
0answers
35 views
Cannot connect after Availability Group automatic failover
We have a SQL Server setup with Availability Groups, in the cluster we have four nodes, two in one datacenter and two in another datacenter.
There are four AGs on these cluster nodes, each primarily ...
2
votes
1answer
17 views
What type of replication do I need to push webdata to offline database for analytics?
I'm new to replication, as I've been mostly an old school ETL type person.
I have a SQL SERVER database that runs a front end web presence. There's alot of data there.
I have been tasked to perform ...
2
votes
2answers
23 views
What is the maximum latency / distance mysql replication can tolerate without having errors or wrong data?
I have two machines in a master - slave replication. I want to know if they are in two seperate places e.g. London, England and Tokyo, Japan are there going to be any latency issues.
What exactly is ...
1
vote
1answer
34 views
MySQL Master - Slave replication stops after 20min with no errors
I'm using MariaDB 10.4 in a standard master slave setup.
Everything works fine for about 20min, I can see changes replicating across but then after about 20min replication just stops.
However, if I ...
0
votes
1answer
13 views
Fault tolerance for Database sharding and Database partitioning
I'm aware that database sharding is splitting up of datasets horizontally into various database instances, whereas database partitioning uses one single instance.
In Database Sharding, what if one of ...
0
votes
0answers
23 views
Clarification on SQL Server database replication / Distribution / Performance
I started reading about the scaling database lately due to my recent engagement, and so far, I find it interesting and have been able to successfully set up transactional database replication with SQL ...
0
votes
0answers
35 views
PITR Restore on Postgresql Windows
I have Postgresql 11 running on Windows server and master/slave replication working perfectly.
I have enable the wal_archiving and also i have enabled automatic backups using pg_dump
I need to ask if ...
1
vote
1answer
28 views
I am looking for a query to determine when the snapshot has been finished applying on the subscriber
Is there any way to determine with a query when the replication has finished applying the snapshot on the subscriber?
I have a transnational pull replication set up for reporting purposes and it also ...
0
votes
0answers
69 views
SQL Server Snapshot replication - Failing to start the Publisher snapshot agent
I am trying to set up a Snapshot replication using an Azure SQL Managed Instance. While trying to see the Snapshot Agent status, I see this error. Failed to connect to Azure Storage '' with OS error: ...
0
votes
2answers
29 views
Help setting up Galera Arbitrator
I am testing a MariaDB Galera Cluster set up with only 2 nodes, I have three servers haproxy, node1 and node2 . I was able to set it up and it worked fine until testing phase.
There are two types of ...
0
votes
1answer
14 views
SQL Sever Transactional Replication on DB with deadlocks and blocking issues
Is it feasible to try and start Transactional Replication on a SQL Server DB with deadlocks and blocking issues. Are there any other options for a close to hot backup?
