New MySQL Types

PHP-Editors_com

Hi,

Does anyone have experience of the new Database type in MySQL (not MyISAM). I read the new version of MySQL supports transaction processing quite well. I cant however install it on my production Server at this time. Just wondered if anyone had any comments on how good or bad it is.

Thanks in advance.

stolzyboy

i have heard it is pretty good, however it is an alpha version as of yet, with no known bugs, but shouldn't be used for production server, til the stable version comes out, www.mysql.com has some more information on the new version

jerdo

4.0.x is in Gamma version and they have 4.1 out for developers already but yet again that means it isn't for production use.

[deleted]

The transactions of 4.0 are 'transactions' and that's where it ends.

Note that mysql itself doesn't support transactions, it's the InnoDB table-handler that supports the transactions.

If you're looking for a real database that supports transactions properly (and a sh8tload of other functions that mysql doesn't) then look at postgreSQL, which is also free.

jerdo

Oh how I love the PostgreSQL militants.

[deleted]

hehe...
Face it, MySQL is getting better but it's still not a competitor for the likes of postgresql

🙂

PHP-Editors_com

The problem I find is that most PHP tutorials, scripts and discusions that refer to database usage all use MySQL... it seems to have a much bigger user base. However I do believe production versions are not great and postgreSQL does sound really good.
Hopefully in a year or so, when all (or most of) the MySQL bugs fixed and ready for production, it will be as strong as other DB's.

Thanks for all your views.

[deleted]

Unfortunately MySQL's large userbase sais absolutely nothing about the quality of MySQL.

Maybe someday mysql will be a 'good' database, but it has a very long way to go.