Mysql6 or Mysql5

[Matthew Seaman]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 259 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20090531/710d8afa/signature.pgp