[Pdns-users] Re: transaction support in my db?

James H. Cloos Jr. cloos at jhcloos.com
Tue May 18 22:27:58 UTC 2004


>>>>> "Lehel" == Lehel Bernadt <lists at pmc-services.hu> writes:

Lehel> However, because it isn't the default, you have to
Lehel> specify "type=InnoDB" in your "CREATE TABLE" command for your
Lehel> transaction-enabled table.

More than that, youhave to make sure InnoDB is allowed in the main
config file.  I got burned by that:  debian's default mysql server
install disables InnoDB so I got MyISAM tables even though I had
type=InnoDB in the CREATE TABLE calls....

I switched back to pgsql after that.

(Replication was the only reason I even tried mysql.)

-JimC
-- 
James H. Cloos, Jr. <cloos at jhcloos.com> <http://jhcloos.com>


More information about the Pdns-users mailing list