MySQL Forums
Forum List  »  InnoDB

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

Hi,
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


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


Sorry, only registered users may post in this forum.

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.