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
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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.<>

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