MySQL Forums
Forum List  »  Stored Procedures

Best practice for deployment of stored procedures
Posted by: Gregor Müller
Date: January 28, 2019 03:03PM

Hi there,

we use a lot of stored procedures in our project and have some infrastructure to "deploy" them. Currently we drop all and recreate them, because there are maintained within the php codebase.

This might lead to Call statements not being executable because for a short moment the stored procedure does not exist.

Is there a way to "lock" all clients? What is your best practice on deploying stored procedures.

Thank you,

Gregor

Options: ReplyQuote


Subject
Views
Written By
Posted
Best practice for deployment of stored procedures
950
January 28, 2019 03:03PM


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.