New answers tagged replication
0
votes
message 'The Distributor has not been installed correctly'
First you make sure you connect to your distributor server with [server\instance]
from you publisher server.
Also you need to set up all the replication accounts and make sure they have the right ...
3
votes
Accepted
PostgreSQL: does the WAL group commit affect synchronous replication performance?
commit_delay should have no impact on synchronous replication. No matter how it is set, PostgreSQL waits until the WAL is flushed locally (which may take longer with commit_delay set to a non-zero ...
- 35.3k
1
vote
Accepted
MariaDB Multi level replication (replicate from slave)
Both of these are needed:
log_bin
log_slave_updates
Be aware that if the Primary in the second DC goes down, the Replicas in the same DC will not be receiving updates. A partial workaround is to ...
- 70.5k
0
votes
High Load MariaDB Cluster (Galera Multi Master Replication) - Same hardware needed for Slaves?
You have Galera active, but are using it as a "single-Primary" with "multiple Replicas", correct?
All writes occur on all servers. This is a fact of any replication topology. ...
- 70.5k
0
votes
High Load MariaDB Cluster (Galera Multi Master Replication) - Same hardware needed for Slaves?
I want to add Slaves to get "realtime" Backups of the Cluster
Your use case is still unclear. If you want the standby nodes to accept the application workload if the main cluster is ...
- 22.4k
0
votes
Speedup DROP huge MySQL replicated table
This article aptly explains why there's performance impact or slow mysql drop table and walks through the possible options to improve the table drop speed.
- 1,894
0
votes
postgres 11.3 checksum validation post migration
you can't achieve zero downtime migration with pg_dump. writes that happen after the dump begins and before the restore completes and you cut-over to the new database will be lost.
What you want is ...
- 2,608
0
votes
Add an arbiter to mongodb ReplicaSet failed
Had the same problem on existing cluster with mongo 5.0.12. I intentionally installed mongo 6.0 on arbiter to upgrade all nodes to 6.0. There was no errors, except for
"msg":"Failed to ...
- 123
0
votes
Accepted
EDB Replication Server, Sequences not updating
This is working as designed. In a multi-master replication setting sequences can be (and normally are) updated independently on each write node. To avoid conflicts consider using multimaster-ready ...
- 22.4k
2
votes
Can oplog be put in a different disk partition?
Yes, add storage.directoryPerDB: true to your configuration:
storage:
dbPath: /var/lib/mongo
directoryPerDB: true
Then you can put a symbolic link at /var/lib/mongo/local pointing to your disk
- 2,522
0
votes
Syncing data between onprem and Azure SQL
Keep in Mind that Azure Data Sync Does not accept computed columns in the tables involved in the data sync!
0
votes
in PostgreSQL REPMGR Master-Slave environment is it necessary to have same H/W config for HOT STANDBY setup?
Unfortunately yes, you need the stand by to be pretty much the same or better hardware than the master. I too was hoping that I could use a lesser stand-by just to track the activity but it turns out ...
- 345
0
votes
in PostgreSQL REPMGR Master-Slave environment is it necessary to have same H/W config for HOT STANDBY setup?
There are only a few settings that must not be lower on the standby than on the primary:
max_connections
max_worker_processes
max_wal_senders
max_prepared_transactions
max_locks_per_transaction
...
- 35.3k
1
vote
Accepted
Replication from a secondary in a high availability group
Is this possible to use the Secondary only as the Publisher, with no changes on the Primary?
No, in fact you can't use the Secondary as a Replication Publisher at all, even if you setup the Primary ...
- 26.6k
1
vote
Server 'repl_distributor' is not configured for DATA ACCESS
try to use this to check first
SELECT
name,
is_data_access_enabled
FROM sys.servers;
then if value is 0 run:
EXEC sp_serveroption
@server = 'repl_distributor',
@optname = 'DATA ...
1
vote
Sql Server : How to query list of subscriptions and Articles (for a given publication) from Publisher
Regarding listing the subscribers of a publication:
I had to modify the query provided by Kin Shah as sometimes I have 2 subscriptions to the same subscriber server and that query was not catching ...
0
votes
How do we switchover a slave to another master instead of promoting the slave to be the master?
What version of MySQL?
Do you have GTIDs turned on?
The 10 Replicas on the inactive Master (during the upgrade) will not receive replication. And, without GTIDs, it is clumsy to get them sync'd up ...
- 70.5k
0
votes
Sync Schema changes automatically with Logical Replication Postgresql
As you saw, logical replication does not replicate DDL. That's the first point of the documentation (see https://www.postgresql.org/docs/15/logical-replication-restrictions.html)
What I would do is:
...
- 1,385
0
votes
Accepted
Is it possible to have 2 arbiter on a replica set on my setup?
I deviated from my original approach and I tried to download the tgz and not the normal installer for mongodb as per suggestion of @Wernfried which contains the binary files.
From there, the method ...
- 59
0
votes
How to speed up SHOW BINARY LOGS
Aurora gives you limited control over configuration and operations.
If you can't change the max_binlog_size in your parameter group, then I think your options are limited to:
Shorten ...
- 10.4k
0
votes
How to speed up SHOW BINARY LOGS
You have about 120GB across 945 binlogs. Let's change that to 120GB across about 95 binlogs. (I and assuming that the sluggishness is due to the number of files, not the size of the files.)
Change ...
- 70.5k
0
votes
Is it possible to have 2 arbiter on a replica set on my setup?
Yes, you can do that. However, because arbiters don't have any DB data, there is no reason to do that. Just upgrade your arbiters to 5.0, then upgrade your secondaries to 5.0, when those secondaries ...
- 5,323
Top 50 recent answers are included