How do you specify a read replica using Sequelize?

Question

How do you specify a read replica using Sequelize?

I have created a very basic test based on their documentation.

https://github.com/sequelize/sequelize/blob/master/docs/usage.md

var Sequelize = require("sequelize");

var sequelize = new Sequelize('database', 'root', '', {
    dialect: 'mysql',
    port: 3306,
    replication: {
        read: [
            { host: 'host1' }
        ],
        write: { host: 'host2' }
    },
    pool: { // If you want to override the options used for the read pool you can do so 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 the following 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
    at module.exports.connect (/Users/tim/code/sequelizetest/node_modules/sequelize/lib/dialects/mysql/connector-manager.js:333:44)

Answer 1

I found a link to the bug here.

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

You need to add your own pool property.