[Pdns-dev] [PATCH] SlaveDB for gmysql backend 2.9.22

[InterNetX - Eduard Folltrauer]

Hi,

if you have multiple powerdns hosts running using one mysql database,
with this little patch you can distribute database load to each of the
hosts. Using mysql replication you can run on each host an mysql slave
and configure powerdns to use local database to resolve the queries.
Update/insert queries will still go to the configured gmysql database
but select queries will go to the configured gmysql-slave database.

## Slave DB config settings
gmysql-slave-socket=
gmysql-slave-host=
gmysql-slave-port=
gmysql-slave-dbname=
gmysql-slave-user=
gmysql-slave-password=

If you have any questions or if you see any problems with this patch
please let me know. Thank you.

@Bert: Should we adapt the patch to PDNS 3.0 or do you see any problems?
Thanks.

Kind regards,
Eduard
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pdns-2.9.22-slavedb.patch
Type: text/x-patch
Size: 6240 bytes
Desc: not available
URL: <http://mailman.powerdns.com/pipermail/pdns-dev/attachments/20110119/1b643f15/attachment.bin>