I understand from Unsupported Feature List that
get_lock is not supported.
I am using a migration tool that is explicit calling this MySql function to migrate tables in ‘cluster mode’; meaning that it holds a lock until all migration scripts are executing, just to avoid that another microservices isn’t doing the same at the same time for example.
Any suggestions on using another default function in Singlestore? Or do we have to implement a stored procedure that does the same (create the table, insert a record, dropping the table when everything is done, then trying to insert a value with the same PK => this would fail if the same migration is already running).