Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

RDS MySQL replication problem Error_code: MY-001062

0

Hi, I have configuration:

  • rds mysql 8.0.36 multi az deployment (active - standby)
  • few instances of read-replica I have configured job to scale in and scale out of my main database (to save $ after business hours). Since few days I observer that after scale in and out jobs synchronisation to read-replicas is gone with Error_code: MY-001062. Restarting of read-replicas, restarting main database did not help. This setup works perfect almost 1 year and start crashes 3 or 4 days ago. Any ideas ? how to resolve problem

Thx

Topics
AnalyticsMigration & ModernizationDatabase
Tags
Amazon Relational Database ServiceMySQLDatabase
Language
English
asked 2 years ago554 views
1 Answer
0

Hi,

In MySQl, error 1062 is about duplicate entries. See https://bobcares.com/blog/error-no-1062/

As you didn't give much details about your config, I suggest that you read the article in details to see if one of the proposed recipes to fix applies to your use case.

Best,

Didier

EXPERT
answered 2 years ago
  • Wojtek
    2 years ago

    Hi, I saw this, but as I mentioned - replication to read-replicas is ok till start scale in/out jobs with main database.

    Wojtek

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content