Oracle Releases MySQL 5.5

darthcamaro writes "Two years after Sun released MySQL 5.1, Oracle has picked up the ball with the official release of MySQL 5.5. New features include semi-synchronous replication, InnoDB by default and new SIGNAL/RESIGNAL support for exception handling. Above all, Oracle stressed that they are committed to further MySQL open source development and that they see it as a complementary technology to their proprietary Oracle database."

Comments

Re:From the article....

[tomhudson]

When's the last time you lost data with mysql that was directly attributable to the database, and not to a messed-up query or a hardware or network problem?

To hear everyone going on so much, you'd think that you couldn't even run a web site with it.

Obviously that's not the case, so a LOT of the complaining is just nonsense, same as the vi vs emacs jihads.

-- Barbie

Re:You have nothing to fear.

[tepples]

Postgres.

Any other questions you have?

Here's one: how to adapt LAMP applications that depend on behaviors of MySQL.

Windows kernel-mode code signing

[tepples]

VirtualBox? I'm afraid to even think about it... I love VirtualBox.

At ever step of the way it still be open source. If you don't like what they're doing and want to change it, make a fork.

Some virtualization features, such as USB forwarding, require kernel-mode device drivers. On 64-bit Windows Vista and 64-bit Windows 7 operating systems, all kernel-mode device drivers must be digitally signed with a timestamp from a commmercial certificate authority recognized by Microsoft. If you add your own self-signed CA, you get the always-on-top notice "Test Mode" in all four corners of the screen. Unless you are forking on behalf of an established organization that already has a kernel-mode code signing certificate, the advantage of the official version over your fork is that the end user doesn't have to throw his computer into "Test Mode". The only way out that I can see is to run GNU/Linux on the bare hardware, and that brings hardware compatibility issues that I don't feel like bringing up yet again.

Re:The thing is, Oracle still owns it.

[icebraining]

They are getting rid of GNU autotools, because autotools is a mess of applications being layered on top of each other through the years. CMake accomplishes the same stuff, including most parameters you need, in a much cleaner way.

If you want to change the prefix, you just need to override CMAKE_INSTALL_PREFIX with "cmake -DCMAKE_INSTALL_PREFIX=/new/path ."

Re:From the article....

[shish]

When's the last time you lost data with mysql that was directly attributable to the database

A couple of years ago (the last time I used mysql), I was running it on a tiny VM, where I found it hit the memory and disk limits quite frequently -- and in each case, the server would crash and leave corrupt tables which required 20-30 mins of fixing. Running postgres in the same situation, out of memory causes a single worker process to die (but you can then reconnect, it's not the whole server that's down), out of disk causes "error, out of disk space" (and you can still make read-only queries).

Also, running a pretty high load website (>1000 queries/sec) on not-that-great hardware, it seems mysql would randomly drop table indexes when it couldn't keep up with inserts, thus bringing the whole site grinding to a halt. Since switching that site to postgres, it's been a lot more reliable (it's also been faster, since postgres' indexes are better, and it runs straightforward queries better, where I was always contorting queries to avoid mysql performace gotchas, but those aren't really data loss)