What would not be good about Mysql while having 1000 devices ?
We recommend a local MySQL database.
why local?
Because from practice it works much better than remote. The usage pattern is very different from a typical database. You have extremely high write frequency.
Can we use managed database also ??
Why not?
@Ashok, I have a similar requirement, let me know if you want to tag team and work together?
@Alaa are you using mysql locally on EC2 or you have it decoupled?
@sdntech what is you requirements??
i have about 1000 cars , and I'm using ec2 and MySQL database
can anyone suggest me what is the best database for traccar. , rds or arura and what is the storage type gp or io ? and what is the best database instance size