title: Mysql : How to run heavy analytical query at real time
body: <p>I am running a crm application which uses mysql database. My application generating lots of data in mysql. Now i want to give my customer a reporting section where admin can view real time report, they should be able to filter at real time. Basically i want my data to be slice and dice at real time fast as possible.
     I have implemented the reporting using mysql and php. But now as data is too much query takes too much time and page does not load. After few read i came across few term like Nosql, mongoDb , cassandra , OLAP , hadoop etc but i was confuse which to choose. Is there any mechanism  which would transfer my data from mysql to nosql on which i can run my reporting query ans serve my customer keeping my mysql database as it is ? </p>