2
votes
Accepted
How to replicate between On-Premises and Azure in Mongodb
Basically, you add those three nodes as secondary to your current on-premise replica set. (rs.add(FQDN))
Not necessary to be hidden, but set priority lower than nodes at the premises, to prevent ...
- 5,198
1
vote
Logical Replication to different schema name
this feature is scheduled on PostgreSQL 15
Logical replication
support for publishing all tables of a schema added (commit 5a283246)
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=...
1
vote
SQL Replication Automatically Add table to Publisher
I know this is an old post, but here is a script I just wrote that handles the whole thing.
It adds missing articles to all publications existing on the source DB.
Adjust as needed for your ...
- 346
1
vote
What max_allowed_packet is big enough, and why do I need to change it?
If you see binlog on the master, binlog positions are wrong. Sometimes error is not what it seems to be. Do not change max packet value. We need to do a little work through here. So, my suggestion, ...
- 131
1
vote
What can cause TRUNCATE TABLE to take a really long time?
First of all you should use latest version of MySQL or MariaDB as in these version this bug has been fixed.
This bug can come up when you DROP or TRUNCATE a table and you have a large buffer pool, ...
- 131
Only top scored, non community-wiki answers of a minimum length are eligible