Re: GET_LOCK in ndb clusters
Hi Jon,
I think I'm replying to the correct reply this time :-).
I looked at the updates in this section, which I'll try to quote here:
-----
21.2.7.10 Limitations Relating to Multiple NDB Cluster Nodes
- No distributed table locks.
A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this lock. This is true for a lock issued by any statement that locks tables as part of its operations. (See next item for an example.)
Implementing table locks in NDBCLUSTER can be done in an API application, and ensuring that all applications start by setting LockMode to LM_Read or LM_Exclusive. For more information about how to do this, see the description of NdbOperation::getLockHandle() in the NDB Cluster API Guide.
-----
I'm not sure GET_LOCK should be lumped in with table locks. I believe it's providing what's known as "user-level locks".
I'm also not sure any of the rest of those 2 paragraphs apply to user-level locks, like I'm thinking that NdbOperation::getLockHandle() is not going to help enable cluster-wide user-level locks.
I think a new section/bullet with
- No user-level locks.
as the header would be clearer and perhaps with some suggestions/guidance such as what Frazer is suggesting - essentially you can roll your own cluster-wide user-level lock-ish things by using rows in a "user-lock" table of your own (without some of the fun features that GET_LOCK provides).
I still would like to see GET_NDB_LOCK someday.
Thanks,
Pete
Subject
Views
Written By
Posted
1073
October 19, 2021 08:23AM
478
October 19, 2021 01:16PM
492
October 19, 2021 03:06PM
531
October 19, 2021 05:20PM
420
October 19, 2021 07:07PM
456
October 20, 2021 09:40AM
423
October 19, 2021 06:09PM
Re: GET_LOCK in ndb clusters
426
October 20, 2021 06:24AM
479
October 20, 2021 06:45AM
430
October 20, 2021 08:19AM
414
October 20, 2021 08:56AM
442
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.