MySQL Forums
Forum List  »  InnoDB

Running queries across different shards in Mysql 8
Posted by: newbie mysql
Date: April 29, 2019 11:23AM

I have an application where I will definitely to shard. We are collecting gps location of vehicles every 10 seconds. Thus we cant run on a single machine for few thousand vehicles. Thus we could now shard into different machine e.g for every 3000 vehicles into one shard. The problem is at times we need to run a query example for a particular time perioud we would like to find to all those vehicles which was in particular area. So we have to run the same queries manually on each shard. Is there any efficient way in Mysql 8 or with Proxysql to resolve this. Thank you.

Options: ReplyQuote

Written By
Running queries across different shards in Mysql 8
April 29, 2019 11:23AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.