how to modify the way powerdns reads from mysql DB

PowerDNS has its own schema it expects to see in the database - you can extend the schema if you wish as long as the expected tables/columns remain as a subset. Or, if needed, you can modify each of the individual queries it uses during operation through the *-query settings in your pdns.conf file, as long as the modified queries return the same set of information for the stage of processing in which the query is needed.

I'd suggest reviewing https://doc.powerdns.com/md/authoritati … c-mypgsql/">https://doc.powerdns.com/md/authoritative/backend-generic-mypgsql/ for more detailed information.

-- David