Percieved data loss when reloading and MySQL fails

[diogotcorreia]

If Triton is configured to use MySQL and Triton is reloaded (e.g., through /triton reload), it will fallback to local storage if it can't connect to the database. This makes it seem like all translations are gone.

This problem is exacerbated with the fact that if you download from TWIN after that, those translations will be saved to local storage instead and create two distinct storages.

There are a few things can be improved here:

• [ ] Stop Triton if it can't connect to MySQL. This is better than making it seem like it's working when it is not, and if Triton is configured to use MySQL, it probably means that local storage is empty anyway.
• [ ] Reevaluate HikariCP settings. One common error is "Too many connections".
• [ ] Do partial inserts instead of dropping the entire database and reupload when something has to be saved.