Pregunta de entrevista de Easytech Services

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

Respuesta de la entrevista

Anónimo

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.