New answers tagged replication
0
votes
High Availability postgres db cluster with Patroni and Etcd
No.
Patroni will automatically perform pg_basebackup.
see the answer to 3.
If you have a single etcd, you have a single point of failure. No good. You need to setup an etcd cluster on three nodes ...
- 47.9k
0
votes
Should I write to MySQL slave (replica) for reporting?
Replication in MySQL 8:
Source to Replica Replication:
The source is the primary, and there are one or more replicas, which
are secondaries. The source applies transactions, commits them and
then ...
- 428
0
votes
Myloader error during Restorin MariadDB Slave: Duplicate entry 'ТОБАР' for key 'UX_B_SEARCH_STEM'
A previous (now fixed bug) MDEV-31120 may have affected your backups.
I recommend restoring to a version equal or later than the fixVersion in bug report (10.6.15, 10.9.8, 10.10.6, 10.11.5).
You might ...
- 7,649
0
votes
MySql binlog file getting truncated/shrinked during replication
There couldn't be a case where some logs are deleted due to crash, right?
No, I've never seen files be truncated. Binary log files are append-only.
It is normal for old binary log files to be removed ...
- 13.9k
0
votes
MySql binlog file getting truncated/shrinked during replication
It sounds like the length of the binlog was not stored in a timely manner.
Add confguration:
sync_binlog = 1
is probably the solution -- if this problem occurs after a crash and server restart.
- 76.9k
0
votes
Looking for best option(s) to have near real-time data synced from SQL Managed Instance to another SQL Managed Instance
The analog of Managed Instance Link for MI-to-MI replication is an Auto Failover Group:
- 45.9k
0
votes
How to make sure that all required wal files are availables before starting a standby server?
restore_command should read files from the archive, and it is your responsibility not to delete archived WAL segments you still need for catching up or pg_rewind. So with a WAL archive and a correctly ...
- 47.9k
Top 50 recent answers are included