title: Getting Solr to run, with data from many different relational tables in MySQL
body: <p>We wish to implement faceted searching, and faster search results for our system. I've researched a bit, and Solr seems to be an amazing thing, exactly what we need. But, none of us have worked with Solr before, and before we start overhauling our system to work nicely with Solr, I want to know how to migrate data from MySQL to Solr, or set it up so Solr can read the database. The catch is that the data is in many different tables.</p>
  
  <p>For example, a <code>product</code> might have attributes, childs, pricing, tags, all in different tables. Would Solr be able to access all of these tables properly, and connect them to the right product?</p>
  
  <p>Or, would we need to create a (huge) <code>xml</code> file in which each product is placed, with all the relevant attributes? We're at just shy of 50.000 products now, but we expect growth up to hundreds of percents in the coming two years.</p>