How can I keep multiple MySQL connections to different databases in nodeJS?

Question

Node.js

Good day friends! The question arose of how to simultaneously hold and access a specific connection to a particular database (on MySQL, of course). Without breaking connections.

Answer 1

Easily.
Also just to another variable.

mysql = require('mysql');

// первое
dbConn1 = mysql.createConnection({
    host: DB_HOST,
    user: DB_USER,
    password: DB_PASSWORD,
    database: "database1"
});
dbConn1.connect ( function() {
    console.log('connecting to db1');
})

// и второе
dbConn2 = mysql.createConnection({
    host: DB_HOST,
    user: DB_USER,
    password: DB_PASSWORD,
    database: "database2"
});
dbConn2.connect( function() {
    console.log('connecting to db2');
})