1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
0
Hi there I understand that you created a read only-only aurora replica cluster to offload intense queries. It is expected to have replica lag since binlog replication is asynchronous If nothing is happening on the master [1], the replica will wait for until the master to sent event hence the event that you see. The replica is only active when there is changes to apply[2]. Additionally, it is best practice that the size of the replica be equal to the master instance.
I hope the above information is helpful.
References:
[1]https://aws.amazon.com/premiumsupport/knowledge-center/rds-mysql-high-replica-lag/
[2] https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
con risposta 2 anni fa
Contenuto pertinente
- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata un anno fa