I'll start from afar, we worked with traccar for tests on a MySQL database - but with the increase in the number of objects and the server's operating time, I began to think about scaling the database, it was decided to switch to postgresql and now we are talking about scaling.
Tell me, has anyone encountered sharding of the traccar database?
If you have encountered it, how did you implement it?
I'm looking towards the citusdata of the postgres extension
I'll start from afar, we worked with traccar for tests on a MySQL database - but with the increase in the number of objects and the server's operating time, I began to think about scaling the database, it was decided to switch to postgresql and now we are talking about scaling.
Tell me, has anyone encountered sharding of the traccar database?
If you have encountered it, how did you implement it?
I'm looking towards the citusdata of the postgres extension