I am evaluating MonetDB for a multi-tenanted OLAP solution. I understand that there is a concept of schema similar to mysql in MonetDb but is it really scalable in terms of schema's. Can I put a reasonable number of schemas and all performing nearly the same or multiple instances of the monetdb server will be needed ?
Also is it scalable in terms of number of indexes? Coz in a multi-tenanted environment our number of indexes will also increase with number of tenants.
I have looked all over to find out about this but could not get a satisfactory answer.
You can manage multiple instances of the MonetDB server using monetdbd, the MonetDB daemon. I would recommend this for multi-tenant environments. Not sure what you mean by "number of indexes"...