title: Database for Full Text Search and 200M+ Records
body: <p>Iam about to create a huge database with at least 200 Million entries.
  The database needs to be searchable using full text and should be fast. </p>
  
  <p>My database gets data from many different datasources and i need to import the new or updated data regularly.</p>
  
  <p>Is it a good idea to store all my data in a relational database like mysql and then create a nosql document database (e.g. mongodb or elasticsearch) just for the purpose of searching or does that not provide any benefit in terms of 
  reliability and the prevention of redundant information?</p>