<p>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.</p>
<p>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.</p>
<p>--<br>
Sent from my Ice Cream Sandwich!</p>
<div class="gmail_quote">On Feb 17, 2012 12:05 PM, "Geoffrey Myers" <<a href="mailto:lists@serioustechnology.com">lists@serioustechnology.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Lightner, Jeff wrote:<br>
> Silence here I think doesn't say that much. I've noticed that<br>
> commercial install questions here usually go unanswered whereas<br>
> discussions of emacs vs vi can go on for days. I'd think most folks<br>
> doing clustering for MySQL are doing it in a commercial environment.<br>
><br>
> Have you looked for MySQL specific forums or mailing lists?<br>
><br>
> Was I correct in thinking you'd be amenable to Postgresql instead?<br>
> If so did you see Geoffrey Meyers' post?<br>
<br>
Is MySQL ACID compliant yet? If it is not, I think that says a lot with<br>
regard to the direction I would take.<br>
<br>
--<br>
Until later, Geoffrey<br>
<br>
"I predict future happiness for America if they can prevent<br>
the government from wasting the labors of the people under<br>
the pretense of taking care of them."<br>
- Thomas Jefferson<br>
_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
</blockquote></div>