Igor Zhbanov wrote:
> Hello!
>
> I want to try to setup DBmail over MySQL NDB cluster. Is it possible?
> Has anyone successful installation?
>
> I have read messages of this mailing list of the times when MySQL
> cluster holds all tables in memory. But for now MySQL cluster can
> store non-indexed columns on disk. So, if you don't need to make
> indexed search of letters content, you don't need to hold all letters
> in memory. E.g. you can have FROM, TO and account headers in memory
> and store message body on disk. So, it is not an issue anymore.
>
> I need to know: is there any specific notes for using DBmail over NDB
> engine? Is it possible? Is there any spicific related to NDB vs.
> InnoDB for DBmail?
I'm not aware of anyone having tried this yet.
Reading through the limitations doc I notice:
'''
There are no prefix indexes; only entire fields can be
indexed.
'''
But dbmail does use prefix indexes at least in 1 place - the
dbmail_headervalue table.
Savepoints are not supported. This is not a problem yet, but using them
was a low-priority planned feature, so if people start using NDB we'll
have to forgo on those.
Foreign key constructs are ignored. This is bad, we need them and rely
on them.
As far as I can tell, this last one is the only real problem. Is foreign
key support on the roadmap for NDB?
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
