[ale] MySQL Cluster

Michael Trausch mike at trausch.us
Fri Feb 17 16:54:18 EST 2012


MySQL is not ACID compliant; it only supports transactions if the table
supports them, and not forcibly database-wide. Transactions break on tables
that support them if tables that do not support them are used in the same
query. And it has no support for MVCC, so concurrency suffers if
transactions are in use.

Having used both MySQL and PostgreSQL, I will say that if you need serious
ACID compliance, use PostgreSQL.  As far as clustering goes, though: I know
that PostgreSQL does it, but I have never had a need to use it. I could see
about spending some time setting one up, though, once I get my new server
up and running.

--
Sent from my Ice Cream Sandwich!
On Feb 17, 2012 12:05 PM, "Geoffrey Myers" <lists at serioustechnology.com>
wrote:

> Lightner, Jeff wrote:
> > Silence here I think doesn't say that much.  I've noticed that
> > commercial install questions here usually go unanswered whereas
> > discussions of emacs vs vi can go on for days.  I'd think most folks
> > doing clustering for MySQL are doing it in a commercial environment.
> >
> > Have you looked for MySQL specific forums or mailing lists?
> >
> > Was I correct in thinking you'd be amenable to Postgresql instead?
> > If so did you see Geoffrey Meyers' post?
>
> Is MySQL ACID compliant yet?  If it is not, I think that says a lot with
> regard to the direction I would take.
>
> --
> Until later, Geoffrey
>
> "I predict future happiness for America if they can prevent
> the government from wasting the labors of the people under
> the pretense of taking care of them."
> - Thomas Jefferson
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20120217/7de1ea26/attachment.html 


More information about the Ale mailing list