How to asynchronously execute Lua code in Nginx location?

Question

CMS

Hi all!
Problem in the following:
There is a normal location which processes incoming requests. It was necessary to add a counter to the mysql table, which takes into account some parameters from the request_uri for a given location.
As a result, the counter works fine, but there is one "But .." - when the tablet is blocked for writing (during the dump), Nginx returns an error 500. After increasing the timeout for the request, the page simply waits until the Lua script returns success or an error.
How can I make sure that the work of the counter does not affect the work of the rest of the location?
To work with MySQL, the library is used - lua-resty-mysql.
The script is "imported" into the location configuration via access_by_lua_file, because inside location there is a proxy_pass on the backend.
I'm new to lua-nginx, so I'll be glad for any help - up to links where and what to read.
Thank you!

Answer 1

I would also advise either Opencart or our Minicart CMS, if you don’t use it, just don’t display it, but as practice shows, any projects grow and sooner or later you will still need unnecessary functions, such as comparison of goods, the “postpone goods” function, card payments and much more.
Engines are made to suit the maximum number of people, so take a proven and most suitable for you without doping and preferably a boxed version, that is, a CMS that is only an online store and not WordPress.

Answer 2

Try to write
after the answer to the client.
Something like

ngx.say("привет")
ngx.eof() // тут клиент отключится
mysql:new() // всякая хрень дальше

Answer 3

I would do mirroring through mirror nginx.org/ru/docs/http/ngx_http_mirror_module.html
You can do anything in this location