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');
var url = require("url");
var SocksConnection = require('socksjs');
var remote_options = {
  host:'your-database.eu-west-1.rds.amazonaws.com',
  port: 3306
};
var proxy = url.parse(process.env.STATICA_URL);
var auth = proxy.auth;
var username = auth.split(":")[0]
var 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();

If you have questions, or if this solution doesn’t work or fit your use case, please reach out to us at Support so we can help figure it out with you.


Working with sensitive data, like HIPAA, Financial, or Personally Identifiable Information (PII)? 
    Then you will want to check out our QuotaGuard Shield solution, it's the same as QuotaGuard Static, but with stronger end to end security for your requests. We can also help migrate current Static customers to Shield for free, just reach out to us at Support to request assistance.