Results 1 to 2 of 2
  1. #1
    addanki80 is offline Member
    Join Date
    Apr 2014
    Posts
    1
    Rep Power
    0

    Default Need help on sharded query

    Hi Guys,

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

  2. #2
    gimbal2 is offline Just a guy
    Join Date
    Jun 2013
    Location
    Netherlands
    Posts
    4,358
    Rep Power
    6

    Default 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.

    Good luck!
    "Syntactic sugar causes cancer of the semicolon." -- Alan Perlis

Similar Threads

  1. Replies: 3
    Last Post: 10-19-2012, 11:16 PM
  2. SQL query to HQL
    By alvin0618 in forum JDBC
    Replies: 3
    Last Post: 04-08-2011, 10:00 AM
  3. hql query
    By murali23krishna in forum JDBC
    Replies: 1
    Last Post: 03-17-2011, 08:25 AM
  4. Sql Query
    By Nomad in forum JDBC
    Replies: 16
    Last Post: 02-20-2009, 02:58 PM
  5. Help in Query
    By geeta_ravikanti in forum JDBC
    Replies: 0
    Last Post: 03-31-2008, 02:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •