On Wed, 4 Apr 2012, James Harper <james.harper@bendigoit.com.au> wrote:
Does MySQL support enough replication these days to meet your requirements? What sort of geographic distribution are you after?
I want replication that doesn't have a special operation for a node leaving the cluster (EG unlike what might be necessary if a MySQL master went down) and which allows new nodes to be added at run-time.
Also for email it doesn't matter much if writes don't propagate instantly.
At this time I don't plan distribution outside one site.
I recall reading about a MTA that had a MySQL backend, the performance reports were not good at all.
Do you need replication for load spreading or redundancy? If the former, Cyrus IMAP is pretty good at spreading mailboxes across multiple servers while retaining a single IMAP namespace. If the latter then I recommend looking at DRBD, although of course that is limited to 2 node clusters unless you run iscsi on top of it... Unless of course you do find the mythical clustered database backend you seek! James