MySQL Forums
Forum List  »  NDB clusters

Re: Error 1064 Duplicate entry 'ndbcluster-96' for key 'tables.engine'
Posted by: Tony Soprano
Date: January 19, 2024 03:10PM

Thanks again for your kind answer mr. Patricio,
I wish to ask your professional help online via anydesk or zoom whatever, willing to pay for your work.
please contact me if you're willing at my work email: support@nethops.net

in case you wont do then here some questions and doubts....

I dunno how to do these procedures please kindly give me example:
- quote yours:"you can always do a fresh-reset on MySQL server which does clean every entry in DD."

quote:"you can always restart each MySQL server and let it resync its DD with NDB" I've done this already 3 times. i totally shut down ndb and turn off all VM's,
then turn on in order:
1) mngm node with mysqld node 1
2) data node 1 which stuck for 13 mins. i was waching tail -f logs
so i decided to start data node2 and then both start to do them duty
until both online and connected to mgnm node
3) mysql node 2 which has ver. 8.0.34 while all others 8.0.33

I've decided to try update all nodes to 8.0.36 next week in this order:
1) mgng and mysql node1 with v.8.0.33
2) mysql node2 with v.8.0.34
3) data node1 with v.8.0.33
4) data node2 with v.8.0.33
i have doubt abt this, for mysql nodes it's enough apt upgrade i guess, but for data not working so i have to download manually DEB files.
My question is, i'll just install with dpkg those new versions or i have to delete first the old one?
if i delete old one i'll lose all data ?
Thanks for your answers.

Options: ReplyQuote




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.