Grant Peel wrote:
Does anyone have any expierience with it? Is it solid? Fast? Are
there any 'gotchas' when using databases developed on older versions
of Mysql? (4).
I can't answer about speed or solidity -- except to point out that MySQL
themselves describe MYSQL 6.0 as an "alpha development release".
http://dev.mysql.com/downloads/mysql/6.0.html
MySQL 5.1 is the preferred generally-available release at the moment. 5.1 is
certainly reasonably solid, but I don't think it offers much in terms of speed
increases over 5.0 and it's likely to be slower than a 4.x system. Of course,
4.x doesn't support any of the transactional stuff or foreign keys or higher
concurrency / multiple CPUs anything like as well as the later versions.
As for compatibility between MySQL 4.x and MySQL 6.x; well, it might work,
but the chances are it will break due to a number of small but incompatible
changes in schemas, SQL etc. etc. Most readily available software will work
with MySQL 5.0+ nowadays, and it is usually possible for a reasonably
experienced
DBA to load data dumped out of a 4.x server into a 5.x server without too
much expenditure of either ingenuity or profanity.
Cheers,
Matthew
--
Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard
Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate
Kent, CT11 9PW
signature.asc
Description: OpenPGP digital signature