MySQL Forums
Forum List  »  NDB clusters

Re: ndb_restore
Posted by: Frazer Clement
Date: February 05, 2020 04:32PM

Hi,
Thank you for offering to file some bug reports!

I agree with your points about the ndb_schema_dist_upgrade_allowed option, the default is not correct, and there should be more safeguards before the schema distribution upgraded is allowed. Work on this is underway, but that does not help you unfortunately.

This upgrade of this functionality is currently controlled by the MySQLDs as it is only used by the MySQLD layer to distribute schema changes between themselves. However I do take your point that it is not good that one MySQLD can negatively affect the service offered by others - this breaks one of the purposes of having multiple MySQLDs in the first place - isolation and redundancy.

I would say that it is slightly unusual to have MySQLDs joining the cluster for periodic tasks like you describe, but there is nothing in the architecture which prevents it or normally makes it problematic, prior to this upgrade functionality.

On the last question about upgrading the schema distribution while there are data nodes or MYSQLD nodes on the old version - I cannot think of a situation where this would be useful, and so we should make it impossible.

Sorry once again for the problems this has caused - hopefully you can get your systems stabilized again quickly.

Thank you for taking the time to reply,
Frazer

Options: ReplyQuote


Subject
Views
Written By
Posted
280
January 28, 2020 11:32AM
102
February 05, 2020 11:05AM
76
February 05, 2020 01:12PM
Re: ndb_restore
76
February 05, 2020 04:32PM
74
February 09, 2020 03:38PM
66
February 11, 2020 09:51AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.