title: How to use Elastic Search on top of a pre-existing SQL Database?
body: <p>I've been reading through a lot of good documentation about how to implement Elastic Search on a website with javascript or PHP.</p>
  
  <p>Very good <a href="http://www.elasticsearchtutorial.com/basic-elasticsearch-concepts.html">introduction to ES</a>.</p>
  
  <p>Very complete documentation <a href="http://okfnlabs.org/blog/2013/07/01/elasticsearch-query-tutorial.html">here</a> and <a href="http://exploringelasticsearch.com/modeling_data.html#sec-modeling-type-basics">here</a>.</p>
  
  <p>A whole <a href="http://joelabrahamsson.com/elasticsearch-101/">CRUD</a>.</p>
  
  <p>Elastic search with PHP: <a href="https://speakerdeck.com/farrelley/elasticsearch-for-php-lone-star-php-2012">here</a>, <a href="http://elasticsearch-users.115913.n3.nabble.com/Elastica-PHP-client-for-elasticsearch-td1738187.html">here</a>, and <a href="http://hublog.hubmed.org/archives/001907.html">here</a>.</p>
  
  <p>So the reason why I'm giving you those URLs is to understand how to use one or many of those great documentations when having a pre-existing SQL DB.</p>
  
  <p>I'm missing the point somewhere: As they said Elasticsearch will create its own indexes and DB with MongoDB, I don't understand how can I use my (gigantic) database using SQL? Let say I have a MySQL DB, and I would like to use Elasticsearch to make my research faster and to propose the user pre-made queries, how do I do that? How does ES works over/along MySQL? How to transfer this gigantic set of Datas (over 8GB) into ES DB in order to be fully efficient at the beginning?</p>
  
  <p>Many Thanks  </p>