[imp] MySQL Cluster

[Marko Djukic]

Quoting Sam Lalonde <salalond at uoguelph.ca>:

> Is anyone using MySQL cluster as their backend database?  Any comments?

Yes. In MySQL cluster in its current state is not really viable unless you have
massive amounts of RAM.

Biggest issues is that any varchar field will be expanded to it's full potential
size. ie: varchar(255) even if it has only 1 byte per record, will use all 255
bytes for each record.

So one example of trying to load into a MySQL cluster a relatively simple 100MB
database (on a regular MySQL install) bloats to 1.8GB in a MySQL cluster. Not
really viable even on a box with 4GB of RAM.

m.


--
Marko Djukic
Horde Project (http://horde.org/)