Easytech Services interview question

They asked me how i will manage the MySQL server for their OLAP services?

Interview Answer

Anonymous

28 Jun 2017

I told them that MySQL has capability to serve both OLTP and OLAP services well if it nicely and thoroughly configured and managed. So for OLAP services we can make use of MyISAM engines for read and Full table scan queries, further we can create cluster and use partitioning to achieve high throughput.