[dijit]

I hate how entrenched MySQL is.

We had 6 months of testing a high-throughput database trying to get it to do the consistency and latency required for peak load to no avail. (Even to the point of replacing the kernel with a custom one, and using a faster memory allocator)

PostgreSQL could do it with only minor configuration tweaks.

It still took a further 1.5 years to get the central IT body of my company to allow us to use it, and we wouldn't have had that if our software didn't 100% require it.. I hate to imagine how other software that actually needs conversion is right now.

sidenote: I've had many corruption issues from using MySQL, so I'm double-baffled.

[ZenoArrow]

> "sidenote: I've had many corruption issues from using MySQL, so I'm double-baffled."

MyISAM or InnoDB?

Also, have you considered trying MariaDB?

[dijit]

the consistency issues come from the handling of those filesystems by the control interface above it.

I'm fairly certain innodb by itself is pretty decent, in fact you can configure away the horrible behaviour nowadays, but I'm usually called in when things go wrong- and people usually keep the defaults.