[MTOS-dev] MySQLStorageEngine and DisableAutoCommit directives

[Hirotaka Ogawa]

Hi,

To begin supporting InnoDB and transactions, we need at least two new
directives, namely MySQLStorageEngine and DisableAutoCommit.

MySQLStorageEngine is to specify one of MySQL Storage Engines, such as
"InnoDB", "MyISAM", "BDB".  MyISAM is selected if no
MySQLStorageEngine specified.
And, DisableAutoCommit is to disable AutoCommit.
MT::ObjectDriverFactory disables AutoCommit feature only when
mt-config.cgi has "DisableAutoCommit 1".

Attached patch is to realize these experimental directives.  But, this
patch only provides directives, and doesn't provide any utilities.
For example, we need to modify mt-wizard.cgi to be able to configure
to use InnoDB, besides this patch.  And, we have to add
begin_transaction() and commit() methods, and then have to modify
MT::Apps to use them properly.

If you try to use InnoDB for testing purpose, please follow these steps:

1) Access http://.../mt-wizard.cgi to create mt-config.cgi
2) And then, add "MySQLStorageEngine InnoDB" line to mt-config.cgi by hand
3) Then, access http://.../mt-update.cgi?__mode=install to install
initial settings.

-- 
Hirotaka Ogawa makes no sense.
http://as-is.net/blog/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mtos-r1437-mysql-storage-engine-directive.patch
Type: text/x-patch
Size: 1784 bytes
Desc: not available
Url : http://www.sixapart.com/pipermail/mtos-dev/attachments/20080302/afb4f3b0/attachment-0001.bin