title: Solr and MySQL, How to keep an updated index, and, is a DB even needed if it's simple?
body: <p>I'm a complete beginner with Solr, so bear with me. :)</p>
  
  <p>In my current project I have a very simple DB - just 1 table that contains 4 fields: id, name, subject, msg.</p>
  
  <p>The way I understand, every time a new record is added (or removed), I'd need to add that record to the index, essentially performing two operations: inserting the record into the DB and adding it to the index.</p>
  
  <p>Is this standard procedure, or is there a way to direct Solr to automatically reindex the DB table either at some interval or whenever there are updates?</p>
  
  <p>Also, since the table is so simple, does it even make sense to store this info in the DB? Why not just keep it in the Solr index, considering that I want the records to be searchable by name, subject, and msg?</p>
  
  <p>My setup is Java, Hibernate, MySQL, and Solrj.</p>