Need help on sharded query
Please help me to find the best way to handle the following implementation
1.Fire multiple mysql queries in parallel on different mysql DBs located on different server locations.
2.Fetch the data and aggregate the data grouping on a specified column.
3.Mysql DBs contain same DB tables but with partitioned data.
Any java/j2ee technologies are fine.
Thanks in advance,
Re: Need help on sharded query
Okay. Use plain Java + JDBC. You'll have to do threading to fire things in parallel, but remember that if you want to fire 8 things in parallel on one machine you'll need either 8 cores or 8 CPUs.