title: Best way to store XML data in a MySQL database, with some specific requirements
body: <p>I am receiving XML data from a service. The test data I am receiving back has about 300 XML nodes, clearly far too many to create individual rows for in a MySQL database.</p>
  
  <p>The problem is that we ideally need to store <em>all</em> the data, and we will probably need to reference the data again at some point in the future - we can't just process through it once and delete the XML string.</p>
  
  <p>What's the best way of storing this data in a MySQL database?</p>
  
  <p>I have forecast that at the predicted rate within a few months, if we were to store the raw XML data in <code>TEXT</code> format, the database could grow to around 500MB. In the long run this feels impractical.</p>