New answers tagged

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 ...
Laurenz Albe's user avatar
  • 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 ...
prasad_'s user avatar
  • 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 ...
danblack's user avatar
  • 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 ...
Bill Karwin's user avatar
  • 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.
Rick James's user avatar
  • 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:
David Browne - Microsoft's user avatar
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 ...
Laurenz Albe's user avatar
  • 47.9k

Top 50 recent answers are included