MySQL Version 4.0 Dubbed Production

[jatar_k]

[mysql.com...]

The main new features of MySQL version 4.0 are geared toward enhancing the MySQL database software as the solution for mission-critical, heavy-load database systems and to optimize performance as an embedded database.

foreign keys and sub selects, I am very excited. There are a lot of interesting new features that will really ramp up mysql.

[bcolflesh]

Before the inevitable PostgreSQL sourpuss posts, I'd also like to express my excitement for 4.0!

Regards,
Brent

[lorax]

>> The transactional engine, InnoDB, in the standard 4.0 binaries, adding transactions, row-level locking, and foreign key integrity

YAY! Finally - transactional processing. Thanks jatar_k this is the best news I've had all weekend! :)

[txbakers]

Is it official yet? Are we on 4.0 Production?

Also, what might I run into updating from 3.2 to 4.0? Should it be a simple install? Do I have to uninstall first?

What can I expect? I'm a little nervous about this since it is a live database on my sites......

[sun818]

Has anyone used the mySQL ODBC drivers? How's the select and update performance? I'm thinking for non-technical people, Microsoft Access may be the front end they use and link mySQL tables through ODBC.

[txbakers]

I've been using the mySQL ODBC driver without a problem.

Although 98% of my pages are using a direct connection with ADO, some still use an ODBC call and I haven't had any problems.