New answers tagged

-1 votes

MySql (local-Online) replication

1.cat network dns 2.ping ping ip/hostname must ok 3.need check error log
user avatar
2 votes
Accepted

Azure Database Performance Throttling - Use Replication or?

Depending on which flavour of Azure SQL is being used you may be able to implement Resource Governor or equivalent. This allows you to allocate a portion of the hardware to each workload. The large ...
user avatar
3 votes
Accepted

MySQL replication setup based on an LVM snapshot – am I forgetting anything?

FLUSH TABLES WITH READ LOCK is sufficient. This locks the tables, preventing new writes, and it also makes sure any other writes to tables are flushed to the disk volume for MyISAM tables. For InnoDB ...
user avatar
  • 9,248
0 votes
Accepted

Restore SQL Server replication subscriber

I've mostly only worked with Transactional Replication so I'm not an expert on Merge Replication, but maybe it's just a matter of taking and restoring a backup of the Subscriber database? Here's the ...
user avatar
  • 24.1k
1 vote

SQL Server replication msRepl_commands msRepls_transactions tables growing

I cannot guarantee that these suggestions will solve your problem. These are common issues that I am aware of why data is not deleted from the two tables you mentioned even though the data has been ...
user avatar
  • 12.2k
1 vote
Accepted

Upgrading Logical Replica of PostgreSQL

So I figured out the problem. pg_upgrade will not migrate the pg_replication_origin data, hence I had to re-create the origins using pg_replication_origin_create and the replication was replicating ...
user avatar

Top 50 recent answers are included