Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

New answers tagged

1 vote
Accepted

How can I monitor query performance on my Azure read-replica database?

Query Store is not available on read replicas. One way to monitor query performance is using Dynamic Management Views (DMVs). You can rely sys.[dm_db_wait_stats] to monitor waits see script I shared ...
Alberto Morillo's user avatar
0 votes

Do the vCores in my Read-Replica process the synchronization activity?

Actually, it appears that my initial understanding was correct. Here are the side by side (top / bottom) comparisons of the activity profile for the primary and replica databases. Clearly, the replica ...
Yossi Geretz's user avatar
0 votes

Can I create a Geo Replica of a Named Replica?

I was unable to find a way to do this. Certainly it does not appear to be supported through the Azure management console. I don't know that it is impossible to do through programmatic interface so I'm ...
Yossi Geretz's user avatar
1 vote
Accepted

Why can't I create more than 1 geo replica for my primary database?

You probably have already enable named read scale out or zone redundancy for the database and is counting that as part of the replication limit. With Hyperscale, named replicas or high availability ...
Alberto Morillo's user avatar
0 votes

Slave_IO_Running: Connecting in Master-Slave Replication

if all other settings and configurations and commands betwen the machines and their IP addresses are ok then try sudo ufw allow 3306 the port 3306 could be blocked by the ubuntu 20 firewall by default ...
lisawebcoder's user avatar
0 votes

Replicate Data from 2008R2 to 2012 for Reporting Purposes

Should I opt snapshot replication or transaction replication or log shipping? First of all exclude log shipping from your solution because you can either applying changes from primary or perform ...
SergeyA's user avatar
  • 690
0 votes
Accepted

Postgres Replication Stuck/Reversing?

I had a problem that the wal_receiver_timeout was too low. I set it to 0 on the slaves.
mj_'s user avatar
  • 307
0 votes
Accepted

Postgres logical replication and table rename

You should rename the table on the publisher first, then add the renamed table to the publication. Then run ALTER SUBSCRIPTION ... REFRESH PUBLICATION WITH (copy_data = off) on the subscriber and wait ...
Laurenz Albe's user avatar
  • 52.7k
0 votes
Accepted

How to find the records that are waiting to be replicated?

this query on the distribution database has helped me. SELECT t.article_id,s.agent_id, 'UndelivCmdsInDistDB'=SUM(CASE WHEN xact_seqno > h.maxseq THEN 1 ELSE 0 END), 'DelivCmdsInDistDB'...
Marcello Miorelli's user avatar
0 votes
Accepted

RDBMS vs NoSQL decision making

RDBMS are good for storing your core data. Keep using them like we were using them 20-30 years ago. Nearly nothing has changed. NoSQL are good for storing logs, JSON, XML. 30-20 years ago we were ...
Francesco Mantovani's user avatar
0 votes

replicating one master to multiple slaves and from multiple slaves to one master

If all you need is to send "test completed" to the master, then allow the test program to access the Master to do that write. Then think about whether to replicate that info (eg by limiting ...
Rick James's user avatar
  • 78.3k
1 vote

More replication slots created/requested than max_sync_workers_per_subscription

In short: there is a known bug with an excessive number of replication slots due to a race condition between the end of one tableworker process (synchronizing one table) and the start of the next one. ...
Melkij's user avatar
  • 3,189
0 votes

replicating one master to multiple slaves and from multiple slaves to one master

I dont't knows about Mysql but it quite easy with mariadb version 10 and up which support multi master. make all satellite replicate the master databases. on master server.cnf set : log_slave_updates ...
dominix's user avatar
  • 123
0 votes

Why is my 4-node replicaset setup is not working?

2 out of 4 is not the majority, thus a PRIMARY cannot be elected. Having more than one ARBITER is not recommended and in newer releases, it is even not permitted by default, see Concerns with Multiple ...
Wernfried Domscheit's user avatar
0 votes
Accepted

Will a replicated event cause issues?

DELETE FROM session WHERE expiration < (UNIX_TIMESTAMP() - 7200) AND @@server_id = 1234567; Each MySQL instance in the replica-set must have a unique server_id (read https://dev.mysql.com/doc/...
Bill Karwin's user avatar
0 votes
Accepted

How does this user log in to the database server, when its login is deactivated on the database server?

My problem was that I was creating a Server Login and then I was creating a Database User, but I was not connecting the User to the Login. As such, the User was in fact a contained user, even though ...
Yossi Geretz's user avatar

Top 50 recent answers are included