alternative-sails-mysql v2.0.0
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.
Installation
Install from NPM.
# In your app:
$ npm install alternative-sails-mysql
Usage
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.
License
This adapter, like the Sails framework is free and open-source under the MIT License.