Hi there, I have a back-end project with nodejs using mysql

Question

Hi there, I have a back-end project with nodejs using mysql

as a database.
There is two scenario I hope you would help me to make the right decision.

There is 10 service (a simple class or function inside app) that each X seconds is calling mysql procedure and sends result with API or websocket.

having a separated connection for each service is better or one mysql connection for all of them?

0

11.08.2021

9 ответов

28 просмотров

Farhad Mehryari Автор вопроса

any idea? 🙄

0

11.08.2021

Farhad Mehryari Автор вопроса

Thomas
How would you have one connection for all of them?...

before starting all services I create a connection and pass in service constructor like below: class App { async init() { const connection = await this.connect() let services = [] for(service in services) { const instance = new service(connection) } } connect(): Promise<connection> { // returns connection } }

0

11.08.2021

painor

Farhad Mehryari
before starting all services I create a connection...

when you said service I think most people thought about systemd related stuff not just a class with functions.

0

11.08.2021

Farhad Mehryari Автор вопроса

painor
when you said service I think most people thought ...

Sorry, simply I mean a function or class.

0

11.08.2021