title: Partitioning mySQL tables that has foreign keys?
body: <p>What would be an appropriate way to do this, since mySQL obviously doesnt enjoy this.
  To leave either partitioning or the foreign keys out from the database design would not seem like a good idea to me. I'll guess that there is a workaround for this?</p>
  
  <p>Update 03/24:</p>
  
  <p><a href="http://opendba.blogspot.com/2008/10/mysql-partitioned-tables-with-trigger.html" rel="nofollow noreferrer">http://opendba.blogspot.com/2008/10/mysql-partitioned-tables-with-trigger.html</a></p>
  
  <p><a href="https://stackoverflow.com/questions/1537219/how-to-handle-foreign-key-while-partitioning">How to handle foreign key while partitioning</a></p>
  
  <p>Thanks!</p>