goquo-mysql

goquo-mysql

mysql wrapper for projects at GoQuo Vietnam

Config parameters

mysqlGroups: if you're using 1 server only. set it up as master. If you want to use it in cluster mode, add your database replicas to replica set

let replica1 = parseDbUrl(process.env.MYSQL_REPLICA_1)
configConnection('replica', replica1)
mysqlGroups.push(replica1)

stdTTL: cache TTL

ttlPercent: ttl Percent

Example

'use strict'

// NOTE: install dotenv and parse-database-url with npm first

require('dotenv').config({ path: '.env_example', silent: true})

let parseDbUrl = require('parse-database-url'),
    mysqlGroups = []

let Master = parseDbUrl(process.env.MYSQL_MASTER_URL)
configConnection('master', Master)
mysqlGroups.push(Master)

function configConnection(groupName, config) {
    config.groupName = groupName
    config.connectionLimit = parseInt(process.env.MYSQL_CONNECTION_LIMIT)
    config.dateStrings = true
}

return require('./index')({mysqlGroups: mysqlGroups, stdTTL: 3600000, ttlPercent: 80})
    .then(function(mysql){
        // do your things here
    })
    .catch(function(err) {
        throw err
        console.log(err)
        process.exit(1)
    })