Como posso usar logs binários de uma instância de banco de dados ativa do Amazon RDS para MySQL para replicar para uma instância on-premises em espera?

Por que minha tarefa do CDC do AWS DMS falhou com um erro 1236 ao usar o MySQL como origem?

Como soluciono o erro “READONLY You can't write against a read only replica” [Não é possível gravar em uma réplica somente para leitura] após o failover do cluster do Redis (modo cluster desabilitado)?

Solução de problemas do erro do AWS DMS “Last Error Replication task out of memory. Stop Reason FATAL_ERROR Error Level FATAL”

Some time ago I have posted this:

[https://repost.aws/questions/QUPmtTo4DuT2STM21dxD3KBA/amazon-aurora-mysql-auto-increment-sometimes-gets-out-of-sync-on-read-and-write-replicas](https://repost.aws/questions/QUPmtTo4DuT2STM21dxD3KBA/amazon-aurora-mysql-auto-increment-sometimes-gets-out-of-sync-on-read-and-write-replicas)

The autoincrement was not in sync for some tables on read and write replicas. I was told by our AWS account managers that this was a bug in Aurora mysql version 5. We have upgraded to version 8. Currently we have 8.0.mysql_aurora.3.04.0. The bug was not fixed, or maybe it was fixed and came back again. 

![Enter image description here](/media/postImages/original/IMtop73KX9QGmi-cvw180JkA)

![Enter image description here](/media/postImages/original/IMGL2BIruYTR2NWrEyvxmyIQ)

Because of this I sometimes have errors on inserts. The autoincrement seems to get in sync on database failover. 

As you can see in the images, multiple tables have autoincrement out of sync. Amazon AWS please fix this bug!

Amazon Aurora 8.0 MYSQL AUTO_INCREMENT sometimes gets out of sync on read and write replicas

Conteúdo relevante