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
2,895
questions
0
votes
0answers
13 views
MySQL database cluster vs. replication setup for large crawler indexes
What is the most efficient way to set up a MySQL cluster or replication in an application that has a crawler/indexing engine with thousands of read/writes and then a separate front-end for public ...
0
votes
1answer
11 views
MySql Replication Failure on primary secondary
We have experienced replication failure between primary - secondary databases.
I have tried various scenarios to get replication to work again, which included deleting secondary database and ...
0
votes
2answers
23 views
MySql replication Failure
I have a mysql (Ver 14.14 Distrib 5.7.29, for Linux (x86_64)) primary -> secondary replication setup. Initially the replication was working successfully until we had to restart the primary database. ...
1
vote
1answer
22 views
Pglogical - multiple database tables to single table
I have 4 databases, each database is having 2 tables. The table structure on all the databases are same. So i want to replicate these two tables from all 4 databases to a single database.
So my ...
0
votes
1answer
19 views
Transactional Data Replication, SQL Server version compatibility
I've been following the Microsoft Tutorial: Configure replication between two fully connected servers (transactional). Everything has gone "smooth", however the 'New Subscription Wizard' is stopping ...
1
vote
1answer
34 views
SQL Server strategy for high availability with batch drop/create updates [closed]
Have a production SQL Server 2017 db that is populated nightly using sqoop from another source beyond our control. Would like to fully sync certain tables without bringing down the app (right now we ...
1
vote
1answer
32 views
Could once `max_standby_archive_delay` and `max_standby_streaming_delay` with value -1 can cause replication stop on heavy loads?
In my replication servers on a postgresql master-slave replication scheme on aws RDS I get the following error:
SQLSTATE[40001]: Serialization failure: 7 ERROR: canceling statement due to conflict ...
0
votes
2answers
18 views
MySql replication failed with error 1236 data position > file size with relay-bin file not increasing
My slave machine reset and now on SLAVE SHOW STATUS\G I have the error:
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start ...
0
votes
0answers
14 views
MySQL replica is lagging without resource saturation
I am running MySQL 5.6.41 on AWS RDS. I have one multi-AZ master and one multi-AZ read replica. It is a vanilla configuration MySQL configuration, so the binlog is in MIXED format and the replication ...
0
votes
0answers
18 views
Master slave replication - DATETIME columns not replicating the time
I have master which is mariadb 5.5 and slave mariadb 10.3, the replication works fine except for the DATETIME columns which are syncing the date part but not the time.
On master: LastLogin 2020-01-15 ...
0
votes
0answers
19 views
Renaming multiple databases on a MySQL slave
I have 4 mysql databases that I'm replicating from a master to a slave. In the past, I have renamed one of them because the slave is also a dev server where it has a dev version of that schema with ...
0
votes
1answer
25 views
Does this plan work as a Failover strategy-SQL Server 2016 Standard Edition
We have two SQL Server 2016 Standard edition (standard edition due to budget issues) configured one as primary sql server and another one as fail-over server.
I have implemented Transactional ...
1
vote
1answer
78 views
Replication Hung - Seconds_Behind_Master Increasing
One of my slave is no longer replicating. The seconds_behind_master continue to increase, Exec_Master_Log_Pos does not increase, and Relay_Log_Space does increase. Slave_IO_Running and ...
0
votes
1answer
21 views
Can I change the wal_level from logical to replica? If so are any impact on the replication process?
Is there a chance to change the wal_level from logical to replica without any impact. I know this involves a restart of services but is this possible?
For example if there is a already a logical ...
0
votes
1answer
73 views
PostgreSQL 9.6 pg_rewind - takes a long time to replicate
I use Streaming Replication,and Replication works normally.
Two servers are HA and PostgreSQL DB is replicated.
The data in the DB is about 40G.
When a failover occurs, the slave is successfully ...
0
votes
0answers
21 views
What happens to the transactional replication if azure sql Vm(publisher and distributor) is stopped and restarted from portal?
I am a newbie...I have azure sql vm and sql managed instance. I have setup transactional replication between them. Now if I stop the vm from the portal will the replication still continue after ...
0
votes
1answer
46 views
SQL Server AlwaysOn AG Secondary Replica is not joined [closed]
I have created an Availablity Group on SQL Server 2019. I selected 2 SQL server for Replicas but the Secondary replica has an error:
This secondary database is not joined to the availability group....
2
votes
1answer
112 views
Scheduled snapshots of views (without using materialized views or Oracle Golden Gate)?
I have 40 views in an Oracle 18c GIS database that are used in a map in a workorder management system (WMS).
The views are served up to the WMS map via a web service.
There are an average of 10,...
0
votes
1answer
25 views
MySQL replication and ProxySQL
I just came across ProxySQL. I have one simple question, if I were to use ProxySQL, do I still need to set up Replication(master-slave) first for MySQL server? Because there is hostgroup(0,1) in ...
0
votes
1answer
16 views
PostgreSQL stop streamig replication
I've setup streaming replication between a master and a backup server. Now I want to stop the replication but I've noticed that every time I stop postgres in the backup server some old WALs files stay ...
0
votes
0answers
23 views
MySQL oomkiller crashes after backup [duplicate]
I am using percona and the backups run successfully. However after the backup is done and sometimes during the backup MySQL is crashing and I am not certain where to start.
Running show engine ...
0
votes
1answer
30 views
WAL Archiving and pg_basebackup
For backing up our postgres database, we're considering 2 separate options:
1- Logical backup with pg_dump
2- pg_basebackup with consistent WAL Archiving.
So I have two questions:
1- How often ...
0
votes
1answer
30 views
How to resynchronize replica in Postgresql
I have a server with Centos6 and Postgresql 9.2, I have set up a replica in postgresql to another server of the same characteristics, today in the morning I have an error in the archiver process on ...
0
votes
0answers
59 views
MSSQL - Can not start snapshot agent
I'm trying to setup a replication, but the snapshot agent will not start.
It tells me
Error messages:
Message: Data source name not found and no default driver specified
Stack: at ...
0
votes
0answers
57 views
MSSQL - Setting up simple Replication fails
Heads up: I'm a rookie when it comes to SQL Administration.
Im seting up a simple MSSQL Replication running server '19 (developer edition).
The server and agent services run as local admin on the ...
0
votes
0answers
13 views
How to setup MongoDB replication using openssl keyfile
I am having 3 standalone Mongo servers. All the three had setup using keyFile
Security:
keyFile: /var/lib/mongo/mongodb.key
Now I tried to add these servers into replication set. So I had ...
2
votes
0answers
80 views
SQL Server Replication Administrative Password not working
I have been struggling for the past one week to setup the replication in our environment and has been stuck on Administrative Password issue when adding Distributor on Publisher Server.
Important ...
0
votes
0answers
46 views
Help with set up replication distribution database in Always On availability group
After following official microsoft guide and sample walkthrough:
https://docs.microsoft.com/en-us/sql/relational-databases/replication/configure-distribution-availability-group?view=sql-server-2017
...
0
votes
0answers
9 views
Merge Replication not deleting unmatched filter rows from Subscriber Database
I have applied filters on articles in SQL Merge Replication and syncing the data using MergeSynchronizationAgent via Web Synchronization. The data is syncing as per the applied filters from publisher ...
0
votes
0answers
13 views
Creating subscriber for replication without initialization?
Just wondering - I am sitting here for past 30 minutes waiting for Subscriber to finish initialization for Merge Replication.
Could I skip this step somehow? and skip snapshot creation?
I have:
...
0
votes
0answers
28 views
Mongo DB : Attempting to initiate a replica set with name rs1, but command line reports rs1; rejecting
MongoDB Enterprise > rep_cfg = { _id : "rs1", members : [ {_id:0, host:"Server1:27007", priority:2}, {_id:1, host:"Server2:27007", priority:1}, {_id:2, host:"Server3:...
6
votes
3answers
793 views
Keeping data in old Database (SQL 2008) identical to new Database (SQL 2016)?
I am moving database to new server.
New server has SQL Server 2016 running, current server has SQL Server 2008.
I need to have backup/fallback plan in place for few weeks (in case something goes ...
1
vote
1answer
23 views
What are drawbacks of setting REPLICA IDENTITY FULL in PostgreSQL table
I want to use the wal2json extension to capture the changes in the PostgreSQL database.
I need to find the diff between old and new rows.
Having searched the Internet for an answer, I realized that ...
0
votes
0answers
16 views
Data compression at distribution level in SQL Server replication
I have SQL Server transactional replication setup.
For one of the server I am facing slowness due to limited network bandwidth. Is there any way to compress data at distribution level only.
1
vote
2answers
39 views
For AlwaysOn AGs, can a secondary replica cause contention on the primary when the resources of the secondary are maxed out?
Is it possible and in what ways can the secondary replica cause contention against the primary replica when the secondary replica's resources are maxed out (e.g. does the primary "lock" up while ...
1
vote
1answer
28 views
Find all tables in a snapshot replication that have primary keys
I've been tasked with moving all tables in a single snapshot replication that have primary keys to the transaction replication.
I've tried to break it down into two steps, finding all tables in a ...
1
vote
1answer
69 views
Is there a maximum IOPS for MySQL asynchronous replication on the slave server?
I have been struggling with this issue for a while now. I have a simple Master-Slave setup with MySQL 8.0.15 installed on both systems. In day-to-day operations the slave keeps up the Master with no ...
7
votes
1answer
242 views
Is there a way to determine what kind of data is sitting in the Redo Queue for an AlwaysOn AG Secondary Replica?
Do any of the DMVs or is there another way to expose what kind of data is in the Redo Queue that's in process of being synced up to a secondary replica? (E.g. is it table data and which table, or is ...
2
votes
1answer
141 views
What's the cause for an AlwaysOn AG Secondary Replica to have a high Redo Queue Size and Estimated Recovery Time with a good Redo Rate?
SQL14 is the Primary server, SQL16 is the Secondary Replica, and they're setup using synchronous commit availability mode:
As of yesterday it appeared that data stopped synchronizing from the primary ...
0
votes
0answers
36 views
Transactional Replication with 2 subscribers
I have an existing subscriber and want to setup another subscriber but on different machine.So 2 subscribers, 1 publisher
I want to initiate it from a backup rather than snapshot but when i try set ...
0
votes
1answer
36 views
Can a subscriber be a publisher at same time
I want to setup a topology for replication.
The scenario is such that a subscriber is subscribed to transaction replication based publisher (distributor running on publisher).
I then want this ...
0
votes
0answers
18 views
what is the difference between replication options proc exec and definition only?
I understand proc exec option as for example when you run a procedure which inserts 1000 records into table, those insert afterwards will be replicated to the subscriber. When it comes to definition ...
0
votes
0answers
21 views
Is subscription database considered as read-only?
I am not sure about that because while users implement SELECT from subscription database, publisher replicates data to the subscription server meaning that INSERT and UPDATE also take place (which are ...
0
votes
0answers
26 views
Mongodb doesn't respond
We have a sharded cluster with 3 shards. The version is: 3.6.13. The users of the prod. database (1,8 TB sized) complain about an issue.
System works normally but after sometime it stucks and doesn't ...
0
votes
3answers
46 views
When does PostgreSQL move a WAL file to archive?
I'm a complete newbie with PostgreSQL - please forgive my gaffs - and have inherited a service using a master-slave cluster at the backend.
Currently on the slave, the disk is filling up with WAL ...
1
vote
0answers
18 views
SQL Replication sysarticles Status 57
I am looking at the data kept in the various SQL Replication tables. I am trying to understand what information is available and what it means.
In this example I have push replication on the ...
1
vote
1answer
27 views
Mongodb automatic Replica Set creation with JS driver
The MongoDB docs state that one can use the mongo client console to initialize replica sets by running rs.initiate([config]). However, I don't want to have to manually use the command line for this. ...
1
vote
1answer
14 views
How to make UUID() function, statement-based replication safe?
I'm trying the copy and generating UUID()s on the fly for exiting data when executing A insert from select.
How can I make the UUID() function statement-based replication safe?
Can I somehow use the ...
0
votes
1answer
33 views
Intentionally slow down importing of (Percona) MySQL 5.7 dump
I need to move a very large MySQL table (250M rows, 120 columns. 120GB of data, 310GB of index) from one database instance to another (on AWS). For reasons beyond the scope of this question, this is ...
0
votes
1answer
325 views
Replication problem in SQL Server 2019
I have installed SQL Server 2019 RC1 and cannot create a snapshot. I keep getting the same message when I run the snapshot agent:
2019-10-30 12:32:41.59 Microsoft (R) SQL Server Snapshot Agent
2019-...
