BDB vs. Mysql

[csn]

I was going to install Moveable Type and use Berkeley DB, but then I saw this:

Note: There are two storage options for Movable Type, Berkeley DB or MySQL. Nearly all hosts with Perl support include Berkeley DB, and many support MySQL. We strongly recommend using a MySQL database if the option exists on your server.

http://www.movabletype.org/requirements.shtml

Mysql over BDB? What advantages does mysql have over bdb?

[Sxooter]

Considering MySQL supports BDB tables, BDB is basically a subset of MySQL, for the most part. I.e. the advantage is that MySQL provides a nice, since to use SQL front end to the BDB tables instead of the library interface most of are used to using.

Probably a bit faster too, due to things like caching and all going on in MySQL, and the fact that MySQL likely is using myisam tables, not BDB when running underneath it.

Of course, BDB would be more reliable in a crash, so there's the trade off.

I wonder if you could make MySQL use BDB or innodb table types for it?

[csn]

Oh yeah, forgot about all the table types mysql has 😉.

Last time I used mysql/phpmyadmin, you could change a table's type right in the web interface - bdb, innodb, myisam, xyz, etc. I think there's an ALTER TABLE command behind it. I can't remember exactly, but think I had some problems converting from myisam to innodb.