Lots of mysql clients?

Question

MySQL

There is a main process in which the RPC server is opened.
The same process uses the cluster module to create 500+ forks, they are workers that will do the work.
Is it possible to open a connection to mysql in each worker, or is it better to keep the connection in the master and kick the master from the workers so that he updates the database?
PS Is it possible to fork an open connection from the master?

Answer 1

500+ workers? on one machine? why so many? performance will only lose from such a number
of subjects, open a connection in each worker, mysql is not able to resolve concurrent access to one connection. Within a single process, this is handled by driver libs by queuing requests, but on multiple processes this will be a problem.

Answer 2

Do you have 500+ processors on your machine? It makes no sense to make the number of workers greater than the number of available cores.
Reduce the number of workers and open a connection pool in each worker.