[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