Django: Use MySQL and ElasticSearch in single application
<p>I want to use <code>MySQL</code> and <code>ElasticSearch</code> using <code>Haystack</code> within single <code>Django</code> application. Our's application deals with a huge set of relational data with 300+ tables and MySql is the best choice to serve that. But we want fast searching on few columns of tables with 10 Million+ rows.</p>

<p><strong><em>Is it possible in Django to use MySQL as primary data storage and use ElasticSearch for search related queries?</em></strong> I searched on internet but couldn't find any related information. </p>

<ul>
<li><strong><em>If yes</em></strong>, what should be the approach? Any related links or blogs will be very helpful. </li>
<li><strong><em>If not</em></strong>, what should be the alternative approach?</li>
</ul>