[Pdns-users] transaction support in my db?
Bob Lockie
bjlockie at lockie.ca
Wed May 12 20:53:41 UTC 2004
On 05/12/04 14:54 Lehel Bernadt spoke:
> On Wednesday 12 May 2004 20:25, Bob Lockie wrote:
>
>>Maybe the PowerDNS documentation was written before MySQL supported
>>transactions.
>
>
> No, it wasn't. MySQL can use different storage engines, the default (MyISAM)
> doesn't support transactions, but InnoDB does. However, because it isn't the
> default, you have to specify "type=InnoDB" in your "CREATE TABLE" command for
> your transaction-enabled table.
Thanks for the clarification.
I copied the SQL statements from the documentation and they do that.
More information about the Pdns-users
mailing list