[MXS-1367] Abstract internal SQL queries Created: 2017-08-22 Updated: 2017-12-01 Resolved: 2017-11-02 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | Core |
| Affects Version/s: | None |
| Fix Version/s: | 2.1.10 |
| Type: | New Feature | Priority: | Major |
| Reporter: | markus makela | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
The loss of a connection during an SQL query by the monitor should not affect the end result if the connection can be created again. This would reduce the rate of false positives that the MaxScale monitors generate when combined with the configurable connection retry amount. Partiall |
| Comments |
| Comment by markus makela [ 2017-09-04 ] |
|
A triage operation would be to enable MYSQL_OPT_RECONNECT for all connections in MaxScale. This should not have any negative side effects on how the monitors perform their work. A more advanced version could retry multiple times with configurable wait period between each attempt. |
| Comment by markus makela [ 2017-10-02 ] |
|
Combining OPT_RECONNECT with simple retrying of the queries is enough to abstract away any irrelevant connection problems. |