mardi 3 mars 2015

Is there any way to perform atomic updates of stored procedures in MySQL?


I know that MySQL does not support atomic updates of stored procedures yet and it is bug which was reported on 2005 but not yet resolved.(http://ift.tt/1AB0fQH).


In our project multiple store procedure call within a second, we provide high availability service to client. but due to this bug are not updating any store procedure during production hours. If we update any thing in store procedure MySQL simply drop the entire procedure and recreate again which create downtime issue for our client.


It's also possible that a client calls a stored routine in exactly the moment between a DROP and a CREATE which create major issue for us.


Any one facing this kind of issue ? if yes if you have any way to resolve this kind of issue then please share.


Thanks





Aucun commentaire:

Enregistrer un commentaire