MySQL adapter for Sails.js
Last updated 3 months ago by melamber .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install alternative-sails-mysql 
SYNC missed versions from official npm registry.

Alternative-Sails-MySQL Adapter

Alternative MySQL adapter for the Sails framework and Waterline ORM. This is fork of original sails-mysql driver. This adapter can be used for replicas connections. It does not use real pool for replicas. It uses logic on top level code for switching between mysql instances. Adapter supports load balancing and alternative connections fot failure cases.


Install from NPM.

# In your app:
$ npm install alternative-sails-mysql


Use additional param alternative to specify alternative connection for load balancing and failure cases of the main connection. Param alternative takes string with alternative connection name.

Example of configuration:

datastores: {
  default: {
    adapter: 'alternative-sails-mysql',
    user: 'user',
    password: 'password',
    database: 'database',
    socketPath: 'socketPath',
    alternative: 'defaultAlternative',
  defaultAlternative: {
    adapter: 'alternative-sails-mysql',
    user: 'user',
    password: 'password',
    database: 'defaultAlternative',
    socketPath: 'socketPath',

Running the tests

To run the tests, point this adapter at your database by specifying a connection URL and run npm test:

WATERLINE_ADAPTER_TESTS_URL=mysql://root:myc00lP4ssw0rD@localhost/adapter_tests npm test

For more info, see Reference > Configuration > sails.config.datastores > The connection URL, or ask for help.


This adapter, like the Sails framework is free and open-source under the MIT License.

Current Tags

  • 1.1.0                                ...           latest (3 months ago)

1 Versions

  • 1.1.0                                ...           3 months ago
Maintainers (1)
Today 0
This Week 0
This Month 0
Last Day 0
Last Week 0
Last Month 0
Dependencies (5)
Dev Dependencies (4)
Dependents (0)

Copyright 2014 - 2016 © |