In order to allow multiple factories to use the same database use locks for alter table/column and create/alter table. This way factories can start in parallel without running into errors (most of the time and during initial startup). In case alter statements take a long time, a factory which is unable to obtain a lock, should exit with an error.
In order to allow multiple factories to use the same database use locks for
alter table/columnandcreate/alter table. This way factories can start in parallel without running into errors (most of the time and during initial startup). In casealterstatements take a long time, a factory which is unable to obtain a lock, should exit with an error.https://mariadb.com/kb/en/get_lock/ https://dev.mysql.com/doc/refman/8.4/en/locking-functions.html
Also: Add readOnly parameter to disable write access to a PL. Write access to a read only PL should always be treated as an error (PL exception).