Mysql 4.0

is the new stable mysql release. is it stable though?

[eaden]

I am wanting to try out mysql 4.0, but I'm running a production webserver. As it's not "beta" software the usual "don't install beta software on production servers" rule doesn't seem to apply.

However I would like to develop my new sites using the new features, such as row level locking.

Has anyone used mysql 4.0, and does it work like 3.x? I.e. will existing webscripts still run without errors? Is it faster?

[rayvd]

If I were you, I'd set it up on a test server. Personally, I'll be waiting a couple months (probably 6) before moving to 4.x. The subqueries look nice, but if there are _any_ incompatibilities or changed queries it will make things quite messy to fix on my site :)

[daisho]

I run MySQL 4.0.12 on production servers without problem. That's the version listed as "Stable" from MySQL.

daisho.

[Lisa]

I run a few copies of MySQL 4.x right now. I don't run a copy on any production boxes yet. Queries will never change from version to version, so there is no fear there, SQL is SQL, just different engines and different support out there.

Speaking of issues, I put 4.x on one backend processing servers that does A LOT of work but after finding a few bugs I migrated back to 3.23. Seems 4.x is not stress tested enough yet. There are a few issues yet to be worked out. I think the bug I speak of had to do more with a combined FreeBSD + MySQL 4.x bug.

I will give 4.x a few more months before my production servers get a crack at 4.x. I am a long time oracle user, but we use MySQL at my company. So I am going to enjoy some of these new features that I have been missing!

From what I have seen, If you don't have a busy busy server. MySQL 4.x is very safe. I think it is safe for use by normal websites. Just not servers doing heavy crunching.