Hello,
I have been using Traccar with the default H2 DB for years.
By now the DB weighs more than 10 GB, but I must say that Traccar always runs fast despite having 4 years or so of data (8 vehicles).
If I were to migrate to Mysql what would be the short and long term benefits? Would I risk the DB H2 crashing at any moment?
Has anyone made the switch to production and noticed improvements?
Thanks for the answers
The main benefit is reliability. I have never heard of MySQL getting corrupted randomly. With H2 it can happen. Then with MySQL you can use all the available tooling. For example you can enable backups, you can query the database directly if that's something you're interested in, etc.
Hello,
I have been using Traccar with the default H2 DB for years.
By now the DB weighs more than 10 GB, but I must say that Traccar always runs fast despite having 4 years or so of data (8 vehicles).
If I were to migrate to Mysql what would be the short and long term benefits? Would I risk the DB H2 crashing at any moment?
Has anyone made the switch to production and noticed improvements?
Thanks for the answers