¿Cómo puedo resolver problemas comunes al utilizar réplicas de lectura en Amazon Aurora?

¿Por qué la réplica de lectura de mi Amazon Aurora se ha retrasado y se ha reiniciado?

¿Cómo puedo crear una réplica de lectura para una instancia de base de datos de Amazon Aurora MySQL?

¿Cómo soluciono el error “READONLY You can't write against a read only replica” (No se puede escribir en una réplica de solo lectura) después de la conmutación por error de mi clúster de Redis (modo clúster desactivado)?

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

Contenido relevante