PDNS Sqlite

clarity_64

Does anyone here have any experience with the setup above? I want to try it out because I really want an interface to make changes. I can't stand having to write out bind files. I am just lazy.

BoGs

Goggling for the win?

http://www.howtoforge.com/installing-powerdns-with-mysql-backend-and-poweradmin-on-debian-etch
http://www.linux-faqs.info/dns/high-available-dns-with-powerdns-and-mysql

Damian

@BoGs said: Goggling for the win?

Neither of those pertain to sqlite.

clarity_64

The key here is that I don't want mysql, and I know how to install the sqlite backend. I just wanted to know if anyone has any experience with performance.

Maounique

mysql is a memory hog. DNS setups are usually on very "light" memory VPSes.
M

BoGs

http://doc.powerdns.com/gsqlite.html

I do not like sqlite because it is not a production database, it cannot handle the requests (depending on the num of requests) as mysql or postgresql can. I recommend researching sqlite and production and then reviewing the possibility of getting a real database.

clarity_64

Well what is the best low memory usage database backend for PDNS?

BoGs

You can very much run a mysql / postgres db instance on a LEB, there are plenty of articles on how to set-up the low mem usage and as well the database caching which will help plenty.