MySQL Readies Release Candidate For 5.1

Anonymous Dolphin writes "MySQL has released plans for a final RC for the MySQL 5.1 server. Monty Widenius, the CTO and founder of MySQL, has put up a request for more feedback from the community. You can get the latest RC here. Please help with the testing of 5.1 and report your bugs here."

Comments

Sigh. Forgot Link.

[weston]

MySQL XML Functions.

Re:nice feature set

[Bill, Shooter of Bul]

Not exactly. 5.1 introduces row based replication as opposed to the statement based replication that is incompatible with the new behavior. Statement based replication has the slaves execute the exact same statement on the slave. Row based just passes the new values of the modification to the slave.

Re:Do people trust this project anymore?

[Bill, Shooter of Bul]

You haven't kept up. Sun stated that nothing was going to change with the license. The "closed source" portion had already been released under the gpl and Sun said it would stay that way. In Fact they just moved from the closed source bitkeeper to bazaar for source code control, allowing anyone to track their progress.

PostgreSQL is a fine Database as well. MySql just seems to be used more in web environments.

Re:So will Postgres ever catch MySQL?

[landonf]

I'm unfamiliar with MySQL's partitioning -- is it radically different from postgresql's partitioning?

I'm using inheritance to implement table partitioning with a rather large (50+ gig) PostgreSQL/PostGIS database. Constraint exclusion allows the query planner to use CHECK constraints to avoid even looking at tables where conditions contradict the constraints.

Re:Hosting providers

[xiaomai]

This isn't really true of an upgrade from Mysql 4.x -> 5.x. MySQL changed some things (notably their JOIN syntax) to make them more compliant with the ANSI standards. So assuming you're dealing w/ PHP/MySQL programmers that only knew the MySQL way to do joins, their applications may break on upgrade.

For more information, see the section entitled "Join Processing Changes" here:

http://dev.mysql.com/doc/refman/5.0/en/join.html

Re:Yeah, but does it have sub second Timestamps?

[Unordained]

If you're going to switch databases over the issue, you might as well consider other options, like Firebird: it's also free, I do believe the timestamps have better-than-second precision (at the very least it insists on showing me 4 extra digits I never use for anything), and it's certainly easier to install, setup, and admin than PostgreSQL (IMO). It has limitations, of course, and you should be careful to read the fine print, as you would with any product selection. I would worry that you're using some particularly esoteric features of PostgreSQL that won't translate well to Firebird, but if MySQL is even an option for you, that's highly unlikely.

Slashdot declined to carry the story I posted on it (yeah, yeah, grousing...), but Firebird 2.1 (release) came out three months ago, with some really nifty features like on-commit triggers that let you enforce constraints no other database will help you enforce (that I've seen -- Oracle certainly won't.) It rocks.

Your mileage WILL vary, but I'd recommend at least checking it out. Either http://www.ibphoenix.com/ or http://www.firebirdsql.org/.

Re:Thanks for the correction

[Tim C]

And anyone who likes to bitch about MySQL deserves an Oracle bill.

Or they could use Postgres...