QuotaGuard

On April 1, 2021, we are moving all of our QuotaGuard Support Documentation to 

https://quotaguard.github.io/qg-docs/

 Please Update Your Support Bookmarks

 Documentation for this article will be maintained at 

https://quotaguard.github.io/qg-docs/nodejs-mysql.html 

Please click on the above link to ensure you are reading 

the most recent and updated documentation.

You can route all database traffic via a Static IP in Node.js using QuotaGuard Static. 

Currently there is a limitation in that you can't use the built in connection pooling, so this is not recommended for high traffic applications. 

var mysql = require('mysql2'),
    url = require('url'),
    SocksConnection = require('socksjs');

var remote_options = {
    host:'your-database.eu-west-1.rds.amazonaws.com',
    port: 3306
};

var proxy = url.parse(process.env.QUOTAGUARDSTATIC_URL),
    auth = proxy.auth,
    username = auth.split(':')[0],
    pass = auth.split(':')[1];

var sock_options = {
    host: proxy.hostname,
    port: 1080,
    user: username,
    pass: pass
};

var sockConn = new SocksConnection(remote_options, sock_options);
var dbConnection = mysql.createConnection({
    user: 'dbuser',
    database: 'dbname',
    password: 'dbpassword',
    stream: sockConn
});
dbConnection.query('SELECT 1+1 as test1;', function(err, rows, fields) {
    if (err) throw err;

    console.log('Result: ', rows);
    sockConn.dispose();
});
dbConnection.end();