Dec 11
Application: one host with a huge disk space.
+ less memory as one DB instance serves all
- huge disk is a must, although we can map drives and use symlinks
- local access to db data files only (no network)
* Works only with regular/packed MyIsam DB i.e. each time there is a new chunk of data we have to stop DB and to the maintenance chores - dump/import/pack
* It is possible to merge readonly and regular tables
* Select with a key type search returns single record even if there were a few others with the same key. Select with a “like” type search (table scan) returns all of them.
