'NodeJS Knex database fallback for MySQL database
I am using the knex library (https://www.npmjs.com/package/knex) for NodeJS and MySQL and I would like to implement a fallback database connection in case that the current database is not reachable anymore.
I ve read that via the knex config it is possible to use for example the config options "ping" (https://github.com/knex/knex/issues/1198#issuecomment-185310131) and "afterCreate" (https://github.com/knex/documentation/pull/17/files) to detect if it is not possible anymore to connect to the database.
But in case it is not possible how exactly can i overwrite the existing connection settings, establish a new database connection and make it available to all upcoming queries within these config options?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|