[Pdns-users] Using MyIsam tables instead of InnoDB for gmysql backend

Derrik Pates demon at devrandom.net
Wed Aug 17 11:48:07 UTC 2005


Wouter Westenbrink wrote:
> I would like to know if its safe to use MyIsam tables instead of InnoDB for
> the generic mysql backend.

Depends on specifically how you are going to be using your PowerDNS
setup. If it is going to be receiving AXFRs, you'll want to use InnoDB
tables instead as the transactional features are used while handling
AXFRs to rollback in case of a failure during the transfer. However,
these days I can't see any real reason why you wouldn't be able to use
InnoDB, as (at most) it's a runtime configuration option to enable it in
mysqld.

-- 
Derrik Pates
demon at devrandom.net


More information about the Pdns-users mailing list