Question

In Logs and Queries getting error

Posted April 6, 2021 211 views
DigitalOcean Managed MySQL Database

As I was looking at my managed database it showing error
system user | connecting host | Connect: Waiting for master to send event | 17180976ms
In Master Database i looked last error from slave is error reconnecting to master ‘repluser@IP’

Need Solution.

edited by bobbyiliev

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hi @fantasysports

a) Can you confirm if database have any tables without a primary key, contain more than 5000 rows?

Database with tables without a primary keys may experience replication issues as per detailed here . To prevent this, we now requires you to add a primary key for each new table you create in any managed MySQL database as well as add it on the existing databases to avoid replication issues.

https://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/#how-digitalocean-uses-primary-keys%3Chttps://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/%3E

b) There can be severe resource starvation for your service which may affect the replication. Normally if there is any issue in replication of any cluster, our monitoring automatically detects and resolves it, so this would likely how it got fixed.

If you experiencing this error frequently, please raise support ticket for our team for further investigation.

Regards,
Priyanka