Connection to multiple databases on different hosts of the same API Rest

Question

This is my configuration file of my API connections

const mysql = require("mysql");

const pool = mysql.createPool({
  connectionLimit: 10,
  user: user1,
  password: 123456,
  database: database1,
  host: host1.server.com,
  port: 3306,
});

exports.pool = pool;

What I need is for my API to connect to more than one server, where the databases are. How can be?

I tried it like this and it didn't work:

const mysql = require("mysql");

const pool1 = mysql.createPool({
  connectionLimit: 10,
  user: user1,
  password: 123456,
  database: database1,
  host: host1.server.com,
  port: 3306,
});

const pool2 = mysql.createPool({
  connectionLimit: 10,
  user: user2,
  password: 123456,
  database: database2,
  host: host2.server.com,
  port: 3306,
});

exports.pool = { pool1, pool2};

Can someone help me?

Check out this post. I believe it may have something to do with connections vs pools. — code
– code, Commented Dec 30, 2021 at 0:38
This post is about connections, I would like it to be in a Pool. — Nebenzahl
– Nebenzahl, Commented Dec 30, 2021 at 0:42
Yes, but perhaps pools are the problem. Why not try it with a regular connection and debug from there? — code
– code, Commented Dec 30, 2021 at 1:02

Nebenzahl · Accepted Answer · 2021-12-30 01:28:20Z

1

I solved the problem.

I wasn't exporting correctly. Then I fixed it as below, and it worked.

module.exports = { pool, pool2 };

answered Dec 30, 2021 at 1:28

Nebenzahl

3714 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connection to multiple databases on different hosts of the same API Rest

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related