MySQL Forums
Forum List  »  NDB clusters

GET_LOCK in ndb clusters
Posted by: Pete Ditmars
Date: October 19, 2021 08:23AM

Hi,

Can someone confirm whether GET_LOCK() can be made to work cluster-wide across an NDB cluster?

If it can be made to work, what is the configuration setting is that we are missing, because I just confirmed I can lock the same name multiple times from different sessions with GET_LOCK() when connecting to different mysqld servers.

I can't believe I assumed this would work... and am now finding it doesn't.

The documentation in section 12.15 "Locking Functions" here https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html

says innocently enough (after many paragraphs explaining how it works)

"Names are locked on a server-wide basis"

Is implicit in that comment that "Names are NOT locked on an NDB cluster-wide basis. The same name can be locked by different sessions if they connect to different mysql servers within a single cluster." ?

I'm looking in section 23.2.7 Known Limitations of NDB Cluster here https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations.html
and I don't see GET_LOCK listed anywhere.

I see in section 23.2.7.10 Limitations Relating to Multiple NDB Cluster Nodes
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-multiple-nodes.html
that "No distributed table locks" is a limitation but GET_LOCK is not mentioned.

Thanks for any help, or even confirmation that this doesn't work.

Pete

Options: ReplyQuote


Subject
Views
Written By
Posted
GET_LOCK in ndb clusters
475
October 19, 2021 08:23AM
203
October 19, 2021 01:16PM
214
October 19, 2021 03:06PM
278
October 19, 2021 05:20PM
184
October 19, 2021 07:07PM
214
October 20, 2021 09:40AM
161
October 19, 2021 06:09PM
168
October 20, 2021 06:24AM
187
October 20, 2021 06:45AM
183
October 20, 2021 08:19AM
174
October 20, 2021 08:56AM
184
October 20, 2021 04:01AM


Sorry, you can't reply to this topic. It has been closed.

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.