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 ...
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 ...
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 ...
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 ...
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.
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:
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 ...
Top 50 recent answers are included
Related Tags
replication × 3406mysql × 1355
sql-server × 849
postgresql × 523
transactional-replication × 237
mongodb × 224
mariadb × 190
master-slave-replication × 137
mysql-5.5 × 119
sql-server-2012 × 114
merge-replication × 110
sql-server-2008-r2 × 109
sql-server-2008 × 108
backup × 103
mysql-5.6 × 100
amazon-rds × 71
sql-server-2016 × 66
oracle × 65
mysql-5.7 × 62
failover × 62
data-synchronization × 60
innodb × 59
database-design × 56
galera × 56
performance × 55