New answers tagged

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 ...
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
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 ...
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