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.
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!
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.
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.