node.js - How do you specify a read replica using Sequelize? -

node.js - How do you specify a read replica using Sequelize? -

how specify read replica using sequelize?

i have created basic test based on documentation.

http://sequelizejs.com/docs/latest/usage

var sequelize = require("sequelize"); var sequelize = new sequelize('database', 'root', '', { dialect: 'mysql', port: 3306, replication: { read: [ { host: 'host1' } ], write: { host: 'host2' } }, pool: { // if want override options used read pool can here maxconnections: 20, maxidletime: 30000 } }) var test = sequelize.define('grammar_scores', { id: { type: sequelize.integer, primarykey: true, autoincrement: true }, user_id: { type: sequelize.integer, index: true } }, { underscored: true }); test.findall({ where:{user_id:89} }).success(console.log);

which throws next error...

/users/tim/code/sequelizetest/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:333 if (config.pool !== null && config.pool.handledisconnects) { ^ typeerror: cannot read property 'handledisconnects' of undefined @ module.exports.connect (/users/tim/code/sequelizetest/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:333:44)

i found link bug here.

https://github.com/sequelize/sequelize/pull/1251

you need add together own pool property.

node.js sequelize.js