Question:
Hi people.
For development, we got a database on MySQL
. A lot of functionality was written in triggers to tables, which led to a corresponding drop in performance. One solution would be to execute this functionality asynchronously. In MS SQL
this task is solved simply with the help of Service Broker
. So the question is:
Does MySQL
functionality similar to Service Broker в MS SQL
?
Answer:
Asynchronous query execution in mysql is not available out of the box. But inquisitive minds solve this problem using non-standard client libraries ( http://habrahabr.ru/post/155377/ or http://samag.ru/archive/article/2542 ) or using strange mechanisms like this – http: // www.phphighload.com/2013/05/asynchronous-mysql-queries-with-xbox.html