Question

In Logs and Queries getting error

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.


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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<https://www.digitalocean.com/docs/databases/mysql/how-to/create-primary-keys/>

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