Nose: Added SQL statements for GSQL tables

2012-05-28T09:18:12Z

Added SQL statements for GSQL tables

New page

The PowerDNS opendbx backend allows you to adapt the SQL statements so the backend will work with the database schema of the gMySQL/gPgSQL backends too if you modify the statements like listed below.

'''Note:''' The statements below don't use the indices as optimal as before and this might lead to a lower performance than before.

== Modified SQL statements ==

; opendbx-sql-lookupsoa : Retrieve SOA record for domain. Default is:

SELECT
d."id", NULL, r."ttl", r."content"
FROM "records" r
JOIN "domains" d ON r."domain_id"=d."id"
WHERE r."name"=':name' AND r."type"='SOA'

; opendbx-sql-zoneinfo : Get stored information about a domain. Default is:

SELECT
d."id", d."name", d."type",
d."master", d."last_check", r."content"
FROM "domains" d
LEFT JOIN "records" r ON ( d."id"=r."domain_id" AND r."type"='SOA' )
WHERE d."name"=':name'

; opendbx-sql-master : Get master record for zone. Default is:

SELECT "master"
FROM "domains"
WHERE "name"=':name' AND "type"='SLAVE'

; opendbx-sql-infoslaves : Get all unfresh slaves. Default is:

SELECT
d."id", d."name", d."master", d."notified_serial",
d."last_check", r."change_date", r."content"
FROM "domains" d
LEFT JOIN "records" r ON ( d."id"=r."domain_id" AND r."type"='SOA' )
WHERE d."type"='SLAVE'

; opendbx-sql-infomasters : Get all updates masters. Default is:

SELECT
d."id", d."name", d."master", d."notified_serial",
d."last_check", r."change_date", r."content"
FROM "domains" d
JOIN "records" r ON d."id"=r."domain_id"
WHERE d."type"='MASTER' AND r."type"='SOA'

PowerDNS OpenDBX Backend/Configuration/GSQL only - Revision history

Nose: Added SQL statements for GSQL tables