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.

[NaysKutzu]

I mean when you use MySQL you can like download the hole database as a cache on a local file and then serve that file till a change was made to the database :Ö))

[NaysKutzu]

Or when uploading you can do the same thing create a local database and serve that :) and just slowly upload the db to host :)

[diogotcorreia]

That kinda defeats the purpose of a database in the first place 😅
And it's likely that most of your server will not work if the database is down anyway, so it shouldn't matter if Triton stops itself or something similar

[NaysKutzu]

Ik but that how most web app's do just save cache and server cache till some change :)