gq-mariadb
v1.0.2
Published
mariadb/mysql wrapper for projects at GoQuo Vietnam
Downloads
17
Readme
gq-mariadb
mariadb/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('./gq-mariadb')({mysqlGroups: mysqlGroups, stdTTL: 3600000, ttlPercent: 80})
.then(function(mysql){
// do your things here
})
.catch(function(err) {
throw err
console.log(err)
process.exit(1)
})