From Traccar docs:
By default Traccar uses an embedded H2 database, but we don’t recommend for it for production…
I’m aware of your How to install Traccar on Portainer video. However, if I get it correctly, it doesn’t use MySQL to persist the tracking data.
So, I’d like to suggest a new video here; show how to install and setup Traccar on Portainer using Docker Compose but with MySQL database instead of H2.