Pergunta de entrevista da empresa Easytech Services

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

Resposta da entrevista

Sigiloso

28 de jun. de 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.