[Kea-users] Need help in MySQL queries - KEA

Igor Smitran sigor at blic.net
Tue Dec 27 10:20:05 UTC 2016

Galera MySQL is MySQL cluster. Kea already has mysql support and already 
does all the work you mentioned.
Why would you write another API for functionality that is already 

On 12/27/2016 08:47 AM, Nandan Adhikari wrote:
> Hi,
> I am writing a service which assigns IP addresses to newly provisioned 
> VMs or physical machines from a pre-defined IP pool. I want to use KEA 
> with Galera MySQL backend. The problem I am facing is that there is no 
> docs/info regarding the Table schema details or SQL queries to do 
> common tasks like:
> 1) lease lookup by mac/ip
> 2) reservation lookup by mac/ip
> 3) add new lease
> 4) delete an existing lease
> Here is what I am thinking for above APIs:
> 1) lease lookup by mac: (SELECT INET_NTOA(address) as address, 
> HEX(hwaddr) as hwaddr, hostname from lease4 where HEX(hwaddr)= ?", macid)
> If you could advice me on how to write such API's to do basic management.
> -- 
> Thanks & warm wishes,
> Nandan Adhikari
> _______________________________________________
> Kea-users mailing list
> Kea-users at lists.isc.org
> https://lists.isc.org/mailman/listinfo/kea-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.isc.org/pipermail/kea-users/attachments/20161227/4adba59c/attachment.htm>

More information about the Kea-users mailing list