title: Can I use multiple servers to increase mysql's data upload performance?
body: <p>I am in the process of setting up a mysql server to store some data but realized(after reading a bit this weekend) I might have a problem uploading the data in time.</p>
  
  <p>I basically have multiple servers generating daily data and then sending it to a shared queue to process/analyze.  The data is about 5 billion rows(although its very small data, an ID number in a column and a dictionary of ints in another).  Most of the performance reports I have seen have shown insert speeds of 60 to 100k/second which would take over 10 hours. We need the data in very quickly so we can work on it that day and then we may discard it(or achieve the table to S3 or something).</p>
  
  <p>What can I do? I have 8 servers at my disposal(in addition to the database server), can I somehow use them to make the uploads faster?  At first I was thinking of using them to push data to the server at the same time but I'm also thinking maybe I can load the data onto each of them and then somehow try to merge all the separated data into one server? </p>
  
  <p>I was going to use mysql with innodb(I can use any other settings it helps) but its not finalized so if mysql doesn't work is there something else that will(I have used hbase before but was looking for a mysql solution first in case I have problems seems more widely used and easier to get help)?</p>